The tables below pertain to the California Colleges Promise Grant online application.
CC Promise Grant Data Fields Table Mapping - Banner
For more details, see the CC Promise Grant Application data dictionary.
College Adaptor Payload Field | Data Dictionary Name | Banner Table Name | Banner Field Name | Explanation |
---|---|---|---|---|
appId | app_id | CC_PROMISE_GRANT_STG | APP_ID | See the CCPG Data Specification here. |
ccId | ccc_id | CC_PROMISE_GRANT_STG | CCC_ID | See the CCPG Data Specification here. |
confirmationNumber | confirmation_number | CC_PROMISE_GRANT_STG | CONFIRMATION_NUMBER | See the CCPG Data Specification here. |
status | status | CC_PROMISE_GRANT_STG | STATUS | See the CCPG Data Specification here. |
appLang | app_lang | CC_PROMISE_GRANT_STG | APP_LANG | See the CCPG Data Specification here. |
collegeId | college_id | CC_PROMISE_GRANT_STG | COLLEGE_ID | See the CCPG Data Specification here. |
yearCode | year_code | CC_PROMISE_GRANT_STG | YEAR_CODE | See the CCPG Data Specification here. |
yearDescription | year_description | CC_PROMISE_GRANT_STG | YEAR_DESCRIPTION | See the CCPG Data Specification here. |
determinedResidentca | determined_residentca | CC_PROMISE_GRANT_STG | DETERMINED_RESIDENTCA | See the CCPG Data Specification here. |
determinedAB540Eligible | determined_ab540_eligible | CC_PROMISE_GRANT_STG | DETERMINED_AB540_ELIGIBLE | See the CCPG Data Specification here. |
determinedNonResExempt | determined_non_res_exempt | CC_PROMISE_GRANT_STG | DETERMINED_NON_RES_EXEMPT | See the CCPG Data Specification here. |
lastname | lastname | CC_PROMISE_GRANT_STG | LASTNAME | See the CCPG Data Specification here. |
firstname | firstname | CC_PROMISE_GRANT_STG | FIRSTNAME | See the CCPG Data Specification here. |
middlename | middlename | CC_PROMISE_GRANT_STG | MIDDLENAME | See the CCPG Data Specification here. |
mainphone | mainphone | CC_PROMISE_GRANT_STG | MAINPHONE | See the CCPG Data Specification here. |
mainphoneExt | mainphone_ext | CC_PROMISE_GRANT_STG | MAINPHONE_EXT | See the CCPG Data Specification here. |
mainphoneAuthText | mainphone_auth_text | CC_PROMISE_GRANT_STG | MAINPHONE_AUTH_TEXT | See the CCPG Data Specification here. |
CC_PROMISE_GRANT_STG | See the CCPG Data Specification here. | |||
nonUsAddress | non_us_address | CC_PROMISE_GRANT_STG | NON_US_ADDRESS | See the CCPG Data Specification here. |
streetaddress1 | streetaddress1 | CC_PROMISE_GRANT_STG | STREETADDRESS1 | See the CCPG Data Specification here. |
streetaddress2 | streetaddress2 | CC_PROMISE_GRANT_STG | STREETADDRESS2 | See the CCPG Data Specification here. |
city | city | CC_PROMISE_GRANT_STG | CITY | See the CCPG Data Specification here. |
state | state | CC_PROMISE_GRANT_STG | STATE | See the CCPG Data Specification here. |
province | province | CC_PROMISE_GRANT_STG | PROVINCE | See the CCPG Data Specification here. |
country | country | CC_PROMISE_GRANT_STG | COUNTRY | See the CCPG Data Specification here. |
postalcode | postalcode | CC_PROMISE_GRANT_STG | POSTALCODE | See the CCPG Data Specification here. |
ssn | ssn | CC_PROMISE_GRANT_STG | SSN_TEXT | See the CCPG Data Specification here. |
ssnType | ssn_type | CC_PROMISE_GRANT_STG | SSN_TYPE | See the CCPG Data Specification here. |
studentCollegeId | student_college_id | CC_PROMISE_GRANT_STG | STUDENT_COLLEGE_ID | See the CCPG Data Specification here. |
birthdate | birthdate | CC_PROMISE_GRANT_STG | BIRTHDATE | See the CCPG Data Specification here. |
maritalStatus | marital_status | CC_PROMISE_GRANT_STG | MARITAL_STATUS | See the CCPG Data Specification here. |
regDomPartner | reg_dom_partner | CC_PROMISE_GRANT_STG | REG_DOM_PARTNER | See the CCPG Data Specification here. |
bornBefore23Year | born_before_23_year | CC_PROMISE_GRANT_STG | BORN_BEFORE_23_YEAR | See the CCPG Data Specification here. |
marriedOrRdp | married_or_rdp | CC_PROMISE_GRANT_STG | MARRIED_OR_RDP | See the CCPG Data Specification here. |
usVeteran | us_veteran | CC_PROMISE_GRANT_STG | US_VETERAN | See the CCPG Data Specification here. |
dependents | dependents | CC_PROMISE_GRANT_STG | DEPENDENTS | See the CCPG Data Specification here. |
parentsDeceased | parents_deceased | CC_PROMISE_GRANT_STG | PARENTS_DECEASED | See the CCPG Data Specification here. |
emancipatedMinor | emancipated_minor | CC_PROMISE_GRANT_STG | EMANCIPATED_MINOR | See the CCPG Data Specification here. |
legalGuardianship | legal_guardianship | CC_PROMISE_GRANT_STG | LEGAL_GUARDIANSHIP | See the CCPG Data Specification here. |
homelessYouthSchool | homeless_youth_school | CC_PROMISE_GRANT_STG | HOMELESS_YOUTH_SCHOOL | See the CCPG Data Specification here. |
homelessYouthHud | homeless_youth_hud | CC_PROMISE_GRANT_STG | HOMELESS_YOUTH_HUD | See the CCPG Data Specification here. |
homelessYouthOther | homeless_youth_other | CC_PROMISE_GRANT_STG | HOMELESS_YOUTH_OTHER | See the CCPG Data Specification here. |
dependentOnParentTaxes | dependent_on_parent_taxes | CC_PROMISE_GRANT_STG | DEPENDENT_ON_PARENT_TAXES | See the CCPG Data Specification here. |
livingWithParents | living_with_parents | CC_PROMISE_GRANT_STG | LIVING_WITH_PARENTS | See the CCPG Data Specification here. |
dependencyStatus | dependency_status | CC_PROMISE_GRANT_STG | DEPENDENCY_STATUS | See the CCPG Data Specification here. |
certVeteranAffairs | cert_veteran_affairs | CC_PROMISE_GRANT_STG | CERT_VETERAN_AFFAIRS | See the CCPG Data Specification here. |
certNationalGuard | cert_national_guard | CC_PROMISE_GRANT_STG | CERT_NATIONAL_GUARD | See the CCPG Data Specification here. |
eligCovidDeath | elig_covid_death | CC_PROMISE_GRANT_STG | ||
eligExoneratedCrime | elig_exonerated_crime | CC_PROMISE_GRANT_STG | ||
eligMedalHonor | elig_medal_honor | CC_PROMISE_GRANT_STG | ELIG_MEDAL_HONOR | See the CCPG Data Specification here. |
eligSept11 | elig_sept_11 | CC_PROMISE_GRANT_STG | ELIG_SEPT_11 | See the CCPG Data Specification here. |
eligPoliceFire | elig_police_fire | CC_PROMISE_GRANT_STG | ELIG_POLICE_FIRE | See the CCPG Data Specification here. |
tanfCalworks | tanf_calworks | CC_PROMISE_GRANT_STG | TANF_CALWORKS | See the CCPG Data Specification here. |
ssiSsp | ssi_ssp | CC_PROMISE_GRANT_STG | SSI_SSP | See the CCPG Data Specification here. |
generalAssistance | general_assistance | CC_PROMISE_GRANT_STG | GENERAL_ASSISTANCE | See the CCPG Data Specification here. |
parentsAssistance | parents_assistance | CC_PROMISE_GRANT_STG | PARENTS_ASSISTANCE | See the CCPG Data Specification here. |
depNumberHousehold | dep_number_household | CC_PROMISE_GRANT_STG | DEP_NUMBER_HOUSEHOLD | See the CCPG Data Specification here. |
indNumberHousehold | ind_number_household | CC_PROMISE_GRANT_STG | IND_NUMBER_HOUSEHOLD | See the CCPG Data Specification here. |
depGrossIncome | dep_gross_income | CC_PROMISE_GRANT_STG | DEP_GROSS_INCOME | See the CCPG Data Specification here. |
indGrossIncome | ind_gross_income | CC_PROMISE_GRANT_STG | IND_GROSS_INCOME | See the CCPG Data Specification here. |
depOtherIncome | dep_other_income | CC_PROMISE_GRANT_STG | DEP_OTHER_INCOME | See the CCPG Data Specification here. |
indOtherIncome | ind_other_income | CC_PROMISE_GRANT_STG | IND_OTHER_INCOME | See the CCPG Data Specification here. |
depTotalIncome | dep_total_income | CC_PROMISE_GRANT_STG | DEP_TOTAL_INCOME | See the CCPG Data Specification here. |
indTotalIncome | ind_total_income | CC_PROMISE_GRANT_STG | IND_TOTAL_INCOME | See the CCPG Data Specification here. |
eligMethodA | elig_method_a | CC_PROMISE_GRANT_STG | ELIG_METHOD_A | See the CCPG Data Specification here. |
eligMethodB | elig_method_b | CC_PROMISE_GRANT_STG | ELIG_METHOD_B | See the CCPG Data Specification here. |
eligBogfw | elig_bogfw | CC_PROMISE_GRANT_STG | ELIG_BOGFW | See the CCPG Data Specification here. |
confirmationParentGuardian | confirmation_parent_guardian | CC_PROMISE_GRANT_STG | CONFIRMATION_PARENT_GUARDIAN | See the CCPG Data Specification here. |
parentGuardianName | parent_guardian_name | CC_PROMISE_GRANT_STG | PARENT_GUARDIAN_NAME | See the CCPG Data Specification here. |
ackFinAid | ack_fin_aid | CC_PROMISE_GRANT_STG | ACK_FIN_AID | See the CCPG Data Specification here. |
confirmationApplicant | confirmation_applicant | CC_PROMISE_GRANT_STG | CONFIRMATION_APPLICANT | See the CCPG Data Specification here. |
lastPage | last_page | CC_PROMISE_GRANT_STG | LAST_PAGE | See the CCPG Data Specification here. |
ssnLast4 | ssn_last4 | CC_PROMISE_GRANT_STG | SSN_LAST4 | See the CCPG Data Specification here. |
tstmpSubmit | tstmp_submit | CC_PROMISE_GRANT_STG | TSTMP_SUBMIT | See the CCPG Data Specification here. |
tstmpCreate | tstmp_create | CC_PROMISE_GRANT_STG | TSTMP_CREATE | See the CCPG Data Specification here. |
tstmpUpdate | tstmp_update | CC_PROMISE_GRANT_STG | TSTMP_UPDATE | See the CCPG Data Specification here. |
tstmpDownload | tstmp_download | CC_PROMISE_GRANT_STG | TSTMP_DOWNLOAD | See the CCPG Data Specification here. |
termCode | term_code | CC_PROMISE_GRANT_STG | TERM_CODE | See the CCPG Data Specification here. |
ipAddress | ip_address | CC_PROMISE_GRANT_STG | IP_ADDRESS | See the CCPG Data Specification here. |
campaign1 | campaign1 | CC_PROMISE_GRANT_STG | CAMPAIGN1 | See the CCPG Data Specification here. |
campaign2 | campaign2 | CC_PROMISE_GRANT_STG | CAMPAIGN2 | See the CCPG Data Specification here. |
campaign3 | campaign3 | CC_PROMISE_GRANT_STG | CAMPAIGN3 | See the CCPG Data Specification here. |
ssnException | ssn_exception | CC_PROMISE_GRANT_STG | SSN_EXCEPTION | See the CCPG Data Specification here. |
collegeName | college_name | CC_PROMISE_GRANT_STG | COLLEGE_NAME | See the CCPG Data Specification here. |
preferredFirstname | preferred_firstname | CC_PROMISE_GRANT_STG | PREFERRED_FIRSTNAME | See the CCPG Data Specification here. |
preferredMiddlename | preferred_middlename | CC_PROMISE_GRANT_STG | PREFERRED_MIDDLENAME | See the CCPG Data Specification here. |
preferredLastname | preferred_lastname | CC_PROMISE_GRANT_STG | PREFERRED_LASTNAME | See the CCPG Data Specification here. |
preferredName | preferred_name | CC_PROMISE_GRANT_STG | PREFERRED_NAME | See the CCPG Data Specification here. |
ssnNo | ssn_no | CC_PROMISE_GRANT_STG | SSN_NO | See the CCPG Data Specification here. |
noPermAddressHomeless | no_perm_address_homeless | CC_PROMISE_GRANT_STG | NO_PERM_ADDRESS_HOMELESS | See the CCPG Data Specification here. |
noMailingAddressHomeless | no_mailing_address_homeless | CC_PROMISE_GRANT_STG | NO_MAILING_ADDRESS_HOMELESS | See the CCPG Data Specification here. |
determinedHomeless | determined_homeless | CC_PROMISE_GRANT_STG | DETERMINED_HOMELESS | See the CCPG Data Specification here. |
eligMethodD | elig_method_d | CC_PROMISE_GRANT_STG | ELIG_METHOD_D | See the CCPG Data Specification here. |
mainphoneintl | mainphoneintl | CC_PROMISE_GRANT_STG | MAINPHONEINTL | See the CCPG Data Specification here. |