Info |
---|
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 |
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 |
See here
highestEduLevel | highest_edu_level | SZRAPLY | HIGHEST_EDU_LEVEL |
See here
consentIndicator | consent_indicator | SZRAPLY | CONSENT_INDICATOR |
appLang | app_lang | SZRAPLY | APP_LANG |
ackFinAid | ack_fin_aid | SZRAPLY | ACK_FIN_AID |
See here
finAidRef | fin_aid_ref | SZRAPLY | FIN_AID_REF |
confirmation | confirmation | SZRAPLY | CONFIRMATION |
supPageCode | sup_page_code | SZRAPLY | SUP_PAGE_CODE |
See here
lastPage | last_page | SZRAPLY | LAST_PAGE |
See here
streetaddress1 | streetaddress1 | SZRAPLY | STREETADDRESS1 |
streetaddress2 | streetaddress2 | SZRAPLY | STREETADDRESS2 |
city | city | SZRAPLY | CITY |
See here
postalcode | postalcode | SZRAPLY | POSTALCODE |
See here
state | state | SZRAPLY | STATE |
nonusaprovince | nonusaprovince | SZRAPLY | NONUSAPROVINCE |
country | country | SZRAPLY | COUNTRY |
See here
nonUsAddress | non_us_address | SZRAPLY | NON_US_ADDRESS |
SZRAPLY |
permStreetaddress1 | perm_streetaddress1 | SZRAPLY | PERM_STREETADDRESS1 |
See here
permStreetaddress2 | perm_streetaddress2 | SZRAPLY | PERM_STREETADDRESS2 |
See here
permCity | perm_city | SZRAPLY | PERM_CITY |
permPostalcode | perm_postalcode | SZRAPLY | PERM_POSTALCODE |
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 |
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 |
See here
higherEduLevel | higher_edu_level | SZRAPLY | HIGHER_EDU_LEVEL |
higherCompDate | higher_comp_date | SZRAPLY | HIGHER_COMP_DATE |
hsNotAttended | hs_not_attended | SZRAPLY | HS_NOT_ATTENDED |
See here
cahsGraduated | cahs_graduated | SZRAPLY | CAHS_GRADUATED |
See here
cahs3year | cahs_3year | SZRAPLY | CAHS_3YEAR |
hsName | hs_name | SZRAPLY | HS_NAME |
hsCity | hs_city | SZRAPLY | HS_CITY |
See here
hsState | hs_state | SZRAPLY | HS_STATE |
hsCountry | hs_country | SZRAPLY | HS_COUNTRY |
hsCds | hs_cds | SZRAPLY | HS_CDS |
See here
hsCeeb | hs_ceeb | SZRAPLY | HS_CEEB |
See here
hsNotListed | hs_not_listed | SZRAPLY | HS_NOT_LISTED |
homeSchooled | home_schooled | SZRAPLY | HOME_SCHOOLED |
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 |
pgFirstname | pg_firstname | SZRAPLY | PG_FIRSTNAME |
See here
pgLastname | pg_lastname | SZRAPLY | PG_LASTNAME |
pgRel | pg_rel | SZRAPLY | PG_REL |
pg1Edu | pg1_edu | SZRAPLY | PG1_EDU |
See here
pg2Edu | pg2_edu | SZRAPLY | PG2_EDU |
See here
pgEduMis | pg_edu_mis | SZRAPLY | PG_EDU_MIS |
under19Ind | under19_ind | SZRAPLY | UNDER19_IND |
dependentStatus | dependent_status | SZRAPLY | DEPENDENT_STATUS |
See here
raceEthnic | race_ethnic | SZRAPLY | RACE_ETHNIC |
See here
hispanic | hispanic | SZRAPLY | HISPANIC |
raceGroup | race_group | SZRAPLY | RACE_GROUP |
raceEthnicFull | race_ethnic_full | SZRAPLY | RACE_ETHNIC_FULL |
See here
ssn | ssn | SZRAPLY |
SSN
SSN | |||
birthdate | birthdate | SZRAPLY | BIRTHDATE |
firstname | firstname | SZRAPLY | FIRSTNAME |
See here
middlename | middlename | SZRAPLY | MIDDLENAME |
lastname | lastname | SZRAPLY | LASTNAME |
suffix | suffix | SZRAPLY | SUFFIX |
See here
otherfirstname | otherfirstname | SZRAPLY | OTHERFIRSTNAME |
See here
othermiddlename | othermiddlename | SZRAPLY | OTHERMIDDLENAME |
otherlastname | otherlastname | SZRAPLY | OTHERLASTNAME |
citizenshipStatus | citizenship_status | SZRAPLY | CITIZENSHIP_STATUS |
See here
alienRegNumber | alien_reg_number | SZRAPLY | ALIEN_REG_NUMBER |
See here
visaType | visa_type | SZRAPLY | VISA_TYPE |
noDocuments | no_documents | SZRAPLY | NO_DOCUMENTS |
alienRegIssueDate | alien_reg_issue_date | SZRAPLY | ALIEN_REG_ISSUE_DATE |
See here
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 |
See here
militaryDischargeDate | military_discharge_date | SZRAPLY | MILITARY_DISCHARGE_DATE |
See here
militaryHomeState | military_home_state | SZRAPLY | MILITARY_HOME_STATE |
militaryHomeCountry | military_home_country | SZRAPLY | MILITARY_HOME_COUNTRY |
militaryCaStationed | military_ca_stationed | SZRAPLY | MILITARY_CA_STATIONED |
See here
militaryLegalResidence | military_legal_residence | SZRAPLY | MILITARY_LEGAL_RESIDENCE |
See here
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 |
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 |
See here
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 |
See here
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 |
caOutsideLawsuit | ca_outside_lawsuit | SZRAPLY | CA_OUTSIDE_LAWSUIT |
See here
caOutsideLawsuitYear | ca_outside_lawsuit_year | SZRAPLY | CA_OUTSIDE_LAWSUIT_YEAR |
resStatus | res_status | SZRAPLY | RES_STATUS |
resStatusChange | res_status_change | SZRAPLY | RES_STATUS_CHANGE |
See here
resPrevDate | res_prev_date | SZRAPLY | RES_PREV_DATE |
See here
admIneligible | adm_ineligible | SZRAPLY | ADM_INELIGIBLE |
eligAb540 | elig_ab540 | SZRAPLY | ELIG_AB540 |
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 |
experience | experience | SZRAPLY | EXPERIENCE |
See here
recommend | recommend | SZRAPLY | RECOMMEND |
comments | comments | SZRAPLY | COMMENTS |
comfortableEnglish | comfortable_english | SZRAPLY | COMFORTABLE_ENGLISH |
See here
financialAssistance | financial_assistance | SZRAPLY | FINANCIAL_ASSISTANCE |
See here
tanfSsiGa | tanf_ssi_ga | SZRAPLY | TANF_SSI_GA |
fosterYouths | foster_youths | SZRAPLY | FOSTER_YOUTHS |
athleticIntercollegiate | athletic_intercollegiate | SZRAPLY | ATHLETIC_INTERCOLLEGIATE |
See here
athleticIntramural | athletic_intramural | SZRAPLY | ATHLETIC_INTRAMURAL |
See here
athleticNotInterested | athletic_not_interested | SZRAPLY | ATHLETIC_NOT_INTERESTED |
academicCounseling | academic_counseling | SZRAPLY | ACADEMIC_COUNSELING |
basicSkills | basic_skills | SZRAPLY | BASIC_SKILLS |
See here
calworks | calworks | SZRAPLY |
CALWORKS
CALWORKS | |||
careerPlanning | career_planning | SZRAPLY | CAREER_PLANNING |
childCare | child_care | SZRAPLY | CHILD_CARE |
See here
counselingPersonal | counseling_personal | SZRAPLY | COUNSELING_PERSONAL |
dsps | dsps | SZRAPLY | DSPS |
eops | eops | SZRAPLY | EOPS |
See here
esl | esl | SZRAPLY | ESL |
See here
healthServices | health_services | SZRAPLY | HEALTH_SERVICES |
housingInfo | housing_info | SZRAPLY | HOUSING_INFO |
employmentAssistance | employment_assistance | SZRAPLY | EMPLOYMENT_ASSISTANCE |
See here
onlineClasses | online_classes | SZRAPLY | ONLINE_CLASSES |
See here
reentryProgram | reentry_program | SZRAPLY | REENTRY_PROGRAM |
scholarshipInfo | scholarship_info | SZRAPLY | SCHOLARSHIP_INFO |
studentGovernment | student_government | SZRAPLY | STUDENT_GOVERNMENT |
See here
testingAssessment | testing_assessment | SZRAPLY | TESTING_ASSESSMENT |
transferInfo | transfer_info | SZRAPLY | TRANSFER_INFO |
tutoringServices | tutoring_services | SZRAPLY | TUTORING_SERVICES |
See here
veteransServices | veterans_services | SZRAPLY | VETERANS_SERVICES |
See here
integrityFg01 | integrity_fg_01 | SZRAPLY | INTEGRITY_FG_01 |
integrityFg02 | integrity_fg_02 | SZRAPLY | INTEGRITY_FG_02 |
integrityFg03 | integrity_fg_03 | SZRAPLY | INTEGRITY_FG_03 |
See here
integrityFg04 | integrity_fg_04 | SZRAPLY | INTEGRITY_FG_04 |
See here
integrityFg11 | integrity_fg_11 | SZRAPLY | INTEGRITY_FG_11 |
integrityFg47 | integrity_fg_47 | SZRAPLY | INTEGRITY_FG_47 |
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 |
See here
integrityFg53 | integrity_fg_53 | SZRAPLY | INTEGRITY_FG_53 |
integrityFg54 | integrity_fg_54 | SZRAPLY | INTEGRITY_FG_54 |
integrityFg55 | integrity_fg_55 | SZRAPLY | INTEGRITY_FG_55 |
See here
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 |
integrityFg59 | integrity_fg_59 | SZRAPLY | INTEGRITY_FG_59 |
See here
integrityFg60 | integrity_fg_60 | SZRAPLY | INTEGRITY_FG_60 |
integrityFg61 | integrity_fg_61 | SZRAPLY | INTEGRITY_FG_61 |
integrityFg62 | integrity_fg_62 | SZRAPLY | INTEGRITY_FG_62 |
See here
integrityFg63 | integrity_fg_63 | SZRAPLY | INTEGRITY_FG_63 |
See here
integrityFg70 | integrity_fg_70 | SZRAPLY | INTEGRITY_FG_70 |
integrityFg80 | integrity_fg_80 | SZRAPLY | INTEGRITY_FG_80 |
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 |
col1City | col1_city | SZRAPLY | COL1_CITY |
See here
col1State | col1_state | SZRAPLY | COL1_STATE |
col1Country | col1_country | SZRAPLY | COL1_COUNTRY |
col1StartDate | col1_start_date | SZRAPLY | COL1_START_DATE |
See here
col1EndDate | col1_end_date | SZRAPLY | COL1_END_DATE |
See here
col1DegreeDate | col1_degree_date | SZRAPLY | COL1_DEGREE_DATE |
col1DegreeObtained | col1_degree_obtained | SZRAPLY | COL1_DEGREE_OBTAINED |
col2Ceeb | col2_ceeb | SZRAPLY | COL2_CEEB |
See here
col2Cds | col2_cds | SZRAPLY | COL2_CDS |
See here
col2NotListed | col2_not_listed | SZRAPLY | COL2_NOT_LISTED |
col2Name | col2_name | SZRAPLY | COL2_NAME |
col2City | col2_city | SZRAPLY | COL2_CITY |
See here
col2State | col2_state | SZRAPLY | COL2_ |
STATE | |||
col2Country | col2_country | SZRAPLY | COL2_COUNTRY |
col2StartDate | col2_start_date | SZRAPLY | COL2_START_DATE |
See here
col2EndDate | col2_end_date | SZRAPLY | COL2_END_DATE |
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 |
col3NotListed | col3_not_listed | SZRAPLY | COL3_NOT_LISTED |
col3Name | col3_name | SZRAPLY | COL3_NAME |
See here
col3City | col3_city | SZRAPLY | COL3_CITY |
See here
col3State | col3_state | SZRAPLY | COL3_STATE |
col3Country | col3_country | SZRAPLY | COL3_COUNTRY |
col3StartDate | col3_start_date | SZRAPLY | COL3_START_DATE |
See here
col3EndDate | col3_end_date | SZRAPLY | COL3_END_DATE |
col3DegreeDate | col3_degree_date | SZRAPLY | COL3_DEGREE_DATE |
col3DegreeObtained | col3_degree_obtained | SZRAPLY | COL3_DEGREE_OBTAINED |
See here
col4Ceeb | col4_ceeb | SZRAPLY | COL4_CEEB |
See here
col4Cds | col4_cds | SZRAPLY | COL4_CDS |
col4NotListed | col4_not_listed | SZRAPLY | COL4_NOT_LISTED |
col4Name | col4_name | SZRAPLY | COL4_NAME |
See here
col4City | col4_city | SZRAPLY | COL4_CITY |
See here
col4State | col4_state | SZRAPLY | COL4_STATE |
col4Country | col4_country | SZRAPLY | COL4_COUNTRY |
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 |
See here
districtName | district_name | SZRAPLY | DISTRICT_NAME |
termCode | term_code | SZRAPLY | TERM_CODE |
termDescription | term_description | SZRAPLY | TERM_DESCRIPTION |
See here
majorCode | major_code | SZRAPLY | MAJOR_CODE |
See here
majorDescription | major_description | SZRAPLY | MAJOR_DESCRIPTION |
tstmpSubmit | tstmp_submit | SZRAPLY | TSTMP_SUBMIT |
tstmpCreate | tstmp_create | SZRAPLY | TSTMP_CREATE |
See here
tstmpUpdate | tstmp_update | SZRAPLY | TSTMP_UPDATE |
ssnDisplay | ssn_display | SZRAPLY | SSN_DISPLAY |
fosterYouthStatus | foster_youth_status | SZRAPLY | FOSTER_YOUTH_STATUS |
See here
fosterYouthPreference | foster_youth_preference | SZRAPLY | FOSTER_YOUTH_PREFERENCE |
See here
fosterYouthMis | foster_youth_mis | SZRAPLY | FOSTER_YOUTH_MIS |
fosterYouthPriority | foster_youth_priority | SZRAPLY | FOSTER_YOUTH_PRIORITY |
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 |
permZip4 | perm_zip4 | SZRAPLY | PERM_ZIP4 |
See here
dischargeType | discharge_type | SZRAPLY | DISCHARGE_TYPE |
collegeExpelledSummary | college_expelled_summary | SZRAPLY | COLLEGE_EXPELLED_SUMMARY |
col1ExpelledStatus | col1_expelled_status | SZRAPLY | COL1_EXPELLED_STATUS |
See here
col2ExpelledStatus | col2_expelled_status | SZRAPLY | COL2_EXPELLED_STATUS |
See here
col3ExpelledStatus | col3_expelled_status | SZRAPLY | COL3_EXPELLED_STATUS |
col4ExpelledStatus | col4_expelled_status | SZRAPLY | COL4_EXPELLED_STATUS |
integrityFlags | integrity_flags | SZRAPLY | INTEGRITY_FLAGS |
See here
rdd | rdd | SZRAPLY | RDD |
See here
ssnType | ssn_type | SZRAPLY | SSN_TYPE |
militaryStationedCaEd | military_stationed_ca_ed | SZRAPLY | MILITARY_STATIONED_CA_ED |
integrityFg65 | integrity_fg_65 | SZRAPLY | INTEGRITY_FG_65 |
See here
integrityFg64 | integrity_fg_64 | SZRAPLY | INTEGRITY_FG_64 |
ipAddress | ip_address | SZRAPLY | IP_ADDRESS |
campaign1 | campaign1 | SZRAPLY | CAMPAIGN1 |
See here
campaign2 | campaign2 | SZRAPLY | CAMPAIGN2 |
See here
campaign3 | campaign3 | SZRAPLY | CAMPAIGN3 |
orientation | orientation | SZRAPLY | ORIENTATION_ENCRYPTED |
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 |
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
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 |
highestMathPassedGrade |
highestMathTakenGrade
highest_math_ |
passed_grade | SZRAPLY | HIGHEST_MATH_ |
See here
highestMathCoursePassed
highest_math_course_passed
SZRAPLY
HIGHEST_MATH_COURSE_PASSED
See here
highestMathPassedGrade
highest_math_passed_grade
SZRAPLY
HIGHEST_MATH_PASSED_GRADE
See here
integrityFg30
integrity_fg_30
SZRAPLY
INTEGRITY_FG_30
See 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_FULL
See here
col3CdsFull
col3_cds_full
SZRAPLY
COL3_CDS_FULL
See here
col4CdsFull
col4_cds_full
SZRAPLY
NOCOL4_CDS_FULL
See here
ssid
ssid
SZRAPLY
SSID
See here
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
See 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
See here
secondphoneintl
secondphoneintl
SZRAPLY
SECONDPHONEINTL
See here
nonCredit
non_credit
SZRAPLY
NON_CREDIT
See here
integrityFg81
integrity_fg_81
SZRAPLY
INTEGRITY_FG_81
See here
highestGradeCompleted
highest_grade_completed
SZRAPLY
HIGHEST_GRADE_COMPLETED
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 | 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 |