...
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 |
|---|---|---|---|---|
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 |