...
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.Notes | |||||||
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_eligibleCC_PROMISE_GRANT_STG | SZRPGRT | DETERMINED_AB540_ELIGIBLE | See the CCPG Data Specification here. | |||||||
determinedNonResExempt | determined_non_res_exemptCC_PROMISE_GRANT_STG | SZRPGRT | DETERMINED_NON_RES_EXEMPT | See the CCPG Data Specification here. | |||||||
lastname | lastname | CC_PROMISE_GRANT_STGSZRPGRT | LASTNAMESee the CCPG Data Specification here. | ||||||||
firstname | firstname | CC_PROMISE_GRANT_STGSZRPGRT | FIRSTNAME | See the CCPG Data Specification here. | |||||||
middlename | middlename | CC_PROMISE_GRANT_STGSZRPGRT | MIDDLENAME | See the CCPG Data Specification here. | |||||||
mainphone | mainphone | CC_PROMISE_GRANT_STGSZRPGRT | MAINPHONE | See the CCPG Data Specification here. | |||||||
mainphoneExt | mainphone_extCC_ | PROMISE_GRANT_STGSZRPGRT | MAINPHONE_EXT | See the CCPG Data Specification here.NO LONGER USED | |||||||
mainphoneAuthText | mainphone_auth_textCC_PROMISE_GRANT_STG | SZRPGRT | MAINPHONE_AUTH_TEXT | See the CCPG Data Specification here.NO LONGER USED | |||||||
CC_PROMISE_GRANT_STGSZRPGRT | See the CCPG Data Specification here. | ||||||||||
nonUsAddress | non_us_addressCC_PROMISE_GRANT_STG | SZRPGRT | NON_US_ADDRESSSee the CCPG Data Specification here. | ||||||||
streetaddress1 | streetaddress1 | CC_PROMISE_GRANT_STGSZRPGRT | STREETADDRESS1 | See the CCPG Data Specification here. | |||||||
streetaddress2 | streetaddress2 | CC_PROMISE_GRANT_STGSZRPGRT | STREETADDRESS2 | See the CCPG Data Specification here. | |||||||
city | city | CC_PROMISE_GRANT_STGSZRPGRT | CITY | See the CCPG Data Specification here. | |||||||
state | state | CC_PROMISE_GRANT_STGSZRPGRT | STATESee the CCPG Data Specification here. | ||||||||
province | province | CC_PROMISE_GRANT_STGSZRPGRT | PROVINCESee the CCPG Data Specification here. | ||||||||
country | country | CC_PROMISE_GRANT_STGSZRPGRT | COUNTRY | See the CCPG Data Specification here. | |||||||
postalcode | postalcode | CC_PROMISE_GRANT_STGSZRPGRT | POSTALCODE | See the CCPG Data Specification here. | |||||||
ssn | ssn | CC_PROMISE_GRANT_STGSZRPGRT | SSN_TEXTSee the CCPG Data Specification here. | ||||||||
ssnType | ssn_typeCC_ | PROMISE_GRANT_STGSZRPGRT | SSN_TYPESee the CCPG Data Specification here. | ||||||||
studentCollegeId | student_college_idCC_PROMISE_GRANT_STG | SZRPGRT | STUDENT_COLLEGE_ID | See the CCPG Data Specification here. | |||||||
birthdate | birthdate | CC_PROMISE_GRANT_STGSZRPGRT | BIRTHDATE | See the CCPG Data Specification here. | |||||||
maritalStatus | marital_statusCC_ | PROMISE_GRANT_STGSZRPGRT | MARITAL_STATUS | See the CCPG Data Specification here. | |||||||
regDomPartner | reg_dom_partnerCC_PROMISE_GRANT_STG | SZRPGRT | REG_DOM_PARTNER | See the CCPG Data Specification here. | |||||||
bornBefore23Year | born_before_23_yearCC_PROMISE_GRANT_STG | SZRPGRT | BORN_BEFORE_23_YEAR | See the CCPG Data Specification here. | |||||||
marriedOrRdp | married_or_rdpCC_PROMISE_GRANT_STG | SZRPGRT | MARRIED_OR_RDPSee the CCPG Data Specification here. | ||||||||
usVeteran | us_veteranCC_ | PROMISE_GRANT_STGSZRPGRT | US_VETERANSee the CCPG Data Specification here. | ||||||||
dependents | dependents | CC_PROMISE_GRANT_STGSZRPGRT | DEPENDENTS | See the CCPG Data Specification here. | |||||||
parentsDeceased | parents_deceasedCC_ | PROMISE_GRANT_STGSZRPGRT | PARENTS_DECEASED | See the CCPG Data Specification here. | |||||||
emancipatedMinor | emancipated_minorCC_ | PROMISE_GRANT_STGSZRPGRT | EMANCIPATED_MINOR | See the CCPG Data Specification here. | |||||||
legalGuardianship | legal_guardianshipCC_ | PROMISE_GRANT_STGSZRPGRT | LEGAL_GUARDIANSHIPSee the CCPG Data Specification here. | ||||||||
homelessYouthSchool | homeless_youth_schoolCC_PROMISE_GRANT_STG | SZRPGRT | HOMELESS_YOUTH_SCHOOL | See the CCPG Data Specification here. | |||||||
homelessYouthHud | homeless_youth_hudCC_PROMISE_GRANT_STG | SZRPGRT | HOMELESS_YOUTH_HUD | See the CCPG Data Specification here. | |||||||
homelessYouthOther | homeless_youth_otherCC_PROMISE_GRANT_STG | SZRPGRT | HOMELESS_YOUTH_OTHER | See the CCPG Data Specification here. | |||||||
dependentOnParentTaxes | dependent_on_parent_taxesCC_PROMISE_GRANT_STG | SZRPGRT | DEPENDENT_ON_PARENT_TAXES | See the CCPG Data Specification here. | |||||||
livingWithParents | living_with_parentsCC_PROMISE_GRANT_STG | SZRPGRT | LIVING_WITH_PARENTS | See the CCPG Data Specification here. | |||||||
dependencyStatus | dependency_statusCC_ | PROMISE_GRANT_STGSZRPGRT | DEPENDENCY_STATUSSee the CCPG Data Specification here. | ||||||||
certVeteranAffairs | cert_veteran_affairsCC_PROMISE_GRANT_STG | SZRPGRT | CERT_VETERAN_AFFAIRS | See the CCPG Data Specification here. | |||||||
certNationalGuard | cert_national_guardCC_PROMISE_GRANT_STG | SZRPGRT | 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_honorCC_PROMISE_GRANT_STG | SZRPGRT | ELIG_MEDAL_HONORSee the CCPG Data Specification here. | ||||||||
eligSept11 | elig_sept_11CC_PROMISE_GRANT_STG | SZRPGRT | ELIG_SEPT_11 | See the CCPG Data Specification here. | |||||||
eligPoliceFire | elig_police_fireCC_PROMISE_GRANT_STG | SZRPGRT | ELIG_POLICE_FIRE | See the CCPG Data Specification here. | |||||||
eligCovidDeath | elig_covid_deathCC_PROMISE_GRANT_STG | SZRPGRT | ELIG_COVID_DEATH | Added Question added 2022-2023 / SG v.4.4 | |||||||
eligExoneratedCrime | elig_exonerated_crimeCC_PROMISE_GRANT_STG | SZRPGRT | ELIG_EXONERATED_CRIME | Added Question added 2022-2023 / SG v.4.4 | |||||||
tanfCalworks | tanf_calworksCC_ | PROMISE_GRANT_STGSZRPGRT | TANF_CALWORKS | See the CCPG Data Specification here. | |||||||
ssiSsp | ssi_sspCC_ | PROMISE_GRANT_STGSZRPGRT | SSI_SSPSee the CCPG Data Specification here. | ||||||||
generalAssistance | general_assistanceCC_ | PROMISE_GRANT_STGSZRPGRT | GENERAL_ASSISTANCESee the CCPG Data Specification here. | ||||||||
parentsAssistance | parents_assistanceCC_ | PROMISE_GRANT_STGSZRPGRT | PARENTS_ASSISTANCE | See the CCPG Data Specification here. | |||||||
depNumberHousehold | dep_number_householdCC_PROMISE_GRANT_STG | SZRPGRT | DEP_NUMBER_HOUSEHOLD | See the CCPG Data Specification here. | |||||||
indNumberHousehold | ind_number_householdCC_PROMISE_GRANT_STG | SZRPGRT | IND_NUMBER_HOUSEHOLDSee the CCPG Data Specification here. | ||||||||
depGrossIncome | dep_gross_incomeCC_PROMISE_GRANT_STG | SZRPGRT | DEP_GROSS_INCOMESee the CCPG Data Specification here. | ||||||||
indGrossIncome | ind_gross_incomeCC_PROMISE_GRANT_STG | SZRPGRT | IND_GROSS_INCOME | See the CCPG Data Specification here. | |||||||
depOtherIncome | dep_other_incomeCC_PROMISE_GRANT_STG | SZRPGRT | DEP_OTHER_INCOMESee the CCPG Data Specification here. | ||||||||
indOtherIncome | ind_other_incomeCC_PROMISE_GRANT_STG | SZRPGRT | IND_OTHER_INCOME | See the CCPG Data Specification here. | |||||||
depTotalIncome | dep_total_incomeCC_PROMISE_GRANT_STG | SZRPGRT | DEP_TOTAL_INCOME | See the CCPG Data Specification here. | |||||||
indTotalIncome | ind_total_incomeCC_PROMISE_GRANT_STG | SZRPGRT | IND_TOTAL_INCOME | See the CCPG Data Specification here. | |||||||
eligMethodA | elig_method_aCC_PROMISE_GRANT_STG | SZRPGRT | ELIG_METHOD_ASee the CCPG Data Specification here. | ||||||||
eligMethodB | elig_method_bCC_PROMISE_GRANT_STG | SZRPGRT | ELIG_METHOD_BSee the CCPG Data Specification here. | ||||||||
eligBogfw | elig_bogfwCC_ | PROMISE_GRANT_STGSZRPGRT | ELIG_BOGFW | See the CCPG Data Specification here. | |||||||
confirmationParentGuardian | confirmation_parent_guardianCC_PROMISE_GRANT_STG | SZRPGRT | CONFIRMATION_PARENT_GUARDIAN | See the CCPG Data Specification here. | |||||||
parentGuardianName | parent_guardian_nameCC_PROMISE_GRANT_STG | SZRPGRT | PARENT_GUARDIAN_NAMESee the CCPG Data Specification here. | ||||||||
ackFinAid | ack_fin_aidCC_PROMISE_GRANT_STG | SZRPGRT | ACK_FIN_AIDSee the CCPG Data Specification here. | ||||||||
confirmationApplicant | confirmation_applicantCC_ | PROMISE_GRANT_STGSZRPGRT | CONFIRMATION_APPLICANT | See the CCPG Data Specification here. | |||||||
lastPage | last_pageCC_ | PROMISE_GRANT_STGSZRPGRT | LAST_PAGE | See the CCPG Data Specification here. | |||||||
ssnLast4 | ssn_last4CC_ | PROMISE_GRANT_STGSZRPGRT | SSN_LAST4 | See the CCPG Data Specification here. | |||||||
tstmpSubmit | tstmp_submitCC_ | PROMISE_GRANT_STGSZRPGRT | TSTMP_SUBMIT | See the CCPG Data Specification here. | |||||||
tstmpCreate | tstmp_createCC_ | PROMISE_GRANT_STGSZRPGRT | TSTMP_CREATE | See the CCPG Data Specification here. | |||||||
tstmpUpdate | tstmp_updateCC_ | PROMISE_GRANT_STGSZRPGRT | TSTMP_UPDATESee the CCPG Data Specification here. | ||||||||
tstmpDownload | tstmp_downloadCC_ | PROMISE_GRANT_STGSZRPGRT | TSTMP_DOWNLOADSee the CCPG Data Specification here. | ||||||||
termCode | term_codeCC_ | PROMISE_GRANT_STGSZRPGRT | TERM_CODE | See the CCPG Data Specification here.NOT USED IN CCPG | |||||||
ipAddress | ip_addressCC_ | PROMISE_GRANT_STGSZRPGRT | IP_ADDRESS | See the CCPG Data Specification here. | |||||||
campaign1 | campaign1 | CC_PROMISE_GRANT_STGSZRPGRT | CAMPAIGN1 | See the CCPG Data Specification here. | |||||||
campaign2 | campaign2 | CC_PROMISE_GRANT_STGSZRPGRT | CAMPAIGN2See the CCPG Data Specification here. | ||||||||
campaign3 | campaign3 | CC_PROMISE_GRANT_STGSZRPGRT | CAMPAIGN3 | See the CCPG Data Specification here. | |||||||
ssnException | ssn_exceptionCC_ | PROMISE_GRANT_STGSZRPGRT | SSN_EXCEPTION | See the CCPG Data Specification here. | |||||||
collegeName | college_nameCC_ | PROMISE_GRANT_STGSZRPGRT | COLLEGE_NAME | See the CCPG Data Specification here. | |||||||
preferredFirstname | preferred_firstnameCC_ | PROMISE_GRANT_STGSZRPGRT | PREFERRED_FIRSTNAME | See the CCPG Data Specification here. | |||||||
preferredMiddlename | preferred_middlenameCC_ | PROMISE_GRANT_STGSZRPGRT | PREFERRED_MIDDLENAME | See the CCPG Data Specification here.NO LONGER USED | |||||||
preferredLastname | preferred_lastnameCC_ | PROMISE_GRANT_STGSZRPGRT | PREFERRED_LASTNAME | See the CCPG Data Specification here.NO LONGER USED | |||||||
preferredName | preferred_nameCC_ | PROMISE_GRANT_STGSZRPGRT | PREFERRED_NAME | See the CCPG Data Specification here.NO LONGER USED | |||||||
ssnNo | ssn_noCC_ | PROMISE_GRANT_STGSZRPGRT | SSN_NO | See the CCPG Data Specification here. | |||||||
noPermAddressHomeless | no_perm_address_homelessCC_PROMISE_GRANT_STG | SZRPGRT | NO_PERM_ADDRESS_HOMELESS | See the CCPG Data Specification here. | |||||||
noMailingAddressHomeless | no_mailing_address_homelessCC_PROMISE_GRANT_STG | SZRPGRT | NO_MAILING_ADDRESS_HOMELESS | See the CCPG Data Specification here. | |||||||
determinedHomeless | determined_homelessCC_ | PROMISE_GRANT_STGSZRPGRT | DETERMINED_HOMELESSSee the CCPG Data Specification here. | ||||||||
eligMethodD | elig_method_dCC_PROMISE_GRANT_STG | SZRPGRT | ELIG_METHOD_D | See the CCPG Data Specification here. | |||||||
mainphoneintl | mainphoneintl | CC_PROMISE_GRANT_STGSZRPGRT | MAINPHONEINTLSee the CCPG Data Specification here. |