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

 

otherlastname

otherlastname

PS_CCTC_APPL_STG

CCTC_AKA_LAST_NM

 

citizenshipStatus

citizenship_status

PS_CCTC_APPL_STG

CCTC_CITIZENSHIP

 

alienRegNumber

alien_reg_number

PS_CCTC_APPL_STG

CCTC_ALIEN_REG_NBR

 

visaType

visa_type

PS_CCTC_APPL_STG

CCTC_VISA_TYPE

 

noDocuments

no_documents

PS_CCTC_APPL_STG

CCTC_NO_DOCS

 

alienRegIssueDate

alien_reg_issue_date

PS_CCTC_APPL_STG

CCTC_ALIEN_REG_ISS

 

alienRegExpireDate

alien_reg_expire_date

PS_CCTC_APPL_STG

CCTC_ALIEN_REG_EXP

 

alienRegNoExpire

alien_reg_no_expire

PS_CCTC_APPL_STG

CCTC_ALIEN_NO_EXP

 

militaryStatus

military_status

PS_CCTC_APPL_STG

CCTC_APPL_MIL_STAT

 

militaryDischargeDate

military_discharge_date

PS_CCTC_APPL_STG

CCTC_APPL_MIL_DCDT

 

militaryHomeState

military_home_state

PS_CCTC_APPL_STG

CCTC_APPL_MIL_HMST

 

militaryHomeCountry

military_home_country

PS_CCTC_APPL_STG

CCTC_APPL_MIL_HMCT

 

militaryCaStationed

military_ca_stationed

PS_CCTC_APPL_STG

CCTC_APPL_MIL_CA

 

militaryLegalResidence

military_legal_residence

PS_CCTC_APPL_STG

CCTC_APPL_MIL_LGLR

 

caRes2Years

ca_res_2_years

PS_CCTC_APPL_STG

CCTC_APPL_CA_2YRS

 

caDateCurrent

ca_date_current

PS_CCTC_APPL_STG

CCTC_APPL_CA_BGNDT

 

caNotArrived

ca_not_arrived

PS_CCTC_APPL_STG

CCTC_APPL_CA_NARVD

 

caCollegeEmployee

ca_college_employee

PS_CCTC_APPL_STG

CCTC_APPL_CA_COL_E

 

caSchoolEmployee

ca_school_employee

PS_CCTC_APPL_STG

CCTC_APPL_CA_SCH_E

 

caSeasonalAg

ca_seasonal_ag

PS_CCTC_APPL_STG

CCTC_APPL_CA_AGR_E

 

caFosterYouth

ca_foster_youth

PS_CCTC_APPL_STG

CCTC_APPL_CA_FOSTR

 

caOutsideTax

ca_outside_tax

PS_CCTC_APPL_STG

CCTC_APPL_CA_OOSTX

 

caOutsideTaxYear

ca_outside_tax_year

PS_CCTC_APPL_STG

CCTC_APPL_CA_TXYR

 

caOutsideVoted

ca_outside_voted

PS_CCTC_APPL_STG

CCTC_APPL_CA_OOSVT

 

caOutsideVotedYear

ca_outside_voted_year

PS_CCTC_APPL_STG

CCTC_APPL_CA_VTYR

 

caOutsideCollege

ca_outside_college

PS_CCTC_APPL_STG

CCTC_APPL_CA_OOSED

 

caOutsideCollegeYear

ca_outside_college_year

PS_CCTC_APPL_STG

CCTC_APPL_CA_EDYR

 

caOutsideLawsuit

ca_outside_lawsuit

PS_CCTC_APPL_STG

CCTC_APPL_CA_OOSLS

 

caOutsideLawsuitYear

ca_outside_lawsuit_year

PS_CCTC_APPL_STG

CCTC_APPL_CA_LSYR

 

resStatus

res_status

PS_CCTC_APPL_STG

CCTC_APPL_RESI_STS

 

resStatusChange

res_status_change

PS_CCTC_APPL_STG

CCTC_APPL_RESI_CHG

 

resPrevDate

res_prev_date

PS_CCTC_APPL_STG

CCTC_APPL_RESI_PRV

 

admIneligible

adm_ineligible

PS_CCTC_APPL_STG

CCTC_APPL_ADM_NELG

 

eligAb540

elig_ab540

PS_CCTC_APPL_STG

CCTC_APPL_ELGAB540

 

resAreaA

res_area_a

PS_CCTC_APPL_STG

CCTC_APPL_RESI_A

 

resAreaB

res_area_b

PS_CCTC_APPL_STG

CCTC_APPL_RESI_B

 

resAreaC

res_area_c

PS_CCTC_APPL_STG

CCTC_APPL_RESI_C

 

resAreaD

res_area_d

PS_CCTC_APPL_STG

CCTC_APPL_RESI_D

 

experience

experience

PS_CCTC_APPL_STG

CCTC_APPL_EXPERNCE

 

recommend

recommend

PS_CCTC_APPL_STG

CCTC_APPL_RECMMEND

 

comments

comments

PS_CCTC_APPL_STG

CCTC_APPL_COMMENTS

 

comfortableEnglish

comfortable_english

PS_CCTC_APPL_STG

CCTC_APPL_ENG_CMFT

 

financialAssistance

financial_assistance

PS_CCTC_APPL_STG

CCTC_APPL_INT_FINA

 

tanfSsiGa

tanf_ssi_ga

PS_CCTC_APPL_STG

CCTC_APPL_TANF_SSI

 

fosterYouths

foster_youths

PS_CCTC_APPL_STG

CCTC_APPL_FOSTERS

 

athleticIntercollegiate

athletic_intercollegiate

PS_CCTC_APPL_STG

CCTC_APPL_INT_ATHL

 

athleticIntramural

athletic_intramural

PS_CCTC_APPL_STG

CCTC_APPL_INT_MURL

 

athleticNotInterested

athletic_not_interested

PS_CCTC_APPL_STG

CCTC_APPL_INT_SPRT

 

academicCounseling

academic_counseling

PS_CCTC_APPL_STG

CCTC_APPL_INT_ACAD

 

basicSkills

basic_skills

PS_CCTC_APPL_STG

CCTC_APPL_INT_BASC

 

calworks

calworks

PS_CCTC_APPL_STG

CCTC_APPL_INT_CLWK

 

careerPlanning

career_planning

PS_CCTC_APPL_STG

CCTC_APPL_INT_CPLN

 

childCare

child_care

PS_CCTC_APPL_STG

CCTC_APPL_INT_CHLD

 

counselingPersonal

counseling_personal

PS_CCTC_APPL_STG

CCTC_APPL_INT_CNSL

 

dsps

dsps

PS_CCTC_APPL_STG

CCTC_APPL_INT_DSPS

 

eops

eops

PS_CCTC_APPL_STG

CCTC_APPL_INT_EOPS

 

esl

esl

PS_CCTC_APPL_STG

CCTC_APPL_INT_ESL

 

healthServices

health_services

PS_CCTC_APPL_STG

CCTC_APPL_INT_HLTH

 

housingInfo

housing_info

PS_CCTC_APPL_STG

CCTC_APPL_INT_HOUS

 

employmentAssistance

employment_assistance

PS_CCTC_APPL_STG

CCTC_APPL_INT_EMPL

 

onlineClasses

online_classes

PS_CCTC_APPL_STG

CCTC_APPL_INT_ICLS

 

reentryProgram

reentry_program

PS_CCTC_APPL_STG

CCTC_APPL_INT_RTRY

 

scholarshipInfo

scholarship_info

PS_CCTC_APPL_STG

CCTC_APPL_INT_SCHL

 

studentGovernment

student_government

PS_CCTC_APPL_STG

CCTC_APPL_INT_GVMT

 

testingAssessment

testing_assessment

PS_CCTC_APPL_STG

CCTC_APPL_INT_TEST

 

transferInfo

transfer_info

PS_CCTC_APPL_STG

CCTC_APPL_INT_TRSF

 

tutoringServices

tutoring_services

PS_CCTC_APPL_STG

CCTC_APPL_INT_TUTR

 

veteransServices

veterans_services

PS_CCTC_APPL_STG

CCTC_APPL_INT_VA

 

integrityFg01

integrity_fg_01

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_01

 

integrityFg02

integrity_fg_02

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_02

 

integrityFg03

integrity_fg_03

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_03

 

integrityFg04

integrity_fg_04

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_04

 

integrityFg11

integrity_fg_11

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_11

 

integrityFg47

integrity_fg_47

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_47

 

integrityFg48

integrity_fg_48

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_48

 

integrityFg49

integrity_fg_49

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_49

 

integrityFg50

integrity_fg_50

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_50

 

integrityFg51

integrity_fg_51

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_51

 

integrityFg52

integrity_fg_52

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_52

 

integrityFg53

integrity_fg_53

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_53

 

integrityFg54

integrity_fg_54

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_54

 

integrityFg55

integrity_fg_55

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_55

 

integrityFg56

integrity_fg_56

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_56

 

integrityFg57

integrity_fg_57

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_57

 

integrityFg58

integrity_fg_58

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_58

 

integrityFg59

integrity_fg_59

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_59

 

integrityFg60

integrity_fg_60

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_60

 

integrityFg61

integrity_fg_61

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_61

 

integrityFg62

integrity_fg_62

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_62

 

integrityFg63

integrity_fg_63

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_63

 

integrityFg70

integrity_fg_70

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_70

 

integrityFg80

integrity_fg_80

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_80

 

col1Ceeb

col1_ceeb

PS_CCTC_APPL_STG

CCTC_APPL_CL1_CEEB

 

col1Cds

col1_cds

PS_CCTC_APPL_STG

CCTC_APPL_CL1_CDS

 

col1NotListed

col1_not_listed

PS_CCTC_APPL_STG

CCTC_APPL_CL1_NL

 

col1Name

col1_name

PS_CCTC_APPL_STG

CCTC_APPL_CL1_NAME

 

col1City

col1_city

PS_CCTC_APPL_STG

CCTC_APPL_CL1_CITY

 

col1State

col1_state

PS_CCTC_APPL_STG

CCTC_APPL_CL1_STTE

 

col1Country

col1_country

PS_CCTC_APPL_STG

CCTC_APPL_CL1_CTRY

 

col1StartDate

col1_start_date

PS_CCTC_APPL_STG

CCTC_APPL_CL1_STRT

 

col1EndDate

col1_end_date

PS_CCTC_APPL_STG

CCTC_APPL_CL1_END

 

col1DegreeDate

col1_degree_date

PS_CCTC_APPL_STG

CCTC_APPL_CL1_DGDT

 

col1DegreeObtained

col1_degree_obtained

PS_CCTC_APPL_STG

CCTC_APPL_CL1_DGRE

 

col2Ceeb

col2_ceeb

PS_CCTC_APPL_STG

CCTC_APPL_CL2_CEEB

 

col2Cds

col2_cds

PS_CCTC_APPL_STG

CCTC_APPL_CL2_CDS

 

col2NotListed

col2_not_listed

PS_CCTC_APPL_STG

CCTC_APPL_CL2_NL

 

col2Name

col2_name

PS_CCTC_APPL_STG

CCTC_APPL_CL2_NAME

 

col2City

col2_city

PS_CCTC_APPL_STG

CCTC_APPL_CL2_CITY

 

col2State

col2_state

PS_CCTC_APPL_STG

CCTC_APPL_CL2_STTE

 

col2Country

col2_country

PS_CCTC_APPL_STG

CCTC_APPL_CL2_CTRY

 

col2StartDate

col2_start_date

PS_CCTC_APPL_STG

CCTC_APPL_CL2_STRT

 

col2EndDate

col2_end_date

PS_CCTC_APPL_STG

CCTC_APPL_CL2_END

 

col2DegreeDate

col2_degree_date

PS_CCTC_APPL_STG

CCTC_APPL_CL2_DGDT

 

col2DegreeObtained

col2_degree_obtained

PS_CCTC_APPL_STG

CCTC_APPL_CL2_DGRE

 

col3Ceeb

col3_ceeb

PS_CCTC_APPL_STG

CCTC_APPL_CL3_CEEB

 

col3Cds

col3_cds

PS_CCTC_APPL_STG

CCTC_APPL_CL3_CDS

 

col3NotListed

col3_not_listed

PS_CCTC_APPL_STG

CCTC_APPL_CL3_NL

 

col3Name

col3_name

PS_CCTC_APPL_STG

CCTC_APPL_CL3_NAME

 

col3City

col3_city

PS_CCTC_APPL_STG

CCTC_APPL_CL3_CITY

 

col3State

col3_state

PS_CCTC_APPL_STG

CCTC_APPL_CL3_STTE

 

col3Country

col3_country

PS_CCTC_APPL_STG

CCTC_APPL_CL3_CTRY

 

col3StartDate

col3_start_date

PS_CCTC_APPL_STG

CCTC_APPL_CL3_STRT

 

col3EndDate

col3_end_date

PS_CCTC_APPL_STG

CCTC_APPL_CL3_END

 

col3DegreeDate

col3_degree_date

PS_CCTC_APPL_STG

CCTC_APPL_CL3_DGDT

 

col3DegreeObtained

col3_degree_obtained

PS_CCTC_APPL_STG

CCTC_APPL_CL3_DGRE

 

col4Ceeb

col4_ceeb

PS_CCTC_APPL_STG

CCTC_APPL_CL4_CEEB

 

col4Cds

col4_cds

PS_CCTC_APPL_STG

CCTC_APPL_CL4_CDS

 

col4NotListed

col4_not_listed

PS_CCTC_APPL_STG

CCTC_APPL_CL4_NL

 

col4Name

col4_name

PS_CCTC_APPL_STG

CCTC_APPL_CL4_NAME

 

col4City

col4_city

PS_CCTC_APPL_STG

CCTC_APPL_CL4_CITY

 

col4State

col4_state

PS_CCTC_APPL_STG

CCTC_APPL_CL4_STTE

 

col4Country

col4_country

PS_CCTC_APPL_STG

CCTC_APPL_CL4_CTRY

 

col4StartDate

col4_start_date

PS_CCTC_APPL_STG

CCTC_APPL_CL4_STRT

 

col4EndDate

col4_end_date

PS_CCTC_APPL_STG

CCTC_APPL_CL4_END

 

col4DegreeDate

col4_degree_date

PS_CCTC_APPL_STG

CCTC_APPL_CL4_DGDT

 

col4DegreeObtained

col4_degree_obtained

PS_CCTC_APPL_STG

CCTC_APPL_CL4_DGRE

 

collegeName

college_name

PS_CCTC_APPL_STG

CCTC_APPL_COL_NM

 

districtName

district_name

PS_CCTC_APPL_STG

CCTC_APPL_DIS_NM

 

termCode

term_code

PS_CCTC_APPL_STG

CCTC_TERM_CD

 

termDescription

term_description

PS_CCTC_APPL_STG

CCTC_TERM_DS

 

majorCode

major_code

PS_CCTC_APPL_STG

CCTC_APPL_MJR_CD

 

majorDescription

major_description

PS_CCTC_APPL_STG

CCTC_APPL_MJR_DS

 

tstmpSubmit

tstmp_submit

PS_CCTC_APPL_STG

CCTC_APPL_SBMT_TS

 

tstmpCreate

tstmp_create

PS_CCTC_APPL_STG

CCTC_APPL_CRTE_TS

 

tstmpUpdate

tstmp_update

PS_CCTC_APPL_STG

CCTC_APPL_UPDT_TS

 

ssnDisplay

ssn_display

PS_CCTC_APPL_STG

CCTC_APPL_SSNDSPLY

 

fosterYouthStatus

foster_youth_status

PS_CCTC_APPL_STG

CCTC_APPL_FSTRY_ST

 

fosterYouthPreference

foster_youth_preference

PS_CCTC_APPL_STG

CCTC_APPL_FSTRY_PF

 

fosterYouthMis

foster_youth_mis

PS_CCTC_APPL_STG

CCTC_APPL_FSTRY_MS

 

fosterYouthPriority

foster_youth_priority

PS_CCTC_APPL_STG

CCTC_APPL_FSTRY_PR

 

tstmpDownload

tstmp_download

PS_CCTC_APPL_STG

CCTC_APPL_DWNLD_TS

 

addressValidation

address_validation

PS_CCTC_APPL_STG

CCTC_MADDR_VALID

 

addressValidationOverride

addressValidationOverride

PS_CCTC_APPL_STG

CCTC_MADDR_VOVR

 

addressValidationOverrideTimestamp

addressValidationOverrideTimestamp

PS_CCTC_APPL_STG

CCTC_MADDR_VOVR_TS

 

zip4

zip4

PS_CCTC_APPL_STG

CCTC_MADDR_ZIP4

 

permAddressValidation

perm_address_validation

PS_CCTC_APPL_STG

CCTC_PADDR_VALID

 

permZip4

perm_zip4

PS_CCTC_APPL_STG

CCTC_PADDR_ZIP4

 

dischargeType

discharge_type

PS_CCTC_APPL_STG

CCTC_APPL_MIL_DCTP

 

collegeExpelledSummary

college_expelled_summary

PS_CCTC_APPL_STG

CCTC_APPL_COL_EXP

 

col1ExpelledStatus

col1_expelled_status

PS_CCTC_APPL_STG

CCTC_APPL_CL1_EXP

 

col2ExpelledStatus

col2_expelled_status

PS_CCTC_APPL_STG

CCTC_APPL_CL2_EXP

 

col3ExpelledStatus

col3_expelled_status

PS_CCTC_APPL_STG

CCTC_APPL_CL3_EXP

 

col4ExpelledStatus

col4_expelled_status

PS_CCTC_APPL_STG

CCTC_APPL_CL4_EXP

 

integrityFlags

integrity_flags

PS_CCTC_APPL_STG

CCTC_APPL_IFLAGS

 

rdd

rdd

PS_CCTC_APPL_STG

CCTC_APPL_RDD

 

ssnType

ssn_type

PS_CCTC_APPL_STG

CCTC_APPL_SSN_TYPE

 

militaryStationedCaEd

military_stationed_ca_ed

PS_CCTC_APPL_STG

CCTC_APPL_MIL_CAED

 

integrityFg65

integrity_fg_65

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_65

 

integrityFg64

integrity_fg_64

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_64

 

ipAddress

ip_address

PS_CCTC_APPL_STG

CCTC_IP_ADDRESS

 

campaign1

campaign1

PS_CCTC_APPL_STG

CCTC_APPL_CAMPGN1

 

campaign2

campaign2

PS_CCTC_APPL_STG

CCTC_APPL_CAMPGN2

 

campaign3

campaign3

PS_CCTC_APPL_STG

CCTC_APPL_CAMPGN3

 

orientation

orientation

PS_CCTC_APPL_STG

CCTC_APPL_SXORIENT

 

transgender

transgender

PS_CCTC_APPL_STG

CCTC_APPL_TRNGNDR

 

ssnException

ssn_exception

PS_CCTC_APPL_STG

CCTC_APPL_SSN_EXCP

 

integrityFg71

integrity_fg_71

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_71

 

preferredFirstname

preferred_firstname

PS_CCTC_APPL_STG

CCTC_PRF_FIRST_NM

 

preferredMiddlename

preferred_middlename

PS_CCTC_APPL_STG