Versions Compared

Old Version 1

changes.mady.by.user Patricia Donohue

Saved on

compared with

New Version Current

changes.mady.by.user Patricia Donohue

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For more details, see the CCCApply International Application data dictionary.

College Adaptor Payload Name

CCC Field Name

PeopleSoft DB Staging Table

PeopleSoft Field Name

Explanation

VERSION Release

appId

app_id

PS_CCTC_INTL_STG

CCTC_APPL_ID

See here

cccId

ccc_id

PS_CCTC_INTL_STG

CCTC_CCCID

See here

collegeId

college_id

PS_CCTC_INTL_STG

CCTC_MIS_CD

See here

addressVerified

address_verified

PS_CCTC_INTL_STG

CCTC_INTL_AGTADDRV

See here

agentEmail

agent_email

PS_CCTC_INTL_STG

CCTC_EMAIL_AGNT

See here

agentPhoneExt

agent_phone_ext

PS_CCTC_INTL_STG

CCTC_PHONE_AGNT_EX

See here

agentPhoneNumber

agent_phone_number

PS_CCTC_INTL_STG

CCTC_PHONE_AGNT

See here

altNonUsPhoneAuthTxt

alt_non_us_phone_auth_txt

PS_CCTC_INTL_STG

CCTC_INTL_2PHNESMS

See here

altNonUsPhoneExt

alt_non_us_phone_ext

PS_CCTC_INTL_STG

CCTC_INTL_2PHNEEXT

See here

altNonUsPhoneNumber

alt_non_us_phone_number

PS_CCTC_INTL_STG

CCTC_INTL_2PHNE

See here

appLang

app_lang

PS_CCTC_INTL_STG

CCTC_APPL_LANG_CD

See here

authorizeAgentInfoRelease

authorize_agent_info_release

PS_CCTC_INTL_STG

CCTC_INTL_AGT_AUTH

See here

birthdate

birthdate

PS_CCTC_INTL_STG

CCTC_BIRTHDATE

See here

campaign1

campaign1

PS_CCTC_INTL_STG

CCTC_APPL_CAMPGN1

See here

campaign2

campaign2

PS_CCTC_INTL_STG

CCTC_APPL_CAMPGN2

See here

campaign3

campaign3

PS_CCTC_INTL_STG

CCTC_APPL_CAMPGN3

See here

citizenshipStatus

citizenship_status

PS_CCTC_INTL_STG

CCTC_CITIZENSHIP

See here

city

city

PS_CCTC_INTL_STG

CCTC_INTL_AGTADDRC

See here

coenrollConfirm

coenroll_confirm

PS_CCTC_INTL_STG

CCTC_APPL_CENRL_CF

See here

col1Cds

col1_cds

PS_CCTC_INTL_STG

CCTC_APPL_CL1_CDS

See here

col1CdsFull

col1_cds_full

PS_CCTC_INTL_STG

CCTC_APPL_CL1_FCDS

See here

col1Ceeb

col1_ceeb

PS_CCTC_INTL_STG

CCTC_APPL_CL1_CEEB

See here

col1City

col1_city

PS_CCTC_INTL_STG

CCTC_APPL_CL1_CITY

See here

col1CollegeAttendedId

col1_college_attended_id

PS_CCTC_INTL_STG

CCTC_APPL_CL1_ID

See here

col1Country

col1_country

PS_CCTC_INTL_STG

CCTC_APPL_CL1_CTRY

See here

col1DegreeDate

col1_degree_date

PS_CCTC_INTL_STG

CCTC_APPL_CL1_DGDT

See here

col1DegreeObtained

col1_degree_obtained

PS_CCTC_INTL_STG

CCTC_APPL_CL1_DGRE

See here

col1EndDate

col1_end_date

PS_CCTC_INTL_STG

CCTC_APPL_CL1_END

See here

col1ExpelledStatus

col1_expelled_status

PS_CCTC_INTL_STG

CCTC_APPL_CL1_EXP

See here

col1Major

col1_major

PS_CCTC_INTL_STG

CCTC_APPL_CL1_MJR

See here

col1Name

col1_name

PS_CCTC_INTL_STG

CCTC_APPL_CL1_NAME

See here

col1NonUsProvince

col1_non_us_province

PS_CCTC_INTL_STG

CCTC_APPL_CL1_PRVN

See here

col1NotListed

col1_not_listed

PS_CCTC_INTL_STG

CCTC_APPL_CL1_NL

See here

col1PrimaryInstructionLanguage

col1_primary_instruction_language

PS_CCTC_INTL_STG

CCTC_APPL_CL1_LANG

See here

col1StartDate

col1_start_date

PS_CCTC_INTL_STG

CCTC_APPL_CL1_STRT

See here

col1State

col1_state

PS_CCTC_INTL_STG

CCTC_APPL_CL1_STTE

See here

col2Cds

col2_cds

PS_CCTC_INTL_STG

CCTC_APPL_CL2_CDS

See here

col2Ceeb

col2CdsFull

col2_cds_full

PS_CCTC_INTL_STG

CCTC_APPL_CL2_FCDS

See here

col2Ceeb

col2_ceeb

PS_CCTC_INTL_STG

CCTC_APPL_CL2_CEEB

See here

col2City

col2_city

PS_CCTC_INTL_STG

CCTC_APPL_CL2_CITY

See here

col2CollegeAttendedId

col2_college_attended_id

PS_CCTC_INTL_STG

CCTC_APPL_CL2_ID

See here

col2Country

col2_country

PS_CCTC_INTL_STG

CCTC_APPL_CL2_CTRY

See here

col2DegreeDate

col2_degree_date

PS_CCTC_INTL_STG

CCTC_APPL_CL2_DGDT

See here

col2DegreeObtained

col2_degree_obtained

PS_CCTC_INTL_STG

CCTC_APPL_CL2_DGRE

See here

col2EndDate

col2_end_date

PS_CCTC_INTL_STG

CCTC_APPL_CL2_END

See here

col2ExpelledStatus

col2_expelled_status

PS_CCTC_INTL_STG

CCTC_APPL_CL2_EXP

See here

col2Major

col2_major

PS_CCTC_INTL_STG

CCTC_APPL_CL2_MJR

See here

col2Name

col2_name

PS_CCTC_INTL_STG

CCTC_APPL_CL2_NAME

See here

col2NonUsProvince

col2_non_us_province

PS_CCTC_INTL_STG

CCTC_APPL_CL2_PRVN

See here

col2NotListed

col2_not_listed

PS_CCTC_INTL_STG

CCTC_APPL_CL2_NL

See here

col2PrimaryInstructionLanguage

col2_primary_instruction_language

PS_CCTC_INTL_STG

CCTC_APPL_CL2_LANG

See here

col2StartDate

col2_start_date

PS_CCTC_INTL_STG

CCTC_APPL_CL2_STRT

See here

col2State

col2_state

PS_CCTC_INTL_STG

CCTC_APPL_CL2_STTE

See here

col3Cds

col3_cds

PS_CCTC_INTL_STG

CCTC_APPL_CL3_CDS

See here

col3CdsFull

col3_cds_full

PS_CCTC_INTL_STG

CCTC_APPL_CL3_FCDS

See here

col3Ceeb

col3_ceeb

PS_CCTC_INTL_STG

CCTC_APPL_CL3_CEEB

See here

col3City

col3_city

PS_CCTC_INTL_STG

CCTC_APPL_CL3_CITY

See here

col3CollegeAttendedId

col3_college_attended_id

PS_CCTC_INTL_STG

CCTC_APPL_CL3_ID

See here

col3Country

col3_country

PS_CCTC_INTL_STG

CCTC_APPL_CL3_CTRY

See here

col3DegreeDate

col3_degree_date

PS_CCTC_INTL_STG

CCTC_APPL_CL3_DGDT

See here

col3DegreeObtained

col3_degree_obtained

PS_CCTC_INTL_STG

CCTC_APPL_CL3_DGRE

See here

col3EndDate

col3_end_date

PS_CCTC_INTL_STG

CCTC_APPL_CL3_END

See here

col3ExpelledStatus

col3_expelled_status

PS_CCTC_INTL_STG

CCTC_APPL_CL3_EXP

See here

col3Major

col3_major

PS_CCTC_INTL_STG

CCTC_APPL_CL3_MJR

See here

col3Name

col3_name

PS_CCTC_INTL_STG

CCTC_APPL_CL3_NAME

See here

col3NonUsProvince

col3_non_us_province

PS_CCTC_INTL_STG

CCTC_APPL_CL3_PRVN

See here

col3NotListed

col3_not_listed

PS_CCTC_INTL_STG

CCTC_APPL_CL3_NL

See here

col3PrimaryInstructionLanguage

col3_primary_instruction_language

PS_CCTC_INTL_STG

CCTC_APPL_CL3_LANG

See here

col3StartDate

col3_start_date

PS_CCTC_INTL_STG

CCTC_APPL_CL3_STRT

See here

col3State

col3_state

PS_CCTC_INTL_STG

CCTC_APPL_CL3_STTE

See here

col4Cds

col4_cds

PS_CCTC_INTL_STG

CCTC_APPL_CL4_CDS

See here

col4CdsFull

col4_cds_full

PS_CCTC_INTL_STG

CCTC_APPL_CL4_FCDS

See here

col4Ceeb

col4_ceeb

PS_CCTC_INTL_STG

CCTC_APPL_CL4_CEEB

See here

col4City

col4_city

PS_CCTC_INTL_STG

CCTC_APPL_CL4_CITY

See here

col4CollegeAttendedId

col4_college_attended_id

PS_CCTC_INTL_STG

CCTC_APPL_CL4_ID

See here

col4DegreeDate

col4Country

col4_country

PS_CCTC_INTL_STG

CCTC_APPL_CL4_CTRY

See here

col4DegreeDate

col4_degree_date

PS_CCTC_INTL_STG

CCTC_APPL_CL4_DGDT

See here

col4DegreeObtained

col4_degree_obtained

PS_CCTC_INTL_STG

CCTC_APPL_CL4_DGRE

See here

col4EndDate

col4_end_date

PS_CCTC_INTL_STG

CCTC_APPL_CL4_END

See here

col4ExpelledStatus

col4_expelled_status

PS_CCTC_INTL_STG

CCTC_APPL_CL4_EXP

See here

col4Major

col4_major

PS_CCTC_INTL_STG

CCTC_APPL_CL4_MJR

See here

col4Name

col4_name

PS_CCTC_INTL_STG

CCTC_APPL_CL4_NAME

See here

col4NonUsProvince

col4_non_us_province

PS_CCTC_INTL_STG

CCTC_APPL_CL4_PRVN

See here

col4NotListed

col4_not_listed

PS_CCTC_INTL_STG

CCTC_APPL_CL4_NL

See here

col4PrimaryInstructionLanguage

col4_primary_instruction_language

PS_CCTC_INTL_STG

CCTC_APPL_CL4_LANG

See here

col4StartDate

col4_start_date

PS_CCTC_INTL_STG

CCTC_APPL_CL4_STRT

See here

col4State

col4_state

PS_CCTC_INTL_STG

CCTC_APPL_CL4_STTE

See here

collegeCompDate

college_comp_date

PS_CCTC_INTL_STG

CCTC_APPL_CLCOMPDT

See here

collegeCount

college_count

PS_CCTC_INTL_STG

CCTC_APPL_CLG_CNT

See here

collegeEduLevel

college_edu_level

PS_CCTC_INTL_STG

CCTC_APPL_CLEDULVL

See here

collegeExpelledSummary

college_expelled_summary

PS_CCTC_INTL_STG

CCTC_APPL_COL_EXP

See here

collegeName

college_name

PS_CCTC_INTL_STG

CCTC_APPL_COL_NM

See here

company

company

PS_CCTC_INTL_STG

CCTC_INTL_AGTCMPNY

See here

confirmation

confirmation

PS_CCTC_INTL_STG

CCTC_APPL_CFRM_NBR

See here

consent

consent

PS_CCTC_INTL_STG

CCTC_INFO_CONSENT

See here

contact

contact

PS_CCTC_INTL_STG

CCTC_INTL_AGTCNTCT

See here

country

country

PS_CCTC_INTL_STG

CCTC_INTL_AGTCNTRY

See here

countryOfBirth

country_of_birth

PS_CCTC_INTL_STG

CCTC_BIRTH_COUNTRY

See here

countryOfCitizenship

country_of_citizenship

PS_CCTC_INTL_STG

CCTC_CITZN_COUNTRY

See here

cryptokeyid

cryptokeyid

Not Supported



currentMailingAddressOutsideUs

current_mailing_address_outside_us

Not Supported



currentMailingAddressVerified

current_mailing_address_verified

PS_CCTC_INTL_STG

CCTC_MADDR_VALID

See here

addressValidationOverride

address_validation_override

PS_CCTC_INTL_STG

CCTC_MADDR_VOVR

See here

addressValidationOverrideTimestamp

address_validation_override_timestamp

PS_CCTC_INTL_STG

CCTC_MADDR_VOVR_TS

See here

currentMailingCity

current_mailing_city

PS_CCTC_INTL_STG

CCTC_MADDR_CITY

See here

currentMailingCountry

current_mailing_country

PS_CCTC_INTL_STG

CCTC_MADDR_COUNTRY

See here

currentMailingNonUsAddress

current_mailing_non_us_address

PS_CCTC_INTL_STG

CCTC_MADDR_USA

See here

currentMailingNonUsPostalCode

current_mailing_non_us_postal_code

PS_CCTC_INTL_STG

CCTC_MADDR_IZIP

See here

currentMailingNonUsProvince

current_mailing_non_us_province

PS_CCTC_INTL_STG

CCTC_MADDR_PRVINCE

See here

currentMailingSameAsPermanent

current_mailing_same_as_permanent

PS_CCTC_INTL_STG

CCTC_PERM_EQ_MAIL

See here

currentMailingState

current_mailing_state

PS_CCTC_INTL_STG

CCTC_MADDR_STATE

See here

currentMailingStreet1

current_mailing_street_1

PS_CCTC_INTL_STG

CCTC_MADDR_LINE1

See here

currentMailingStreet2

current_mailing_street_2

PS_CCTC_INTL_STG

CCTC_MADDR_LINE2

See here

noMailingAddressHomeless

currentMailingZipCode

current_mailing_zip_code

PS_CCTC_INTL_STG

CCTC_MADDR_POSTCD

See here

noMailingAddressHomeless

no_mailing_address_homeless

PS_CCTC_INTL_STG

CCTC_MADDR_HOMELSS

See here

noNonUsaPermAddressHomeless

no_non_usa_perm_address_homeless

PS_CCTC_INTL_STG

CCTC_INTL_ADDRHMLS

See here

dep1CountryOfBirth

dep1_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP1_COB

See here

dep1DateOfBirth

dep1_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP1_DOB

See here

dep1DependentId

dep1_dependent_id

Not Supported

dep1FirstName

dep1_first_name

PS_CCTC_INTL_STG

CCTC_DP1_FN

See here

dep1Gender

dep1_gender

PS_CCTC_INTL_STG

CCTC_DP1_GNDR

See here

dep1LastName

dep1_last_name

PS_CCTC_INTL_STG

CCTC_DP1_LN

See here

dep1NoFirstName

dep1_no_first_name

PS_CCTC_INTL_STG

CCTC_DP1_NO_FN

See here

dep1Relationship

dep1_relationship

PS_CCTC_INTL_STG

CCTC_DP1_RELATION

See here

dep10CountryOfBirth

dep10_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP10_COB

See here

dep10DateOfBirth

dep10_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP10_DOB

See here

dep10DependentId

dep10_dependent_id

Not Supported

dep10FirstName

dep10_first_name

PS_CCTC_INTL_STG

CCTC_DP10_FN

See here

dep10Gender

dep10_gender

PS_CCTC_INTL_STG

CCTC_DP10_GNDR

See here

dep10LastName

dep10_last_name

PS_CCTC_INTL_STG

CCTC_DP10_LN

See here

dep10NoFirstName

dep10_no_first_name

PS_CCTC_INTL_STG

CCTC_DP10_NO_FN

See here

dep10Relationship

dep10_relationship

PS_CCTC_INTL_STG

CCTC_DP10_RELATION

See here

dep2CountryOfBirth

dep2_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP2_COB

See here

dep2DateOfBirth

dep2_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP2_DOB

See here

dep2DependentId

dep2_dependent_id

Not Supported

dep2FirstName

dep2_first_name

PS_CCTC_INTL_STG

CCTC_DP2_FN

See here

dep2Gender

dep2_gender

PS_CCTC_INTL_STG

CCTC_DP2_GNDR

See here

dep2LastName

dep2_last_name

PS_CCTC_INTL_STG

CCTC_DP2_LN

See here

dep2NoFirstName

dep2_no_first_name

PS_CCTC_INTL_STG

CCTC_DP2_NO_FN

See here

dep2Relationship

dep2_relationship

PS_CCTC_INTL_STG

CCTC_DP2_RELATION

See here

dep3CountryOfBirth

dep3_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP3_COB

See here

dep3DateOfBirth

dep3_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP3_DOB

See here

dep3DependentId

dep3_dependent_id

Not Supported

dep3FirstName

dep3_first_name

PS_CCTC_INTL_STG

CCTC_DP3_FN

See here

dep3Gender

dep3_gender

PS_CCTC_INTL_STG

CCTC_DP3_GNDR

See here

dep3LastName

dep3_last_name

PS_CCTC_INTL_STG

CCTC_DP3_LN

See here

dep3NoFirstName

dep3_no_first_name

PS_CCTC_INTL_STG

CCTC_DP3_NO_FN

See here

dep3Relationship

dep3_relationship

PS_CCTC_INTL_STG

CCTC_DP3_RELATION

See here

dep4CountryOfBirth

dep4_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP4_COB

See here

dep4DateOfBirth

dep4_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP4_DOB

See here

dep4DependentId

dep4_dependent_id

Not Supported

dep4Gender

dep4FirstName

dep4_first_name

PS_CCTC_INTL_STG

CCTC_DP4_FN

See here

dep4Gender

dep4_gender

PS_CCTC_INTL_STG

CCTC_DP4_GNDR

See here

dep4LastName

dep4_last_name

PS_CCTC_INTL_STG

CCTC_DP4_LN

See here

dep4NoFirstName

dep4_no_first_name

PS_CCTC_INTL_STG

CCTC_DP4_NO_FN

See here

dep4Relationship

dep4_relationship

PS_CCTC_INTL_STG

CCTC_DP4_RELATION

See here

dep5CountryOfBirth

dep5_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP5_COB

See here

dep5DateOfBirth

dep5_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP5_DOB

See here

dep5DependentId

dep5_dependent_id

Not Supported

dep5FirstName

dep5_first_name

PS_CCTC_INTL_STG

CCTC_DP5_FN

See here

dep5Gender

dep5_gender

PS_CCTC_INTL_STG

CCTC_DP5_GNDR

See here

dep5LastName

dep5_last_name

PS_CCTC_INTL_STG

CCTC_DP5_LN

See here

dep5NoFirstName

dep5_no_first_name

PS_CCTC_INTL_STG

CCTC_DP5_NO_FN

See here

dep5Relationship

dep5_relationship

PS_CCTC_INTL_STG

CCTC_DP5_RELATION

See here

dep6CountryOfBirth

dep6_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP6_COB

See here

dep6DateOfBirth

dep6_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP6_DOB

See here

dep6DependentId

dep6_dependent_id

Not Supported

dep6FirstName

dep6_first_name

PS_CCTC_INTL_STG

CCTC_DP6_FN

See here

dep6Gender

dep6_gender

PS_CCTC_INTL_STG

CCTC_DP6_GNDR

See here

dep6LastName

dep6_last_name

PS_CCTC_INTL_STG

CCTC_DP6_LN

See here

dep6NoFirstName

dep6_no_first_name

PS_CCTC_INTL_STG

CCTC_DP6_NO_FN

See here

dep6Relationship

dep6_relationship

PS_CCTC_INTL_STG

CCTC_DP6_RELATION

See here

dep7CountryOfBirth

dep7_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP7_COB

See here

dep7DateOfBirth

dep7_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP7_DOB

See here

dep7DependentId

dep7_dependent_id

Not Supported

dep7FirstName

dep7_first_name

PS_CCTC_INTL_STG

CCTC_DP7_FN

See here

dep7Gender

dep7_gender

PS_CCTC_INTL_STG

CCTC_DP7_GNDR

See here

dep7LastName

dep7_last_name

PS_CCTC_INTL_STG

CCTC_DP7_LN

See here

dep7NoFirstName

dep7_no_first_name

PS_CCTC_INTL_STG

CCTC_DP7_NO_FN

See here

dep7Relationship

dep7_relationship

PS_CCTC_INTL_STG

CCTC_DP7_RELATION

See here

dep8CountryOfBirth

dep8_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP8_COB

See here

dep8DateOfBirth

dep8_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP8_DOB

See here

dep8DependentId

dep8_dependent_id

Not Supported

dep8FirstName

dep8_first_name

PS_CCTC_INTL_STG

CCTC_DP8_FN

See here

dep8Gender

dep8_gender

PS_CCTC_INTL_STG

CCTC_DP8_GNDR

See here

dep8LastName

dep8_last_name

PS_CCTC_INTL_STG

CCTC_DP8_LN

See here

dep8NoFirstName

dep8_no_first_name

PS_CCTC_INTL_STG

CCTC_DP8_NO_FN

See here

dep8Relationship

dep8_relationship

PS_CCTC_INTL_STG

CCTC_DP8_RELATION

See here

dep9CountryOfBirth

dep9_country_of_birth

PS_CCTC_INTL_STG

CCTC_DP9_COB

See here

dep9DependentId

dep9DateOfBirth

dep9_date_of_birth

PS_CCTC_INTL_STG

CCTC_DP9_DOB

See here

dep9DependentId

dep9_dependent_id

Not Supported

dep9FirstName

dep9_first_name

PS_CCTC_INTL_STG

CCTC_DP9_FN

See here

dep9Gender

dep9_gender

PS_CCTC_INTL_STG

CCTC_DP9_GNDR

See here

dep9LastName

dep9_last_name

PS_CCTC_INTL_STG

CCTC_DP9_LN

See here

dep9NoFirstName

dep9_no_first_name

PS_CCTC_INTL_STG

CCTC_DP9_NO_FN

See here

dep9Relationship

dep9_relationship

PS_CCTC_INTL_STG

CCTC_DP9_RELATION

See here

educationalGoal

educational_goal

PS_CCTC_INTL_STG

CCTC_EDU_GOAL

See here

email

email

PS_CCTC_INTL_STG

CCTC_EMAIL

See here

emailVerified

email_verified

PS_CCTC_INTL_STG

CCTC_EMAIL_VER

See here

emailVerifiedTimestamp

email_verified_timestamp

PS_CCTC_INTL_STG

CCTC_EMAIL_VER_TS

See here

preferredMethodOfContact

preferred_method_of_contact

PS_CCTC_INTL_STG

CCTC_PRF_CNCT_MTHD

See here

emergencyContactAddressVerified

emergency_contact_address_verified

PS_CCTC_INTL_STG

CCTC_EMRG_ADDRVALD

See here

emergencyContactCity

emergency_contact_city

PS_CCTC_INTL_STG

CCTC_EMRG_ADDRCITY

See here

emergencyContactCountry

emergency_contact_country

PS_CCTC_INTL_STG

CCTC_EMRG_ADDRCTRY

See here

emergencyContactEmail

emergency_contact_email

PS_CCTC_INTL_STG

CCTC_EMRG_EMAIL

See here

emergencyContactFirstName

emergency_contact_first_name

PS_CCTC_INTL_STG

CCTC_EMRG_FN

See here

emergencyContactLastName

emergency_contact_last_name

PS_CCTC_INTL_STG

CCTC_EMRG_LN

See here

emergencyContactNoFirstName

emergency_contact_no_first_name

PS_CCTC_INTL_STG

CCTC_EMRG_NO_FN

See here

emergencyContactNonUsAddress

emergency_contact_non_us_address

PS_CCTC_INTL_STG

CCTC_EMRG_ADDR_USA

See here

emergencyContactNonUsPostalCode

emergency_contact_non_us_postal_code

PS_CCTC_INTL_STG

CCTC_EMRG_ADDRIZIP

See here

emergencyContactNonUsProvince

emergency_contact_non_us_province

PS_CCTC_INTL_STG

CCTC_EMRG_ADDR_PRV

See here

emergencyContactPhoneAuthTxt

emergency_contact_phone_auth_txt

PS_CCTC_INTL_STG

CCTC_EMRG_PHONESMS

See here

emergencyContactPhoneExt

emergency_contact_phone_ext

PS_CCTC_INTL_STG

CCTC_EMRG_PHONEEXT

See here

emergencyContactPhoneNumber

emergency_contact_phone_number

PS_CCTC_INTL_STG

CCTC_EMRG_PHONE

See here

emergencyContactRelationship

emergency_contact_relationship

PS_CCTC_INTL_STG

CCTC_EMRG_RELATION

See here

emergencyContactState

emergency_contact_state

PS_CCTC_INTL_STG

CCTC_EMRG_ADDRSTTE

See here

emergencyContactStreet1

emergency_contact_street_1

PS_CCTC_INTL_STG

CCTC_EMRG_ADDRLIN1

See here

emergencyContactStreet2

emergency_contact_street_2

PS_CCTC_INTL_STG

CCTC_EMRG_ADDRLIN2

See here

emergencyContactZipCode

emergency_contact_zip_code

PS_CCTC_INTL_STG

CCTC_EMRG_ADDRPOST

See here

engMonthsStudied

eng_months_studied

PS_CCTC_INTL_STG

CCTC_INTL_MON_ENG

See here

engProficiencyDate

eng_proficiency_date

PS_CCTC_INTL_STG

CCTC_INTL_ENGPRFDT

See here

engProficiencyOther

eng_proficiency_other

PS_CCTC_INTL_STG

CCTC_INTL_ENGPRFOT

See here

engProficiencyPrerequisite

eng_proficiency_prerequisite

PS_CCTC_INTL_STG

CCTC_INTL_ENGPRFPQ

See here

engProficiencyReq

eng_proficiency_req

Not Supported

engProficiencyScore

eng_proficiency_score

PS_CCTC_INTL_STG

CCTC_INTL_ENGPRFSC

See here

engProficiencyShowScore

eng_proficiency_show_score

PS_CCTC_INTL_STG

CCTC_INTL_ENGPRFSS

See here

engProficiencyType

eng_proficiency_type

PS_CCTC_INTL_STG

CCTC_INTL_ENGPRFTP

See here

enrollTermCode

enrollStatus

enroll_status

PS_CCTC_INTL_STG

CCTC_APPL_ENR_STAT

See here

enrollTermCode

enroll_term_code

PS_CCTC_INTL_STG

CCTC_APPL_ENRTRMCD

See here

enrollTermDescription

enroll_term_description

PS_CCTC_INTL_STG

CCTC_APPL_ENRTRMDS

See here

esignature

esignature

PS_CCTC_INTL_STG

CCTC_ESIGNATURE

See here

expirationDate

expiration_date

PS_CCTC_INTL_STG

CCTC_ALIEN_REG_EXP

See here

faxNumberNumber

fax_number_number

PS_CCTC_INTL_STG

CCTC_FAX_NUMBER

See here

firstname

firstname

PS_CCTC_INTL_STG

CCTC_LGL_FIRST_NM

See here

gender

gender

PS_CCTC_INTL_STG

CCTC_GENDER

See here

higherLang

higher_lang

Not Supported

highestCompDate

highest_comp_date

PS_CCTC_INTL_STG

CCTC_APPL_HRCOMPDT

See here

highestEduLevel

highest_edu_level

PS_CCTC_INTL_STG

CCTC_APPL_HREDULVL

See here

hispanic

hispanic

PS_CCTC_INTL_STG

CCTC_HISPANIC

See here

hsAddressVerified

hs_address_verified

PS_CCTC_INTL_STG

CCTC_APPL_HS_ADDRV

See here

hsCds

hs_cds

PS_CCTC_INTL_STG

CCTC_APPL_HS_CDS

See here

hsCdsFull

hs_cds_full

PS_CCTC_INTL_STG

CCTC_APPL_HS_FCDS

See here

hsCeeb

hs_ceeb

PS_CCTC_INTL_STG

CCTC_APPL_HS_CEEB

See here

hsCity

hs_city

PS_CCTC_INTL_STG

CCTC_APPL_HS_CITY

See here

hsCompDate

hs_comp_date

PS_CCTC_INTL_STG

CCTC_APPL_HSCOMPDT

See here

hsCountry

hs_country

PS_CCTC_INTL_STG

CCTC_APPL_HS_CNTRY

See here

hsDiplomaCert

hs_diploma_cert

PS_CCTC_INTL_STG

CCTC_APPL_HS_DPLMA

See here

hsDiplomaCertDate

hs_diploma_cert_date

PS_CCTC_INTL_STG

CCTC_APPL_HSDPMADT

See here

hsEduLevel

hs_edu_level

PS_CCTC_INTL_STG

CCTC_APPL_HSEDULVL

See here

hsEndDate

hs_end_date

PS_CCTC_INTL_STG

CCTC_APPL_HSENDDT

See here

hsLang

hs_lang

PS_CCTC_INTL_STG

CCTC_APPL_HSLANGCD

See here

hsName

hs_name

PS_CCTC_INTL_STG

CCTC_APPL_HS_NAME

See here

hsNonUsAddress

hs_non_us_address

PS_CCTC_INTL_STG

CCTC_APPL_HS_USA

See here

hsNonUsPostalCode

hs_non_us_postal_code

PS_CCTC_INTL_STG

CCTC_APPL_HS_IZIP

See here

hsNonUsProvince

hs_non_us_province

PS_CCTC_INTL_STG

CCTC_APPL_HS_PRVNC

See here

hsNotListed

hs_not_listed

PS_CCTC_INTL_STG

CCTC_APPL_HS_NL

See here

hsStartDate

hs_start_date

PS_CCTC_INTL_STG

CCTC_APPL_HSSTRTDT

See here

hsState

hs_state

PS_CCTC_INTL_STG

CCTC_APPL_HS_STATE

See here

hsStreet1

hs_street_1

PS_CCTC_INTL_STG

CCTC_APPL_HS_LINE1

See here

hsStreet2

hs_street_2

PS_CCTC_INTL_STG

CCTC_APPL_HS_LINE2

See here

hsType

hs_type

PS_CCTC_INTL_STG

CCTC_INTL_HS_TYPE

See here

hsZipCode

hs_zip_code

PS_CCTC_INTL_STG

CCTC_APPL_HSPOSTCD

See here

i20ExpirationDate

i20_expiration_date

PS_CCTC_INTL_STG

CCTC_INTL_I20EXPDT

See here

i20IssuingSchoolName

i20_issuing_school_name

PS_CCTC_INTL_STG

CCTC_INTL_I20SCHOL

See here

i94AdmissionNumber

i94_admission_number

PS_CCTC_INTL_STG

CCTC_INTL_I94_ADM

See here

i94ExpirationDate

i94_expiration_date

PS_CCTC_INTL_STG

CCTC_INTL_I94_EXP

See here

idmeConfirmationTimestamp

idme_confirmation_timestamp

PS_CCTC_INTL_STG

CCTC_IDME_CNFRM_TS

SG v.4.9.0

idmeOptinTimestamp

idme_optin_timestamp

PS_CCTC_INTL_STG

CCTC_IDME_OPTIN_TS

SG v.4.9.0

idmeWorkflowStatus

idme_workflow_status

PS_CCTC_INTL_STG

CCTC_IDME_WKFL_STS

SG v.4.9.0

intended4YearMajor

intended_4_year_major

PS_CCTC_INTL_STG

CCTC_INTL_4YR_MJR

See here

ipAddress

ip_address

PS_CCTC_INTL_STG

CCTC_IP_ADDRESS

See here

issueDate

issue_date

PS_CCTC_INTL_STG

CCTC_ALIEN_REG_ISS

See here

lastPage

last_page

PS_CCTC_INTL_STG

CCTC_APPL_LAST_PG

See here

lastname

lastname

PS_CCTC_INTL_STG

CCTC_LGL_LAST_NM

See here

mainPhoneAuthTxt

main_phone_auth_txt

PS_CCTC_INTL_STG

CCTC_PHONE_MAINSMS

See here

mainPhoneExt

main_phone_ext

PS_CCTC_INTL_STG

CCTC_PHONE_MAIN_EX

See here

mainPhoneNumber

main_phone_number

PS_CCTC_INTL_STG

CCTC_PHONE_MAIN

See here

mainPhoneVerified

main_phone_verified

PS_CCTC_INTL_STG

CCTC_PHONE_MN_VER

See here

mainPhoneVerifiedTimestamp

main_phone_verified_timestamp

PS_CCTC_INTL_STG

CCTC_PHONE_MN_VRTS

See here

majorCode

major_code

PS_CCTC_INTL_STG

CCTC_APPL_MJR_CD

See here

majorDescription

major_description

PS_CCTC_INTL_STG

CCTC_APPL_MJR_DS

See here

majorCategory

major_category

PS_CCTC_INTL_STG

CCTC_APPL_MJR_CAT

See here

cipCode

cip_code

PS_CCTC_INTL_STG

CCTC_APPL_MJR_CIP

See here

noI94ExpirationDate

no_i94_expiration_date

PS_CCTC_INTL_STG

CCTC_INTL_I94NOEXP

See here

noVisa

no_visa

PS_CCTC_INTL_STG

CCTC_VISA_NONE

See here

nonUsAddress

non_us_address

PS_CCTC_INTL_STG

CCTC_INTL_AGTUSA

See here

nonUsPermanentHomeAddressSameAsPermanent

non_us_permanent_home_address_same_as_permanent

PS_CCTC_INTL_STG

CCTC_INTL_ADDRSAME

See here

nonUsPermanentHomeAddressVerified

non_us_permanent_home_address_verified

PS_CCTC_INTL_STG

CCTC_INTL_ADDRVALD

See here

nonUsPermanentHomeCity

non_us_permanent_home_city

PS_CCTC_INTL_STG

CCTC_INTL_ADDRCITY

See here

nonUsPermanentHomeCountry

non_us_permanent_home_country

PS_CCTC_INTL_STG

CCTC_INTL_ADDRCTRY

See here

nonUsPermanentHomeNonUsAddress

non_us_permanent_home_non_us_address

PS_CCTC_INTL_STG

CCTC_INTL_ADDR_USA

See here

nonUsPermanentHomeNonUsPostalCode

non_us_permanent_home_non_us_postal_code

PS_CCTC_INTL_STG

CCTC_INTL_ADDRIZIP

See here

nonUsPermanentHomeNonUsProvince

non_us_permanent_home_non_us_province

PS_CCTC_INTL_STG

CCTC_INTL_ADDR_PRV

See here

nonUsPermanentHomeStreet1

non_us_permanent_home_street_1

PS_CCTC_INTL_STG

CCTC_INTL_ADDRLIN1

See here

nonUsPermanentHomeStreet2

non_us_permanent_home_street_2

PS_CCTC_INTL_STG

CCTC_INTL_ADDRLIN2

See here

noNonUsPermanentAddrHomeless

non_us_permanent_home_homeless

PS_CCTC_INTL_STG

CCTC_INTL_ADDRHMLS

See here

nonUsPhoneAuthTxt

non_us_phone_auth_txt

PS_CCTC_INTL_STG

CCTC_INTL_1PHNESMS

See here

nonUsPhoneExt

non_us_phone_ext

PS_CCTC_INTL_STG

CCTC_INTL_1PHNEEXT

See here

nonUsPhoneNumber

non_us_phone_number

PS_CCTC_INTL_STG

CCTC_INTL_1PHNE

See here

nonUsPostalCode

non_us_postal_code

PS_CCTC_INTL_STG

CCTC_INTL_AGTIZIP

See here

nonUsProvince

non_us_province

PS_CCTC_INTL_STG

CCTC_INTL_AGTPRVNC

See here

numberOfDependents

number_of_dependents

PS_CCTC_INTL_STG

CCTC_NBR_DEPENDENT

See here

numberOfPracticalTraining

number_of_practical_training

PS_CCTC_INTL_STG

CCTC_INTL_NBR_PT

See here

otherfirstname

otherfirstname

PS_CCTC_INTL_STG

CCTC_AKA_FIRST_NM

See here

otherlastname

otherlastname

PS_CCTC_INTL_STG

CCTC_AKA_LAST_NM

See here

othermiddlename

othermiddlename

PS_CCTC_INTL_STG

CCTC_AKA_MIDDLE_NM

See here

parentGuardianAddressVerified

parent_guardian_address_verified

PS_CCTC_INTL_STG

CCTC_PG1_ADDRVALID

See here

parentGuardianCity

parent_guardian_city

PS_CCTC_INTL_STG

CCTC_PG1_ADDR_CITY

See here

parentGuardianCountry

parent_guardian_country

PS_CCTC_INTL_STG

CCTC_PG1_ADDR_CTRY

See here

parentGuardianEmail

parent_guardian_email

PS_CCTC_INTL_STG

CCTC_PG1_EMAIL

See here

parentGuardianFirstName

parent_guardian_first_name

PS_CCTC_INTL_STG

CCTC_PG1_FIRST_NM

See here

parentGuardianLastName

parent_guardian_last_name

PS_CCTC_INTL_STG

CCTC_PG1_LAST_NM

See here

parentGuardianNoFirstName

parent_guardian_no_first_name

PS_CCTC_INTL_STG

CCTC_PG1_NO_FN

See here

parentGuardianNonUsPostalCode

parentGuardianNonUsAddress

parent_guardian_non_us_address

PS_CCTC_INTL_STG

CCTC_PG1_ADDR_USA

See here

parentGuardianNonUsPostalCode

parent_guardian_non_us_postal_code

PS_CCTC_INTL_STG

CCTC_PG1_ADDR_IZIP

See here

parentGuardianNonUsProvince

parent_guardian_non_us_province

PS_CCTC_INTL_STG

CCTC_PG1_ADDR_PRV

See here

parentGuardianPhoneAuthTxt

parent_guardian_phone_auth_txt

PS_CCTC_INTL_STG

CCTC_PG1_PHONESMS

See here

parentGuardianPhoneExt

parent_guardian_phone_ext

PS_CCTC_INTL_STG

CCTC_PG1_PHONEEXT

See here

parentGuardianPhoneNumber

parent_guardian_phone_number

PS_CCTC_INTL_STG

CCTC_PG1_PHONE

See here

parentGuardianRelationship

parent_guardian_relationship

PS_CCTC_INTL_STG

CCTC_PG1_RELATION

See here

parentGuardianState

parent_guardian_state

PS_CCTC_INTL_STG

CCTC_PG1_ADDRSTTE

See here

parentGuardianStreet1

parent_guardian_street_1

PS_CCTC_INTL_STG

CCTC_PG1_ADDRLIN1

See here

parentGuardianStreet2

parent_guardian_street_2

PS_CCTC_INTL_STG

CCTC_PG1_ADDRLIN2

See here

parentGuardianZipCode

parent_guardian_zip_code

PS_CCTC_INTL_STG

CCTC_PG1_ADDRPOST

See here

passportCountryOfIssuance

passport_country_of_issuance

PS_CCTC_INTL_STG

CCTC_INTL_PP_CNTRY

See here

passportExpirationDate

passport_expiration_date

PS_CCTC_INTL_STG

CCTC_INTL_PP_EXP

See here

passportNotYet

passport_not_yet

PS_CCTC_INTL_STG

CCTC_INTL_PP_NONE

See here

passportNumber

passport_number

PS_CCTC_INTL_STG

CCTC_INTL_PP_NBR

See here

permAddrAddressVerified

perm_addr_address_verified

PS_CCTC_INTL_STG

CCTC_PADDR_VALID

See here

permAddrCity

perm_addr_city

PS_CCTC_INTL_STG

CCTC_PADDR_CITY

See here

permAddrCountry

perm_addr_country

PS_CCTC_INTL_STG

CCTC_PADDR_COUNTRY

See here

permAddrNonUsAddress

perm_addr_non_us_address

PS_CCTC_INTL_STG

CCTC_PADDR_USA

See here

permAddrNonUsPostalCode

perm_addr_non_us_postal_code

PS_CCTC_INTL_STG

CCTC_PADDR_IZIP

See here

permAddrNonUsProvince

perm_addr_non_us_province

PS_CCTC_INTL_STG

CCTC_PADDR_PRVINCE

See here

permAddrState

perm_addr_state

PS_CCTC_INTL_STG

CCTC_PADDR_STATE

See here

permAddrStreet1

perm_addr_street_1

PS_CCTC_INTL_STG

CCTC_PADDR_LINE1

See here

permAddrStreet2

perm_addr_street_2

PS_CCTC_INTL_STG

CCTC_PADDR_LINE2

See here

permAddrZipCode

perm_addr_zip_code

PS_CCTC_INTL_STG

CCTC_PADDR_POSTCD

See here

noPermAddressHomeless

no_perm_address_homeless

PS_CCTC_INTL_STG

CCTC_PADDR_HOMELSS

See here

phoneAuthTxt

phone_auth_txt

PS_CCTC_INTL_STG

CCTC_INTL_3PHNESMS

See here

phoneExt

phone_ext

PS_CCTC_INTL_STG

CCTC_INTL_3PHNEEXT

See here

phoneNumber

phone_number

PS_CCTC_INTL_STG

CCTC_INTL_3PHNE

See here

preferredFirstname

preferred_firstname

PS_CCTC_INTL_STG

CCTC_PRF_FIRST_NM

See here

preferredLastname

preferred_lastname

PS_CCTC_INTL_STG

CCTC_PRF_LAST_NM

See here

preferredMiddlename

preferred_middlename

PS_CCTC_INTL_STG

CCTC_PRF_MIDDLE_NM

See here

preferredName

preferred_name

PS_CCTC_INTL_STG

CCTC_PRF_NM_SET

See here

presentlyStudyingInUs

presently_studying_in_us

PS_CCTC_INTL_STG

CCTC_INTL_STDY_USA

See here

primaryLanguage

primary_language

PS_CCTC_INTL_STG

CCTC_LANG_CD

See here

pt1AuthorizingSchool

pt1_authorizing_school

PS_CCTC_INTL_STG

CCTC_PT1_SCHOOL_NM

See here

pt1EndDate

pt1_end_date

PS_CCTC_INTL_STG

CCTC_PT1_END_DT

See here

pt1PracticalTrainingId

pt1_practical_training_id

Not Supported

pt1Type



pt1StartDate

pt1_start_date

PS_CCTC_INTL_STG

CCTC_PT1_START_DT

See here

pt1Type

pt1_type

PS_CCTC_INTL_STG

CCTC_PT1_TYPE

See here

pt2AuthorizingSchool

pt2_authorizing_school

PS_CCTC_INTL_STG

CCTC_PT2_SCHOOL_NM

See here

pt2EndDate

pt2_end_date

PS_CCTC_INTL_STG

CCTC_PT2_END_DT

See here

pt2PracticalTrainingId

pt2_practical_training_id

Not Supported



pt2StartDate

pt2_start_date

PS_CCTC_INTL_STG

CCTC_PT2_START_DT

See here

pt2Type

pt2_type

PS_CCTC_INTL_STG

CCTC_PT2_TYPE

See here

pt3AuthorizingSchool

pt3_authorizing_school

PS_CCTC_INTL_STG

CCTC_PT3_SCHOOL_NM

See here

pt3EndDate

pt3_end_date

PS_CCTC_INTL_STG

CCTC_PT3_END_DT

See here

pt3PracticalTrainingId

pt3_practical_training_id

Not Supported



pt3StartDate

pt3_start_date

PS_CCTC_INTL_STG

CCTC_PT3_START_DT

See here

pt3Type

pt3_type

PS_CCTC_INTL_STG

CCTC_PT3_TYPE

See here

pt4AuthorizingSchool

pt4_authorizing_school

PS_CCTC_INTL_STG

CCTC_PT4_SCHOOL_NM

See here

pt4EndDate

pt4_end_date

PS_CCTC_INTL_STG

CCTC_PT4_END_DT

See here

pt4PracticalTrainingId

pt4_practical_training_id

Not Supported



pt4StartDate

pt4_start_date

PS_CCTC_INTL_STG

CCTC_PT4_START_DT

See here

pt4Type

pt4_type

PS_CCTC_INTL_STG

CCTC_PT4_TYPE

See here

raceEthnicity

race_ethnicity

PS_CCTC_INTL_STG

CCTC_RACE_ETH_FLGS

See here

raceEthnicFull

race_ethnic_full

PS_CCTC_INTL_STG

CCTC_RACE_ETHNIC_F

See here

raceGroup

race_group

PS_CCTC_INTL_STG

CCTC_RACE_GROUP

See here

residesInUs

resides_in_us

PS_CCTC_INTL_STG

CCTC_INTL_RESIDEUS

See here

salt

salt

Not Supported



secondPhoneAuthTxt

second_phone_auth_txt

PS_CCTC_INTL_STG

CCTC_PHONE_SCNDSMS

See here

secondPhoneExt

second_phone_ext

PS_CCTC_INTL_STG

CCTC_PHONE_SCND_EX

See here

secondPhoneNumber

second_phone_number

PS_CCTC_INTL_STG

CCTC_PHONE_SCND

See here

sevisIdNumber

sevis_id_number

PS_CCTC_INTL_STG

CCTC_SEVIS_ID

See here

signature

signature

Not Supported



ssn

ssn

PS_CCTC_INTL_STG

CCTC_SSN

See here

ssnNo

ssn_no

PS_CCTC_INTL_STG

CCTC_APPL_SSN_NONE

See here

ssnException

ssn_exception

PS_CCTC_INTL_STG

CCTC_APPL_SSN_EXCP

See here

ssnLast4

ssn_last4

PS_CCTC_INTL_STG

CCTC_SSN_LST4

See here

ssnType

ssn_type

PS_CCTC_INTL_STG

CCTC_APPL_SSN_TYPE

See here

state

state

PS_CCTC_INTL_STG

CCTC_INTL_AGTSTATE

See here

status

status

PS_CCTC_INTL_STG

CCTC_APPL_STATUS

See here

street1

street_1

PS_CCTC_INTL_STG

CCTC_INTL_AGTLINE1

See here

street2

street_2

PS_CCTC_INTL_STG

CCTC_INTL_AGTLINE2

See here

suffix

suffix

PS_CCTC_INTL_STG

CCTC_LGL_SUFFIX

See here

supPageCode

sup_page_code

PS_CCTC_INTL_STG

CCTC_APPL_SQ_PG_CD

See here

termEndDate

term_end_date

PS_CCTC_INTL_STG

CCTC_TERM_END_DT

See here

termStartDate

termStartDate

term_start_date

PS_CCTC_INTL_STG

CCTC_TERM_START_DT

See here

tstmpCreate

tstmp_create

PS_CCTC_INTL_STG

CCTC_APPL_CRTE_TS

See here

tstmpDownload

tstmp_download

PS_CCTC_INTL_STG

CCTC_APPL_DWNLD_TS

See here

tstmpSubmit

tstmp_submit

PS_CCTC_INTL_STG

CCTC_APPL_SBMT_TS

See here

tstmpUpdate

tstmp_update

PS_CCTC_INTL_STG

CCTC_APPL_UPDT_TS

See here

visaType

visa_type

PS_CCTC_INTL_STG

CCTC_VISA_TYPE

See here

zipCode

zip_code

PS_CCTC_INTL_STG

CCTC_INTL_AGTPOST

See here



PS_CCTC_INTL_STG

STATUS_FLAG

A blank value whenever a new row is created. May be optionally used by the college to track processing



PS_CCTC_INTL_STG

STATUS_DTTM

Used for tracking/processing; defaults to the current date/time when a row is created, but should be updated if/when the STATUS_FLAG field is changed



PS_CCTC_INTL_STG

DESCRLONG_NOTES

A blank value whenever a new row is created. May be optionally used by the college to track processing



PS_CCTC_INTL_STG

LASTUPDOPRID

The default value is “CCTC” when a row is created, but this value should be updated to whichever operatorID the college’s IT department changes it to, if desired



PS_CCTC_INTL_STG

LASTUPDDTTM

Last updated date/time

Supplemental Questions Data Fields Mappings - PeopleSoft

The table below pertains to the International App Supplemental Questions fields.

CCC Field Name

PeopleSoft DB Staging Table

PeopleSoft Field Name

Explanation

app_id

PS_CCTC_INTLSQ_STG

CCTC_APPL_ID

See here

supp_text_01

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_01

See here

supp_text_02

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_02

See here

supp_text_03

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_03

See here

supp_text_04

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_04

See here

supp_text_05

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_05

See here

supp_text_06

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_06

See here

supp_text_07

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_07

See here

supp_text_08

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_08

See here

supp_text_09

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_09

See here

supp_text_10

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_10

See here

supp_text_11

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_11

See here

supp_text_12

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_12

See here

supp_text_13

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_13

See here

supp_text_14

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_14

See here

supp_text_15

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_15

See here

supp_text_16

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_16

See here

supp_text_17

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_17

See here

supp_text_18

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_18

See here

supp_text_19

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_19

See here

supp_text_20

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_TXT_20

See here

supp_check_01

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_01

See here

supp_check_02

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_02

See here

supp_check_03

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_03

See here

supp_check_04

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_04

See here

supp_check_05

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_05

See here

supp_check_06

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_06

See here

supp_check_07

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_07

See here

supp_check_08

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_08

See here

supp_check_09

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_09

See here

supp_check_10

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_10

See here

supp_check_11

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_11

See here

supp_check_12

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_12

See here

supp_check_13

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_13

See here

supp_check_14

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_14

See here

supp_check_15

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_15

See here

supp_check_16

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_16

See here

supp_check_17

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_17

See here

supp_check_18

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_18

See here

supp_check_19

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_19

See here

supp_check_20

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_20

See here

supp_check_21

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_21

See here

supp_check_22

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_22

See here

supp_check_23

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_23

See here

supp_check_24

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_24

See here

supp_check_25

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_25

See here

supp_check_26

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_26

See here

supp_check_27

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_27

See here

supp_check_28

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_28

See here

supp_check_29

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_29

See here

supp_check_30

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_30

See here

supp_check_31

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_31

See here

supp_check_32

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_32

See here

supp_check_33

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_33

See here

supp_check_34

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_34

See here

supp_check_35

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_35

See here

supp_check_36

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_36

See here

supp_check_37

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_37

See here

supp_check_38

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_38

See here

supp_check_39

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_39

See here

supp_check_40

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_40

See here

supp_check_41

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_41

See here

supp_check_42

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_42

See here

supp_check_43

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_43

See here

supp_check_44

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_44

See here

supp_check_45

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_45

See here

supp_check_46

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_46

See here

supp_check_47

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_47

See here

supp_check_48

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_48

See here

supp_check_49

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_49

See here

supp_check_50

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CBX_50

See here

supp_yesno_01

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_01

See here

supp_yesno_02

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_02

See here

supp_yesno_03

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_03

See here

supp_yesno_04

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_04

See here

supp_yesno_05

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_05

See here

supp_yesno_06

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_06

See here

supp_yesno_07

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_07

See here

supp_yesno_08

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_08

See here

supp_yesno_09

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_09

See here

supp_yesno_10

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_10

See here

supp_yesno_11

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_11

See here

supp_yesno_12

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_12

See here

supp_yesno_13

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_13

See here

supp_yesno_14

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_14

See here

supp_yesno_15

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_15

See here

supp_yesno_16

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_16

See here

supp_yesno_17

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_17

See here

supp_yesno_18

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_18

See here

supp_yesno_19

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_19

See here

supp_yesno_20

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_20

See here

supp_yesno_21

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_21

See here

supp_yesno_22

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_22

See here

supp_yesno_23

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_23

See here

supp_yesno_24

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_24

See here

supp_yesno_25

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_25

See here

supp_yesno_26

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_26

See here

supp_yesno_27

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_27

See here

supp_yesno_28

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_28

See here

supp_yesno_29

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_29

See here

supp_yesno_30

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_YN_30

See here

supp_menu_01

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_01

See here

supp_menu_02

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_02

See here

supp_menu_03

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_03

See here

supp_menu_04

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_04

See here

supp_menu_05

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_05

See here

supp_menu_06

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_06

See here

supp_menu_07

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_07

See here

supp_menu_08

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_08

See here

supp_menu_09

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_09

See here

supp_menu_10

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_10

See here

supp_menu_11

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_11

See here

supp_menu_12

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_12

See here

supp_menu_13

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_13

See here

supp_menu_14

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_14

See here

supp_menu_15

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_15

See here

supp_menu_16

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_16

See here

supp_menu_17

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_17

See here

supp_menu_18

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_18

See here

supp_menu_19

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_19

See here

supp_menu_20

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_20

See here

supp_menu_21

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_21

See here

supp_menu_22

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_22

See here

supp_menu_23

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_23

See here

supp_menu_24

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_24

See here

supp_menu_25

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_25

See here

supp_menu_26

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_26

See here

supp_menu_27

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_27

See here

supp_menu_28

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_28

See here

supp_menu_29

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_29

See here

supp_menu_30

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_MNU_30

See here

supp_date_01

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_DT_01

See here

supp_date_02

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_DT_02

See here

supp_date_03

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_DT_03

See here

supp_date_04

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_DT_04

See here

supp_date_05

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_DT_05

See here

supp_state_01

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_ST_01

See here

supp_state_02

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_ST_02

See here

supp_state_03

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_ST_03

See here

supp_state_04

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_ST_04

See here

supp_state_05

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_ST_05

See here

supp_country_01

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CT_01

See here

supp_country_02

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CT_02

See here

supp_country_03

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CT_03

See here

supp_country_04

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CT_04

See here

supp_country_05

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_CT_05

See here

supp_phonenumber_01

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_PHN_01

See here

supp_phonenumber_02

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_PHN_02

See here

supp_phonenumber_03

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_PHN_03

See here

supp_phonenumber_04

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_PHN_04

See here

supp_phonenumber_05

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_PHN_05

See here

supp_secret_01

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_SCT_01

See here

supp_secret_02

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_SCT_02

See here

supp_secret_03

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_SCT_03

See here

supp_secret_04

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_SCT_04

See here

supp_secret_05

PS_CCTC_INTLSQ_STG

CCTC_APPLSQ_SCT_05

See here


PS_CCTC_INTLSQ_STG

STATUS_FLAG

A single blank character whenever a new row is created. May be optionally used by the college to track processing


PS_CCTC_INTLSQ_STG

STATUS_DTTM

Used for tracking/processing; defaults to the current date/time when a row is created, should be updated if/when the STATUS_FLAG field is changed


PS_CCTC_INTLSQ_STG

DESCRLONG_NOTES

A blank value whenever a new row is created. May be optionally used by the college to track processing


PS_CCTC_INTLSQ_STG

LASTUPDOPRID

The default value is “CCTC” when a row is created, but this value should be updated to whichever operatorID the college’s IT department changes it to, if desired


PS_CCTC_INTLSQ_STG

LASTUPDDTTM

Last updated date/time