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

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