The tables below pertain to the CCCApply Standard & Noncredit Applications.
...
College Adaptor Payload Name | CCC Field Name | Banner DB Staging Table | Banner Field Name | Notes | |
---|---|---|---|---|---|
studentParent | student_parent | SG v.4.7 | |||
acceptedTerms | accepted_terms | SZRAPLY | ACCEPTED_TERMS | SG v.4.6 | |
acceptedTermsTimestamp | accepted_terms_timestamp | SZRAPLY | ACCEPTED_TERMS_TSTMP | SG v.4.6 | |
ipAddressAtAccountCreation | ip_address_at_account_creation | SZRAPLY | IP_ADDR_ACCT_CREATE | SG v.4.7 | |
ipAddressAtAppCreation | ip_address_at_app_creation | SZRAPLY | IP_ADDR_APP_CREATE | SG v.4.7 | |
mailingAddressValidationOverride | mailing_address_validation_override | SZRAPLY | MAIL_ADDR_VALIDATION_OVR | SG v.4.7 | |
phoneType | phone_type | SZRAPLY | PHONE_TYPE | SG v.4.7 | |
appId | app_id | SZRAPLY | APP_ID | See here | |
cccId | ccc_id | SZRAPLY | CCC_ID | See here | |
status | status | SZRAPLY | STATUSSee here | ||
collegeId | college_id | SZRAPLY | COLLEGE_IDSee here | ||
termId | term_id | SZRAPLY | TERM_ID | See hereNOT USED | |
majorId | major_id | SZRAPLY | MAJOR_ID | See hereNOT USED | |
intendedMajor | intended_major | SZRAPLY | INTENDED_MAJORSee here | ||
eduGoal | edu_goal | SZRAPLY | EDU_GOAL | See here | |
highestEduLevel | highest_edu_level | SZRAPLY | HIGHEST_EDU_LEVEL | See here | |
consentIndicator | consent_indicator | SZRAPLY | CONSENT_INDICATORSee here | ||
appLang | app_lang | SZRAPLY | APP_LANGSee here | ||
ackFinAid | ack_fin_aid | SZRAPLY | ACK_FIN_AID | See here | |
finAidRef | fin_aid_ref | SZRAPLY | FIN_AID_REF | See here | |
confirmation | confirmation | SZRAPLY | CONFIRMATION | See here | |
supPageCode | sup_page_code | SZRAPLY | SUP_PAGE_CODE | See here | |
lastPage | last_page | SZRAPLY | LAST_PAGE | See here | |
streetaddress1 | streetaddress1 | SZRAPLY | STREETADDRESS1See here | ||
streetaddress2 | streetaddress2 | SZRAPLY | STREETADDRESS2 | See here | |
city | city | SZRAPLY | CITYSee here | ||
postalcode | postalcode | SZRAPLY | POSTALCODESee here | ||
state | state | SZRAPLY | STATESee here | ||
nonusaprovince | nonusaprovince | SZRAPLY | NONUSAPROVINCE | See here | |
country | country | SZRAPLY | COUNTRYSee here | ||
nonUsAddress | non_us_address | SZRAPLY | NON_US_ADDRESSSee here | ||
SZRAPLY | EMAILSee here | ||||
permStreetaddress1 | perm_streetaddress1 | SZRAPLY | PERM_STREETADDRESS1See here | ||
permStreetaddress2 | perm_streetaddress2 | SZRAPLY | PERM_STREETADDRESS2See here | ||
permCity | perm_city | SZRAPLY | PERM_CITYSee here | ||
permPostalcode | perm_postalcode | SZRAPLY | PERM_POSTALCODESee here | ||
permState | perm_state | SZRAPLY | PERM_STATE | See here | |
permNonusaprovince | perm_nonusaprovince | SZRAPLY | PERM_NONUSAPROVINCESee here | ||
permCountry | perm_country | SZRAPLY | PERM_COUNTRYSee here | ||
addressSame | address_same | SZRAPLY | ADDRESS_SAMESee here | ||
mainphone | mainphone | SZRAPLY | MAINPHONESee here | ||
mainphoneExt | mainphone_ext | SZRAPLY | MAINPHONE_EXT | See hereNO LONGER USED | |
mainphoneAuthText | mainphone_auth_text | SZRAPLY | MAINPHONE_AUTH_TEXT | See hereNO LONGER USED | |
secondphone | secondphone | SZRAPLY | SECONDPHONESee here | NO LONGER USED | |
secondphoneExt | secondphone_ext | SZRAPLY | SECONDPHONE_EXT | See hereNO LONGER USED | |
secondphoneAuthText | secondphone_auth_text | SZRAPLY | SECONDPHONE_AUTH_TEXT | See hereNO LONGER USED | |
enrollStatus | enroll_status | SZRAPLY | ENROLL_STATUSSee here | ||
hsEduLevel | hs_edu_level | SZRAPLY | HS_EDU_LEVELSee here | ||
hsCompDate | hs_comp_date | SZRAPLY | HS_COMP_DATESee hereDATE | ||
higherEduLevel | higher_edu_level | SZRAPLY | HIGHER_EDU_LEVELSee here | ||
higherCompDate | higher_comp_date | SZRAPLY | HIGHER_COMP_DATESee here | ||
hsNotAttended | hs_not_attended | SZRAPLY | HS_NOT_ATTENDEDSee here | ||
cahsGraduated | cahs_graduated | SZRAPLY | CAHS_GRADUATED | See here | |
cahs3year | cahs_3year | SZRAPLY | CAHS_3YEARSee here | ||
hsName | hs_name | SZRAPLY | HS_NAME | See here | |
hsCity | hs_city | SZRAPLY | HS_CITY | See here | |
hsState | hs_state | SZRAPLY | HS_STATE | See here | |
hsCountry | hs_country | SZRAPLY | HS_COUNTRY | See here | |
hsCds | hs_cds | SZRAPLY | HS_CDS | See here | |
hsCeeb | hs_ceeb | SZRAPLY | HS_CEEBSee here | ||
hsNotListed | hs_not_listed | SZRAPLY | HS_NOT_LISTEDSee here | ||
homeSchooled | home_schooled | SZRAPLY | HOME_SCHOOLED | See here | |
collegeCount | college_count | SZRAPLY | COLLEGE_COUNT | See here | |
hsAttendance | hs_attendance | SZRAPLY | HS_ATTENDANCE | See here | |
coenrollConfirm | coenroll_confirm | SZRAPLY | COENROLL_CONFIRMSee here | ||
gender | gender | SZRAPLY | GENDER | See here | |
pgFirstname | pg_firstname | SZRAPLY | PG_FIRSTNAMESee here | ||
pgLastname | pg_lastname | SZRAPLY | PG_LASTNAMESee here | ||
pgRel | pg_rel | SZRAPLY | PG_REL | See here | |
pg1Edu | pg1_edu | SZRAPLY | PG1_EDU | See here | |
pg2Edu | pg2_edu | SZRAPLY | PG2_EDUSee here | ||
pgEduMis | pg_edu_mis | SZRAPLY | PG_EDU_MISSee here | ||
under19Ind | under19_ind | SZRAPLY | UNDER19_IND | See here | |
dependentStatus | dependent_status | SZRAPLY | DEPENDENT_STATUS | See here | |
raceEthnic | race_ethnic | SZRAPLY | RACE_ETHNICSee here | ||
hispanic | hispanic | SZRAPLY | HISPANICSee here | ||
raceGroup | race_group | SZRAPLY | RACE_GROUP | See here | |
raceEthnicFull | race_ethnic_full | SZRAPLY | RACE_ETHNIC_FULLSee hereFULL | ||
ssn | ssn | SZRAPLY | SSNSee here | ||
birthdate | birthdate | SZRAPLY | BIRTHDATESee here | ||
firstname | firstname | SZRAPLY | FIRSTNAMESee here | ||
middlename | middlename | SZRAPLY | MIDDLENAME | See here | |
lastname | lastname | SZRAPLY | LASTNAMESee here | ||
suffix | suffix | SZRAPLY | SUFFIX | See here | |
otherfirstname | otherfirstname | SZRAPLY | OTHERFIRSTNAME | See here | |
othermiddlename | othermiddlename | SZRAPLY | OTHERMIDDLENAME | See here | |
otherlastname | otherlastname | SZRAPLY | OTHERLASTNAME | See here | |
citizenshipStatus | citizenship_status | SZRAPLY | CITIZENSHIP_STATUS | See here | |
alienRegNumber | alien_reg_number | SZRAPLY | ALIEN_REG_NUMBERSee here | ||
visaType | visa_type | SZRAPLY | VISA_TYPESee here | ||
noDocuments | no_documents | SZRAPLY | NO_DOCUMENTS | See here | |
alienRegIssueDate | alien_reg_issue_date | SZRAPLY | ALIEN_REG_ISSUE_DATE | See here | |
alienRegExpireDate | alien_reg_expire_date | SZRAPLY | ALIEN_REG_EXPIRE_DATE | See here | |
alienRegNoExpire | alien_reg_no_expire | SZRAPLY | ALIEN_REG_NO_EXPIRESee here | ||
militaryStatus | military_status | SZRAPLY | MILITARY_STATUS | See here | |
militaryDischargeDate | military_discharge_date | SZRAPLY | MILITARY_DISCHARGE_DATESee here | ||
militaryHomeState | military_home_state | SZRAPLY | MILITARY_HOME_STATESee here | ||
militaryHomeCountry | military_home_country | SZRAPLY | MILITARY_HOME_COUNTRY | See here | |
militaryCaStationed | military_ca_stationed | SZRAPLY | MILITARY_CA_STATIONED | See here | |
militaryLegalResidence | military_legal_residence | SZRAPLY | MILITARY_LEGAL_RESIDENCESee here | ||
caRes2Years | ca_res_2_years | SZRAPLY | CA_RES_2_YEARSSee here | ||
caDateCurrent | ca_date_current | SZRAPLY | CA_DATE_CURRENT | See here | |
caNotArrived | ca_not_arrived | SZRAPLY | CA_NOT_ARRIVED | See here | |
caCollegeEmployee | ca_college_employee | SZRAPLY | CA_COLLEGE_EMPLOYEESee here | ||
caSchoolEmployee | ca_school_employee | SZRAPLY | CA_SCHOOL_EMPLOYEESee here | ||
caSeasonalAg | ca_seasonal_ag | SZRAPLY | CA_SEASONAL_AG | See here | |
caFosterYouth | ca_foster_youth | SZRAPLY | CA_FOSTER_YOUTHSee hereYOUTH | ||
caOutsideTax | ca_outside_tax | SZRAPLY | CA_OUTSIDE_TAXSee here | ||
caOutsideTaxYear | ca_outside_tax_year | SZRAPLY | CA_OUTSIDE_TAX_YEARSee here | ||
caOutsideVoted | ca_outside_voted | SZRAPLY | CA_OUTSIDE_VOTEDSee here | ||
caOutsideVotedYear | ca_outside_voted_year | SZRAPLY | CA_OUTSIDE_VOTED_YEAR | See here | |
caOutsideCollege | ca_outside_college | SZRAPLY | CA_OUTSIDE_COLLEGESee here | ||
caOutsideCollegeYear | ca_outside_college_year | SZRAPLY | CA_OUTSIDE_COLLEGE_YEAR | See here | |
caOutsideLawsuit | ca_outside_lawsuit | SZRAPLY | CA_OUTSIDE_LAWSUIT | See here | |
caOutsideLawsuitYear | ca_outside_lawsuit_year | SZRAPLY | CA_OUTSIDE_LAWSUIT_YEAR | See here | |
resStatus | res_status | SZRAPLY | RES_STATUS | See here | |
resStatusChange | res_status_change | SZRAPLY | RES_STATUS_CHANGE | See here | |
resPrevDate | res_prev_date | SZRAPLY | RES_PREV_DATESee here | ||
admIneligible | adm_ineligible | SZRAPLY | ADM_INELIGIBLESee here | ||
eligAb540 | elig_ab540 | SZRAPLY | ELIG_AB540 | See here | |
resAreaA | res_area_a | SZRAPLY | RES_AREA_A | See here | |
resAreaB | res_area_b | SZRAPLY | RES_AREA_B | See here | |
resAreaC | res_area_c | SZRAPLY | RES_AREA_CSee here | ||
resAreaD | res_area_d | SZRAPLY | RES_AREA_D | See here | |
experience | experience | SZRAPLY | EXPERIENCESee here | ||
recommend | recommend | SZRAPLY | RECOMMENDSee here | ||
comments | comments | SZRAPLY | COMMENTS | See here | |
comfortableEnglish | comfortable_english | SZRAPLY | COMFORTABLE_ENGLISH | See here | |
financialAssistance | financial_assistance | SZRAPLY | FINANCIAL_ASSISTANCESee here | ||
tanfSsiGa | tanf_ssi_ga | SZRAPLY | TANF_SSI_GASee here | ||
fosterYouths | foster_youths | SZRAPLY | FOSTER_YOUTHS | See here | |
athleticIntercollegiate | athletic_intercollegiate | SZRAPLY | ATHLETIC_INTERCOLLEGIATE | See here | |
athleticIntramural | athletic_intramural | SZRAPLY | ATHLETIC_INTRAMURALSee here | ||
athleticNotInterested | athletic_not_interested | SZRAPLY | ATHLETIC_NOT_INTERESTEDSee here | ||
academicCounseling | academic_counseling | SZRAPLY | ACADEMIC_COUNSELING | See here | |
basicSkills | basic_skills | SZRAPLY | BASIC_SKILLSSee hereSKILLS | ||
calworks | calworks | SZRAPLY | CALWORKSSee here | ||
careerPlanning | career_planning | SZRAPLY | CAREER_PLANNINGSee here | ||
childCare | child_care | SZRAPLY | CHILD_CARESee here | ||
counselingPersonal | counseling_personal | SZRAPLY | COUNSELING_PERSONAL | See here | |
dsps | dsps | SZRAPLY | DSPSSee here | ||
eops | eops | SZRAPLY | EOPS | See here | |
esl | esl | SZRAPLY | ESL | See here | |
healthServices | health_services | SZRAPLY | HEALTH_SERVICES | See here | |
housingInfo | housing_info | SZRAPLY | HOUSING_INFO | See here | |
employmentAssistance | employment_assistance | SZRAPLY | EMPLOYMENT_ASSISTANCE | See here | |
onlineClasses | online_classes | SZRAPLY | ONLINE_CLASSESSee here | ||
reentryProgram | reentry_program | SZRAPLY | REENTRY_PROGRAMSee here | ||
scholarshipInfo | scholarship_info | SZRAPLY | SCHOLARSHIP_INFO | See here | |
studentGovernment | student_government | SZRAPLY | STUDENT_GOVERNMENT | See here | |
testingAssessment | testing_assessment | SZRAPLY | TESTING_ASSESSMENT | See here | |
transferInfo | transfer_info | SZRAPLY | TRANSFER_INFOSee here | ||
tutoringServices | tutoring_services | SZRAPLY | TUTORING_SERVICES | See here | |
veteransServices | veterans_services | SZRAPLY | VETERANS_SERVICESSee here | ||
integrityFg01 | integrity_fg_01 | SZRAPLY | INTEGRITY_FG_01See here | ||
integrityFg02 | integrity_fg_02 | SZRAPLY | INTEGRITY_FG_02 | See here | |
integrityFg03 | integrity_fg_03 | SZRAPLY | INTEGRITY_FG_03 | See here | |
integrityFg04 | integrity_fg_04 | SZRAPLY | INTEGRITY_FG_04See here | ||
integrityFg11 | integrity_fg_11 | SZRAPLY | INTEGRITY_FG_11See here | ||
integrityFg47 | integrity_fg_47 | SZRAPLY | INTEGRITY_FG_47 | See here | |
integrityFg48 | integrity_fg_48 | SZRAPLY | INTEGRITY_FG_48 | See here | |
integrityFg49 | integrity_fg_49 | SZRAPLY | INTEGRITY_FG_49See here | ||
integrityFg50 | integrity_fg_50 | SZRAPLY | INTEGRITY_FG_50See here | ||
integrityFg51 | integrity_fg_51 | SZRAPLY | INTEGRITY_FG_51 | See here | |
integrityFg52 | integrity_fg_52 | SZRAPLY | INTEGRITY_FG_52See here52 | ||
integrityFg53 | integrity_fg_53 | SZRAPLY | INTEGRITY_FG_53See here | ||
integrityFg54 | integrity_fg_54 | SZRAPLY | INTEGRITY_FG_54See here | ||
integrityFg55 | integrity_fg_55 | SZRAPLY | INTEGRITY_FG_55See here | ||
integrityFg56 | integrity_fg_56 | SZRAPLY | INTEGRITY_FG_56 | See here | |
integrityFg57 | integrity_fg_57 | SZRAPLY | INTEGRITY_FG_57See here | ||
integrityFg58 | integrity_fg_58 | SZRAPLY | INTEGRITY_FG_58 | See here | |
integrityFg59 | integrity_fg_59 | SZRAPLY | INTEGRITY_FG_59 | See here | |
integrityFg60 | integrity_fg_60 | SZRAPLY | INTEGRITY_FG_60 | See here | |
integrityFg61 | integrity_fg_61 | SZRAPLY | INTEGRITY_FG_61 | See here | |
integrityFg62 | integrity_fg_62 | SZRAPLY | INTEGRITY_FG_62 | See here | |
integrityFg63 | integrity_fg_63 | SZRAPLY | INTEGRITY_FG_63See here | ||
integrityFg70 | integrity_fg_70 | SZRAPLY | INTEGRITY_FG_70See here | ||
integrityFg80 | integrity_fg_80 | SZRAPLY | INTEGRITY_FG_80 | See here | |
col1Ceeb | col1_ceeb | SZRAPLY | COL1_CEEB | See here | |
col1Cds | col1_cds | SZRAPLY | COL1_CDS | See here | |
col1NotListed | col1_not_listed | SZRAPLY | COL1_NOT_LISTEDSee here | ||
col1Name | col1_name | SZRAPLY | COL1_NAME | See here | |
col1City | col1_city | SZRAPLY | COL1_CITYSee here | ||
col1State | col1_state | SZRAPLY | COL1_STATESee here | ||
col1Country | col1_country | SZRAPLY | COL1_COUNTRY | See here | |
col1StartDate | col1_start_date | SZRAPLY | COL1_START_DATE | See here | |
col1EndDate | col1_end_date | SZRAPLY | COL1_END_DATESee here | ||
col1DegreeDate | col1_degree_date | SZRAPLY | COL1_DEGREE_DATESee here | ||
col1DegreeObtained | col1_degree_obtained | SZRAPLY | COL1_DEGREE_OBTAINED | See here | |
col2Ceeb | col2_ceeb | SZRAPLY | COL2_CEEB | See here | |
col2Cds | col2_cds | SZRAPLY | COL2_CDSSee here | ||
col2NotListed | col2_not_listed | SZRAPLY | COL2_NOT_LISTEDSee here | ||
col2Name | col2_name | SZRAPLY | COL2_NAME | See here | |
col2City | col2_city | SZRAPLY | COL2_CITYSee hereCITY | ||
col2State | col2_state | SZRAPLY | COL2_STATESee here | ||
col2Country | col2_country | SZRAPLY | COL2_COUNTRYSee here | ||
col2StartDate | col2_start_date | SZRAPLY | COL2_START_DATESee here | ||
col2EndDate | col2_end_date | SZRAPLY | COL2_END_DATE | See here | |
col2DegreeDate | col2_degree_date | SZRAPLY | COL2_DEGREE_DATESee here | ||
col2DegreeObtained | col2_degree_obtained | SZRAPLY | COL2_DEGREE_OBTAINED | See here | |
col3Ceeb | col3_ceeb | SZRAPLY | COL3_CEEB | See here | |
col3Cds | col3_cds | SZRAPLY | COL3_CDS | See here | |
col3NotListed | col3_not_listed | SZRAPLY | COL3_NOT_LISTED | See here | |
col3Name | col3_name | SZRAPLY | COL3_NAME | See here | |
col3City | col3_city | SZRAPLY | COL3_CITYSee here | ||
col3State | col3_state | SZRAPLY | COL3_STATESee here | ||
col3Country | col3_country | SZRAPLY | COL3_COUNTRY | See here | |
col3StartDate | col3_start_date | SZRAPLY | COL3_START_DATE | See here | |
col3EndDate | col3_end_date | SZRAPLY | COL3_END_DATE | See here | |
col3DegreeDate | col3_degree_date | SZRAPLY | COL3_DEGREE_DATESee here | ||
col3DegreeObtained | col3_degree_obtained | SZRAPLY | COL3_DEGREE_OBTAINED | See here | |
col4Ceeb | col4_ceeb | SZRAPLY | COL4_CEEBSee here | ||
col4Cds | col4_cds | SZRAPLY | COL4_CDSSee here | ||
col4NotListed | col4_not_listed | SZRAPLY | COL4_NOT_LISTED | See here | |
col4Name | col4_name | SZRAPLY | COL4_NAME | See here | |
col4City | col4_city | SZRAPLY | COL4_CITYSee here | ||
col4State | col4_state | SZRAPLY | COL4_STATESee here | ||
col4Country | col4_country | SZRAPLY | COL4_COUNTRY | See here | |
col4StartDate | col4_start_date | SZRAPLY | COL4_START_DATE | See here | |
col4EndDate | col4_end_date | SZRAPLY | COL4_END_DATESee here | ||
col4DegreeDate | col4_degree_date | SZRAPLY | COL4_DEGREE_DATESee here | ||
col4DegreeObtained | col4_degree_obtained | SZRAPLY | COL4_DEGREE_OBTAINED | See here | |
collegeName | college_name | SZRAPLY | COLLEGE_NAMESee hereNAME | ||
districtName | district_name | SZRAPLY | DISTRICT_NAMESee here | ||
termCode | term_code | SZRAPLY | TERM_CODESee here | ||
termDescription | term_description | SZRAPLY | TERM_DESCRIPTIONSee here | ||
majorCode | major_code | SZRAPLY | MAJOR_CODE | See here | |
majorDescription | major_description | SZRAPLY | MAJOR_DESCRIPTIONSee here | ||
tstmpSubmit | tstmp_submit | SZRAPLY | TSTMP_SUBMIT | See here | |
tstmpCreate | tstmp_create | SZRAPLY | TSTMP_CREATE | See here | |
tstmpUpdate | tstmp_update | SZRAPLY | TSTMP_UPDATE | See here | |
ssnDisplay | ssn_display | SZRAPLY | SSN_DISPLAY | See here | |
fosterYouthStatus | foster_youth_status | SZRAPLY | FOSTER_YOUTH_STATUS | See here | |
fosterYouthPreference | foster_youth_preference | SZRAPLY | FOSTER_YOUTH_PREFERENCESee here | ||
fosterYouthMis | foster_youth_mis | SZRAPLY | FOSTER_YOUTH_MISSee here | ||
fosterYouthPriority | foster_youth_priority | SZRAPLY | FOSTER_YOUTH_PRIORITY | See here | |
tstmpDownload | tstmp_download | SZRAPLY | TSTMP_DOWNLOAD | See here | |
addressValidation | address_validation | SZRAPLY | ADDRESS_VALIDATION | See here | |
zip4 | zip4 | SZRAPLY | ZIP4See here | ||
permAddressValidation | perm_address_validation | SZRAPLY | PERM_ADDRESS_VALIDATION | See here | |
permZip4 | perm_zip4 | SZRAPLY | PERM_ZIP4See here | ||
dischargeType | discharge_type | SZRAPLY | DISCHARGE_TYPESee here | ||
collegeExpelledSummary | college_expelled_summary | SZRAPLY | COLLEGE_EXPELLED_SUMMARY | See here | |
col1ExpelledStatus | col1_expelled_status | SZRAPLY | COL1_EXPELLED_STATUS | See here | |
col2ExpelledStatus | col2_expelled_status | SZRAPLY | COL2_EXPELLED_STATUSSee here | ||
col3ExpelledStatus | col3_expelled_status | SZRAPLY | COL3_EXPELLED_STATUSSee here | ||
col4ExpelledStatus | col4_expelled_status | SZRAPLY | COL4_EXPELLED_STATUS | See here | |
integrityFlags | integrity_flags | SZRAPLY | INTEGRITY_FLAGS | See here | |
rdd | rdd | SZRAPLY | RDDSee here | ||
ssnType | ssn_type | SZRAPLY | SSN_TYPESee here | ||
militaryStationedCaEd | military_stationed_ca_ed | SZRAPLY | MILITARY_STATIONED_CA_ED | See here | |
integrityFg65 | integrity_fg_65 | SZRAPLY | INTEGRITY_FG_65See here | ||
integrityFg64 | integrity_fg_64 | SZRAPLY | INTEGRITY_FG_64See here | ||
ipAddress | ip_address | SZRAPLY | IP_ADDRESSSee here | ||
campaign1 | campaign1 | SZRAPLY | CAMPAIGN1See here | ||
campaign2 | campaign2 | SZRAPLY | CAMPAIGN2 | See here | |
campaign3 | campaign3 | SZRAPLY | CAMPAIGN3 | See here | |
orientation | orientation | SZRAPLY | ORIENTATION_ENCRYPTED | See here | |
transgender | transgender | SZRAPLY | TRANSGENDER_ENCRYPTED | See here | |
ssnException | ssn_exception | SZRAPLY | SSN_EXCEPTION | See here | |
integrityFg71 | integrity_fg_71 | SZRAPLY | INTEGRITY_FG_71See here | ||
preferredFirstname | preferred_firstname | SZRAPLY | PREFERRED_FIRSTNAME | See here | |
preferredMiddlename | preferred_middlename | SZRAPLY | PREFERRED_MIDDLENAME | See here | |
preferredLastname | preferred_lastname | SZRAPLY | PREFERRED_LASTNAMESee here | ||
preferredName | preferred_name | SZRAPLY | PREFERRED_NAMESee here | ||
ssnNo | ssn_no | SZRAPLY | SSN_NO | See here | |
completedEleventhGrade | completed_eleventh_grade | SZRAPLY | COMPLETED_ELEVENTH_GRADE | See hereNO LONGER USED | |
gradePointAverage | grade_point_average | SZRAPLY | GRADE_POINT_AVERAGESee here | ||
highestEnglishCourse | highest_english_course | SZRAPLY | HIGHEST_ENGLISH_COURSE | See here | |
highestEnglishGrade | highest_english_grade | SZRAPLY | HIGHEST_ENGLISH_GRADESee here | ||
highestMathCourseTaken | highest_math_course_taken | SZRAPLY | HIGHEST_MATH_COURSE_TAKENSee here | ||
highestMathTakenGrade | highest_math_taken_grade | SZRAPLY | HIGHEST_MATH_TAKEN_GRADE | See here | |
highestMathCoursePassed | highest_math_course_passed | SZRAPLY | HIGHEST_MATH_COURSE_PASSED | See here | |
highestMathPassedGrade | highest_math_passed_grade | SZRAPLY | HIGHEST_MATH_PASSED_GRADESee here | ||
integrityFg30 | integrity_fg_30 | SZRAPLY | INTEGRITY_FG_30See here | ||
hsCdsFull | hs_cds_full | SZRAPLY | HS_CDS_FULL | See here | |
col1CdsFull | col1_cds_full | SZRAPLY | COL1_CDS_FULL | See here | |
col2CdsFull | col2_cds_full | SZRAPLY | COL2_CDS_FULLSee here | ||
col3CdsFull | col3_cds_full | SZRAPLY | COL3_CDS_FULLSee here | ||
col4CdsFull | col4_cds_full | SZRAPLY | NOCOL4_CDS_FULL | See here | |
ssid | ssid | SZRAPLY | SSIDSee here | ||
noPermAddressHomeless | no_perm_address_homeless | SZRAPLY | NO_PERM_ADDRESS_HOMELESSSee here | ||
noMailingAddressHomeless | no_mailing_address_homeless | SZRAPLY | NO_MAILING_ADDRESS_HOMELESSSee here | ||
termStart | term_start | SZRAPLY | TERM_STARTSee here | ||
termEnd | term_end | SZRAPLY | TERM_END | See here | |
homelessYouth | homeless_youth | SZRAPLY | HOMELESS_YOUTH | See here | |
integrityFg40 | integrity_fg_40 | SZRAPLY | INTEGRITY_FG_40 | See here | |
cipCode | cip_code | SZRAPLY | CIP_CODE | See here | |
majorCategory | major_category | SZRAPLY | MAJOR_CATEGORY | See here | |
mainphoneintl | mainphoneintl | SZRAPLY | MAINPHONEINTL | No Longer Used | |
secondphoneintl | secondphoneintl | SZRAPLY | SECONDPHONEINTL | No Longer Used | |
nonCredit | non_credit | SZRAPLY | NON_CREDITSee here | ||
integrityFg81 | integrity_fg_81 | SZRAPLY | INTEGRITY_FG_81 | See here | |
highestGradeCompleted | highest_grade_completed | SZRAPLY | HIGHEST_GRADE_COMPLETED | See here | |
emailVerified | email_verified | SZRAPLY | EMAIL_VERIFIEDPending release | SG v.4.7 | |
emailVerifiedTimestamp | email_verified_timestamp | SZRAPLY | EMAIL_VERIFIED_TSTMPPending | releaseSG v.4.7 | |
mainphoneVerified | phone_verified | SZRAPLY | PHONE_VERIFIEDPending release | SG v.4.7 | |
mainphoneVerifiedTimestamp | phone_verified_timestamp | SZRAPLY | PHONE_VERIFIED_TSTMPPending | releaseSG v.4.7 | |
preferredMethodOfContact | preferred_contact_method | SZRAPLY | PREF_CONTACT_METHODPending | releaseSG v.4.7 | |
addressValidationOverride | address_validation_override | SZRAPLY | ADDRESS_VAL_OVERRIDEPending | releaseSG v.4.7 | |
addressValidationOverrideTimestamp | address_validation_override_timestamp | SZRAPLY | ADDRESS_VAL_OVER_TSTMP | Pending releaseSG v.4.7 |
Supplemental Questions Data Fields Mappings - Banner
...
College Adaptor Payload Name | CCC Field Name | Banner DB Staging Table | Banner Field Name | Explanation |
---|---|---|---|---|
appId | app_id | SZRAPLY | APP_ID | See here |
suppText01 | supp_text_01 | SZRAPLY | SUPP_TEXT_01 | See here |
suppText02 | supp_text_02 | SZRAPLY | SUPP_TEXT_02 | See here |
suppText03 | supp_text_03 | SZRAPLY | SUPP_TEXT_03 | See here |
suppText04 | supp_text_04 | SZRAPLY | SUPP_TEXT_04 | See here |
suppText05 | supp_text_05 | SZRAPLY | SUPP_TEXT_05 | See here |
suppText06 | supp_text_06 | SZRAPLY | SUPP_TEXT_06 | See here |
suppText07 | supp_text_07 | SZRAPLY | SUPP_TEXT_07 | See here |
suppText08 | supp_text_08 | SZRAPLY | SUPP_TEXT_08 | See here |
suppText09 | supp_text_09 | SZRAPLY | SUPP_TEXT_09 | See here |
suppText10 | supp_text_10 | SZRAPLY | SUPP_TEXT_10 | See here |
suppText11 | supp_text_11 | SZRAPLY | SUPP_TEXT_11 | See here |
suppText12 | supp_text_12 | SZRAPLY | SUPP_TEXT_12 | See here |
suppText13 | supp_text_13 | SZRAPLY | SUPP_TEXT_13 | See here |
suppText14 | supp_text_14 | SZRAPLY | SUPP_TEXT_14 | See here |
suppText15 | supp_text_15 | SZRAPLY | SUPP_TEXT_15 | See here |
suppText16 | supp_text_16 | SZRAPLY | SUPP_TEXT_16 | See here |
suppText17 | supp_text_17 | SZRAPLY | SUPP_TEXT_17 | See here |
suppText18 | supp_text_18 | SZRAPLY | SUPP_TEXT_18 | See here |
suppText19 | supp_text_19 | SZRAPLY | SUPP_TEXT_19 | See here |
suppText20 | supp_text_20 | SZRAPLY | SUPP_TEXT_20 | See here |
suppCheck01 | supp_check_01 | SZRAPLY | SUPP_CHECK_01 | See here |
suppCheck02 | supp_check_02 | SZRAPLY | SUPP_CHECK_02 | See here |
suppCheck03 | supp_check_03 | SZRAPLY | SUPP_CHECK_03 | See here |
suppCheck04 | supp_check_04 | SZRAPLY | SUPP_CHECK_04 | See here |
suppCheck05 | supp_check_05 | SZRAPLY | SUPP_CHECK_05 | See here |
suppCheck06 | supp_check_06 | SZRAPLY | SUPP_CHECK_06 | See here |
suppCheck07 | supp_check_07 | SZRAPLY | SUPP_CHECK_07 | See here |
suppCheck08 | supp_check_08 | SZRAPLY | SUPP_CHECK_08 | See here |
suppCheck09 | supp_check_09 | SZRAPLY | SUPP_CHECK_09 | See here |
suppCheck10 | supp_check_10 | SZRAPLY | SUPP_CHECK_10 | See here |
suppCheck11 | supp_check_11 | SZRAPLY | SUPP_CHECK_11 | See here |
suppCheck12 | supp_check_12 | SZRAPLY | SUPP_CHECK_12 | See here |
suppCheck13 | supp_check_13 | SZRAPLY | SUPP_CHECK_13 | See here |
suppCheck14 | supp_check_14 | SZRAPLY | SUPP_CHECK_14 | See here |
suppCheck15 | supp_check_15 | SZRAPLY | SUPP_CHECK_15 | See here |
suppCheck16 | supp_check_16 | SZRAPLY | SUPP_CHECK_16 | See here |
suppCheck17 | supp_check_17 | SZRAPLY | SUPP_CHECK_17 | See here |
suppCheck18 | supp_check_18 | SZRAPLY | SUPP_CHECK_18 | See here |
suppCheck19 | supp_check_19 | SZRAPLY | SUPP_CHECK_19 | See here |
suppCheck20 | supp_check_20 | SZRAPLY | SUPP_CHECK_20 | See here |
suppCheck21 | supp_check_21 | SZRAPLY | SUPP_CHECK_21 | See here |
suppCheck22 | supp_check_22 | SZRAPLY | SUPP_CHECK_22 | See here |
suppCheck23 | supp_check_23 | SZRAPLY | SUPP_CHECK_23 | See here |
suppCheck24 | supp_check_24 | SZRAPLY | SUPP_CHECK_24 | See here |
suppCheck25 | supp_check_25 | SZRAPLY | SUPP_CHECK_25 | See here |
suppCheck26 | supp_check_26 | SZRAPLY | SUPP_CHECK_26 | See here |
suppCheck27 | supp_check_27 | SZRAPLY | SUPP_CHECK_27 | See here |
suppCheck28 | supp_check_28 | SZRAPLY | SUPP_CHECK_28 | See here |
suppCheck29 | supp_check_29 | SZRAPLY | SUPP_CHECK_29 | See here |
suppCheck30 | supp_check_30 | SZRAPLY | SUPP_CHECK_30 | See here |
suppCheck31 | supp_check_31 | SZRAPLY | SUPP_CHECK_31 | See here |
suppCheck32 | supp_check_32 | SZRAPLY | SUPP_CHECK_32 | See here |
suppCheck33 | supp_check_33 | SZRAPLY | SUPP_CHECK_33 | See here |
suppCheck34 | supp_check_34 | SZRAPLY | SUPP_CHECK_34 | See here |
suppCheck35 | supp_check_35 | SZRAPLY | SUPP_CHECK_35 | See here |
suppCheck36 | supp_check_36 | SZRAPLY | SUPP_CHECK_36 | See here |
suppCheck37 | supp_check_37 | SZRAPLY | SUPP_CHECK_37 | See here |
suppCheck38 | supp_check_38 | SZRAPLY | SUPP_CHECK_38 | See here |
suppCheck39 | supp_check_39 | SZRAPLY | SUPP_CHECK_39 | See here |
suppCheck40 | supp_check_40 | SZRAPLY | SUPP_CHECK_40 | See here |
suppCheck41 | supp_check_41 | SZRAPLY | SUPP_CHECK_41 | See here |
suppCheck42 | supp_check_42 | SZRAPLY | SUPP_CHECK_42 | See here |
suppCheck43 | supp_check_43 | SZRAPLY | SUPP_CHECK_43 | See here |
suppCheck44 | supp_check_44 | SZRAPLY | SUPP_CHECK_44 | See here |
suppCheck45 | supp_check_45 | SZRAPLY | SUPP_CHECK_45 | See here |
suppCheck46 | supp_check_46 | SZRAPLY | SUPP_CHECK_46 | See here |
suppCheck47 | supp_check_47 | SZRAPLY | SUPP_CHECK_47 | See here |
suppCheck48 | supp_check_48 | SZRAPLY | SUPP_CHECK_48 | See here |
suppCheck49 | supp_check_49 | SZRAPLY | SUPP_CHECK_49 | See here |
suppCheck50 | supp_check_50 | SZRAPLY | SUPP_CHECK_50 | See here |
suppYesno01 | supp_yesno_01 | SZRAPLY | SUPP_YESNO_01 | See here |
suppYesno02 | supp_yesno_02 | SZRAPLY | SUPP_YESNO_02 | See here |
suppYesno03 | supp_yesno_03 | SZRAPLY | SUPP_YESNO_03 | See here |
suppYesno04 | supp_yesno_04 | SZRAPLY | SUPP_YESNO_04 | See here |
suppYesno05 | supp_yesno_05 | SZRAPLY | SUPP_YESNO_05 | See here |
suppYesno06 | supp_yesno_06 | SZRAPLY | SUPP_YESNO_06 | See here |
suppYesno07 | supp_yesno_07 | SZRAPLY | SUPP_YESNO_07 | See here |
suppYesno08 | supp_yesno_08 | SZRAPLY | SUPP_YESNO_08 | See here |
suppYesno09 | supp_yesno_09 | SZRAPLY | SUPP_YESNO_09 | See here |
suppYesno10 | supp_yesno_10 | SZRAPLY | SUPP_YESNO_10 | See here |
suppYesno11 | supp_yesno_11 | SZRAPLY | SUPP_YESNO_11 | See here |
suppYesno12 | supp_yesno_12 | SZRAPLY | SUPP_YESNO_12 | See here |
suppYesno13 | supp_yesno_13 | SZRAPLY | SUPP_YESNO_13 | See here |
suppYesno14 | supp_yesno_14 | SZRAPLY | SUPP_YESNO_14 | See here |
suppYesno15 | supp_yesno_15 | SZRAPLY | SUPP_YESNO_15 | See here |
suppYesno16 | supp_yesno_16 | SZRAPLY | SUPP_YESNO_16 | See here |
suppYesno17 | supp_yesno_17 | SZRAPLY | SUPP_YESNO_17 | See here |
suppYesno18 | supp_yesno_18 | SZRAPLY | SUPP_YESNO_18 | See here |
suppYesno19 | supp_yesno_19 | SZRAPLY | SUPP_YESNO_19 | See here |
suppYesno20 | supp_yesno_20 | SZRAPLY | SUPP_YESNO_20 | See here |
suppYesno21 | supp_yesno_21 | SZRAPLY | SUPP_YESNO_21 | See here |
suppYesno22 | supp_yesno_22 | SZRAPLY | SUPP_YESNO_22 | See here |
suppYesno23 | supp_yesno_23 | SZRAPLY | SUPP_YESNO_23 | See here |
suppYesno24 | supp_yesno_24 | SZRAPLY | SUPP_YESNO_24 | See here |
suppYesno25 | supp_yesno_25 | SZRAPLY | SUPP_YESNO_25 | See here |
suppYesno26 | supp_yesno_26 | SZRAPLY | SUPP_YESNO_26 | See here |
suppYesno27 | supp_yesno_27 | SZRAPLY | SUPP_YESNO_27 | See here |
suppYesno28 | supp_yesno_28 | SZRAPLY | SUPP_YESNO_28 | See here |
suppYesno29 | supp_yesno_29 | SZRAPLY | SUPP_YESNO_29 | See here |
suppYesno30 | supp_yesno_30 | SZRAPLY | SUPP_YESNO_30 | See here |
suppMenu01 | supp_menu_01 | SZRAPLY | SUPP_MENU_01 | See here |
suppMenu02 | supp_menu_02 | SZRAPLY | SUPP_MENU_02 | See here |
suppMenu03 | supp_menu_03 | SZRAPLY | SUPP_MENU_03 | See here |
suppMenu04 | supp_menu_04 | SZRAPLY | SUPP_MENU_04 | See here |
suppMenu05 | supp_menu_05 | SZRAPLY | SUPP_MENU_05 | See here |
suppMenu06 | supp_menu_06 | SZRAPLY | SUPP_MENU_06 | See here |
suppMenu07 | supp_menu_07 | SZRAPLY | SUPP_MENU_07 | See here |
suppMenu08 | supp_menu_08 | SZRAPLY | SUPP_MENU_08 | See here |
suppMenu09 | supp_menu_09 | SZRAPLY | SUPP_MENU_09 | See here |
suppMenu10 | supp_menu_10 | SZRAPLY | SUPP_MENU_10 | See here |
suppMenu11 | supp_menu_11 | SZRAPLY | SUPP_MENU_11 | See here |
suppMenu12 | supp_menu_12 | SZRAPLY | SUPP_MENU_12 | See here |
suppMenu13 | supp_menu_13 | SZRAPLY | SUPP_MENU_13 | See here |
suppMenu14 | supp_menu_14 | SZRAPLY | SUPP_MENU_14 | See here |
suppMenu15 | supp_menu_15 | SZRAPLY | SUPP_MENU_15 | See here |
suppMenu16 | supp_menu_16 | SZRAPLY | SUPP_MENU_16 | See here |
suppMenu17 | supp_menu_17 | SZRAPLY | SUPP_MENU_17 | See here |
suppMenu18 | supp_menu_18 | SZRAPLY | SUPP_MENU_18 | See here |
suppMenu19 | supp_menu_19 | SZRAPLY | SUPP_MENU_19 | See here |
suppMenu20 | supp_menu_20 | SZRAPLY | SUPP_MENU_20 | See here |
suppMenu21 | supp_menu_21 | SZRAPLY | SUPP_MENU_21 | See here |
suppMenu22 | supp_menu_22 | SZRAPLY | SUPP_MENU_22 | See here |
suppMenu23 | supp_menu_23 | SZRAPLY | SUPP_MENU_23 | See here |
suppMenu24 | supp_menu_24 | SZRAPLY | SUPP_MENU_24 | See here |
suppMenu25 | supp_menu_25 | SZRAPLY | SUPP_MENU_25 | See here |
suppMenu26 | supp_menu_26 | SZRAPLY | SUPP_MENU_26 | See here |
suppMenu27 | supp_menu_27 | SZRAPLY | SUPP_MENU_27 | See here |
suppMenu28 | supp_menu_28 | SZRAPLY | SUPP_MENU_28 | See here |
suppMenu29 | supp_menu_29 | SZRAPLY | SUPP_MENU_29 | See here |
suppMenu30 | supp_menu_30 | SZRAPLY | SUPP_MENU_30 | See here |
suppDate01 | supp_date_01 | SZRAPLY | SUPP_DATE_01 | See here |
suppDate02 | supp_date_02 | SZRAPLY | SUPP_DATE_02 | See here |
suppDate03 | supp_date_03 | SZRAPLY | SUPP_DATE_03 | See here |
suppDate04 | supp_date_04 | SZRAPLY | SUPP_DATE_04 | See here |
suppDate05 | supp_date_05 | SZRAPLY | SUPP_DATE_05 | See here |
suppState01 | supp_state_01 | SZRAPLY | SUPP_STATE_01 | See here |
suppState02 | supp_state_02 | SZRAPLY | SUPP_STATE_02 | See here |
suppState03 | supp_state_03 | SZRAPLY | SUPP_STATE_03 | See here |
suppState04 | supp_state_04 | SZRAPLY | SUPP_STATE_04 | See here |
suppState05 | supp_state_05 | SZRAPLY | SUPP_STATE_05 | See here |
suppCountry01 | supp_country_01 | SZRAPLY | SUPP_COUNTRY_01 | See here |
suppCountry02 | supp_country_02 | SZRAPLY | SUPP_COUNTRY_02 | See here |
suppCountry03 | supp_country_03 | SZRAPLY | SUPP_COUNTRY_03 | See here |
suppCountry04 | supp_country_04 | SZRAPLY | SUPP_COUNTRY_04 | See here |
suppCountry05 | supp_country_05 | SZRAPLY | SUPP_COUNTRY_05 | See here |
suppPhonenumber01 | supp_phonenumber_01 | SZRAPLY | SUPP_PHONENUMBER_01 | See here |
suppPhonenumber02 | supp_phonenumber_02 | SZRAPLY | SUPP_PHONENUMBER_02 | See here |
suppPhonenumber03 | supp_phonenumber_03 | SZRAPLY | SUPP_PHONENUMBER_03 | See here |
suppPhonenumber04 | supp_phonenumber_04 | SZRAPLY | SUPP_PHONENUMBER_04 | See here |
suppPhonenumber05 | supp_phonenumber_05 | SZRAPLY | SUPP_PHONENUMBER_05 | See here |
suppSecret01 | supp_secret_01 | SZRAPLY | SUPP_SECRET_01 | See here |
suppSecret02 | supp_secret_02 | SZRAPLY | SUPP_SECRET_02 | See here |
suppSecret03 | supp_secret_03 | SZRAPLY | SUPP_SECRET_03 | See here |
suppSecret04 | supp_secret_04 | SZRAPLY | SUPP_SECRET_04 | See here |
suppSecret05 | supp_secret_05 | SZRAPLY | SUPP_SECRET_05 | See here |
...