CCCApply Standard SuperGlue Data Mappings - PeopleSoft

The tables below pertain to the CCCApply Standard & Noncredit Applications.

Contents

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

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

CCTC_PRF_MIDDLE_NM

No Longer Used

preferredLastname

preferred_lastname

PS_CCTC_APPL_STG

CCTC_PRF_LAST_NM

No Longer Used

preferredName

preferred_name

PS_CCTC_APPL_STG

CCTC_PRF_NM_SET

No Longer Used

ssnNo

ssn_no

PS_CCTC_APPL_STG

CCTC_APPL_SSN_NONE

 

completedEleventhGrade

completed_eleventh_grade

PS_CCTC_APPL_STG

CCTC_APPL_11G

 

gradePointAverage

grade_point_average

PS_CCTC_APPL_STG

CCTC_APPL_HS_GPA

 

highestEnglishCourse

highest_english_course

PS_CCTC_APPL_STG

CCTC_APPL_ENG_HCC

 

highestEnglishGrade

highest_english_grade

PS_CCTC_APPL_STG

CCTC_APPL_ENG_GRD

 

highestMathCourseTaken

highest_math_course_taken

PS_CCTC_APPL_STG

CCTC_APPL_MTH_HCC

 

highestMathTakenGrade

highest_math_taken_grade

PS_CCTC_APPL_STG

CCTC_APPL_MTHCGRD

 

highestMathCoursePassed

highest_math_course_passed

PS_CCTC_APPL_STG

CCTC_APPL_MTH_HCP

 

highestMathPassedGrade

highest_math_passed_grade

PS_CCTC_APPL_STG

CCTC_APPL_MTHPGRD

 

integrityFg30

integrity_fg_30

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_30

 

hsCdsFull

hs_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_HS_FCDS

 

col1CdsFull

col1_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_CL1_FCDS

 

col2CdsFull

col2_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_CL2_FCDS

 

col3CdsFull

col3_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_CL3_FCDS

 

col4CdsFull

col4_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_CL4_FCDS

 

ssid

ssid

PS_CCTC_APPL_STG

CCTC_SSID

 

noPermAddressHomeless

no_perm_address_homeless

PS_CCTC_APPL_STG

CCTC_PADDR_HOMELSS

 

noMailingAddressHomeless

no_mailing_address_homeless

PS_CCTC_APPL_STG

CCTC_MADDR_HOMELSS

 

termStart

term_start

PS_CCTC_APPL_STG

CCTC_TERM_START_DT

 

termEnd

term_end

PS_CCTC_APPL_STG

CCTC_TERM_END_DT

 

homelessYouth

homeless_youth

PS_CCTC_APPL_STG

CCTC_APPL_HL_YOUTH

 

integrityFg40

integrity_fg_40

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_40

 

cipCode

cip_code

PS_CCTC_APPL_STG

CCTC_APPL_MJR_CIP

 

majorCategory

major_category

PS_CCTC_APPL_STG

CCTC_APPL_MJR_CAT

 

mainphoneintl

mainphoneintl

PS_CCTC_APPL_STG

CCTC_PHONE_MAININT

 

secondphoneintl

secondphoneintl

PS_CCTC_APPL_STG

CCTC_PHONE_SCNDINT

No Longer Used

nonCredit

non_credit

PS_CCTC_APPL_STG

CCTC_APPL_NOCREDIT

 

integrityFg81

integrity_fg_81

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_81

 

highestGradeCompleted

highest_grade_completed

PS_CCTC_APPL_STG

CCTC_APPL_HGC

 





PS_CCTC_APPL_STG

STATUS_FLAG

A blank value whenever a new row is created. May be optionally used by the college to track processing





PS_CCTC_APPL_STG

STATUS_DTTM

Used for tracking/processing; defaults to the current date/time when a row is created, but should be updated if/when the STATUS_FLAG field is changed





PS_CCTC_APPL_STG

DESCRLONG_NOTES

A blank value whenever a new row is created. May be optionally used by the college to track processing





PS_CCTC_APPL_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_APPL_STG

LASTUPDDTTM

Last updated date/time

 

CCCApply Supplemental Questions Data Fields Mappings - PeopleSoft

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

appId

app_id

PS_CCTC_APPLSQ_STG

CCTC_APPL_ID

See here

suppText01

supp_text_01

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_01

See here

suppText02

supp_text_02

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_02

See here

suppText03

supp_text_03

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_03

See here

suppText04

supp_text_04

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_04

See here

suppText05

supp_text_05

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_05

See here

suppText06

supp_text_06

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_06

See here

suppText07

supp_text_07

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_07

See here

suppText08

supp_text_08

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_08

See here

suppText09

supp_text_09

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_09

See here

suppText10

supp_text_10

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_10

See here

suppText11

supp_text_11

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_11

See here

suppText12

supp_text_12

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_12

See here

suppText13

supp_text_13

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_13

See here

suppText14

supp_text_14

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_14

See here

suppText15

supp_text_15

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_15

See here

suppText16

supp_text_16

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_16

See here

suppText17

supp_text_17

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_17

See here

suppText18

supp_text_18

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_18

See here

suppText19

supp_text_19

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_19

See here

suppText20

supp_text_20

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_TXT_20

See here

suppCheck01

supp_check_01

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_01

See here

suppCheck02

supp_check_02

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_02

See here

suppCheck03

supp_check_03

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_03

See here

suppCheck04

supp_check_04

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_04

See here

suppCheck05

supp_check_05

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_05

See here

suppCheck06

supp_check_06

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_06

See here

suppCheck07

supp_check_07

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_07

See here

suppCheck08

supp_check_08

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_08

See here

suppCheck09

supp_check_09

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_09

See here

suppCheck10

supp_check_10

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_10

See here

suppCheck11

supp_check_11

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_11

See here

suppCheck12

supp_check_12

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_12

See here

suppCheck13

supp_check_13

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_13

See here

suppCheck14

supp_check_14

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_14

See here

suppCheck15

supp_check_15

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_15

See here

suppCheck16

supp_check_16

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_16

See here

suppCheck17

supp_check_17

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_17

See here

suppCheck18

supp_check_18

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_18

See here

suppCheck19

supp_check_19

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_19

See here

suppCheck20

supp_check_20

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_20

See here

suppCheck21

supp_check_21

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_21

See here

suppCheck22

supp_check_22

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_22

See here

suppCheck23

supp_check_23

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_23

See here

suppCheck24

supp_check_24

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_24

See here

suppCheck25

supp_check_25

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_25

See here

suppCheck26

supp_check_26

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_26

See here

suppCheck27

supp_check_27

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_27

See here

suppCheck28

supp_check_28

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_28

See here

suppCheck20

supp_check_29

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_29

See here

suppCheck30

supp_check_30

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_30

See here

suppCheck31

supp_check_31

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_31

See here

suppCheck32

supp_check_32

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_32

See here

suppCheck33

supp_check_33

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_33

See here

suppCheck34

supp_check_34

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_34

See here

suppCheck35

supp_check_35

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_35

See here

suppCheck36

supp_check_36

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_36

See here

suppCheck37

supp_check_37

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_37

See here

suppCheck38

supp_check_38

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_38

See here

suppCheck39

supp_check_39

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_39

See here

suppCheck40

supp_check_40

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_40

See here

suppCheck41

supp_check_41

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_41

See here

suppCheck42

supp_check_42

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_42

See here

suppCheck43

supp_check_43

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_43

See here

suppCheck44

supp_check_44

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_44

See here

suppCheck45

supp_check_45

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_45

See here

suppCheck46

supp_check_46

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_46

See here

suppCheck47

supp_check_47

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_47

See here

suppCheck48

supp_check_48

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_48

See here

suppCheck49

supp_check_49

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_49

See here

suppCheck50

supp_check_50

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CBX_50

See here

suppYesno01

supp_yesno_01

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_01

See here

suppYesno02

supp_yesno_02

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_02

See here

suppYesno03

supp_yesno_03

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_03

See here

suppYesno04

supp_yesno_04

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_04

See here

suppYesno05

supp_yesno_05

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_05

See here

suppYesno06

supp_yesno_06

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_06

See here

suppYesno07

supp_yesno_07

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_07

See here

suppYesno08

supp_yesno_08

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_08

See here

suppYesno09

supp_yesno_09

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_09

See here

suppYesno10

supp_yesno_10

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_10

See here

suppYesno11

supp_yesno_11

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_11

See here

suppYesno12

supp_yesno_12

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_12

See here

suppYesno13

supp_yesno_13

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_13

See here

suppYesno14

supp_yesno_14

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_14

See here

suppYesno15

supp_yesno_15

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_15

See here

suppYesno16

supp_yesno_16

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_16

See here

suppYesno17

supp_yesno_17

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_17

See here

suppYesno18

supp_yesno_18

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_18

See here

suppYesno19

supp_yesno_19

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_19

See here

suppYesno20

supp_yesno_20

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_20

See here

suppYesno21

supp_yesno_21

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_21

See here

suppYesno22

supp_yesno_22

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_22

See here

suppYesno23

supp_yesno_23

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_23

See here

suppYesno24

supp_yesno_24

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_24

See here

suppYesno25

supp_yesno_25

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_25

See here

suppYesno26

supp_yesno_26

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_26

See here

suppYesno27

supp_yesno_27

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_27

See here

suppYesno28

supp_yesno_28

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_28

See here

suppYesno29

supp_yesno_29

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_29

See here

suppYesno30

supp_yesno_30

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_YN_30

See here

suppMenu01

supp_menu_01

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_01

See here

suppMenu02

supp_menu_02

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_02

See here

suppMenu03

supp_menu_03

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_03

See here

suppMenu04

supp_menu_04

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_04

See here

suppMenu05

supp_menu_05

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_05

See here

suppMenu06

supp_menu_06

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_06

See here

suppMenu07

supp_menu_07

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_07

See here

suppMenu08

supp_menu_08

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_08

See here

suppMenu09

supp_menu_09

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_09

See here

suppMenu10

supp_menu_10

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_10

See here

suppMenu11

supp_menu_11

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_11

See here

suppMenu12

supp_menu_12

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_12

See here

suppMenu13

supp_menu_13

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_13

See here

suppMenu14

supp_menu_14

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_14

See here

suppMenu15

supp_menu_15

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_15

See here

suppMenu16

supp_menu_16

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_16

See here

suppMenu17

supp_menu_17

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_17

See here

suppMenu18

supp_menu_18

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_18

See here

suppMenu19

supp_menu_19

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_19

See here

suppMenu20

supp_menu_20

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_20

See here

suppMenu21

supp_menu_21

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_21

See here

suppMenu22

supp_menu_22

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_22

See here

suppMenu23

supp_menu_23

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_23

See here

suppMenu24

supp_menu_24

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_24

See here

suppMenu25

supp_menu_25

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_25

See here

suppMenu26

supp_menu_26

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_26

See here

suppMenu27

supp_menu_27

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_27

See here

suppMenu28

supp_menu_28

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_28

See here

suppMenu29

supp_menu_29

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_29

See here

suppMenu30

supp_menu_30

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_MNU_30

See here

suppDate01

supp_date_01

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_DT_01

See here

suppDate02

supp_date_02

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_DT_02

See here

suppDate03

supp_date_03

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_DT_03

See here

suppDate04

supp_date_04

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_DT_04

See here

suppDate05

supp_date_05

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_DT_05

See here

suppState01

supp_state_01

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_ST_01

See here

suppState02

supp_state_02

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_ST_02

See here

suppState03

supp_state_03

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_ST_03

See here

suppState04

supp_state_04

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_ST_04

See here

suppState05

supp_state_05

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_ST_05

See here

suppCountry01

supp_country_01

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CT_01

See here

suppCountry02

supp_country_02

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CT_02

See here

suppCountry03

supp_country_03

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CT_03

See here

suppCountry04

supp_country_04

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CT_04

See here

suppCountry05

supp_country_05

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_CT_05

See here

suppPhonenumber01

supp_phonenumber_01

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_PHN_01

See here

suppPhonenumber02

supp_phonenumber_02

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_PHN_02

See here

suppPhonenumber03

supp_phonenumber_03

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_PHN_03

See here

suppPhonenumber04

supp_phonenumber_04

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_PHN_04

See here

suppPhonenumber05

supp_phonenumber_05

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_PHN_05

See here

suppSecret01

supp_secret_01

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_SCT_01

See here

suppSecret02

supp_secret_02

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_SCT_02

See here

suppSecret03

supp_secret_03

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_SCT_03

See here

suppSecret04

supp_secret_04

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_SCT_04

See here

suppSecret05

supp_secret_05

PS_CCTC_APPLSQ_STG

CCTC_APPLSQ_SCT_05

See here





PS_CCTC_APPLSQ_STG

STATUS_FLAG

A single blank character whenever a new row is created. May be optionally used by the college to track processing





PS_CCTC_APPLSQ_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





PS_CCTC_APPLSQ_STG

DESCRLONG_NOTES

A blank value whenever a new row is created. May be optionally used by the college to track processing





PS_CCTC_APPLSQ_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_APPLSQ_STG

LASTUPDDTTM

Last updated date/time