Page Comparison

...

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.
email	email	CC_PROMISE_GRANT_STG	EMAIL	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.
eligCovidDeath	elig_covid_death	CC_PROMISE_GRANT_STG	ELIG_COVID_DEATH	Added 2022-2023
eligExoneratedCrime	elig_exonerated_crime	CC_PROMISE_GRANT_STG	ELIG_EXONERATED_CRIME	Added 2022-2023
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.

...

Versions Compared

Old Version 2

New Version 3

Key