Page Comparison

...

See the CCPG Data Specification here.

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
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
email	email	CC_PROMISE_GRANT_STGSZRPGRT	EMAIL	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.

Versions Compared

Old Version 5

New Version 6

Key