CCCApply Standard Application SuperGlue Data Mappings - Banner
The tables below pertain to the CCCApply Standard & Noncredit Applications.
On This Page:
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 |
|
collegeId | college_id | SZRAPLY | COLLEGE_ID |
|
termId | term_id | SZRAPLY | TERM_ID | NOT USED |
majorId | major_id | SZRAPLY | MAJOR_ID | NOT USED |
intendedMajor | intended_major | SZRAPLY | INTENDED_MAJOR |
|
eduGoal | edu_goal | SZRAPLY | EDU_GOAL |
|
highestEduLevel | highest_edu_level | SZRAPLY | HIGHEST_EDU_LEVEL |
|
consentIndicator | consent_indicator | SZRAPLY | CONSENT_INDICATOR |
|
appLang | app_lang | SZRAPLY | APP_LANG |
|
ackFinAid | ack_fin_aid | SZRAPLY | ACK_FIN_AID |
|
finAidRef | fin_aid_ref | SZRAPLY | FIN_AID_REF |
|
confirmation | confirmation | SZRAPLY | CONFIRMATION |
|
supPageCode | sup_page_code | SZRAPLY | SUP_PAGE_CODE |
|
lastPage | last_page | SZRAPLY | LAST_PAGE |
|
streetaddress1 | streetaddress1 | SZRAPLY | STREETADDRESS1 |
|
streetaddress2 | streetaddress2 | SZRAPLY | STREETADDRESS2 |
|
city | city | SZRAPLY | CITY |
|
postalcode | postalcode | SZRAPLY | POSTALCODE |
|
state | state | SZRAPLY | STATE |
|
nonusaprovince | nonusaprovince | SZRAPLY | NONUSAPROVINCE |
|
country | country | SZRAPLY | COUNTRY |
|
nonUsAddress | non_us_address | SZRAPLY | NON_US_ADDRESS |
|
SZRAPLY |
| |||
permStreetaddress1 | perm_streetaddress1 | SZRAPLY | PERM_STREETADDRESS1 |
|
permStreetaddress2 | perm_streetaddress2 | SZRAPLY | PERM_STREETADDRESS2 |
|
permCity | perm_city | SZRAPLY | PERM_CITY |
|
permPostalcode | perm_postalcode | SZRAPLY | PERM_POSTALCODE |
|
permState | perm_state | SZRAPLY | PERM_STATE |
|
permNonusaprovince | perm_nonusaprovince | SZRAPLY | PERM_NONUSAPROVINCE |
|
permCountry | perm_country | SZRAPLY | PERM_COUNTRY |
|
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 |
|
hsEduLevel | hs_edu_level | SZRAPLY | HS_EDU_LEVEL |
|
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 |
|
cahs3year | cahs_3year | SZRAPLY | CAHS_3YEAR |
|
hsName | hs_name | SZRAPLY | HS_NAME |
|
hsCity | hs_city | SZRAPLY | HS_CITY |
|
hsState | hs_state | SZRAPLY | HS_STATE |
|
hsCountry | hs_country | SZRAPLY | HS_COUNTRY |
|
hsCds | hs_cds | SZRAPLY | HS_CDS |
|
hsCeeb | hs_ceeb | SZRAPLY | HS_CEEB |
|
hsNotListed | hs_not_listed | SZRAPLY | HS_NOT_LISTED |
|
homeSchooled | home_schooled | SZRAPLY | HOME_SCHOOLED |
|
collegeCount | college_count | SZRAPLY | COLLEGE_COUNT |
|
hsAttendance | hs_attendance | SZRAPLY | HS_ATTENDANCE |
|
coenrollConfirm | coenroll_confirm | SZRAPLY | COENROLL_CONFIRM |
|
gender | gender | SZRAPLY | GENDER |
|
pgFirstname | pg_firstname | SZRAPLY | PG_FIRSTNAME |
|
pgLastname | pg_lastname | SZRAPLY | PG_LASTNAME |
|
pgRel | pg_rel | SZRAPLY | PG_REL |
|
pg1Edu | pg1_edu | SZRAPLY | PG1_EDU |
|
pg2Edu | pg2_edu | SZRAPLY | PG2_EDU |
|
pgEduMis | pg_edu_mis | SZRAPLY | PG_EDU_MIS |
|
under19Ind | under19_ind | SZRAPLY | UNDER19_IND |
|
dependentStatus | dependent_status | SZRAPLY | DEPENDENT_STATUS |
|
raceEthnic | race_ethnic | SZRAPLY | RACE_ETHNIC |
|
hispanic | hispanic | SZRAPLY | HISPANIC |
|
raceGroup | race_group | SZRAPLY | RACE_GROUP |
|
raceEthnicFull | race_ethnic_full | SZRAPLY | RACE_ETHNIC_FULL |
|
ssn | ssn | SZRAPLY | SSN |
|
birthdate | birthdate | SZRAPLY | BIRTHDATE |
|
firstname | firstname | SZRAPLY | FIRSTNAME |
|
middlename | middlename | SZRAPLY | MIDDLENAME |
|
lastname | lastname | SZRAPLY | LASTNAME |
|
suffix | suffix | SZRAPLY | SUFFIX |
|
otherfirstname | otherfirstname | SZRAPLY | OTHERFIRSTNAME |
|
othermiddlename | othermiddlename | SZRAPLY | OTHERMIDDLENAME |
|
otherlastname | otherlastname | SZRAPLY | OTHERLASTNAME |
|
citizenshipStatus | citizenship_status | SZRAPLY | CITIZENSHIP_STATUS |
|
alienRegNumber | alien_reg_number | SZRAPLY | ALIEN_REG_NUMBER |
|
visaType | visa_type | SZRAPLY | VISA_TYPE |
|
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 |
|
alienRegNoExpire | alien_reg_no_expire | SZRAPLY | ALIEN_REG_NO_EXPIRE |
|
militaryStatus | military_status | SZRAPLY | MILITARY_STATUS |
|
militaryDischargeDate | military_discharge_date | SZRAPLY | MILITARY_DISCHARGE_DATE |
|
militaryHomeState | military_home_state | SZRAPLY | MILITARY_HOME_STATE |
|
militaryHomeCountry | military_home_country | SZRAPLY | MILITARY_HOME_COUNTRY |
|
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 |
|
caDateCurrent | ca_date_current | SZRAPLY | CA_DATE_CURRENT |
|
caNotArrived | ca_not_arrived | SZRAPLY | CA_NOT_ARRIVED |
|
caCollegeEmployee | ca_college_employee | SZRAPLY | CA_COLLEGE_EMPLOYEE |
|
caSchoolEmployee | ca_school_employee | SZRAPLY | CA_SCHOOL_EMPLOYEE |
|
caSeasonalAg | ca_seasonal_ag | SZRAPLY | CA_SEASONAL_AG |
|
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 |
|
caOutsideCollege | ca_outside_college | SZRAPLY | CA_OUTSIDE_COLLEGE |
|
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 |
|
resStatus | res_status | SZRAPLY | RES_STATUS |
|
resStatusChange | res_status_change | SZRAPLY | RES_STATUS_CHANGE |
|
resPrevDate | res_prev_date | SZRAPLY | RES_PREV_DATE |
|
admIneligible | adm_ineligible | SZRAPLY | ADM_INELIGIBLE |
|
eligAb540 | elig_ab540 | SZRAPLY | ELIG_AB540 |
|
resAreaA | res_area_a | SZRAPLY | RES_AREA_A |
|
resAreaB | res_area_b | SZRAPLY | RES_AREA_B |
|
resAreaC | res_area_c | SZRAPLY | RES_AREA_C |
|
resAreaD | res_area_d | SZRAPLY | RES_AREA_D |
|
experience | experience | SZRAPLY | EXPERIENCE |
|
recommend | recommend | SZRAPLY | RECOMMEND |
|
comments | comments | SZRAPLY | COMMENTS |
|
comfortableEnglish | comfortable_english | SZRAPLY | COMFORTABLE_ENGLISH |
|
financialAssistance | financial_assistance | SZRAPLY | FINANCIAL_ASSISTANCE |
|
tanfSsiGa | tanf_ssi_ga | SZRAPLY | TANF_SSI_GA |
|
fosterYouths | foster_youths | SZRAPLY | FOSTER_YOUTHS |
|
athleticIntercollegiate | athletic_intercollegiate | SZRAPLY | ATHLETIC_INTERCOLLEGIATE |
|
athleticIntramural | athletic_intramural | SZRAPLY | ATHLETIC_INTRAMURAL |
|
athleticNotInterested | athletic_not_interested | SZRAPLY | ATHLETIC_NOT_INTERESTED |
|
academicCounseling | academic_counseling | SZRAPLY | ACADEMIC_COUNSELING |
|
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 |
|
dsps | dsps | SZRAPLY | DSPS |
|
eops | eops | SZRAPLY | EOPS |
|
esl | esl | SZRAPLY | ESL |
|
healthServices | health_services | SZRAPLY | HEALTH_SERVICES |
|
housingInfo | housing_info | SZRAPLY | HOUSING_INFO |
|
employmentAssistance | employment_assistance | SZRAPLY | EMPLOYMENT_ASSISTANCE |
|
onlineClasses | online_classes | SZRAPLY | ONLINE_CLASSES |
|
reentryProgram | reentry_program | SZRAPLY | REENTRY_PROGRAM |
|
scholarshipInfo | scholarship_info | SZRAPLY | SCHOLARSHIP_INFO |
|
studentGovernment | student_government | SZRAPLY | STUDENT_GOVERNMENT |
|
testingAssessment | testing_assessment | SZRAPLY | TESTING_ASSESSMENT |
|
transferInfo | transfer_info | SZRAPLY | TRANSFER_INFO |
|
tutoringServices | tutoring_services | SZRAPLY | TUTORING_SERVICES |
|
veteransServices | veterans_services | SZRAPLY | VETERANS_SERVICES |
|
integrityFg01 | integrity_fg_01 | SZRAPLY | INTEGRITY_FG_01 |
|
integrityFg02 | integrity_fg_02 | SZRAPLY | INTEGRITY_FG_02 |
|
integrityFg03 | integrity_fg_03 | SZRAPLY | INTEGRITY_FG_03 |
|
integrityFg04 | integrity_fg_04 | SZRAPLY | INTEGRITY_FG_04 |
|
integrityFg11 | integrity_fg_11 | SZRAPLY | INTEGRITY_FG_11 |
|
integrityFg47 | integrity_fg_47 | SZRAPLY | INTEGRITY_FG_47 |
|
integrityFg48 | integrity_fg_48 | SZRAPLY | INTEGRITY_FG_48 |
|
integrityFg49 | integrity_fg_49 | SZRAPLY | INTEGRITY_FG_49 |
|
integrityFg50 | integrity_fg_50 | SZRAPLY | INTEGRITY_FG_50 |
|
integrityFg51 | integrity_fg_51 | SZRAPLY | INTEGRITY_FG_51 |
|
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 |
|
integrityFg57 | integrity_fg_57 | SZRAPLY | INTEGRITY_FG_57 |
|
integrityFg58 | integrity_fg_58 | SZRAPLY | INTEGRITY_FG_58 |
|
integrityFg59 | integrity_fg_59 | SZRAPLY | INTEGRITY_FG_59 |
|
integrityFg60 | integrity_fg_60 | SZRAPLY | INTEGRITY_FG_60 |
|
integrityFg61 | integrity_fg_61 | SZRAPLY | INTEGRITY_FG_61 |
|
integrityFg62 | integrity_fg_62 | SZRAPLY | INTEGRITY_FG_62 |
|
integrityFg63 | integrity_fg_63 | SZRAPLY | INTEGRITY_FG_63 |
|
integrityFg70 | integrity_fg_70 | SZRAPLY | INTEGRITY_FG_70 |
|
integrityFg80 | integrity_fg_80 | SZRAPLY | INTEGRITY_FG_80 |
|
col1Ceeb | col1_ceeb | SZRAPLY | COL1_CEEB |
|
col1Cds | col1_cds | SZRAPLY | COL1_CDS |
|
col1NotListed | col1_not_listed | SZRAPLY | COL1_NOT_LISTED |
|
col1Name | col1_name | SZRAPLY | COL1_NAME |
|
col1City | col1_city | SZRAPLY | COL1_CITY |
|
col1State | col1_state | SZRAPLY | COL1_STATE |
|
col1Country | col1_country | SZRAPLY | COL1_COUNTRY |
|
col1StartDate | col1_start_date | SZRAPLY | COL1_START_DATE |
|
col1EndDate | col1_end_date | SZRAPLY | COL1_END_DATE |
|
col1DegreeDate | col1_degree_date | SZRAPLY | COL1_DEGREE_DATE |
|
col1DegreeObtained | col1_degree_obtained | SZRAPLY | COL1_DEGREE_OBTAINED |
|
col2Ceeb | col2_ceeb | SZRAPLY | COL2_CEEB |
|
col2Cds | col2_cds | SZRAPLY | COL2_CDS |
|
col2NotListed | col2_not_listed | SZRAPLY | COL2_NOT_LISTED |
|
col2Name | col2_name | SZRAPLY | COL2_NAME |
|
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 |
|
col2DegreeDate | col2_degree_date | SZRAPLY | COL2_DEGREE_DATE |
|
col2DegreeObtained | col2_degree_obtained | SZRAPLY | COL2_DEGREE_OBTAINED |
|
col3Ceeb | col3_ceeb | SZRAPLY | COL3_CEEB |
|
col3Cds | col3_cds | SZRAPLY | COL3_CDS |
|
col3NotListed | col3_not_listed | SZRAPLY | COL3_NOT_LISTED |
|
col3Name | col3_name | SZRAPLY | COL3_NAME |
|
col3City | col3_city | SZRAPLY | COL3_CITY |
|
col3State | col3_state | SZRAPLY | COL3_STATE |
|
col3Country | col3_country | SZRAPLY | COL3_COUNTRY |
|
col3StartDate | col3_start_date | SZRAPLY | COL3_START_DATE |
|
col3EndDate | col3_end_date | SZRAPLY | COL3_END_DATE |
|
col3DegreeDate | col3_degree_date | SZRAPLY | COL3_DEGREE_DATE |
|
col3DegreeObtained | col3_degree_obtained | SZRAPLY | COL3_DEGREE_OBTAINED |
|
col4Ceeb | col4_ceeb | SZRAPLY | COL4_CEEB |
|
col4Cds | col4_cds | SZRAPLY | COL4_CDS |
|
col4NotListed | col4_not_listed | SZRAPLY | COL4_NOT_LISTED |
|
col4Name | col4_name | SZRAPLY | COL4_NAME |
|
col4City | col4_city | SZRAPLY | COL4_CITY |
|
col4State | col4_state | SZRAPLY | COL4_STATE |
|
col4Country | col4_country | SZRAPLY | COL4_COUNTRY |
|
col4StartDate | col4_start_date | SZRAPLY | COL4_START_DATE |
|
col4EndDate | col4_end_date | SZRAPLY | COL4_END_DATE |
|
col4DegreeDate | col4_degree_date | SZRAPLY | COL4_DEGREE_DATE |
|
col4DegreeObtained | col4_degree_obtained | SZRAPLY | COL4_DEGREE_OBTAINED |
|
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 |
|
majorDescription | major_description | SZRAPLY | MAJOR_DESCRIPTION |
|
tstmpSubmit | tstmp_submit | SZRAPLY | TSTMP_SUBMIT |
|
tstmpCreate | tstmp_create | SZRAPLY | TSTMP_CREATE |
|
tstmpUpdate | tstmp_update | SZRAPLY | TSTMP_UPDATE |
|
ssnDisplay | ssn_display | SZRAPLY | SSN_DISPLAY |
|
fosterYouthStatus | foster_youth_status | SZRAPLY | FOSTER_YOUTH_STATUS |
|
fosterYouthPreference | foster_youth_preference | SZRAPLY | FOSTER_YOUTH_PREFERENCE |
|
fosterYouthMis | foster_youth_mis | SZRAPLY | FOSTER_YOUTH_MIS |
|
fosterYouthPriority | foster_youth_priority | SZRAPLY | FOSTER_YOUTH_PRIORITY |
|
tstmpDownload | tstmp_download | SZRAPLY | TSTMP_DOWNLOAD |
|
addressValidation | address_validation | SZRAPLY | ADDRESS_VALIDATION |
|
zip4 | zip4 | SZRAPLY | ZIP4 |
|
permAddressValidation | perm_address_validation | SZRAPLY | PERM_ADDRESS_VALIDATION |
|
permZip4 | perm_zip4 | SZRAPLY | PERM_ZIP4 |
|
dischargeType | discharge_type | SZRAPLY | DISCHARGE_TYPE |
|
collegeExpelledSummary | college_expelled_summary | SZRAPLY | COLLEGE_EXPELLED_SUMMARY |
|
col1ExpelledStatus | col1_expelled_status | SZRAPLY | COL1_EXPELLED_STATUS |
|
col2ExpelledStatus | col2_expelled_status | SZRAPLY | COL2_EXPELLED_STATUS |
|
col3ExpelledStatus | col3_expelled_status | SZRAPLY | COL3_EXPELLED_STATUS |
|
col4ExpelledStatus | col4_expelled_status | SZRAPLY | COL4_EXPELLED_STATUS |
|
integrityFlags | integrity_flags | SZRAPLY | INTEGRITY_FLAGS |
|
rdd | rdd | SZRAPLY | RDD |
|
ssnType | ssn_type | SZRAPLY | SSN_TYPE |
|
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 |
|
ipAddress | ip_address | SZRAPLY | IP_ADDRESS |
|
campaign1 | campaign1 | SZRAPLY | CAMPAIGN1 |
|
campaign2 | campaign2 | SZRAPLY | CAMPAIGN2 |
|
campaign3 | campaign3 | SZRAPLY | CAMPAIGN3 |
|
orientation | orientation | SZRAPLY | ORIENTATION_ENCRYPTED |
|
transgender | transgender | SZRAPLY | TRANSGENDER_ENCRYPTED |
|
ssnException | ssn_exception | SZRAPLY | SSN_EXCEPTION |
|
integrityFg71 | integrity_fg_71 | SZRAPLY | INTEGRITY_FG_71 |
|
preferredFirstname | preferred_firstname | SZRAPLY | PREFERRED_FIRSTNAME |
|
preferredMiddlename | preferred_middlename | SZRAPLY | PREFERRED_MIDDLENAME |
|
preferredLastname | preferred_lastname | SZRAPLY | PREFERRED_LASTNAME |
|
preferredName | preferred_name | SZRAPLY | PREFERRED_NAME |
|
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 |
|
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 |
|
highestMathTakenGrade | highest_math_taken_grade | SZRAPLY | HIGHEST_MATH_TAKEN_GRADE |
|
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 |
|
hsCdsFull | hs_cds_full | SZRAPLY | HS_CDS_FULL |
|
col1CdsFull | col1_cds_full | SZRAPLY | COL1_CDS_FULL |
|
col2CdsFull | col2_cds_full | SZRAPLY | COL2_CDS_FULL |
|
col3CdsFull | col3_cds_full | SZRAPLY | COL3_CDS_FULL |
|
col4CdsFull | col4_cds_full | SZRAPLY | NOCOL4_CDS_FULL |
|
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 |
|
homelessYouth | homeless_youth | SZRAPLY | HOMELESS_YOUTH |
|
integrityFg40 | integrity_fg_40 | SZRAPLY | INTEGRITY_FG_40 |
|
cipCode | cip_code | SZRAPLY | CIP_CODE |
|
majorCategory | major_category | SZRAPLY | MAJOR_CATEGORY |
|
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 |
|
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 |