CC Promise Grant Application SuperGlue Data Mappings - PeopleSoft

The tables below pertain to the California Colleges Promise Grant online application.

CC Promise Grant Data Fields Table Mapping - PeopleSoft

For more details, see the CC Promise Grant Application data dictionary.

College Adaptor Payload Field Name	Data Dictionary Name	PS Table Name	PS Name	Explanation
appId	app_id	PS_CCTC_PMGT_STG	CCTC_PMGT_ID	See the CCPG Data Specification here.
ccId	ccc_id	PS_CCTC_PMGT_STG	CCTC_CCCID	See the CCPG Data Specification here.
confirmationNumber	confirmation_number	PS_CCTC_PMGT_STG	CCTC_APPL_CFRM_NBR	See the CCPG Data Specification here.
status	status	PS_CCTC_PMGT_STG	CCTC_APPL_STATUS	See the CCPG Data Specification here.
appLang	app_lang	PS_CCTC_PMGT_STG	CCTC_APPL_LANG_CD	See the CCPG Data Specification here.
collegeId	college_id	PS_CCTC_PMGT_STG	CCTC_MIS_CD	See the CCPG Data Specification here.
yearCode	year_code	PS_CCTC_PMGT_STG	CCTC_PMGT_YEAR_CD	See the CCPG Data Specification here.
yearDescription	year_description	PS_CCTC_PMGT_STG	CCTC_PMGT_YEAR_DS	See the CCPG Data Specification here.
determinedResidentca	determined_residentca	PS_CCTC_PMGT_STG	CCTC_PMGT_CA_RESI	See the CCPG Data Specification here.
determinedAB540Eligible	determined_ab540_eligible	PS_CCTC_PMGT_STG	CCTC_APPL_ELGAB540	See the CCPG Data Specification here.
determinedNonResExempt	determined_non_res_exempt	PS_CCTC_PMGT_STG	CCTC_PMGT_CARESI_E	See the CCPG Data Specification here.
lastname	lastname	PS_CCTC_PMGT_STG	CCTC_LGL_LAST_NM	See the CCPG Data Specification here.
firstname	firstname	PS_CCTC_PMGT_STG	CCTC_LGL_FIRST_NM	See the CCPG Data Specification here.
middlename	middlename	PS_CCTC_PMGT_STG	CCTC_LGL_MIDDLE_NM	See the CCPG Data Specification here.
mainphone	mainphone	PS_CCTC_PMGT_STG	CCTC_PHONE_MAIN	See the CCPG Data Specification here.
mainphoneExt	mainphone_ext	PS_CCTC_PMGT_STG	CCTC_PHONE_MAIN_EX	See the CCPG Data Specification here.
mainphoneAuthText	mainphone_auth_text	PS_CCTC_PMGT_STG	CCTC_PHONE_MAINSMS	See the CCPG Data Specification here.
mainphoneVerified	mainphone_verified	PS_CCTC_PMGT_STG	CCTC_PHONE_MN_VER	See the CCPG Data Specification here.
mainphoneVerifiedTimestamp	mainphone_verified_timestmp	PS_CCTC_PMGT_STG	CCTC_PHONE_MN_VRTS	See the CCPG Data Specification here.
email	email	PS_CCTC_PMGT_STG	CCTC_EMAIL	See the CCPG Data Specification here.
emailVerified	email_verified	PS_CCTC_PMGT_STG	CCTC_EMAIL_VER	See the CCPG Data Specification here.
emailVerifiedTimestamp	email_verified_timestamp	PS_CCTC_PMGT_STG	CCTC_EMAIL_VER_TS	See the CCPG Data Specification here.
preferredMethodOfContact	preferred_method_of_contact	PS_CCTC_PMGT_STG	CCTC_PRF_CNCT_MTHD	See the CCPG Data Specification here.
nonUsAddress	non_us_address	PS_CCTC_PMGT_STG	CCTC_MADDR_USA	See the CCPG Data Specification here.
addressValidationOverride	address_validation_override	PS_CCTC_PMGT_STG	CCTC_MADDR_VOVR	See the CCPG Data Specification here.
addressValidationOverrideTimestamp	address_validation_override_timestamp	PS_CCTC_PMGT_STG	CCTC_MADDR_VOVR_TS	See the CCPG Data Specification here.
streetaddress1	streetaddress1	PS_CCTC_PMGT_STG	CCTC_MADDR_LINE1	See the CCPG Data Specification here.
streetaddress2	streetaddress2	PS_CCTC_PMGT_STG	CCTC_MADDR_LINE2	See the CCPG Data Specification here.
city	city	PS_CCTC_PMGT_STG	CCTC_MADDR_CITY	See the CCPG Data Specification here.
state	state	PS_CCTC_PMGT_STG	CCTC_MADDR_STATE	See the CCPG Data Specification here.
province	province	PS_CCTC_PMGT_STG	CCTC_MADDR_PRVINCE	See the CCPG Data Specification here.
country	country	PS_CCTC_PMGT_STG	CCTC_MADDR_COUNTRY	See the CCPG Data Specification here.
postalcode	postalcode	PS_CCTC_PMGT_STG	CCTC_MADDR_POSTCD	See the CCPG Data Specification here.
ssn	ssn	PS_CCTC_PMGT_STG	CCTC_SSN	See the CCPG Data Specification here.
ssnType	ssn_type	PS_CCTC_PMGT_STG	CCTC_APPL_SSN_TYPE	See the CCPG Data Specification here.
studentCollegeId	student_college_id	PS_CCTC_PMGT_STG	CCTC_PMGT_EMPLID	See the CCPG Data Specification here.
birthdate	birthdate	PS_CCTC_PMGT_STG	CCTC_BIRTHDATE	See the CCPG Data Specification here.
maritalStatus	marital_status	PS_CCTC_PMGT_STG	CCTC_MARITAL_STAT	See the CCPG Data Specification here.
regDomPartner	reg_dom_partner	PS_CCTC_PMGT_STG	CCTC_PMGT_APG_RDP	See the CCPG Data Specification here.
bornBefore23Year	born_before_23_year	PS_CCTC_PMGT_STG	CCTC_PMGT_OVER23	See the CCPG Data Specification here.
marriedOrRdp	married_or_rdp	PS_CCTC_PMGT_STG	CCTC_PMGT_MRD_RDP	See the CCPG Data Specification here.
usVeteran	us_veteran	PS_CCTC_PMGT_STG	CCTC_USA_VETERAN	See the CCPG Data Specification here.
dependents	dependents	PS_CCTC_PMGT_STG	CCTC_PMGT_DPNDTS	See the CCPG Data Specification here.
parentsDeceased	parents_deceased	PS_CCTC_PMGT_STG	CCTC_PMGT_PG_DECD	See the CCPG Data Specification here.
emancipatedMinor	emancipated_minor	PS_CCTC_PMGT_STG	CCTC_PMGT_EMANCPTD	See the CCPG Data Specification here.
legalGuardianship	legal_guardianship	PS_CCTC_PMGT_STG	CCTC_PMGT_LGL_GRDN	See the CCPG Data Specification here.
homelessYouthSchool	homeless_youth_school	PS_CCTC_PMGT_STG	CCTC_PMGT_HL_EDU	See the CCPG Data Specification here.
homelessYouthHud	homeless_youth_hud	PS_CCTC_PMGT_STG	CCTC_PMGT_HL_HUD	See the CCPG Data Specification here.
homelessYouthOther	homeless_youth_other	PS_CCTC_PMGT_STG	CCTC_PMGT_HL_MISC	See the CCPG Data Specification here.
dependentOnParentTaxes	dependent_on_parent_taxes	PS_CCTC_PMGT_STG	CCTC_PMGT_DPNDPGTX	See the CCPG Data Specification here.
livingWithParents	living_with_parents	PS_CCTC_PMGT_STG	CCTC_PMGT_LVNG_PGS	See the CCPG Data Specification here.
dependencyStatus	dependency_status	PS_CCTC_PMGT_STG	CCTC_PMGT_DPNDCY	See the CCPG Data Specification here.
certVeteranAffairs	cert_veteran_affairs	PS_CCTC_PMGT_STG	CCTC_PMGT_CERT_VA	See the CCPG Data Specification here.
certNationalGuard	cert_national_guard	PS_CCTC_PMGT_STG	CCTC_PMGT_CERT_NG	See the CCPG Data Specification here.
eligMedalHonor	elig_medal_honor	PS_CCTC_PMGT_STG	CCTC_PMGT_ELIG_MOH	See the CCPG Data Specification here.
eligSept11	elig_sept_11	PS_CCTC_PMGT_STG	CCTC_PMGT_ELIG_911	See the CCPG Data Specification here.
eligPoliceFire	elig_police_fire	PS_CCTC_PMGT_STG	CCTC_PMGT_ELIG_KIA	See the CCPG Data Specification here.
eligCovidDeath	elig_covid_death	PS_CCTC_PMGT_STG	CCTC_COVID_DEATH	Added 2022-2023
eligExoneratedCrime	elig_exonerated_crime	PS_CCTC_PMGT_STG	CCTC_ELIG_EX_CRIME	Added 2022-2023
tanfCalworks	tanf_calworks	PS_CCTC_PMGT_STG	CCTC_PMGT_TANF_CW	See the CCPG Data Specification here.
ssiSsp	ssi_ssp	PS_CCTC_PMGT_STG	CCTC_PMGT_SSI_SSP	See the CCPG Data Specification here.
generalAssistance	general_assistance	PS_CCTC_PMGT_STG	CCTC_PMGT_GEN_HELP	See the CCPG Data Specification here.
parentsAssistance	parents_assistance	PS_CCTC_PMGT_STG	CCTC_PMGT_PG_HELP	See the CCPG Data Specification here.
depNumberHousehold	dep_number_household	PS_CCTC_PMGT_STG	CCTC_PMGT_DP_NBRHH	See the CCPG Data Specification here.
indNumberHousehold	ind_number_household	PS_CCTC_PMGT_STG	CCTC_PMGT_ID_NBRHH	See the CCPG Data Specification here.
depGrossIncome	dep_gross_income	PS_CCTC_PMGT_STG	CCTC_PMGT_DP_GI	See the CCPG Data Specification here.
indGrossIncome	ind_gross_income	PS_CCTC_PMGT_STG	CCTC_PMGT_IND_GI	See the CCPG Data Specification here.
depOtherIncome	dep_other_income	PS_CCTC_PMGT_STG	CCTC_PMGT_DP_MSCI	See the CCPG Data Specification here.
indOtherIncome	ind_other_income	PS_CCTC_PMGT_STG	CCTC_PMGT_IND_MSCI	See the CCPG Data Specification here.
depTotalIncome	dep_total_income	PS_CCTC_PMGT_STG	CCTC_PMGT_DP_TTLI	See the CCPG Data Specification here.
indTotalIncome	ind_total_income	PS_CCTC_PMGT_STG	CCTC_PMGT_IND_TTLI	See the CCPG Data Specification here.
eligMethodA	elig_method_a	PS_CCTC_PMGT_STG	CCTC_PMGT_ELIG_A	See the CCPG Data Specification here.
eligMethodB	elig_method_b	PS_CCTC_PMGT_STG	CCTC_PMGT_ELIG_B	See the CCPG Data Specification here.
eligBogfw	elig_bogfw	PS_CCTC_PMGT_STG	CCTC_PMGT_ELIGIBLE	See the CCPG Data Specification here.
confirmationParentGuardian	confirmation_parent_guardian	PS_CCTC_PMGT_STG	CCTC_PMGT_PG_CNFRM	See the CCPG Data Specification here.
parentGuardianName	parent_guardian_name	PS_CCTC_PMGT_STG	CCTC_PG1_FULL_NM	See the CCPG Data Specification here.
ackFinAid	ack_fin_aid	PS_CCTC_PMGT_STG	CCTC_APPL_ACK_FA	See the CCPG Data Specification here.
confirmationApplicant	confirmation_applicant	PS_CCTC_PMGT_STG	CCTC_PMGT_AP_CNFRM	See the CCPG Data Specification here.
lastPage	last_page	PS_CCTC_PMGT_STG	CCTC_APPL_LAST_PG	See the CCPG Data Specification here.
ssnLast4	ssn_last4	PS_CCTC_PMGT_STG	CCTC_SSN_LST4	See the CCPG Data Specification here.
tstmpSubmit	tstmp_submit	PS_CCTC_PMGT_STG	CCTC_APPL_SBMT_TS	See the CCPG Data Specification here.
tstmpCreate	tstmp_create	PS_CCTC_PMGT_STG	CCTC_APPL_CRTE_TS	See the CCPG Data Specification here.
tstmpUpdate	tstmp_update	PS_CCTC_PMGT_STG	CCTC_APPL_UPDT_TS	See the CCPG Data Specification here.
tstmpDownload	tstmp_download	PS_CCTC_PMGT_STG	CCTC_APPL_DWNLD_TS	See the CCPG Data Specification here.
termCode	term_code	PS_CCTC_PMGT_STG	CCTC_APPL_TERM_CD	See the CCPG Data Specification here.
ipAddress	ip_address	PS_CCTC_PMGT_STG	CCTC_IP_ADDRESS	See the CCPG Data Specification here.
campaign1	campaign1	PS_CCTC_PMGT_STG	CCTC_APPL_CAMPGN1	See the CCPG Data Specification here.
campaign2	campaign2	PS_CCTC_PMGT_STG	CCTC_APPL_CAMPGN2	See the CCPG Data Specification here.
campaign3	campaign3	PS_CCTC_PMGT_STG	CCTC_APPL_CAMPGN3	See the CCPG Data Specification here.
ssnException	ssn_exception	PS_CCTC_PMGT_STG	CCTC_APPL_SSN_EXCP	See the CCPG Data Specification here.
collegeName	college_name	PS_CCTC_PMGT_STG	CCTC_APPL_COL_NM	See the CCPG Data Specification here.
preferredFirstname	preferred_firstname	PS_CCTC_PMGT_STG	CCTC_PRF_FIRST_NM	See the CCPG Data Specification here.
preferredMiddlename	preferred_middlename	PS_CCTC_PMGT_STG	CCTC_PRF_MIDDLE_NM	See the CCPG Data Specification here.
preferredLastname	preferred_lastname	PS_CCTC_PMGT_STG	CCTC_PRF_LAST_NM	See the CCPG Data Specification here.
preferredName	preferred_name	PS_CCTC_PMGT_STG	CCTC_PRF_NM_SET	See the CCPG Data Specification here.
ssnNo	ssn_no	PS_CCTC_PMGT_STG	CCTC_APPL_SSN_NONE	See the CCPG Data Specification here.
noPermAddressHomeless	no_perm_address_homeless	PS_CCTC_PMGT_STG	CCTC_PADDR_HOMELSS	See the CCPG Data Specification here.
noMailingAddressHomeless	no_mailing_address_homeless	PS_CCTC_PMGT_STG	CCTC_MADDR_HOMELSS	See the CCPG Data Specification here.
determinedHomeless	determined_homeless	PS_CCTC_PMGT_STG	CCTC_PMGT_HL_FAO	See the CCPG Data Specification here.
eligMethodD	elig_method_d	PS_CCTC_PMGT_STG	CCTC_PMGT_ELIG_D	See the CCPG Data Specification here.
mainphoneintl	mainphoneintl	PS_CCTC_PMGT_STG	CCTC_PHONE_MAININT	See the CCPG Data Specification here.
sisProcessedFlag		PS_CCTC_PMGT_STG	STATUS_FLAG	A single character blank value whenever a new row is created. May be optionally used by the college to track processing
tstmpSISProcessed		PS_CCTC_PMGT_STG	STATUS_DTTM	Used for tracking/processing; defaults to the current date/time when a row is created, should be updated if/when the STATUS_FLAG field is changed
sisProcessedNotes		PS_CCTC_PMGT_STG	DESCRLONG_NOTES	A blank value whenever a new row is created. May be optionally used by the college to track processing
		PS_CCTC_PMGT_STG	LASTUPDOPRID	The default value is “CCTC” when a row is created, but this value should be updated to whichever operatorID the college’s IT department changes it to, if desired
		PS_CCTC_PMGT_STG	LASTUPDDTTM	Last updated date/time