Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
The tables below pertain to the California Colleges Promise Grant online applicationreflect 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 |
---|
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
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 |
See the CCPG Data Specification here.
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 |
See the CCPG Data Specification here.
eligMedalHonor | elig_ |
medal_ |
honor | SZRPGRT |
ELIG_ |
MEDAL_ |
HONOR |
eligSept11 | elig_ |
sept_ |
11 | SZRPGRT |
ELIG_ |
SEPT_ |
11 |
eligPoliceFire | elig_ |
police_ |
fire | SZRPGRT | ELIG_ |
POLICE_ |
See the CCPG Data Specification here.
FIRE | |
eligCovidDeath | elig_ |
covid_ |
death | SZRPGRT | ELIG_ |
COVID_ |
See the CCPG Data Specification here.
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 |
See the CCPG Data Specification here.
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 |