The tables below pertain to the CCCApply Standard & Noncredit Applications.
Contents
Table of Contents | ||||
---|---|---|---|---|
|
Standard Data Fields Table Mapping - Banner
For more details, see the CCCApply Standard & Noncredit Application data dictionary.
...
College Adaptor Payload Name
...
CCC Field Name
...
Banner DB Staging Table
...
Banner Field Name
...
The tables below pertain to the CCCApply Standard & Noncredit Applications.
On This Page:
Table of Contents | ||||
---|---|---|---|---|
|
Standard Data Fields Table Mapping - Banner
For more details, see the CCCApply Standard & Noncredit Application data dictionary.
College Adaptor Payload Name | CCC Field Name | Banner DB Staging Table | Banner Field Name | Notes |
---|---|---|---|---|
raceAIANOtherDescription | race_aian_other_description | SZRAPLY | RACE_AIAN_OTHER_DESCRIPTION | SG 4.10 |
studentDepsUnder18 | student_deps_under18 | SZRAPLY | STU_DEPS_UNDER_18 | SG 4.10 |
studentDeps18Over | student_deps_18over | SZRAPLY | STU_DEPS_18_OVER | SG 4.10 |
idmeConfirmationTimestamp | idme_confirmation_timestamp | SZRAPLY | IDME_CONFIRMATION_TSTMP | SG v.4.9 |
idmeOptinTimestamp | idme_optin_timestamp | SZRAPLY | IDME_OPTIN_TSTMP | SG v.4.9 |
idmeWorkflowStatus | idme_workflow_status | SZRAPLY | IDME_WORKFLOW_STATUS | SG v.4.9 |
studentParent | student_parent | SZRAPLY | 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 | STATUS |
collegeId | college_id | SZRAPLY | COLLEGE_ID |
See here
termId | term_id | SZRAPLY | TERM_ID |
NOT USED | |||
majorId | major_id | SZRAPLY | MAJOR_ID |
NOT USED | |||
intendedMajor | intended_major | SZRAPLY | INTENDED_MAJOR |
See here
eduGoal | edu_goal | SZRAPLY | EDU_GOAL |
See here
highestEduLevel | highest_edu_level | SZRAPLY | HIGHEST_EDU_LEVEL |
consentIndicator | consent_indicator | SZRAPLY | CONSENT_INDICATOR |
appLang | app_lang | SZRAPLY | APP_LANG |
See here
ackFinAid | ack_fin_aid | SZRAPLY | ACK_FIN_AID |
finAidRef | fin_aid_ref | SZRAPLY | FIN_AID_REF |
confirmation | confirmation | SZRAPLY | CONFIRMATION |
See here
supPageCode | sup_page_code | SZRAPLY | SUP_PAGE_CODE |
See here
lastPage | last_page | SZRAPLY | LAST_PAGE |
streetaddress1 | streetaddress1 | SZRAPLY | STREETADDRESS1 |
streetaddress2 | streetaddress2 | SZRAPLY | STREETADDRESS2 |
city | city | SZRAPLY | CITY |
postalcode | postalcode | SZRAPLY | POSTALCODE |
See here
state | state | SZRAPLY | STATE |
nonusaprovince | nonusaprovince | SZRAPLY | NONUSAPROVINCE |
See here
country | country | SZRAPLY | COUNTRY |
See here
nonUsAddress | non_us_address | SZRAPLY | NON_US_ADDRESS |
See here
SZRAPLY |
permStreetaddress1 | perm_streetaddress1 | SZRAPLY | PERM_STREETADDRESS1 |
See here
permStreetaddress2 | perm_streetaddress2 | SZRAPLY | PERM_STREETADDRESS2 |
permCity | perm_city | SZRAPLY | PERM_CITY |
permPostalcode | perm_postalcode | SZRAPLY | PERM_POSTALCODE |
See here
permState | perm_state | SZRAPLY | PERM_STATE |
See here
permNonusaprovince | perm_nonusaprovince | SZRAPLY | PERM_NONUSAPROVINCE |
See here
permCountry | perm_country | SZRAPLY | PERM_COUNTRY |
addressSame | address_same | SZRAPLY | ADDRESS_SAME |
See here
mainphone | mainphone | SZRAPLY | MAINPHONE |
See here
mainphoneExt | mainphone_ext | SZRAPLY | MAINPHONE_EXT |
NO LONGER USED | |||
mainphoneAuthText | mainphone_auth_text | SZRAPLY | MAINPHONE_AUTH_TEXT |
NO LONGER USED | |||
secondphone | secondphone | SZRAPLY | SECONDPHONE |
NO LONGER USED | |||
secondphoneExt | secondphone_ext | SZRAPLY | SECONDPHONE_EXT |
NO LONGER USED | |||
secondphoneAuthText | secondphone_auth_text | SZRAPLY | SECONDPHONE_AUTH_TEXT |
NO LONGER USED | |||
enrollStatus | enroll_status | SZRAPLY | ENROLL_STATUS |
hsEduLevel | hs_edu_level | SZRAPLY | HS_EDU_LEVEL |
See here
hsCompDate | hs_comp_date | SZRAPLY | HS_COMP_ |
DATE | |||
higherEduLevel | higher_edu_level | SZRAPLY | HIGHER_EDU_LEVEL |
higherCompDate | higher_comp_date | SZRAPLY | HIGHER_COMP_DATE |
hsNotAttended | hs_not_attended | SZRAPLY | HS_NOT_ATTENDED |
cahsGraduated | cahs_graduated | SZRAPLY | CAHS_GRADUATED |
See here
cahs3year | cahs_3year | SZRAPLY | CAHS_3YEAR |
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_CEEB |
hsNotListed | hs_not_listed | SZRAPLY | HS_NOT_LISTED |
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_CONFIRM |
gender | gender | SZRAPLY | GENDER |
See here
pgFirstname | pg_firstname | SZRAPLY | PG_FIRSTNAME |
pgLastname | pg_lastname | SZRAPLY | PG_LASTNAME |
pgRel | pg_rel | SZRAPLY | PG_REL |
See here
pg1Edu | pg1_edu | SZRAPLY | PG1_EDU |
See here
pg2Edu | pg2_edu | SZRAPLY | PG2_EDU |
pgEduMis | pg_edu_mis | SZRAPLY | PG_EDU_MIS |
under19Ind | under19_ind | SZRAPLY | UNDER19_IND |
See here
dependentStatus | dependent_status | SZRAPLY | DEPENDENT_STATUS |
See here
raceEthnic | race_ethnic | SZRAPLY | RACE_ETHNIC |
hispanic | hispanic | SZRAPLY | HISPANIC |
raceGroup | race_group | SZRAPLY | RACE_GROUP |
See here
raceEthnicFull | race_ethnic_full | SZRAPLY | RACE_ETHNIC_ |
FULL | |||
ssn | ssn | SZRAPLY | SSN |
birthdate | birthdate | SZRAPLY | BIRTHDATE |
firstname | firstname | SZRAPLY | FIRSTNAME |
middlename | middlename | SZRAPLY | MIDDLENAME |
See here
lastname | lastname | SZRAPLY | LASTNAME |
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_NUMBER |
visaType | visa_type | SZRAPLY | VISA_TYPE |
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_EXPIRE |
militaryStatus | military_status | SZRAPLY | MILITARY_STATUS |
See here
militaryDischargeDate | military_discharge_date | SZRAPLY | MILITARY_DISCHARGE_DATE |
militaryHomeState | military_home_state | SZRAPLY | MILITARY_HOME_STATE |
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_RESIDENCE |
caRes2Years | ca_res_2_years | SZRAPLY | CA_RES_2_YEARS |
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_EMPLOYEE |
caSchoolEmployee | ca_school_employee | SZRAPLY | CA_SCHOOL_EMPLOYEE |
caSeasonalAg | ca_seasonal_ag | SZRAPLY | CA_SEASONAL_AG |
See here
caFosterYouth | ca_foster_youth | SZRAPLY | CA_FOSTER_ |
YOUTH | |||
caOutsideTax | ca_outside_tax | SZRAPLY | CA_OUTSIDE_TAX |
caOutsideTaxYear | ca_outside_tax_year | SZRAPLY | CA_OUTSIDE_TAX_YEAR |
caOutsideVoted | ca_outside_voted | SZRAPLY | CA_OUTSIDE_VOTED |
caOutsideVotedYear | ca_outside_voted_year | SZRAPLY | CA_OUTSIDE_VOTED_YEAR |
See here
caOutsideCollege | ca_outside_college | SZRAPLY | CA_OUTSIDE_COLLEGE |
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_DATE |
admIneligible | adm_ineligible | SZRAPLY | ADM_INELIGIBLE |
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_C |
resAreaD | res_area_d | SZRAPLY | RES_AREA_D |
See here
experience | experience | SZRAPLY | EXPERIENCE |
recommend | recommend | SZRAPLY | RECOMMEND |
comments | comments | SZRAPLY | COMMENTS |
See here
comfortableEnglish | comfortable_english | SZRAPLY | COMFORTABLE_ENGLISH |
See here
financialAssistance | financial_assistance | SZRAPLY | FINANCIAL_ASSISTANCE |
tanfSsiGa | tanf_ssi_ga | SZRAPLY | TANF_SSI_GA |
fosterYouths | foster_youths | SZRAPLY | FOSTER_YOUTHS |
See here
athleticIntercollegiate | athletic_intercollegiate | SZRAPLY | ATHLETIC_INTERCOLLEGIATE |
See here
athleticIntramural | athletic_intramural | SZRAPLY | ATHLETIC_INTRAMURAL |
athleticNotInterested | athletic_not_interested | SZRAPLY | ATHLETIC_NOT_INTERESTED |
academicCounseling | academic_counseling | SZRAPLY | ACADEMIC_COUNSELING |
See here
basicSkills | basic_skills | SZRAPLY | BASIC_ |
SKILLS | |||
calworks | calworks | SZRAPLY | CALWORKS |
careerPlanning | career_planning | SZRAPLY | CAREER_PLANNING |
childCare | child_care | SZRAPLY | CHILD_CARE |
counselingPersonal | counseling_personal | SZRAPLY | COUNSELING_PERSONAL |
See here
dsps | dsps | SZRAPLY | DSPS |
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_CLASSES |
reentryProgram | reentry_program | SZRAPLY | REENTRY_PROGRAM |
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_INFO |
tutoringServices | tutoring_services | SZRAPLY | TUTORING_SERVICES |
See here
veteransServices | veterans_services | SZRAPLY | VETERANS_SERVICES |
integrityFg01 | integrity_fg_01 | SZRAPLY | INTEGRITY_FG_01 |
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_04 |
integrityFg11 | integrity_fg_11 | SZRAPLY | INTEGRITY_FG_11 |
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_49 |
integrityFg50 | integrity_fg_50 | SZRAPLY | INTEGRITY_FG_50 |
integrityFg51 | integrity_fg_51 | SZRAPLY | INTEGRITY_FG_51 |
See here
integrityFg52 | integrity_fg_52 | SZRAPLY | INTEGRITY_FG_ |
52 | |||
integrityFg53 | integrity_fg_53 | SZRAPLY | INTEGRITY_FG_53 |
integrityFg54 | integrity_fg_54 | SZRAPLY | INTEGRITY_FG_54 |
integrityFg55 | integrity_fg_55 | SZRAPLY | INTEGRITY_FG_55 |
integrityFg56 | integrity_fg_56 | SZRAPLY | INTEGRITY_FG_56 |
See here
integrityFg57 | integrity_fg_57 | SZRAPLY | INTEGRITY_FG_57 |
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_63 |
integrityFg70 | integrity_fg_70 | SZRAPLY | INTEGRITY_FG_70 |
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_LISTED |
col1Name | col1_name | SZRAPLY | COL1_NAME |
See here
col1City | col1_city | SZRAPLY | COL1_CITY |
col1State | col1_state | SZRAPLY | COL1_STATE |
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_DATE |
col1DegreeDate | col1_degree_date | SZRAPLY | COL1_DEGREE_DATE |
col1DegreeObtained | col1_degree_obtained | SZRAPLY | COL1_DEGREE_OBTAINED |
See here
col2Ceeb | col2_ceeb | SZRAPLY | COL2_CEEB |
See here
col2Cds | col2_cds | SZRAPLY | COL2_CDS |
col2NotListed | col2_not_listed | SZRAPLY | COL2_NOT_LISTED |
col2Name | col2_name | SZRAPLY | COL2_NAME |
See here
col2City | col2_city | SZRAPLY | COL2_ |
CITY | |||
col2State | col2_state | SZRAPLY | COL2_STATE |
col2Country | col2_country | SZRAPLY | COL2_COUNTRY |
col2StartDate | col2_start_date | SZRAPLY | COL2_START_DATE |
col2EndDate | col2_end_date | SZRAPLY | COL2_END_DATE |
See here
col2DegreeDate | col2_degree_date | SZRAPLY | COL2_DEGREE_DATE |
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_CITY |
col3State | col3_state | SZRAPLY | COL3_STATE |
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_DATE |
col3DegreeObtained | col3_degree_obtained | SZRAPLY | COL3_DEGREE_OBTAINED |
See here
col4Ceeb | col4_ceeb | SZRAPLY | COL4_CEEB |
col4Cds | col4_cds | SZRAPLY | COL4_CDS |
col4NotListed | col4_not_listed | SZRAPLY | COL4_NOT_LISTED |
See here
col4Name | col4_name | SZRAPLY | COL4_NAME |
See here
col4City | col4_city | SZRAPLY | COL4_CITY |
col4State | col4_state | SZRAPLY | COL4_STATE |
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_DATE |
col4DegreeDate | col4_degree_date | SZRAPLY | COL4_DEGREE_DATE |
col4DegreeObtained | col4_degree_obtained | SZRAPLY | COL4_DEGREE_OBTAINED |
See here
collegeName | college_name | SZRAPLY | COLLEGE_ |
NAME | |||
districtName | district_name | SZRAPLY | DISTRICT_NAME |
termCode | term_code | SZRAPLY | TERM_CODE |
termDescription | term_description | SZRAPLY | TERM_DESCRIPTION |
majorCode | major_code | SZRAPLY | MAJOR_CODE |
See here
majorDescription | major_description | SZRAPLY | MAJOR_DESCRIPTION |
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_PREFERENCE |
fosterYouthMis | foster_youth_mis | SZRAPLY | FOSTER_YOUTH_MIS |
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 | ZIP4 |
permAddressValidation | perm_address_validation | SZRAPLY | PERM_ADDRESS_VALIDATION |
See here
permZip4 | perm_zip4 | SZRAPLY | PERM_ZIP4 |
dischargeType | discharge_type | SZRAPLY | DISCHARGE_TYPE |
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_STATUS |
col3ExpelledStatus | col3_expelled_status | SZRAPLY | COL3_EXPELLED_STATUS |
col4ExpelledStatus | col4_expelled_status | SZRAPLY | COL4_EXPELLED_STATUS |
See here
integrityFlags | integrity_flags | SZRAPLY | INTEGRITY_FLAGS |
See here
rdd | rdd | SZRAPLY | RDD |
ssnType | ssn_type | SZRAPLY | SSN_TYPE |
militaryStationedCaEd | military_stationed_ca_ed | SZRAPLY | MILITARY_STATIONED_CA_ED |
See here
integrityFg65 | integrity_fg_65 | SZRAPLY | INTEGRITY_FG_65 |
integrityFg64 | integrity_fg_64 | SZRAPLY | INTEGRITY_FG_64 |
ipAddress | ip_address | SZRAPLY | IP_ADDRESS |
campaign1 | campaign1 | SZRAPLY | CAMPAIGN1 |
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_71 |
preferredFirstname | preferred_firstname | SZRAPLY | PREFERRED_FIRSTNAME |
See here
preferredMiddlename | preferred_middlename | SZRAPLY | PREFERRED_MIDDLENAME |
See here
preferredLastname | preferred_lastname | SZRAPLY | PREFERRED_LASTNAME |
preferredName | preferred_name | SZRAPLY | PREFERRED_NAME |
ssnNo | ssn_no | SZRAPLY | SSN_NO |
See here
completedEleventhGrade | completed_eleventh_grade | SZRAPLY | COMPLETED_ELEVENTH_GRADE |
NO LONGER USED | |||
gradePointAverage | grade_point_average | SZRAPLY | GRADE_POINT_AVERAGE |
highestEnglishCourse | highest_english_course | SZRAPLY | HIGHEST_ENGLISH_COURSE |
See here
highestEnglishGrade | highest_english_grade | SZRAPLY | HIGHEST_ENGLISH_GRADE |
highestMathCourseTaken | highest_math_course_taken | SZRAPLY | HIGHEST_MATH_COURSE_TAKEN |
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_GRADE |
integrityFg30 | integrity_fg_30 | SZRAPLY | INTEGRITY_FG_30 |
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_FULL |
col3CdsFull | col3_cds_full | SZRAPLY | COL3_CDS_FULL |
col4CdsFull | col4_cds_full | SZRAPLY | NOCOL4_CDS_FULL |
See here
ssid | ssid | SZRAPLY | SSID |
noPermAddressHomeless | no_perm_address_homeless | SZRAPLY | NO_PERM_ADDRESS_HOMELESS |
noMailingAddressHomeless | no_mailing_address_homeless | SZRAPLY | NO_MAILING_ADDRESS_HOMELESS |
termStart | term_start | SZRAPLY | TERM_START |
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_CREDIT |
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_VERIFIED |
SG v.4.7 | |||
emailVerifiedTimestamp | email_verified_timestamp | SZRAPLY | EMAIL_VERIFIED_TSTMP |
SG v.4.7 | |||
mainphoneVerified | phone_verified | SZRAPLY | PHONE_VERIFIED |
---|
SG v.4.7 | |||
mainphoneVerifiedTimestamp | phone_verified_timestamp | SZRAPLY | PHONE_VERIFIED_TSTMP |
---|
SG v.4.7 | |||
preferredMethodOfContact | preferred_contact_method | SZRAPLY | PREF_CONTACT_METHOD |
SG v.4.7 | |||
addressValidationOverride | address_validation_override | SZRAPLY | ADDRESS_VAL_OVERRIDE |
SG v.4.7 | |||
addressValidationOverrideTimestamp | address_validation_override_timestamp | SZRAPLY | ADDRESS_VAL_OVER_TSTMP |
SG v.4.7 |
Supplemental Questions Data Fields Mappings - Banner
The table below pertains to the Supplemental Questions for the Standard/Noncredit Application
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 |