# 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.

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. |

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 |