...
For more details, see the CCCApply International Application data dictionary.
College Adaptor Payload Field | CCC Field Name | Banner DB Staging Table | Banner Field Name | VERSION Release |
|---|---|---|---|---|
appId | app_id | SZRINTL | APP_ID | |
cccId | ccc_id | SZRINTL | CCC_ID | |
collegeId | college_id | SZRINTL | COLLEGE_ID | |
addressVerified | address_verified | SZRINTL | ADDRESS_VERIFIED | |
agentPhoneExt | agent_phone_ext | SZRINTL | AGENT_PHONE_EXT | |
agentPhoneNumber | agent_phone_number | SZRINTL | AGENT_PHONE_NUMBER | |
altNonUsPhoneAuthTxt | alt_non_us_phone_auth_txt | SZRINTL | ALT_NON_US_PHONE_AUTH_TXT | |
altNonUsPhoneExt | alt_non_us_phone_ext | SZRINTL | ALT_NON_US_PHONE_EXT | |
altNonUsPhoneNumber | alt_non_us_phone_number | SZRINTL | ALT_NON_US_PHONE_NUMBER | |
appLang | app_lang | SZRINTL | APP_LANG | |
authorizeAgentInfoRelease | authorize_agent_info_release | SZRINTL | AUTHORIZE_AGENT_INFO_RELEASE | |
birthdate | birthdate | SZRINTL | BIRTH_DATE | |
campaign1 | campaign1 | SZRINTL | CAMPAIGN1 | |
coenrollConfirm | coenroll_confirm | SZRINTL | COENROLL_CONFIRM | |
campaign2 | campaign2 | SZRINTL | CAMPAIGN2 | |
campaign3 | campaign3 | SZRINTL | CAMPAIGN3 | |
citizenshipStatus | citizenship_status | SZRINTL | CITIZENSHIP_STATUS | |
city | city | SZRINTL | CITY | |
col1Cds | col1_cds | SZRINTL | COL1_CDS | |
col1CdsFull | col1_cds_full | SZRINTL | COL1_CDS_FULL | |
col1Ceeb | col1_ceeb | SZRINTL | COL1_CEEB | |
col1City | col1_city | SZRINTL | COL1_CITY | |
col1CollegeAttendedId | col1_college_attended_id | SZRINTL | COL1_COLLEGE_ATTENDED_ID | |
col1Country | col1_country | SZRINTL | COL1_COUNTRY | |
col1DegreeDate | col1_degree_date | SZRINTL | COL1_DEGREE_DATE | |
col1DegreeObtained | col1_degree_obtained | SZRINTL | COL1_DEGREE_OBTAINED | |
col1EndDate | col1_end_date | SZRINTL | COL1_END_DATE | |
col1ExpelledStatus | col1_expelled_status | SZRINTL | COL1_EXPELLED_STATUS | |
col1Major | col1_major | SZRINTL | COL1_MAJOR | |
col1Name | col1_name | SZRINTL | COL1_NAME | |
col1NonUsProvince | col1_non_us_province | SZRINTL | COL1_NON_US_PROVINCE | |
col1NotListed | col1_not_listed | SZRINTL | COL1_NOT_LISTED | |
col1PrimaryInstructionLanguage | col1_primary_instruction_language | SZRINTL | COL1_PRIMARY_INSTR_LANG | |
col1StartDate | col1_start_date | SZRINTL | COL1_START_DATE | |
col1State | col1_state | SZRINTL | COL1_STATE | |
col2Cds | col2_cds | SZRINTL | COL2_CDS | |
col2CdsFull | col2_cds_full | SZRINTL | COL2_CDS_FULL | |
col2Ceeb | col2_ceeb | SZRINTL | COL2_CEEB | |
col2City | col2_city | SZRINTL | COL2_CITY | |
col2CollegeAttendedId | col2_college_attended_id | SZRINTL | COL2_COLLEGE_ATTENDED_ID | |
col2Country | col2_country | SZRINTL | COL2_COUNTRY | |
col2DegreeDate | col2_degree_date | SZRINTL | COL2_DEGREE_DATE | |
col2DegreeObtained | col2_degree_obtained | SZRINTL | COL2_DEGREE_OBTAINED | |
col2EndDate | col2_end_date | SZRINTL | COL2_END_DATE | |
col2ExpelledStatus | col2_expelled_status | SZRINTL | COL2_EXPELLED_STATUS | |
col2Major | col2_major | SZRINTL | COL2_MAJOR | |
col2Name | col2_name | SZRINTL | COL2_NAME | |
col2NonUsProvince | col2_non_us_province | SZRINTL | COL2_NON_US_PROVINCE | |
col2NotListed | col2_not_listed | SZRINTL | COL2_NOT_LISTED | |
col2PrimaryInstructionLanguage | col2_primary_instruction_language | SZRINTL | COL2_PRIMARY_INSTR_LANG | |
col2StartDate | col2_start_date | SZRINTL | COL2_START_DATE | |
col2State | col2_state | SZRINTL | COL2_STATE | |
col3Cds | col3_cds | SZRINTL | COL3_CDS | |
col3CdsFull | col3_cds_full | SZRINTL | COL3_CDS_FULL | |
col3Ceeb | col3_ceeb | SZRINTL | COL3_CEEB | |
col3City | col3_city | SZRINTL | COL3_CITY | |
col3CollegeAttendedId | col3_college_attended_id | SZRINTL | COL3_COLLEGE_ATTENDED_ID | |
col3Country | col3_country | SZRINTL | COL3_COUNTRY | |
col3DegreeDate | col3_degree_date | SZRINTL | COL3_DEGREE_DATE | |
col3DegreeObtained | col3_degree_obtained | SZRINTL | COL3_DEGREE_OBTAINED | |
col3EndDate | col3_end_date | SZRINTL | COL3_END_DATE | |
col3ExpelledStatus | col3_expelled_status | SZRINTL | COL3_EXPELLED_STATUS | |
col3Major | col3_major | SZRINTL | COL3_MAJOR | |
col3Name | col3_name | SZRINTL | COL3_NAME | |
col3NonUsProvince | col3_non_us_province | SZRINTL | COL3_NON_US_PROVINCE | |
col3NotListed | col3_not_listed | SZRINTL | COL3_NOT_LISTED | |
col3PrimaryInstructionLanguage | col3_primary_instruction_language | SZRINTL | COL3_PRIMARY_INSTR_LANG | |
col3StartDate | col3_start_date | SZRINTL | COL3_START_DATE | |
col3State | col3_state | SZRINTL | COL3_STATE | |
col4Cds | col4_cds | SZRINTL | COL4_CDS | |
col4CdsFull | col4_cds_full | SXRINTL | COL4_CDS_FULL | |
col4Ceeb | col4_ceeb | SZRINTL | COL4_CEEB | |
col4City | col4_city | SZRINTL | COL4_CITY | |
col4CollegeAttendedId | col4_college_attended_id | SZRINTL | COL4_COLLEGE_ATTENDED_ID | |
col4Country | col4_country | SZRINTL | COL4_COUNTRY | |
col4DegreeDate | col4_degree_date | SZRINTL | COL4_DEGREE_DATE | |
col4DegreeObtained | col4_degree_obtained | SZRINTL | COL4_DEGREE_OBTAINED | |
col4EndDate | col4_end_date | SZRINTL | COL4_END_DATE | |
col4ExpelledStatus | col4_expelled_status | SZRINTL | COL4_EXPELLED_STATUS | |
col4Major | col4_major | SZRINTL | COL4_MAJOR | |
col4Name | col4_name | SZRINTL | COL4_NAME | |
col4NonUsProvince | col4_non_us_province | SZRINTL | COL4_NON_US_PROVINCE | |
col4NotListed | col4_not_listed | SZRINTL | COL4_NOT_LISTED | |
col4PrimaryInstructionLanguage | col4_primary_instruction_language | SZRINTL | COL4_PRIMARY_INSTR_LANG | |
col4StartDate | col4_start_date | SZRINTL | COL4_START_DATE | |
col4State | col4_state | SZRINTL | COL4_STATE | |
collegeCompDate | college_comp_date | SZRINTL | COLLEGE_COMP_DATE | |
collegeCount | college_count | SZRINTL | COLLEGE_COUNT | |
collegeEduLevel | college_edu_level | SZRINTL | COLLEGE_EDU_LEVEL | |
collegeExpelledSummary | college_expelled_summary | SZRINTL | COLLEGE_EXPELLED_SUMMARY | |
collegeName | college_name | SZRINTL | COLLEGE_NAME | |
company | company | SZRINTL | CURR_MAILNG_CITY | |
confirmation | confirmation | SZRINTL | CURR_MAILNG_COUNTRY | |
consent | consent | SZRINTL | CURR_MAILNG_NON_US_ADDRESS | |
contact | contact | SZRINTL | CURR_MAILNG_NON_US_POSTAL_CODE | |
country | country | SZRINTL | CURR_MAILNG_NON_US_PROVINCE | |
countryOfBirth | country_of_birth | SZRINTL | COUNTRY_OF_BIRTH | |
countryOfCitizenship | country_of_citizenship | SZRINTL | COUNTRY_OF_CITIZENSHIP | |
cryptokeyid | cryptokeyid | |||
currentMailingAddressOutsideUs | current_mailing_address_outside_us | SZRINTL | CURR_MAILNG_ADDR_OUTSIDE_US | |
currentMailingAddressVerified | current_mailing_address_verified | SZRINTL | CURR_MAILNG_ADDR_VERIFIED | |
currentMailingCity | current_mailing_city | SZRINTL | CURR_MAILNG_CITY | |
currentMailingCountry | current_mailing_country | SZRINTL | CURR_MAILNG_COUNTRY | |
currentMailingNonUsAddress | current_mailing_non_us_address | SZRINTL | CURR_MAILNG_NON_US_ADDRESS | |
currentMailingNonUsPostalCode | current_mailing_non_us_postal_code | SZRINTL | CURR_MAILNG_NON_US_POSTAL_CODE | |
currentMailingNonUsProvince | current_mailing_non_us_province | SZRINTL | CURR_MAILNG_NON_US_PROVINCE | |
currentMailingSameAsPermanent | current_mailing_same_as_permanent | SZRINTL | CURR_MAILNG_SAME_AS_PERMANENT | |
currentMailingState | current_mailing_state | SZRINTL | CURR_MAILNG_STATE | |
currentMailingStreet1 | current_mailing_street_1 | SZRINTL | CURR_MAILNG_STREET_1 | |
currentMailingStreet2 | current_mailing_street_2 | SZRINTL | CURR_MAILNG_STREET_2 | |
currentMailingZipCode | current_mailing_zip_code | SZRINTL | CURR_MAILNG_ZIP_CODE | |
dep1CountryOfBirth | dep1_country_of_birth | SZRINTL | DEP1_COUNTRY_OF_BIRTH | |
dep1DateOfBirth | dep1_date_of_birth | SZRINTL | DEP1_DATE_OF_BIRTH | |
dep1DependentId | dep1_dependent_id | SZRINTL | DEP1_DEPENDENT_ID | |
dep1FirstName | dep1_first_name | SZRINTL | DEP1_FIRST_NAME | |
dep1Gender | dep1_gender | SZRINTL | DEP1_GENDER | |
dep1LastName | dep1_last_name | SZRINTL | DEP1_LAST_NAME | |
dep1NoFirstName | dep1_no_first_name | SZRINTL | DEP1_NO_FIRST_NAME | |
dep1Relationship | dep1_relationship | SZRINTL | DEP1_RELATIONSHIP | |
dep10CountryOfBirth | dep10_country_of_birth | SZRINTL | DEP10_COUNTRY_OF_BIRTH | |
dep10DateOfBirth | dep10_date_of_birth | SZRINTL | DEP10_DATE_OF_BIRTH | |
dep10DependentId | dep10_dependent_id | SZRINTL | DEP10_DEPENDENT_ID | |
dep10FirstName | dep10_first_name | SZRINTL | DEP10_FIRST_NAME | |
dep10Gender | dep10_gender | SZRINTL | DEP10_GENDER | |
dep10LastName | dep10_last_name | SZRINTL | DEP10_LAST_NAME | |
dep10NoFirstName | dep10_no_first_name | SZRINTL | DEP10_NO_FIRST_NAME | |
dep10Relationship | dep10_relationship | SZRINTL | DEP10_RELATIONSHIP | |
dep2CountryOfBirth | dep2_country_of_birth | SZRINTL | DEP2_COUNTRY_OF_BIRTH | |
dep2DateOfBirth | dep2_date_of_birth | SZRINTL | DEP2_DATE_OF_BIRTH | |
dep2DependentId | dep2_dependent_id | SZRINTL | DEP2_DEPENDENT_ID | |
dep2FirstName | dep2_first_name | SZRINTL | DEP2_FIRST_NAME | |
dep2Gender | dep2_gender | SZRINTL | DEP2_GENDER | |
dep2LastName | dep2_last_name | SZRINTL | DEP2_LAST_NAME | |
dep2NoFirstName | dep2_no_first_name | SZRINTL | DEP2_NO_FIRST_NAME | |
dep2Relationship | dep2_relationship | SZRINTL | DEP2_RELATIONSHIP | |
dep3CountryOfBirth | dep3_country_of_birth | SZRINTL | DEP3_COUNTRY_OF_BIRTH | |
dep3DateOfBirth | dep3_date_of_birth | SZRINTL | DEP3_DATE_OF_BIRTH | |
dep3DependentId | dep3_dependent_id | SZRINTL | DEP3_DEPENDENT_ID | |
dep3FirstName | dep3_first_name | SZRINTL | DEP3_FIRST_NAME | |
dep3Gender | dep3_gender | SZRINTL | DEP3_GENDER | |
dep3LastName | dep3_last_name | SZRINTL | DEP3_LAST_NAME | |
dep3NoFirstName | dep3_no_first_name | SZRINTL | DEP3_NO_FIRST_NAME | |
dep3Relationship | dep3_relationship | SZRINTL | DEP3_RELATIONSHIP | |
dep4CountryOfBirth | dep4_country_of_birth | SZRINTL | DEP4_COUNTRY_OF_BIRTH | |
dep4DateOfBirth | dep4_date_of_birth | SZRINTL | DEP4_DATE_OF_BIRTH | |
dep4DependentId | dep4_dependent_id | SZRINTL | DEP4_DEPENDENT_ID | |
dep4FirstName | dep4_first_name | SZRINTL | DEP4_FIRST_NAME | |
dep4Gender | dep4_gender | SZRINTL | DEP4_GENDER | |
dep4LastName | dep4_last_name | SZRINTL | DEP4_LAST_NAME | |
dep4NoFirstName | dep4_no_first_name | SZRINTL | DEP4_NO_FIRST_NAME | |
dep4Relationship | dep4_relationship | SZRINTL | DEP4_RELATIONSHIP | |
dep5CountryOfBirth | dep5_country_of_birth | SZRINTL | DEP5_COUNTRY_OF_BIRTH | |
dep5DateOfBirth | dep5_date_of_birth | SZRINTL | DEP5_DATE_OF_BIRTH | |
dep5DependentId | dep5_dependent_id | SZRINTL | DEP5_DEPENDENT_ID | |
dep5FirstName | dep5_first_name | SZRINTL | DEP5_FIRST_NAME | |
dep5Gender | dep5_gender | SZRINTL | DEP5_GENDER | |
dep5LastName | dep5_last_name | SZRINTL | DEP5_LAST_NAME | |
dep5NoFirstName | dep5_no_first_name | SZRINTL | DEP5_NO_FIRST_NAME | |
dep5Relationship | dep5_relationship | SZRINTL | DEP5_RELATIONSHIP | |
dep6CountryOfBirth | dep6_country_of_birth | SZRINTL | DEP6_COUNTRY_OF_BIRTH | |
dep6DateOfBirth | dep6_date_of_birth | SZRINTL | DEP6_DATE_OF_BIRTH | |
dep6DependentId | dep6_dependent_id | SZRINTL | DEP6_DEPENDENT_ID | |
dep6FirstName | dep6_first_name | SZRINTL | DEP6_FIRST_NAME | |
dep6Gender | dep6_gender | SZRINTL | DEP6_GENDER | |
dep6LastName | dep6_last_name | SZRINTL | DEP6_LAST_NAME | |
dep6NoFirstName | dep6_no_first_name | SZRINTL | DEP6_NO_FIRST_NAME | |
dep6Relationship | dep6_relationship | SZRINTL | DEP6_RELATIONSHIP | |
dep7CountryOfBirth | dep7_country_of_birth | SZRINTL | DEP7_COUNTRY_OF_BIRTH | |
dep7DateOfBirth | dep7_date_of_birth | SZRINTL | DEP7_DATE_OF_BIRTH | |
dep7DependentId | dep7_dependent_id | SZRINTL | DEP7_DEPENDENT_ID | |
dep7FirstName | dep7_first_name | SZRINTL | DEP7_FIRST_NAME | |
dep7Gender | dep7_gender | SZRINTL | DEP7_GENDER | |
dep7LastName | dep7_last_name | SZRINTL | DEP7_LAST_NAME | |
dep7NoFirstName | dep7_no_first_name | SZRINTL | DEP7_NO_FIRST_NAME | |
dep7Relationship | dep7_relationship | SZRINTL | DEP7_RELATIONSHIP | |
dep8CountryOfBirth | dep8_country_of_birth | SZRINTL | DEP8_COUNTRY_OF_BIRTH | |
dep8DateOfBirth | dep8_date_of_birth | SZRINTL | DEP8_DATE_OF_BIRTH | |
dep8DependentId | dep8_dependent_id | SZRINTL | DEP8_DEPENDENT_ID | |
dep8FirstName | dep8_first_name | SZRINTL | DEP8_FIRST_NAME | |
dep8Gender | dep8_gender | SZRINTL | DEP8_GENDER | |
dep8LastName | dep8_last_name | SZRINTL | DEP8_LAST_NAME | |
dep8NoFirstName | dep8_no_first_name | SZRINTL | DEP8_NO_FIRST_NAME | |
dep8Relationship | dep8_relationship | SZRINTL | DEP8_RELATIONSHIP | |
dep9CountryOfBirth | dep9_country_of_birth | SZRINTL | DEP9_COUNTRY_OF_BIRTH | |
dep9DateOfBirth | dep9_date_of_birth | SZRINTL | DEP9_DATE_OF_BIRTH | |
dep9DependentId | dep9_dependent_id | SZRINTL | DEP9_DEPENDENT_ID | |
dep9FirstName | dep9_first_name | SZRINTL | DEP9_FIRST_NAME | |
dep9Gender | dep9_gender | SZRINTL | DEP9_GENDER | |
dep9LastName | dep9_last_name | SZRINTL | DEP9_LAST_NAME | |
dep9NoFirstName | dep9_no_first_name | SZRINTL | DEP9_NO_FIRST_NAME | |
dep9Relationship | dep9_relationship | SZRINTL | DEP9_RELATIONSHIP | |
educationalGoal | educational_goal | SZRINTL | EDUCATIONAL_GOAL | |
SZRINTL | ||||
emergencyContactAddressVerified | emergency_contact_address_verified | SZRINTL | EMER_CONT_ADDR_VERIFIED | |
emergencyContactCity | emergency_contact_city | SZRINTL | EMER_CONT_CITY | |
emergencyContactCountry | emergency_contact_country | SZRINTL | EMER_CONT_COUNTRY | |
emergencyContactEmail | emergency_contact_email | SZRINTL | EMER_CONT_EMAIL | |
emergencyContactFirstName | emergency_contact_first_name | SZRINTL | EMER_CONT_FIRST_NAME | |
emergencyContactLastName | emergency_contact_last_name | SZRINTL | EMER_CONT_LAST_NAME | |
emergencyContactNoFirstName | emergency_contact_no_first_name | SZRINTL | EMER_CONT_NO_FIRST_NAME | |
emergencyContactNonUsAddress | emergency_contact_non_us_address | SZRINTL | EMER_CONT_NON_US_ADDRESS | |
emergencyContactNonUsPostalCode | emergency_contact_non_us_postal_code | SZRINTL | EMER_CONT_NON_US_POSTAL_CODE | |
emergencyContactNonUsProvince | emergency_contact_non_us_province | SZRINTL | EMER_CONT_NON_US_PROVINCE | |
emergencyContactPhoneAuthTxt | emergency_contact_phone_auth_txt | SZRINTL | EMER_CONT_PHONE_AUTH_TXT | |
emergencyContactPhoneExt | emergency_contact_phone_ext | SZRINTL | EMER_CONT_PHONE_EXT | |
emergencyContactPhoneNumber | emergency_contact_phone_number | SZRINTL | EMER_CONT_PHONE_NUMBER | |
emergencyContactRelationship | emergency_contact_relationship | SZRINTL | EMER_CONT_RELATIONSHIP | |
emergencyContactState | emergency_contact_state | SZRINTL | EMER_CONT_STATE | |
emergencyContactStreet1 | emergency_contact_street_1 | SZRINTL | EMER_CONT_STREET_1 | |
emergencyContactStreet2 | emergency_contact_street_2 | SZRINTL | EMER_CONT_STREET_2 | |
emergencyContactZipCode | emergency_contact_zip_code | SZRINTL | EMER_CONT_ZIP_CODE | |
engMonthsStudied | eng_months_studied | SZRINTL | ENG_MONTHS_STUDIED | |
engProficiencyDate | eng_proficiency_date | SZRINTL | ENG_PROFI_DATE | |
engProficiencyOther | eng_proficiency_other | SZRINTL | ENG_PROFI_OTHER | |
engProficiencyPrerequisite | eng_proficiency_prerequisite | SZRINTL | ENG_PROFI_PREREQUISITE | |
engProficiencyReq | eng_proficiency_req | SZRINTL | ENG_PROFI_REQ | |
engProficiencyScore | eng_proficiency_score | SZRINTL | ENG_PROFI_SCORE | |
engProficiencyShowScore | eng_proficiency_show_score | SZRINTL | ENG_PROFI_SHOW_SCORE | |
engProficiencyType | eng_proficiency_type | SZRINTL | ENG_PROFI_TYPE | |
enrollStatus | enroll_status | SZRINTL | ENROLL_STATUS | |
enrollTermCode | enroll_term_code | SZRINTL | ENROLL_TERM_CODE | |
enrollTermDescription | enroll_term_description | SZRINTL | ENROLL_TERM_DESCRIPTION | |
esignature | esignature | SZRINTL | ESIGNATURE | |
expirationDate | expiration_date | SZRINTL | EXPIRATION_DATE | |
faxNumberNumber | fax_number_number | SZRINTL | FAX_NUMBER_NUMBER | |
firstname | firstname | SZRINTL | FIRST_NAME | |
gender | gender | SZRINTL | GENDER | |
higherLang | higher_lang | SZRINTL | HIGHER_LANG | |
highestCompDate | highest_comp_date | SZRINTL | HIGHEST_COMP_DATE | |
highestEduLevel | highest_edu_level | SZRINTL | HIGHEST_EDU_LEVEL | |
hispanic | hispanic | SZRINTL | HISPANIC | |
hsAddressVerified | hs_address_verified | SZRINTL | HS_ADDR_VERIFIED | |
hsCds | hs_cds | SZRINTL | HS_CDS | |
hsCdsFull | hs_cds_full | SZRINTL | HS_CDS_FULL | |
hsCeeb | hs_ceeb | SZRINTL | HS_CEEB | |
hsCity | hs_city | SZRINTL | HS_CITY | |
hsCompDate | hs_comp_date | SZRINTL | HS_COMP_DATE | |
hsCountry | hs_country | SZRINTL | HS_COUNTRY | |
hsDiplomaCert | hs_diploma_cert | SZRINTL | HS_DIPLOMA_CERT | |
hsDiplomaCertDate | hs_diploma_cert_date | SZRINTL | HS_DIPLOMA_CERT_DATE | |
hsEduLevel | hs_edu_level | SZRINTL | HS_EDU_LEVEL | |
hsEndDate | hs_end_date | SZRINTL | HS_END_DATE | |
hsLang | hs_lang | SZRINTL | HS_LANG | |
hsName | hs_name | SZRINTL | HS_NAME | |
hsNonUsAddress | hs_non_us_address | SZRINTL | HS_NON_US_ADDRESS | |
hsNonUsPostalCode | hs_non_us_postal_code | SZRINTL | HS_NON_US_POSTAL_CODE | |
hsNonUsProvince | hs_non_us_province | SZRINTL | HS_NON_US_PROVINCE | |
hsNotListed | hs_not_listed | SZRINTL | HS_NOT_LISTED | |
hsStartDate | hs_start_date | SZRINTL | HS_START_DATE | |
hsState | hs_state | SZRINTL | HS_STATE | |
hsStreet1 | hs_street_1 | SZRINTL | HS_STREET_1 | |
hsStreet2 | hs_street_2 | SZRINTL | HS_STREET_2 | |
hsType | hs_type | SZRINTL | HS_TYPE | |
hsZipCode | hs_zip_code | SZRINTL | HS_ZIP_CODE | |
i20ExpirationDate | i20_expiration_date | SZRINTL | I20_EXPIRATION_DATE | |
i20IssuingSchoolName | i20_issuing_school_name | SZRINTL | I20_ISSUING_SCHOOL_NAME | |
i94AdmissionNumber | i94_admission_number | SZRINTL | I94_ADMISSION_NUMBER | |
i94ExpirationDate | i94_expiration_date | SZRINTL | I94_EXPIRATION_DATE | |
idmeConfirmationTimestamp | idme_confirmation_timestamp | SZRINTL | IDME_CONFIRMATION_TSTMP | SG V.4.9 |
idmeOptinTimestamp | idme_optin_timestamp | SZRINTL | IDME_OPTIN_TSTMP | SG V.4.9 |
idmeWorkflowStatus | idme_workflow_status | SZRINTL | IDME_WORKFLOW_STATUS | SG V.4.9 |
intended4YearMajor | intended_4_year_major | SZRINTL | INTENDED_4_YEAR_MAJOR | |
ipAddress | ip_address | SZRINTL | IP_ADDRESS | |
issueDate | issue_date | SZRINTL | ISSUE_DATE | |
lastPage | last_page | SZRINTL | LAST_PAGE | |
lastname | lastname | SZRINTL | LAST_NAME | |
mainPhoneAuthTxt | main_phone_auth_txt | SZRINTL | MAIN_PHONE_AUTH_TXT | |
mainPhoneExt | main_phone_ext | SZRINTL | MAIN_PHONE_EXT | |
mainPhoneNumber | main_phone_number | SZRINTL | MAIN_PHONE_NUMBER | |
majorCode | major_code | SZRINTL | MAJOR_CODE | |
majorDescription | major_description | SZRINTL | MAJOR_DESCRIPTION | |
majorCategory | major_category | SZRINTL | MAJOR_CATEGORY | |
cipCode | cip_code | SZRINTL | CIP_CODE | |
middlename | middlename | SZRINTL | MIDDLE_NAME | |
noI94ExpirationDate | no_i94_expiration_date | SZRINTL | NO_I94_EXPIRATION_DATE | |
noVisa | no_visa | SZRINTL | NO_VISA | |
nonUsAddress | non_us_address | SZRINTL | NON_US_ADDRESS | |
nonUsPermanentHomeAddressSameAsPermanent | non_us_permanent_home_address_same_as_permanent | SZRINTL | NON_US_PRMNT_HOM_ADDR_AS_PRMNT | |
nonUsPermanentHomeAddressVerified | non_us_permanent_home_address_verified | SZRINTL | NON_US_PRMNT_HOM_ADDR_VERIFIED | |
nonUsPermanentHomeCity | non_us_permanent_home_city | SZRINTL | NON_US_PRMNT_HOM_CITY | |
nonUsPermanentHomeCountry | non_us_permanent_home_country | SZRINTL | NON_US_PRMNT_HOM_COUNTRY | |
nonUsPermanentHomeNonUsAddress | non_us_permanent_home_non_us_address | SZRINTL | NON_US_PRMNT_HOM_ADDRESS | |
nonUsPermanentHomeNonUsPostalCode | non_us_permanent_home_non_us_postal_code | SZRINTL | NON_US_PRMNT_HOM_PSTL_CD | |
nonUsPermanentHomeNonUsProvince | non_us_permanent_home_non_us_province | SZRINTL | NON_US_PRMNT_HOM_PROVINCE | |
nonUsPermanentHomeStreet1 | non_us_permanent_home_street_1 | SZRINTL | NON_US_PRMNT_HOM_STREET_1 | |
nonUsPermanentHomeStreet2 | non_us_permanent_home_street_2 | SZRINTL | NON_US_PRMNT_HOM_STREET_2 | |
noNonUsPermanentAddrHomeless | non_us_permanent_home_homeless | SZRINTL | NO_NON_USA_PERM_ADDR_HOMELESS | |
nonUsPhoneAuthTxt | non_us_phone_auth_txt | SZRINTL | NON_US_PHONE_AUTH_TXT | |
nonUsPhoneExt | non_us_phone_ext | SZRINTL | NON_US_PHONE_EXT | |
nonUsPhoneNumber | non_us_phone_number | SZRINTL | NON_US_PHONE_NUMBER | |
nonUsPostalCode | non_us_postal_code | SZRINTL | NON_US_POSTAL_CODE | |
nonUsProvince | non_us_province | SZRINTL | NON_US_PROVINCE | |
numberOfDependents | number_of_dependents | SZRINTL | NUMBER_OF_DEPENDENTS | |
numberOfPracticalTraining | number_of_practical_training | SZRINTL | NUMBER_OF_PRACTICAL_TRAINING | |
otherfirstname | otherfirstname | SZRINTL | OTHER_FIRST_NAME | |
otherlastname | otherlastname | SZRINTL | OTHER_LAST_NAME | |
othermiddlename | othermiddlename | SZRINTL | OTHER_MIDDLE_NAME | |
parentGuardianAddressVerified | parent_guardian_address_verified | SZRINTL | PARNT_GUARD_ADDR_VERIFIED | |
parentGuardianCity | parent_guardian_city | SZRINTL | PARNT_GUARD_CITY | |
parentGuardianCountry | parent_guardian_country | SZRINTL | PARNT_GUARD_COUNTRY | |
parentGuardianEmail | parent_guardian_email | SZRINTL | PARNT_GUARD_EMAIL | |
parentGuardianFirstName | parent_guardian_first_name | SZRINTL | PARNT_GUARD_FIRST_NAME | |
parentGuardianLastName | parent_guardian_last_name | SZRINTL | PARNT_GUARD_LAST_NAME | |
parentGuardianNoFirstName | parent_guardian_no_first_name | SZRINTL | PARNT_GUARD_NO_FIRST_NAME | |
parentGuardianNonUsAddress | parent_guardian_non_us_address | SZRINTL | PARNT_GUARD_NON_US_ADDRESS | |
parentGuardianNonUsPostalCode | parent_guardian_non_us_postal_code | SZRINTL | PARNT_GUARD_NON_US_POSTAL_CODE | |
parentGuardianNonUsProvince | parent_guardian_non_us_province | SZRINTL | PARNT_GUARD_NON_US_PROVINCE | |
parentGuardianPhoneAuthTxt | parent_guardian_phone_auth_txt | SZRINTL | PARNT_GUARD_PHONE_AUTH_TXT | |
parentGuardianPhoneExt | parent_guardian_phone_ext | SZRINTL | PARNT_GUARD_PHONE_EXT | |
parentGuardianPhoneNumber | parent_guardian_phone_number | SZRINTL | PARNT_GUARD_PHONE_NUMBER | |
parentGuardianRelationship | parent_guardian_relationship | SZRINTL | PARNT_GUARD_RELATIONSHIP | |
parentGuardianState | parent_guardian_state | SZRINTL | PARNT_GUARD_STATE | |
parentGuardianStreet1 | parent_guardian_street_1 | SZRINTL | PARNT_GUARD_STREET_1 | |
parentGuardianStreet2 | parent_guardian_street_2 | SZRINTL | PARNT_GUARD_STREET_2 | |
parentGuardianZipCode | parent_guardian_zip_code | SZRINTL | PARNT_GUARD_ZIP_CODE | |
passportCountryOfIssuance | passport_country_of_issuance | SZRINTL | PASSPORT_COUNTRY_OF_ISSUANCE | |
passportExpirationDate | passport_expiration_date | SZRINTL | PASSPORT_EXPIRATION_DATE | |
passportNotYet | passport_not_yet | SZRINTL | PASSPORT_NOT_YET | |
passportNumber | passport_number | SZRINTL | PASSPORT_NUMBER | |
permAddrAddressVerified | perm_addr_address_verified | SZRINTL | PERM_ADDR_ADDR_VERIFIED | |
permAddrCity | perm_addr_city | SZRINTL | PERM_ADDR_CITY | |
permAddrCountry | perm_addr_country | SZRINTL | PERM_ADDR_COUNTRY | |
permAddrNonUsAddress | perm_addr_non_us_address | SZRINTL | PERM_ADDR_NON_US_ADDRESS | |
permAddrNonUsPostalCode | perm_addr_non_us_postal_code | SZRINTL | PERM_ADDR_NON_US_POSTAL_CODE | |
permAddrNonUsProvince | perm_addr_non_us_province | SZRINTL | PERM_ADDR_NON_US_PROVINCE | |
permAddrState | perm_addr_state | SZRINTL | PERM_ADDR_STATE | |
permAddrStreet1 | perm_addr_street_1 | SZRINTL | PERM_ADDR_STREET_1 | |
permAddrStreet2 | perm_addr_street_2 | SZRINTL | PERM_ADDR_STREET_2 | |
permAddrZipCode | perm_addr_zip_code | SZRINTL | PERM_ADDR_ZIP_CODE | |
noPermAddressHomeless | no_perm_address_homeless | SZRINTL | NO_PERM_ADDRESS_HOMELESS | |
phoneAuthTxt | phone_auth_txt | SZRINTL | PHONE_AUTH_TXT | |
phoneExt | phone_ext | SZRINTL | PHONE_EXT | |
phoneNumber | phone_number | SZRINTL | PHONE_NUMBER | |
preferredFirstname | preferred_firstname | SZRINTL | PREFERRED_FIRSTNAME | |
preferredLastname | preferred_lastname | SZRINTL | PREFERRED_LASTNAME | |
preferredMiddlename | preferred_middlename | SZRINTL | PREFERRED_MIDDLENAME | |
preferredName | preferred_name | SZRINTL | PREFERRED_NAME | |
presentlyStudyingInUs | presently_studying_in_us | SZRINTL | PRESENTLY_STUDYING_IN_US | |
primaryLanguage | primary_language | SZRINTL | PRIMARY_LANGUAGE | |
pt1AuthorizingSchool | pt1_authorizing_school | SZRINTL | PT1_AUTHORIZING_SCHOOL | |
pt1EndDate | pt1_end_date | SZRINTL | PT1_END_DATE | |
pt1PracticalTrainingId | pt1_practical_training_id | SZRINTL | PT1_PRACTICAL_TRAINING_ID | |
pt1StartDate | pt1_start_date | SZRINTL | PT1_START_DATE | |
pt1Type | pt1_type | SZRINTL | PT1_TYPE | |
pt2AuthorizingSchool | pt2_authorizing_school | SZRINTL | PT2_AUTHORIZING_SCHOOL | |
pt2EndDate | pt2_end_date | SZRINTL | PT2_END_DATE | |
pt2PracticalTrainingId | pt2_practical_training_id | SZRINTL | PT2_PRACTICAL_TRAINING_ID | |
pt2StartDate | pt2_start_date | SZRINTL | PT2_START_DATE | |
pt2Type | pt2_type | SZRINTL | PT2_TYPE | |
pt3AuthorizingSchool | pt3_authorizing_school | SZRINTL | PT3_AUTHORIZING_SCHOOL | |
pt3EndDate | pt3_end_date | SZRINTL | PT3_END_DATE | |
pt3PracticalTrainingId | pt3_practical_training_id | SZRINTL | PT3_PRACTICAL_TRAINING_ID | |
pt3StartDate | pt3_start_date | SZRINTL | PT3_START_DATE | |
pt3Type | pt3_type | SZRINTL | PT3_TYPE | |
pt4AuthorizingSchool | pt4_authorizing_school | SZRINTL | PT4_AUTHORIZING_SCHOOL | |
pt4EndDate | pt4_end_date | SZRINTL | PT4_END_DATE | |
pt4PracticalTrainingId | pt4_practical_training_id | SZRINTL | PT4_PRACTICAL_TRAINING_ID | |
pt4StartDate | pt4_start_date | SZRINTL | PT4_START_DATE | |
pt4Type | pt4_type | SZRINTL | PT4_TYPE | |
raceEthnicity | race_ethnicity | SZRINTL | RACE_ETHNICITY | |
raceEthnicFull | race_ethnic_full | SZRINTL | RACE_ETHNIC_FULL | |
raceGroup | race_group | SZRINTL | RACE_GROUP | |
salt | salt | SZRINTL | ||
secondPhoneAuthTxt | second_phone_auth_txt | SZRINTL | SECOND_PHONE_AUTH_TXT | |
secondPhoneExt | second_phone_ext | SZRINTL | SECOND_PHONE_EXT | |
secondPhoneNumber | second_phone_number | SZRINTL | SECOND_PHONE_NUMBER | |
sevisIdNumber | sevis_id_number | SZRINTL | SEVIS_ID_NUMBER | |
signature | signature | SZRINTL | SIGNATURE | |
ssn | ssn | SZRINTL | SSN | |
ssnNo | ssn_no | SZRINTL | SSN_NO | |
ssnException | ssn_exception | SZRINTL | SSN_EXCEPTION | |
ssnLast4 | ssn_last4 | SZRINTL | SSN_LAST4 | |
ssnType | ssn_type | SZRINTL | SSN_TYPE | |
state | state | SZRINTL | STATE | |
status | status | SZRINTL | ||
street1 | street_1 | SZRINTL | STREET_1 | |
street2 | street_2 | SZRINTL | STREET_2 | |
suffix | suffix | SZRINTL | SUFFIX | |
supPageCode | sup_page_code | SZRINTL | SUP_PAGE_CODE | |
termEndDate | term_end_date | SZRINTL | TERM_END_DATE | |
termStartDate | term_start_date | SZRINTL | TERM_START_DATE | |
tstmpCreate | tstmp_create | SZRINTL | TSTMP_CREATE | |
tstmpDownload | tstmp_download | SZRINTL | TSTMP_DOWNLOAD | |
tstmpSubmit | tstmp_submit | SZRINTL | TSTMP_SUBMIT | |
tstmpUpdate | tstmp_update | SZRINTL | TSTMP_UPDATE | |
visaType | visa_type | SZRINTL | VISA_TYPE | |
zipCode | zip_code | SZRINTL | ZIP_CODE |
Supplemental Questions Data Fields Mappings - Banner
...