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 |
cccId | ccc_id | SZRAPLY | CCC_ID |
status | status | SZRAPLY | STATUS |
See here
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 |
highestEduLevel | highest_edu_level | SZRAPLY | HIGHEST_EDU_LEVEL |
consentIndicator | consent_indicator | SZRAPLY | CONSENT_INDICATOR |
See here
appLang | app_lang | SZRAPLY | APP_LANG |
ackFinAid | ack_fin_aid | SZRAPLY | ACK_FIN_AID |
finAidRef | fin_aid_ref | SZRAPLY | FIN_AID_REF |
See here
confirmation | confirmation | SZRAPLY | CONFIRMATION |
See here
supPageCode | sup_page_code | SZRAPLY | SUP_PAGE_CODE |
lastPage | last_page | SZRAPLY | LAST_PAGE |
streetaddress1 | streetaddress1 | SZRAPLY | STREETADDRESS1 |
See here
streetaddress2 | streetaddress2 | SZRAPLY | STREETADDRESS2 |
See here
city | city | SZRAPLY | CITY |
postalcode | postalcode | SZRAPLY | POSTALCODE |
state | state | SZRAPLY | STATE |
See here
nonusaprovince | nonusaprovince | SZRAPLY | NONUSAPROVINCE |
country | country | SZRAPLY | COUNTRY |
nonUsAddress | non_us_address | SZRAPLY | NON_US_ADDRESS |
See here
SZRAPLY |
See here
permStreetaddress1 | perm_streetaddress1 | SZRAPLY | PERM_STREETADDRESS1 |
permStreetaddress2 | perm_streetaddress2 | SZRAPLY | PERM_STREETADDRESS2 |
permCity | perm_city | SZRAPLY | PERM_CITY |
See here
permPostalcode | perm_postalcode | SZRAPLY | PERM_POSTALCODE |
See here
permState | perm_state | SZRAPLY | PERM_STATE |
permNonusaprovince | perm_nonusaprovince | SZRAPLY | PERM_NONUSAPROVINCE |
permCountry | perm_country | SZRAPLY | PERM_COUNTRY |
See here
addressSame | address_same | SZRAPLY | ADDRESS_SAME |
mainphone | mainphone | SZRAPLY | MAINPHONE |
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 |
See here
hsEduLevel | hs_edu_level | SZRAPLY | HS_EDU_LEVEL |
hsCompDate | hs_comp_date | SZRAPLY | HS_COMP_DATE |
higherEduLevel | higher_edu_level | SZRAPLY | HIGHER_EDU_LEVEL |
See here
higherCompDate | higher_comp_date | SZRAPLY | HIGHER_COMP_DATE |
See here
hsNotAttended | hs_not_attended | SZRAPLY | HS_NOT_ATTENDED |
cahsGraduated | cahs_graduated | SZRAPLY | CAHS_GRADUATED |
cahs3year | cahs_3year | SZRAPLY | CAHS_3YEAR |
See here
hsName | hs_name | SZRAPLY | HS_NAME |
hsCity | hs_city | SZRAPLY | HS_CITY |
hsState | hs_state | SZRAPLY | HS_STATE |
See here
hsCountry | hs_country | SZRAPLY | HS_COUNTRY |
See here
hsCds | hs_cds | SZRAPLY | HS_CDS |
hsCeeb | hs_ceeb | SZRAPLY | HS_CEEB |
hsNotListed | hs_not_listed | SZRAPLY | HS_NOT_LISTED |
See here
homeSchooled | home_schooled | SZRAPLY | HOME_SCHOOLED |
See here
collegeCount | college_count | SZRAPLY | COLLEGE_COUNT |
hsAttendance | hs_attendance | SZRAPLY | HS_ATTENDANCE |
coenrollConfirm | coenroll_confirm | SZRAPLY | COENROLL_CONFIRM |
See here
gender | gender | SZRAPLY |
GENDER
GENDER | |||
pgFirstname | pg_firstname | SZRAPLY | PG_FIRSTNAME |
pgLastname | pg_lastname | SZRAPLY | PG_LASTNAME |
See here
pgRel | pg_rel | SZRAPLY | PG_REL |
pg1Edu | pg1_edu | SZRAPLY | PG1_EDU |
pg2Edu | pg2_edu | SZRAPLY | PG2_EDU |
See here
pgEduMis | pg_edu_mis | SZRAPLY | PG_EDU_MIS |
See here
under19Ind | under19_ind | SZRAPLY | UNDER19_IND |
dependentStatus | dependent_status | SZRAPLY | DEPENDENT_STATUS |
raceEthnic | race_ethnic | SZRAPLY | RACE_ETHNIC |
See here
hispanic | hispanic | SZRAPLY | HISPANIC |
See here
raceGroup | race_group | SZRAPLY | RACE_GROUP |
raceEthnicFull | race_ethnic_full | SZRAPLY | RACE_ETHNIC_FULL |
ssn | ssn | SZRAPLY | SSN |
See here
birthdate | birthdate | SZRAPLY | BIRTHDATE |
firstname | firstname | SZRAPLY | FIRSTNAME |
middlename | middlename | SZRAPLY | MIDDLENAME |
See here
lastname | lastname | SZRAPLY | LASTNAME |
See here
suffix | suffix | SZRAPLY | SUFFIX |
otherfirstname | otherfirstname | SZRAPLY | OTHERFIRSTNAME |
othermiddlename | othermiddlename | SZRAPLY | OTHERMIDDLENAME |
See here
otherlastname | otherlastname | SZRAPLY | OTHERLASTNAME |
See here
citizenshipStatus | citizenship_status | SZRAPLY | CITIZENSHIP_STATUS |
alienRegNumber | alien_reg_number | SZRAPLY | ALIEN_REG_NUMBER |
visaType | visa_type | SZRAPLY | VISA_TYPE |
See here
noDocuments | no_documents | SZRAPLY | NO_DOCUMENTS |
alienRegIssueDate | alien_reg_issue_date | SZRAPLY | ALIEN_REG_ISSUE_DATE |
alienRegExpireDate | alien_reg_expire_date | SZRAPLY | ALIEN_REG_EXPIRE_DATE |
See here
alienRegNoExpire | alien_reg_no_expire | SZRAPLY | ALIEN_REG_NO_EXPIRE |
See here
militaryStatus | military_status | SZRAPLY | MILITARY_STATUS |
militaryDischargeDate | military_discharge_date | SZRAPLY | MILITARY_DISCHARGE_DATE |
militaryHomeState | military_home_state | SZRAPLY | MILITARY_HOME_STATE |
See here
militaryHomeCountry | military_home_country | SZRAPLY | MILITARY_HOME_COUNTRY |
See here
militaryCaStationed | military_ca_stationed | SZRAPLY | MILITARY_CA_STATIONED |
militaryLegalResidence | military_legal_residence | SZRAPLY | MILITARY_LEGAL_RESIDENCE |
caRes2Years | ca_res_2_years | SZRAPLY | CA_RES_2_YEARS |
See here
caDateCurrent | ca_date_current | SZRAPLY | CA_DATE_CURRENT |
caNotArrived | ca_not_arrived | SZRAPLY | CA_NOT_ARRIVED |
caCollegeEmployee | ca_college_employee | SZRAPLY | CA_COLLEGE_EMPLOYEE |
See here
caSchoolEmployee | ca_school_employee | SZRAPLY | CA_SCHOOL_EMPLOYEE |
See here
caSeasonalAg | ca_seasonal_ag | SZRAPLY | CA_SEASONAL_AG |
caFosterYouth | ca_foster_youth | SZRAPLY | CA_FOSTER_YOUTH |
caOutsideTax | ca_outside_tax | SZRAPLY | CA_OUTSIDE_TAX |
See here
caOutsideTaxYear | ca_outside_tax_year | SZRAPLY | CA_OUTSIDE_TAX_YEAR |
See here
caOutsideVoted | ca_outside_voted | SZRAPLY | CA_OUTSIDE_VOTED |
caOutsideVotedYear | ca_outside_voted_year | SZRAPLY | CA_OUTSIDE_VOTED_YEAR |
caOutsideCollege | ca_outside_college | SZRAPLY | CA_OUTSIDE_COLLEGE |
See here
caOutsideCollegeYear | ca_outside_college_year | SZRAPLY | CA_OUTSIDE_COLLEGE_YEAR |
caOutsideLawsuit | ca_outside_lawsuit | SZRAPLY | CA_OUTSIDE_LAWSUIT |
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 |
resPrevDate | res_prev_date | SZRAPLY | RES_PREV_DATE |
admIneligible | adm_ineligible | SZRAPLY | ADM_INELIGIBLE |
See here
eligAb540 | elig_ab540 | SZRAPLY | ELIG_AB540 |
See here
resAreaA | res_area_a | SZRAPLY | RES_AREA_A |
resAreaB | res_area_b | SZRAPLY | RES_AREA_B |
resAreaC | res_area_c | SZRAPLY | RES_AREA_C |
See here
resAreaD | res_area_d | SZRAPLY | RES_AREA_ |
D | |||
experience | experience | SZRAPLY | EXPERIENCE |
recommend | recommend | SZRAPLY | RECOMMEND |
See here
comments | comments | SZRAPLY | COMMENTS |
comfortableEnglish | comfortable_english | SZRAPLY | COMFORTABLE_ENGLISH |
financialAssistance | financial_assistance | SZRAPLY | FINANCIAL_ASSISTANCE |
See here
tanfSsiGa | tanf_ssi_ga | SZRAPLY | TANF_SSI_GA |
See here
fosterYouths | foster_youths | SZRAPLY | FOSTER_YOUTHS |
athleticIntercollegiate | athletic_intercollegiate | SZRAPLY | ATHLETIC_INTERCOLLEGIATE |
athleticIntramural | athletic_intramural | SZRAPLY | ATHLETIC_INTRAMURAL |
See here
athleticNotInterested | athletic_not_interested | SZRAPLY | ATHLETIC_NOT_INTERESTED |
See here
academicCounseling | academic_counseling | SZRAPLY | ACADEMIC_COUNSELING |
basicSkills | basic_skills | SZRAPLY | BASIC_SKILLS |
calworks | calworks | SZRAPLY | CALWORKS |
See here
careerPlanning | career_planning | SZRAPLY | CAREER_PLANNING |
childCare | child_care | SZRAPLY | CHILD_CARE |
counselingPersonal | counseling_personal | SZRAPLY | COUNSELING_PERSONAL |
See here
dsps | dsps | SZRAPLY | DSPS |
See here
eops | eops | SZRAPLY | EOPS |
esl | esl | SZRAPLY | ESL |
healthServices | health_services | SZRAPLY | HEALTH_SERVICES |
See here
housingInfo | housing_info | SZRAPLY | HOUSING_INFO |
See here
employmentAssistance | employment_assistance | SZRAPLY | EMPLOYMENT_ASSISTANCE |
onlineClasses | online_classes | SZRAPLY | ONLINE_CLASSES |
reentryProgram | reentry_program | SZRAPLY | REENTRY_PROGRAM |
See here
scholarshipInfo | scholarship_info | SZRAPLY | SCHOLARSHIP_INFO |
studentGovernment | student_government | SZRAPLY | STUDENT_GOVERNMENT |
testingAssessment | testing_assessment | SZRAPLY | TESTING_ASSESSMENT |
See here
transferInfo | transfer_info | SZRAPLY | TRANSFER_INFO |
See here
tutoringServices | tutoring_services | SZRAPLY | TUTORING_SERVICES |
veteransServices | veterans_services | SZRAPLY | VETERANS_SERVICES |
integrityFg01 | integrity_fg_01 | SZRAPLY | INTEGRITY_FG_01 |
See here
integrityFg02 | integrity_fg_02 | SZRAPLY | INTEGRITY_FG_02 |
See here
integrityFg03 | integrity_fg_03 | SZRAPLY | INTEGRITY_FG_03 |
integrityFg04 | integrity_fg_04 | SZRAPLY | INTEGRITY_FG_04 |
integrityFg11 | integrity_fg_11 | SZRAPLY | INTEGRITY_FG_11 |
See here
integrityFg47 | integrity_fg_47 | SZRAPLY | INTEGRITY_FG_47 |
integrityFg48 | integrity_fg_48 | SZRAPLY | INTEGRITY_FG_48 |
integrityFg49 | integrity_fg_49 | SZRAPLY | INTEGRITY_FG_49 |
See here
integrityFg50 | integrity_fg_50 | SZRAPLY | INTEGRITY_FG_50 |
See here
integrityFg51 | integrity_fg_51 | SZRAPLY | INTEGRITY_FG_51 |
integrityFg52 | integrity_fg_52 | SZRAPLY | INTEGRITY_FG_52 |
integrityFg53 | integrity_fg_53 | SZRAPLY | INTEGRITY_FG_53 |
See here
integrityFg54 | integrity_fg_54 | SZRAPLY | INTEGRITY_FG_54 |
See here
integrityFg55 | integrity_fg_55 | SZRAPLY | INTEGRITY_FG_55 |
integrityFg56 | integrity_fg_56 | SZRAPLY | INTEGRITY_FG_56 |
integrityFg57 | integrity_fg_57 | SZRAPLY | INTEGRITY_FG_57 |
See here
integrityFg58 | integrity_fg_58 | SZRAPLY | INTEGRITY_FG_58 |
integrityFg59 | integrity_fg_59 | SZRAPLY | INTEGRITY_FG_59 |
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 |
integrityFg63 | integrity_fg_63 | SZRAPLY | INTEGRITY_FG_63 |
integrityFg70 | integrity_fg_70 | SZRAPLY | INTEGRITY_FG_70 |
See here
integrityFg80 | integrity_fg_80 | SZRAPLY | INTEGRITY_FG_80 |
See here
col1Ceeb | col1_ceeb | SZRAPLY | COL1_CEEB |
col1Cds | col1_cds | SZRAPLY | COL1_CDS |
col1NotListed | col1_not_listed | SZRAPLY | COL1_NOT_LISTED |
See here
col1Name | col1_name | SZRAPLY | COL1_ |
NAME | |||
col1City | col1_city | SZRAPLY | COL1_CITY |
col1State | col1_state | SZRAPLY | COL1_STATE |
See here
col1Country | col1_country | SZRAPLY | COL1_COUNTRY |
col1StartDate | col1_start_date | SZRAPLY | COL1_START_DATE |
col1EndDate | col1_end_date | SZRAPLY | COL1_END_DATE |
See here
col1DegreeDate | col1_degree_date | SZRAPLY | COL1_DEGREE_DATE |
See here
col1DegreeObtained | col1_degree_obtained | SZRAPLY | COL1_DEGREE_OBTAINED |
col2Ceeb | col2_ceeb | SZRAPLY | COL2_CEEB |
col2Cds | col2_cds | SZRAPLY | COL2_CDS |
See here
col2NotListed | col2_not_listed | SZRAPLY | COL2_NOT_LISTED |
See here
col2Name | col2_name | SZRAPLY | COL2_NAME |
col2City | col2_city | SZRAPLY | COL2_CITY |
col2State | col2_state | SZRAPLY | COL2_STATE |
See here
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 |
See here
col2DegreeObtained | col2_degree_obtained | SZRAPLY | COL2_DEGREE_OBTAINED |
col3Ceeb | col3_ceeb | SZRAPLY | COL3_CEEB |
col3Cds | col3_cds | SZRAPLY | COL3_CDS |
See here
col3NotListed | col3_not_listed | SZRAPLY | COL3_NOT_LISTED |
See here
col3Name | col3_name | SZRAPLY | COL3_NAME |
col3City | col3_city | SZRAPLY | COL3_CITY |
col3State | col3_state | SZRAPLY | COL3_STATE |
See here
col3Country | col3_country | SZRAPLY | COL3_COUNTRY |
col3StartDate | col3_start_date | SZRAPLY | COL3_START_DATE |
col3EndDate | col3_end_date | SZRAPLY | COL3_END_DATE |
See here
col3DegreeDate | col3_degree_date | SZRAPLY | COL3_DEGREE_DATE |
See here
col3DegreeObtained | col3_degree_obtained | SZRAPLY | COL3_DEGREE_OBTAINED |
col4Ceeb | col4_ceeb | SZRAPLY | COL4_CEEB |
col4Cds | col4_cds | SZRAPLY | COL4_CDS |
See here
col4NotListed | col4_not_listed | SZRAPLY | COL4_NOT_LISTED |
See here
col4Name | col4_name | SZRAPLY | COL4_NAME |
col4City | col4_city | SZRAPLY | COL4_CITY |
col4State | col4_state | SZRAPLY | COL4_STATE |
See here
col4Country | col4_country | SZRAPLY | COL4_COUNTRY |
col4StartDate | col4_start_date | SZRAPLY | COL4_START_DATE |
col4EndDate | col4_end_date | SZRAPLY | COL4_END_DATE |
See here
col4DegreeDate | col4_degree_date | SZRAPLY | COL4_DEGREE_DATE |
See here
col4DegreeObtained | col4_degree_obtained | SZRAPLY | COL4_DEGREE_OBTAINED |
collegeName | college_name | SZRAPLY | COLLEGE_NAME |
districtName | district_name | SZRAPLY | DISTRICT_NAME |
See here
termCode | term_code | SZRAPLY | TERM_CODE |
See here
termDescription | term_description | SZRAPLY | TERM_DESCRIPTION |
majorCode | major_code | SZRAPLY | MAJOR_CODE |
majorDescription | major_description | SZRAPLY | MAJOR_DESCRIPTION |
See here
tstmpSubmit | tstmp_submit | SZRAPLY | TSTMP_SUBMIT |
tstmpCreate | tstmp_create | SZRAPLY | TSTMP_CREATE |
tstmpUpdate | tstmp_update | SZRAPLY | TSTMP_UPDATE |
See here
ssnDisplay | ssn_display | SZRAPLY | SSN_DISPLAY |
See here
fosterYouthStatus | foster_youth_status | SZRAPLY | FOSTER_YOUTH_STATUS |
fosterYouthPreference | foster_youth_preference | SZRAPLY | FOSTER_YOUTH_PREFERENCE |
fosterYouthMis | foster_youth_mis | SZRAPLY | FOSTER_YOUTH_MIS |
See here
fosterYouthPriority | foster_youth_priority | SZRAPLY | FOSTER_YOUTH_PRIORITY |
See here
tstmpDownload | tstmp_download | SZRAPLY | TSTMP_DOWNLOAD |
addressValidation | address_validation | SZRAPLY | ADDRESS_VALIDATION |
zip4 | zip4 | SZRAPLY | ZIP4 |
See here
permAddressValidation | perm_address_validation | SZRAPLY | PERM_ADDRESS_VALIDATION |
permZip4 | perm_zip4 | SZRAPLY | PERM_ZIP4 |
dischargeType | discharge_type | SZRAPLY | DISCHARGE_TYPE |
See here
collegeExpelledSummary | college_expelled_summary | SZRAPLY | COLLEGE_EXPELLED_SUMMARY |
See here
col1ExpelledStatus | col1_expelled_status | SZRAPLY | COL1_EXPELLED_STATUS |
col2ExpelledStatus | col2_expelled_status | SZRAPLY | COL2_EXPELLED_STATUS |
col3ExpelledStatus | col3_expelled_status | SZRAPLY | COL3_EXPELLED_STATUS |
See here
col4ExpelledStatus | col4_expelled_status | SZRAPLY | COL4_EXPELLED_STATUS |
See here
integrityFlags | integrity_flags | SZRAPLY | INTEGRITY_FLAGS |
rdd | rdd | SZRAPLY | RDD |
ssnType | ssn_type | SZRAPLY | SSN_TYPE |
See here
militaryStationedCaEd | military_stationed_ca_ed | SZRAPLY | MILITARY_STATIONED_CA_ED |
integrityFg65 | integrity_fg_65 | SZRAPLY | INTEGRITY_FG_65 |
integrityFg64 | integrity_fg_64 | SZRAPLY | INTEGRITY_FG_64 |
See here
ipAddress | ip_address | SZRAPLY | IP_ADDRESS |
See here
campaign1 | campaign1 | SZRAPLY | CAMPAIGN1 |
campaign2 | campaign2 | SZRAPLY | CAMPAIGN2 |
campaign3 | campaign3 | SZRAPLY | CAMPAIGN3 |
See here
orientation | orientation | SZRAPLY | ORIENTATION_ENCRYPTED |
See here
transgender | transgender | SZRAPLY | TRANSGENDER_ENCRYPTED |
ssnException | ssn_exception | SZRAPLY | SSN_EXCEPTION |
integrityFg71 | integrity_fg_71 | SZRAPLY | INTEGRITY_FG_71 |
See here
preferredFirstname | preferred_firstname | SZRAPLY | PREFERRED_FIRSTNAME |
preferredMiddlename | preferred_middlename | SZRAPLY | PREFERRED_MIDDLENAME |
preferredLastname | preferred_lastname | SZRAPLY | PREFERRED_LASTNAME |
See here
preferredName | preferred_name | SZRAPLY | PREFERRED_NAME |
See here
ssnNo | ssn_no | SZRAPLY | SSN_NO |
completedEleventhGrade | completed_eleventh_grade | SZRAPLY | COMPLETED_ELEVENTH_GRADE |
NO LONGER USED | |||
gradePointAverage | grade_point_average | SZRAPLY | GRADE_POINT_AVERAGE |
See here
highestEnglishCourse | highest_english_course | SZRAPLY | HIGHEST_ENGLISH_COURSE |
highestEnglishGrade | highest_english_grade | SZRAPLY | HIGHEST_ENGLISH_GRADE |
highestMathCourseTaken | highest_math_course_taken | SZRAPLY | HIGHEST_MATH_COURSE_TAKEN |
See here
highestMathTakenGrade | highest_math_taken_grade | SZRAPLY | HIGHEST_MATH_TAKEN_GRADE |
See here
highestMathCoursePassed | highest_math_course_passed | SZRAPLY | HIGHEST_MATH_COURSE_PASSED |
highestMathPassedGrade | highest_math_passed_grade | SZRAPLY | HIGHEST_MATH_PASSED_GRADE |
integrityFg30 | integrity_fg_30 | SZRAPLY | INTEGRITY_FG_30 |
See here
hsCdsFull | hs_cds_full | SZRAPLY | HS_CDS_FULL |
col1CdsFull | col1_cds_full | SZRAPLY | COL1_CDS_FULL |
col2CdsFull | col2_cds_full | SZRAPLY | COL2_CDS_FULL |
See here
col3CdsFull | col3_cds_full | SZRAPLY | COL3_CDS_FULL |
See here
col4CdsFull | col4_cds_full | SZRAPLY | NOCOL4_CDS_FULL |
ssid | ssid | SZRAPLY | SSID |
noPermAddressHomeless | no_perm_address_homeless | SZRAPLY | NO_PERM_ADDRESS_HOMELESS |
See here
noMailingAddressHomeless | no_mailing_address_homeless | SZRAPLY | NO_MAILING_ADDRESS_HOMELESS |
See here
termStart | term_start | SZRAPLY | TERM_START |
termEnd | term_end | SZRAPLY | TERM_END |
homelessYouth | homeless_youth | SZRAPLY | HOMELESS_YOUTH |
See here
integrityFg40 | integrity_fg_40 | SZRAPLY | INTEGRITY_FG_40 |
cipCode | cip_code | SZRAPLY | CIP_CODE |
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 |
See here
integrityFg81 | integrity_fg_81 | SZRAPLY | INTEGRITY_FG_81 |
highestGradeCompleted | highest_grade_completed | SZRAPLY | HIGHEST_GRADE_COMPLETED |
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 |