CCCApply Standard SuperGlue Data Mappings - PeopleSoft
- Patricia Donohue
The tables below pertain to the CCCApply Standard & Noncredit Applications.
On This Page:
Standard Data Fields Table Mapping - PeopleSoft
For more details, see the CCCApply Standard & Noncredit Application data dictionary.
College Adaptor Payload Name | CCC Field Name | PeopleSoft DB Staging Table | PeopleSoft Field Name | Notes |
|---|---|---|---|---|
raceAIANOtherDescription | race_aian_other_description | PS_CCTC_APPL_STG | CCTC_RACE_AIAN_OD | SG v.4.10 |
studentDeps18Over | student_deps_18over | PS_CCTC_APPL_STG | CCTC_APPL_DEPS_18O | SG v.4.10 |
studentDepsUnder18 | student_deps_under18 | PS_CCTC_APPL_STG | CCTC_APPL_DEPS_U18 | SG v.4.10 |
idmeConfirmationTimestamp | idme_confirmation_timestamp | PS_CCTC_APPL_STG | CCTC_IDME_CNFRM_TS | SG v.4.9 |
idmeOptinTimestamp | idme_optin_timestamp | PS_CCTC_APPL_STG | CCTC_IDME_OPTIN_TS | SG v.4.9 |
idmeWorkflowStatus | idme_workflow_status | PS_CCTC_APPL_STG | CCTC_IDME_WKFL_STS | SG v.4.9 |
studentParent | student_parent | PS_CCTC_APPL_STG | CCTC_APPL_STD_PAR | SG v.4.7 |
acceptedTerms | accepted_terms | PS_CCTC_APPL_STG | CCTC_APPL_ACC_TRMS | SG v.4.6 |
acceptedTermsTimestamp | accepted_terms_timestamp | PS_CCTC_APPL_STG | CCTC_APPL_ATRMS_TS | SG v.4.6 |
ipAddressAtAccountCreation | ip_address_at_account_creation | PS_CCTC_APPL_STG | CCTC_APPL_IP_ACCT | SG v.4.7 |
ipAddressAtAppCreation | ip_address_at_app_creation | PS_CCTC_APPL_STG | CCTC_APPL_IP_APP | SG v.4.7 |
mailingAddressValidationOverride | mailing_address_validation_override | PS_CCTC_APPL_STG | CCTC_MADDR_VOVR2 | SG v.4.7 |
phoneType | phone_type | PS_CCTC_APPL_STG | CCTC_PHONE_MN_TYPE | SG v.4.7 |
appId | app_id | PS_CCTC_APPL_STG | CCTC_APPL_ID |
|
cccId | ccc_id | PS_CCTC_APPL_STG | CCTC_CCCID |
|
status | status | PS_CCTC_APPL_STG | CCTC_APPL_STATUS |
|
collegeId | college_id | PS_CCTC_APPL_STG | CCTC_MIS_CD |
|
termId | term_id | PS_CCTC_APPL_STG | CCTC_TERM_ID |
|
majorId | major_id | PS_CCTC_APPL_STG | CCTC_MAJOR_ID |
|
intendedMajor | intended_major | PS_CCTC_APPL_STG | CCTC_MAJOR_NAME |
|
eduGoal | edu_goal | PS_CCTC_APPL_STG | CCTC_EDU_GOAL |
|
highestEduLevel | highest_edu_level | PS_CCTC_APPL_STG | CCTC_HIGHEST_EDU |
|
consentIndicator | consent_indicator | PS_CCTC_APPL_STG | CCTC_INFO_CONSENT |
|
appLang | app_lang | PS_CCTC_APPL_STG | CCTC_APPL_LANG_CD |
|
ackFinAid | ack_fin_aid | PS_CCTC_APPL_STG | CCTC_APPL_ACK_FA |
|
finAidRef | fin_aid_ref | PS_CCTC_APPL_STG | CCTC_APPL_REF_FA |
|
confirmation | confirmation | PS_CCTC_APPL_STG | CCTC_APPL_CFRM_NBR |
|
supPageCode | sup_page_code | PS_CCTC_APPL_STG | CCTC_APPL_SQ_PG_CD |
|
lastPage | last_page | PS_CCTC_APPL_STG | CCTC_APPL_LAST_PG |
|
streetaddress1 | streetaddress1 | PS_CCTC_APPL_STG | CCTC_MADDR_LINE1 |
|
streetaddress2 | streetaddress2 | PS_CCTC_APPL_STG | CCTC_MADDR_LINE2 |
|
city | city | PS_CCTC_APPL_STG | CCTC_MADDR_CITY |
|
postalcode | postalcode | PS_CCTC_APPL_STG | CCTC_MADDR_POSTCD |
|
state | state | PS_CCTC_APPL_STG | CCTC_MADDR_STATE |
|
nonusaprovince | nonusaprovince | PS_CCTC_APPL_STG | CCTC_MADDR_PRVINCE |
|
country | country | PS_CCTC_APPL_STG | CCTC_MADDR_COUNTRY |
|
nonUsAddress | non_us_address | PS_CCTC_APPL_STG | CCTC_MADDR_USA |
|
PS_CCTC_APPL_STG | CCTC_EMAIL |
| ||
emailVerified | emailVerified | PS_CCTC_APPL_STG | CCTC_EMAIL_VER | New |
emailVerifiedTimestamp | emailVerifiedTimestamp | PS_CCTC_APPL_STG | CCTC_EMAIL_VER_TS | New |
permStreetaddress1 | perm_streetaddress1 | PS_CCTC_APPL_STG | CCTC_PADDR_LINE1 |
|
permStreetaddress2 | perm_streetaddress2 | PS_CCTC_APPL_STG | CCTC_PADDR_LINE2 |
|
permCity | perm_city | PS_CCTC_APPL_STG | CCTC_PADDR_CITY |
|
permPostalcode | perm_postalcode | PS_CCTC_APPL_STG | CCTC_PADDR_POSTCD |
|
permState | perm_state | PS_CCTC_APPL_STG | CCTC_PADDR_STATE |
|
permNonusaprovince | perm_nonusaprovince | PS_CCTC_APPL_STG | CCTC_PADDR_PRVINCE |
|
permCountry | perm_country | PS_CCTC_APPL_STG | CCTC_PADDR_COUNTRY |
|
addressSame | address_same | PS_CCTC_APPL_STG | CCTC_PERM_EQ_MAIL |
|
mainphone | mainphone | PS_CCTC_APPL_STG | CCTC_PHONE_MAIN |
|
mainphoneExt | mainphone_ext | PS_CCTC_APPL_STG | CCTC_PHONE_MAIN_EX | No Longer Used |
mainphoneAuthText | mainphone_auth_text | PS_CCTC_APPL_STG | CCTC_PHONE_MAINSMS | No Longer Used |
mainphoneVerified | mainphoneVerified | PS_CCTC_APPL_STG | CCTC_PHONE_MN_VER | New |
mainphoneVerifiedTimestamp | mainphoneVerifiedTimestamp | PS_CCTC_APPL_STG | CCTC_PHONE_MN_VRTS | New |
secondphone | secondphone | PS_CCTC_APPL_STG | CCTC_PHONE_SCND | No Longer Used |
secondphoneExt | secondphone_ext | PS_CCTC_APPL_STG | CCTC_PHONE_SCND_EX | No Longer Used |
secondphoneAuthText | secondphone_auth_text | PS_CCTC_APPL_STG | CCTC_PHONE_SCNDSMS | No Longer Used |
preferredMethodOfContact | preferredMethodOfContact | PS_CCTC_APPL_STG | CCTC_PRF_CNCT_MTHD |
|
enrollStatus | enroll_status | PS_CCTC_APPL_STG | CCTC_APPL_ENR_STAT |
|
hsEduLevel | hs_edu_level | PS_CCTC_APPL_STG | CCTC_APPL_HSEDULVL |
|
hsCompDate | hs_comp_date | PS_CCTC_APPL_STG | CCTC_APPL_HSCOMPDT |
|
higherEduLevel | higher_edu_level | PS_CCTC_APPL_STG | CCTC_APPL_HREDULVL |
|
higherCompDate | higher_comp_date | PS_CCTC_APPL_STG | CCTC_APPL_HRCOMPDT |
|
hsNotAttended | hs_not_attended | PS_CCTC_APPL_STG | CCTC_APPL_HS_NA |
|
cahsGraduated | cahs_graduated | PS_CCTC_APPL_STG | CCTC_APPL_HS_CA |
|
cahs3year | cahs_3year | PS_CCTC_APPL_STG | CCTC_APPL_HS_CA3YR |
|
hsName | hs_name | PS_CCTC_APPL_STG | CCTC_APPL_HS_NAME |
|
hsCity | hs_city | PS_CCTC_APPL_STG | CCTC_APPL_HS_CITY |
|
hsState | hs_state | PS_CCTC_APPL_STG | CCTC_APPL_HS_STATE |
|
hsCountry | hs_country | PS_CCTC_APPL_STG | CCTC_APPL_HS_CNTRY |
|
hsCds | hs_cds | PS_CCTC_APPL_STG | CCTC_APPL_HS_CDS |
|
hsCeeb | hs_ceeb | PS_CCTC_APPL_STG | CCTC_APPL_HS_CEEB |
|
hsNotListed | hs_not_listed | PS_CCTC_APPL_STG | CCTC_APPL_HS_NL |
|
homeSchooled | home_schooled | PS_CCTC_APPL_STG | CCTC_APPL_HOME_EDU |
|
collegeCount | college_count | PS_CCTC_APPL_STG | CCTC_APPL_CLG_CNT |
|
hsAttendance | hs_attendance | PS_CCTC_APPL_STG | CCTC_APPL_HS_ATTND |
|
coenrollConfirm | coenroll_confirm | PS_CCTC_APPL_STG | CCTC_APPL_CENRL_CF |
|
gender | gender | PS_CCTC_APPL_STG | CCTC_GENDER |
|
pgFirstname | pg_firstname | PS_CCTC_APPL_STG | CCTC_PG1_FIRST_NM |
|
pgLastname | pg_lastname | PS_CCTC_APPL_STG | CCTC_PG1_LAST_NM |
|
pgRel | pg_rel | PS_CCTC_APPL_STG | CCTC_PG1_RELATION |
|
pg1Edu | pg1_edu | PS_CCTC_APPL_STG | CCTC_PG1_EDU_LVL |
|
pg2Edu | pg2_edu | PS_CCTC_APPL_STG | CCTC_PG2_EDU_LVL |
|
pgEduMis | pg_edu_mis | PS_CCTC_APPL_STG | CCTC_PG_EDU_MIS |
|
under19Ind | under19_ind | PS_CCTC_APPL_STG | CCTC_APPL_UNDER19 |
|
dependentStatus | dependent_status | PS_CCTC_APPL_STG | CCTC_APPL_DPNDNT |
|
raceEthnic | race_ethnic | PS_CCTC_APPL_STG | CCTC_RACE_ETH_FLGS |
|
hispanic | hispanic | PS_CCTC_APPL_STG | CCTC_HISPANIC |
|
raceGroup | race_group | PS_CCTC_APPL_STG | CCTC_RACE_GROUP |
|
raceEthnicFull | race_ethnic_full | PS_CCTC_APPL_STG | CCTC_RACE_ETHNIC_F |
|
ssn | ssn | PS_CCTC_APPL_STG | CCTC_SSN |
|
birthdate | birthdate | PS_CCTC_APPL_STG | CCTC_BIRTHDATE |
|
firstname | firstname | PS_CCTC_APPL_STG | CCTC_LGL_FIRST_NM |
|
middlename | middlename | PS_CCTC_APPL_STG | CCTC_LGL_MIDDLE_NM |
|
lastname | lastname | PS_CCTC_APPL_STG | CCTC_LGL_LAST_NM |
|
suffix | suffix | PS_CCTC_APPL_STG | CCTC_LGL_SUFFIX |
|
otherfirstname | otherfirstname | PS_CCTC_APPL_STG | CCTC_AKA_FIRST_NM |
|
othermiddlename | othermiddlename | PS_CCTC_APPL_STG | CCTC_AKA_MIDDLE_NM |
|