Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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

...

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

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

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