CC Promise Grant Application SuperGlue Data Mappings - PeopleSoft
The tables below pertain to the latest version of the CC Promise Grant Online Application. See CCCApply Release Notes page for related updates.
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 | Notes |
|---|---|---|---|---|
studentDeps18Over | student_deps_18Over | PS_CCTC_PMGT_STG | CCTC_APPL_DEPS_18O | SG v.4.10 |
studentDepsUnder18 | student_deps_Under18 | PS_CCTC_PMGT_STG | CCTC_APPL_DEPS_U18 | SG v.4.10 |
idmeConfirmationTimestamp | idme_confirmation_timestamp | PS_CCTC_PMGT_STG | CCTC_IDME_CNFRM_TS | SG v.4.9 |
idmeOptinTimestamp | idme_optin_timestamp | PS_CCTC_PMGT_STG | CCTC_IDME_OPTIN_TS | SG v.4.9 |
idmeWorkflowStatus | idme_workflow_status | PS_CCTC_PMGT_STG | CCTC_IDME_WKFL_STS | SG v.4.9 |
studentParent | student_parent | PS_CCTC_PMGT_STG | CCTC_APPL_STD_PAR | Question added Apply v.6.13 / SG v.4.7 |
acceptedTerms | accepted_terms | PS_CCTC_PMGT_STG | CCTC_APPL_ACC_TRMS | SG v.4.7 |
acceptedTermsTimestamp | accepted_terms_timestamp | PS_CCTC_PMGT_STG | CCTC_APPL_ATRMS_TS | SG v.4.7 |
addressValidationOverride | address_validation_override | PS_CCTC_PMGT_STG | CCTC_MADDR_VOVR | SG v.4.6 |
addressValidationOverrideTimestamp | address_validation_override_timestamp | PS_CCTC_PMGT_STG | CCTC_MADDR_VOVR_TS | SG v.4.6 |
emailVerified | email_verified | PS_CCTC_PMGT_STG | CCTC_EMAIL_VER | SG v.4.6 |
emailVerifiedTimestamp | email_verified_timestamp | PS_CCTC_PMGT_STG | CCTC_EMAIL_VER_TS | SG v.4.6 |
ipAddressAtAccountCreation | ip_address_at_account_creation | PS_CCTC_PMGT_STG | CCTC_APPL_IP_ACCT | SG v.4.7 |
ipAddressAtAppCreation | ip_address_at_app_creation | PS_CCTC_PMGT_STG | CCTC_APPL_IP_APP | SG v.4.7 |
mailingAddressValidationOverride | mailing_address_validation_override | PS_CCTC_PMGT_STG | CCTC_MADDR_VOVR2 | SG v.4.7 |
mainphoneVerified | phone_verified | PS_CCTC_PMGT_STG | CCTC_PHONE_MN_VER | SG v.4.6 |
mainphoneVerifiedTimestamp | phone_verified_timestamp | PS_CCTC_PMGT_STG | CCTC_PHONE_MN_VRTS | SG v.4.6 |
phoneType | phone_type | PS_CCTC_PMGT_STG | CCTC_PHONE_MN_TYPE | SG v.4.7 |
preferredMethodOfContact | preferred_contact_method | PS_CCTC_PMGT_STG | CCTC_PRF_CNCT_MTHD | SG v.4.6 |
sisReceipt | sis_receipt | PS_CCTC_PMGT_STG |
| Coming |
appId | app_id | PS_CCTC_PMGT_STG | CCTC_PMGT_ID |
|
ccId | ccc_id | PS_CCTC_PMGT_STG | CCTC_CCCID |
|
confirmationNumber | confirmation_number | PS_CCTC_PMGT_STG | CCTC_APPL_CFRM_NBR |
|
status | status | PS_CCTC_PMGT_STG | CCTC_APPL_STATUS |
|
appLang | app_lang | PS_CCTC_PMGT_STG | CCTC_APPL_LANG_CD |
|
collegeId | college_id | PS_CCTC_PMGT_STG | CCTC_MIS_CD |
|
yearCode | year_code | PS_CCTC_PMGT_STG | CCTC_PMGT_YEAR_CD |
|
yearDescription | year_description | PS_CCTC_PMGT_STG | CCTC_PMGT_YEAR_DS |
|
determinedResidentca | determined_residentca | PS_CCTC_PMGT_STG | CCTC_PMGT_CA_RESI |
|
determinedAB540Eligible | determined_ab540_eligible | PS_CCTC_PMGT_STG | CCTC_APPL_ELGAB540 |
|
determinedNonResExempt | determined_non_res_exempt | PS_CCTC_PMGT_STG | CCTC_PMGT_CARESI_E |
|
lastname | lastname | PS_CCTC_PMGT_STG | CCTC_LGL_LAST_NM |
|
firstname | firstname | PS_CCTC_PMGT_STG | CCTC_LGL_FIRST_NM |
|
middlename | middlename | PS_CCTC_PMGT_STG | CCTC_LGL_MIDDLE_NM |
|
mainphone | mainphone | PS_CCTC_PMGT_STG | CCTC_PHONE_MAIN |
|
mainphoneExt | mainphone_ext | PS_CCTC_PMGT_STG | CCTC_PHONE_MAIN_EX |
|
mainphoneAuthText | mainphone_auth_text | PS_CCTC_PMGT_STG | CCTC_PHONE_MAINSMS |
|
mainphoneVerified | mainphone_verified | PS_CCTC_PMGT_STG | CCTC_PHONE_MN_VER |
|
mainphoneVerifiedTimestamp | mainphone_verified_timestmp | PS_CCTC_PMGT_STG | CCTC_PHONE_MN_VRTS |
|
PS_CCTC_PMGT_STG | CCTC_EMAIL |
| ||
emailVerified | email_verified | PS_CCTC_PMGT_STG | CCTC_EMAIL_VER |
|
emailVerifiedTimestamp | email_verified_timestamp | PS_CCTC_PMGT_STG | CCTC_EMAIL_VER_TS |
|
preferredMethodOfContact | preferred_method_of_contact | PS_CCTC_PMGT_STG | CCTC_PRF_CNCT_MTHD |
|
nonUsAddress | non_us_address | PS_CCTC_PMGT_STG | CCTC_MADDR_USA |
|
addressValidationOverride | address_validation_override | PS_CCTC_PMGT_STG | CCTC_MADDR_VOVR |
|
addressValidationOverrideTimestamp | address_validation_override_timestamp | PS_CCTC_PMGT_STG | CCTC_MADDR_VOVR_TS |
|
streetaddress1 | streetaddress1 | PS_CCTC_PMGT_STG | CCTC_MADDR_LINE1 |
|
streetaddress2 | streetaddress2 | PS_CCTC_PMGT_STG | CCTC_MADDR_LINE2 |
|
city | city | PS_CCTC_PMGT_STG | CCTC_MADDR_CITY |
|
state | state | PS_CCTC_PMGT_STG | CCTC_MADDR_STATE |
|
province | province | PS_CCTC_PMGT_STG | CCTC_MADDR_PRVINCE |
|
country | country | PS_CCTC_PMGT_STG | CCTC_MADDR_COUNTRY |
|
postalcode | postalcode | PS_CCTC_PMGT_STG | CCTC_MADDR_POSTCD |
|
ssn | ssn | PS_CCTC_PMGT_STG | CCTC_SSN |
|
ssnType | ssn_type | PS_CCTC_PMGT_STG | CCTC_APPL_SSN_TYPE |
|
studentCollegeId | student_college_id | PS_CCTC_PMGT_STG | CCTC_PMGT_EMPLID |
|
birthdate | birthdate | PS_CCTC_PMGT_STG | CCTC_BIRTHDATE |
|
maritalStatus | marital_status | PS_CCTC_PMGT_STG | CCTC_MARITAL_STAT |
|
regDomPartner | reg_dom_partner | PS_CCTC_PMGT_STG | CCTC_PMGT_APG_RDP |
|
bornBefore23Year | born_before_23_year | PS_CCTC_PMGT_STG | CCTC_PMGT_OVER23 |
|
marriedOrRdp | married_or_rdp | PS_CCTC_PMGT_STG | CCTC_PMGT_MRD_RDP |
|
usVeteran | us_veteran | PS_CCTC_PMGT_STG | CCTC_USA_VETERAN |
|
dependents | dependents | PS_CCTC_PMGT_STG | CCTC_PMGT_DPNDTS |
|
parentsDeceased |