CCCApply Standard SuperGlue Data Mappings - PeopleSoft

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

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

 

email

email

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