CC Promise Grant Application SuperGlue Data Mappings - Banner
- Patricia Donohue
The tables below reflect the latest version of the CC Promise Grant Online Application.
CC Promise Grant Data Fields Table Mapping - Banner
For more details, see the latest CC Promise Grant Application data dictionary.
College Adaptor Payload Field | Data Dictionary Name | Banner Table Name | Banner Field Name | Notes |
|---|---|---|---|---|
studentDeps18Over | student_deps_18Over | SZRPGRT | STU_DEPS_18_OVER | SG v.4.10 |
studentDepsUnder18 | student_deps_Under18 | SZRPGRT | STU_DEPS_UNDER_18 | SG v.4.10 |
idmeConfirmationTimestamp | idme_confirmation_timestamp | SZRPGRT | IDME_CONFIRMATION_TSTMP | SG v.4.9 |
idmeOptinTimestamp | idme_optin_timestamp | SZRPGRT | IDME_OPTIN_TSTMP | SG v.4.9 |
idmeWorkflowStatus | idme_workflow_status | SZRPGRT | IDME_WORKFLOW_STATUS | SG v.4.9 |
studentParent | student_parent | SZRPGRT | STUDENT_PARENT | Question added v.6.13 / SG v.4.7 |
acceptedTerms | accepted_terms | SZRPGRT | ACCEPTED_TERMS_TSTMP | SG v.4.7 |
acceptedTermsTimestamp | accepted_terms_timestamp | SZRPGRT | ACCEPTED_TERMS_TSTMP | SG v.4.7 |
addressValidationOverride | address_validation_override | SZRPGRT | ADDRESS_VAL_OVERRIDE | SG v.4.6 |
addressValidationOverrideTimestamp | address_validation_override_timestamp | SZRPGRT | ADDRESS_VAL_OVER_TSTMP | SG v.4.6 |
emailVerified | email_verified | SZRPGRT | EMAIL_VERIFIED | SG v.4.6 |
emailVerifiedTimestamp | email_verified_timestamp | SZRPGRT | EMAIL_VERIFIED_TSTMP | SG v.4.6 |
ipAddressAtAccountCreation | ip_address_at_account_creation | SZRPGRT | IP_ADDR_ACCT_CREATE | SG v.4.7 |
ipAddressAtAppCreation | ip_address_at_app_creation | SZRPGRT | IP_ADDR_APP_CREATE | SG v.4.7 |
mailingAddressValidationOverride | mailing_address_validation_override | SZRPGRT | MAIL_ADDR_VALIDATION_OVR | SG v.4.7 |
mainphoneVerified | phone_verified | SZRPGRT | PHONE_VERIFIED | SG v.4.6 |
mainphoneVerifiedTimestamp | phone_verified_timestamp | SZRPGRT | PHONE_VERIFIED_TSTMP | SG v.4.6 |
phoneType | phone_type | SZRPGRT | PHONE_TYPE | SG v.4.7 |
preferredMethodOfContact | preferred_contact_method | SZRPGRT | PREF_CONTACT_METHOD | SG v.4.6 |
sisReceipt | sis_receipt |
|
| Coming |
appId | app_id | SZRPGRT | APP_ID |
|
ccId | ccc_id | SZRPGRT | CCC_ID |
|
confirmationNumber | confirmation_number | SZRPGRT | CONFIRMATION_NUMBER |
|
status | status | SZRPGRT | STATUS |
|
appLang | app_lang | SZRPGRT | APP_LANG |
|
collegeId | college_id | SZRPGRT | COLLEGE_ID |
|
yearCode | year_code | SZRPGRT | YEAR_CODE |
|
yearDescription | year_description | SZRPGRT | YEAR_DESCRIPTION |
|
determinedResidentca | determined_residentca | SZRPGRT | DETERMINED_RESIDENTCA |
|
determinedAB540Eligible | determined_ab540_eligible | SZRPGRT | DETERMINED_AB540_ELIGIBLE |
|
determinedNonResExempt | determined_non_res_exempt | SZRPGRT | DETERMINED_NON_RES_EXEMPT |
|
lastname | lastname | SZRPGRT | LASTNAME |
|
firstname | firstname | SZRPGRT | FIRSTNAME |
|
middlename | middlename | SZRPGRT | MIDDLENAME |
|
mainphone | mainphone | SZRPGRT | MAINPHONE |
|
mainphoneExt | mainphone_ext | SZRPGRT | MAINPHONE_EXT | NO LONGER USED |
mainphoneAuthText | mainphone_auth_text | SZRPGRT | MAINPHONE_AUTH_TEXT | NO LONGER USED |
SZRPGRT |
| |||
nonUsAddress | non_us_address | SZRPGRT | NON_US_ADDRESS |
|
streetaddress1 | streetaddress1 | SZRPGRT | STREETADDRESS1 |
|
streetaddress2 | streetaddress2 | SZRPGRT | STREETADDRESS2 |
|
city | city | SZRPGRT | CITY |
|
state | state | SZRPGRT | STATE |
|
province | province | SZRPGRT | PROVINCE |
|
country | country | SZRPGRT | COUNTRY |
|
postalcode | postalcode | SZRPGRT | POSTALCODE |
|
ssn | ssn | SZRPGRT | SSN_TEXT |
|
ssnType | ssn_type | SZRPGRT | SSN_TYPE |
|
studentCollegeId | student_college_id | SZRPGRT | STUDENT_COLLEGE_ID |
|
birthdate | birthdate | SZRPGRT | BIRTHDATE |
|
maritalStatus | marital_status | SZRPGRT | MARITAL_STATUS |
|
regDomPartner | reg_dom_partner | SZRPGRT | REG_DOM_PARTNER |
|
bornBefore23Year | born_before_23_year | SZRPGRT | BORN_BEFORE_23_YEAR |
|
marriedOrRdp | married_or_rdp | SZRPGRT | MARRIED_OR_RDP |
|
usVeteran | us_veteran | SZRPGRT | US_VETERAN |
|
dependents | dependents | SZRPGRT | DEPENDENTS |
|
parentsDeceased | parents_deceased | SZRPGRT | PARENTS_DECEASED |
|
emancipatedMinor | emancipated_minor | SZRPGRT | EMANCIPATED_MINOR |
|
legalGuardianship | legal_guardianship | SZRPGRT | LEGAL_GUARDIANSHIP |
|
homelessYouthSchool | homeless_youth_school | SZRPGRT | HOMELESS_YOUTH_SCHOOL |
|
homelessYouthHud | homeless_youth_hud | SZRPGRT | HOMELESS_YOUTH_HUD |
|
homelessYouthOther | homeless_youth_other | SZRPGRT | HOMELESS_YOUTH_OTHER |
|
dependentOnParentTaxes | dependent_on_parent_taxes | SZRPGRT | DEPENDENT_ON_PARENT_TAXES |
|
livingWithParents | living_with_parents | SZRPGRT | LIVING_WITH_PARENTS |
|
dependencyStatus | dependency_status | SZRPGRT | DEPENDENCY_STATUS |
|
certVeteranAffairs | cert_veteran_affairs | SZRPGRT | CERT_VETERAN_AFFAIRS |
|
certNationalGuard | cert_national_guard | SZRPGRT | CERT_NATIONAL_GUARD |
|
eligMedalHonor | elig_medal_honor | SZRPGRT | ELIG_MEDAL_HONOR |
|
eligSept11 | elig_sept_11 | SZRPGRT | ELIG_SEPT_11 |
|
eligPoliceFire | elig_police_fire | SZRPGRT | ELIG_POLICE_FIRE |
|
eligCovidDeath | elig_covid_death | SZRPGRT | ELIG_COVID_DEATH | Question added 2022-2023 / SG v.4.4 |
eligExoneratedCrime | elig_exonerated_crime | SZRPGRT | ELIG_EXONERATED_CRIME | Question added 2022-2023 / SG v.4.4 |
tanfCalworks | tanf_calworks | SZRPGRT | TANF_CALWORKS |
|
ssiSsp | ssi_ssp | SZRPGRT | SSI_SSP |
|
generalAssistance | general_assistance | SZRPGRT | GENERAL_ASSISTANCE |
|
parentsAssistance | parents_assistance | SZRPGRT | PARENTS_ASSISTANCE |
|
depNumberHousehold | dep_number_household | SZRPGRT | DEP_NUMBER_HOUSEHOLD |
|
indNumberHousehold | ind_number_household | SZRPGRT | IND_NUMBER_HOUSEHOLD |
|
depGrossIncome | dep_gross_income | SZRPGRT | DEP_GROSS_INCOME |
|
indGrossIncome | ind_gross_income | SZRPGRT | IND_GROSS_INCOME |
|
depOtherIncome | dep_other_income | SZRPGRT | DEP_OTHER_INCOME |
|
indOtherIncome | ind_other_income | SZRPGRT | IND_OTHER_INCOME |
|
depTotalIncome | dep_total_income | SZRPGRT | DEP_TOTAL_INCOME |
|
indTotalIncome | ind_total_income | SZRPGRT | IND_TOTAL_INCOME |
|
eligMethodA | elig_method_a | SZRPGRT | ELIG_METHOD_A |
|
eligMethodB | elig_method_b | SZRPGRT | ELIG_METHOD_B |
|
eligBogfw | elig_bogfw | SZRPGRT | ELIG_BOGFW |
|
confirmationParentGuardian | confirmation_parent_guardian | SZRPGRT | CONFIRMATION_PARENT_GUARDIAN |
|
parentGuardianName | parent_guardian_name | SZRPGRT | PARENT_GUARDIAN_NAME |
|
ackFinAid | ack_fin_aid | SZRPGRT | ACK_FIN_AID |
|
confirmationApplicant | confirmation_applicant | SZRPGRT | CONFIRMATION_APPLICANT |
|
lastPage | last_page | SZRPGRT | LAST_PAGE |
|
ssnLast4 | ssn_last4 | SZRPGRT | SSN_LAST4 |
|
tstmpSubmit | tstmp_submit | SZRPGRT | TSTMP_SUBMIT |
|
tstmpCreate | tstmp_create | SZRPGRT | TSTMP_CREATE |
|
tstmpUpdate | tstmp_update | SZRPGRT | TSTMP_UPDATE |
|
tstmpDownload | tstmp_download | SZRPGRT | TSTMP_DOWNLOAD |
|
termCode | term_code | SZRPGRT | TERM_CODE | NOT USED IN CCPG |
ipAddress | ip_address | SZRPGRT | IP_ADDRESS |
|
campaign1 | campaign1 | SZRPGRT | CAMPAIGN1 |
|
campaign2 | campaign2 | SZRPGRT | CAMPAIGN2 |
|
campaign3 | campaign3 | SZRPGRT | CAMPAIGN3 |
|
ssnException | ssn_exception | SZRPGRT | SSN_EXCEPTION |
|
collegeName | college_name | SZRPGRT | COLLEGE_NAME |
|
preferredFirstname | preferred_firstname | SZRPGRT | PREFERRED_FIRSTNAME |
|
preferredMiddlename | preferred_middlename | SZRPGRT | PREFERRED_MIDDLENAME | NO LONGER USED |
preferredLastname | preferred_lastname | SZRPGRT | PREFERRED_LASTNAME | NO LONGER USED |
preferredName | preferred_name | SZRPGRT | PREFERRED_NAME | NO LONGER USED |
ssnNo | ssn_no | SZRPGRT | SSN_NO |
|
noPermAddressHomeless | no_perm_address_homeless | SZRPGRT | NO_PERM_ADDRESS_HOMELESS |
|
noMailingAddressHomeless | no_mailing_address_homeless | SZRPGRT | NO_MAILING_ADDRESS_HOMELESS |
|
determinedHomeless | determined_homeless | SZRPGRT | DETERMINED_HOMELESS |
|
eligMethodD | elig_method_d | SZRPGRT | ELIG_METHOD_D |
|
mainphoneintl | mainphoneintl | SZRPGRT | MAINPHONEINTL |
|