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.

...

College Adaptor Payload Name

CCC Field Name

PeopleSoft DB Staging Table

PeopleSoft Field Name

Notes

appId

app_id

PS_CCTC_APPL_STG

CCTC_APPL_IDSee here

cccId

ccc_id

PS_CCTC_APPL_STG

CCTC_CCCID

See here

status

status

PS_CCTC_APPL_STG

CCTC_APPL_STATUSSee here

collegeId

college_id

PS_CCTC_APPL_STG

CCTC_MIS_CD

See here

termId

term_id

PS_CCTC_APPL_STG

CCTC_TERM_ID

See here

majorId

major_id

PS_CCTC_APPL_STG

CCTC_MAJOR_IDSee here

intendedMajor

intended_major

PS_CCTC_APPL_STG

CCTC_MAJOR_NAME

See here

eduGoal

edu_goal

PS_CCTC_APPL_STG

CCTC_EDU_GOALSee here

highestEduLevel

highest_edu_level

PS_CCTC_APPL_STG

CCTC_HIGHEST_EDU

See here

consentIndicator

consent_indicator

PS_CCTC_APPL_STG

CCTC_INFO_CONSENTSee here

appLang

app_lang

PS_CCTC_APPL_STG

CCTC_APPL_LANG_CDSee here

ackFinAid

ack_fin_aid

PS_CCTC_APPL_STG

CCTC_APPL_ACK_FA

See here

finAidRef

fin_aid_ref

PS_CCTC_APPL_STG

CCTC_APPL_REF_FASee here

confirmation

confirmation

PS_CCTC_APPL_STG

CCTC_APPL_CFRM_NBR

See here

supPageCode

sup_page_code

PS_CCTC_APPL_STG

CCTC_APPL_SQ_PG_CDSee here

lastPage

last_page

PS_CCTC_APPL_STG

CCTC_APPL_LAST_PGSee here

streetaddress1

streetaddress1

PS_CCTC_APPL_STG

CCTC_MADDR_LINE1

See here

streetaddress2

streetaddress2

PS_CCTC_APPL_STG

CCTC_MADDR_LINE2See here

city

city

PS_CCTC_APPL_STG

CCTC_MADDR_CITYSee here

postalcode

postalcode

PS_CCTC_APPL_STG

CCTC_MADDR_POSTCD

See here

state

state

PS_CCTC_APPL_STG

CCTC_MADDR_STATE

See here

nonusaprovince

nonusaprovince

PS_CCTC_APPL_STG

CCTC_MADDR_PRVINCE

See here

country

country

PS_CCTC_APPL_STG

CCTC_MADDR_COUNTRYSee here

nonUsAddress

non_us_address

PS_CCTC_APPL_STG

CCTC_MADDR_USA

See here

email

email

PS_CCTC_APPL_STG

CCTC_EMAIL

See hereemailVerified

emailVerifiedemail_verified

PS_CCTC_APPL_STG

CCTC_EMAIL_VER

See hereNew

emailVerifiedTimestamp

email_verified_timestampemailVerifiedTimestamp

PS_CCTC_APPL_STG

CCTC_EMAIL_VER_TS

See hereNew

permStreetaddress1

perm_streetaddress1

PS_CCTC_APPL_STG

CCTC_PADDR_LINE1

See here

permStreetaddress2

perm_streetaddress2

PS_CCTC_APPL_STG

CCTC_PADDR_LINE2

See here

permCity

perm_city

PS_CCTC_APPL_STG

CCTC_PADDR_CITYSee here

permPostalcode

perm_postalcode

PS_CCTC_APPL_STG

CCTC_PADDR_POSTCD

See here

permState

perm_state

PS_CCTC_APPL_STG

CCTC_PADDR_STATESee here

permNonusaprovince

perm_nonusaprovince

PS_CCTC_APPL_STG

CCTC_PADDR_PRVINCESee here

permCountry

perm_country

PS_CCTC_APPL_STG

CCTC_PADDR_COUNTRY

See here

addressSame

address_same

PS_CCTC_APPL_STG

CCTC_PERM_EQ_MAILSee here

mainphone

mainphone

PS_CCTC_APPL_STG

CCTC_PHONE_MAIN

See here

mainphoneExt

mainphone_ext

PS_CCTC_APPL_STG

CCTC_PHONE_MAIN_EX

See hereNo Longer Used

mainphoneAuthText

mainphone_auth_text

PS_CCTC_APPL_STG

CCTC_PHONE_MAINSMS

See hereNo Longer Used

mainphoneVerified

mainphone_verifiedmainphoneVerified

PS_CCTC_APPL_STG

CCTC_PHONE_MN_VER

See hereNew

mainphoneVerifiedTimestamp

mainphone_verified_timestampmainphoneVerifiedTimestamp

PS_CCTC_APPL_STG

CCTC_PHONE_MN_VRTS

See hereNew

secondphone

secondphone

PS_CCTC_APPL_STG

CCTC_PHONE_SCND

See hereNo Longer Used

secondphoneExt

secondphone_ext

PS_CCTC_APPL_STG

CCTC_PHONE_SCND_EX

See hereNo Longer Used

secondphoneAuthText

secondphone_auth_text

PS_CCTC_APPL_STG

CCTC_PHONE_SCNDSMS

See hereNo Longer Used

preferredMethodOfContact

preferred_method_of_contactpreferredMethodOfContact

PS_CCTC_APPL_STG

CCTC_PRF_CNCT_MTHDSee here

enrollStatus

enroll_status

PS_CCTC_APPL_STG

CCTC_APPL_ENR_STAT

See here

hsEduLevel

hs_edu_level

PS_CCTC_APPL_STG

CCTC_APPL_HSEDULVL

See here

hsCompDate

hs_comp_date

PS_CCTC_APPL_STG

CCTC_APPL_HSCOMPDT

See here

higherEduLevel

higher_edu_level

PS_CCTC_APPL_STG

CCTC_APPL_HREDULVLSee here

higherCompDate

higher_comp_date

PS_CCTC_APPL_STG

CCTC_APPL_HRCOMPDTSee here

hsNotAttended

hs_not_attended

PS_CCTC_APPL_STG

CCTC_APPL_HS_NA

See here

cahsGraduated

cahs_graduated

PS_CCTC_APPL_STG

CCTC_APPL_HS_CASee here

cahs3year

cahs_3year

PS_CCTC_APPL_STG

CCTC_APPL_HS_CA3YR

See here

hsName

hs_name

PS_CCTC_APPL_STG

CCTC_APPL_HS_NAMESee here

hsCity

hs_city

PS_CCTC_APPL_STG

CCTC_APPL_HS_CITYSee here

hsState

hs_state

PS_CCTC_APPL_STG

CCTC_APPL_HS_STATE

See here

hsCountry

hs_country

PS_CCTC_APPL_STG

CCTC_APPL_HS_CNTRYSee here

hsCds

hs_cds

PS_CCTC_APPL_STG

CCTC_APPL_HS_CDS

See here

hsCeeb

hs_ceeb

PS_CCTC_APPL_STG

CCTC_APPL_HS_CEEBSee here

hsNotListed

hs_not_listed

PS_CCTC_APPL_STG

CCTC_APPL_HS_NLSee here

homeSchooled

home_schooled

PS_CCTC_APPL_STG

CCTC_APPL_HOME_EDUSee here

collegeCount

college_count

PS_CCTC_APPL_STG

CCTC_APPL_CLG_CNT

See here

hsAttendance

hs_attendance

PS_CCTC_APPL_STG

CCTC_APPL_HS_ATTND

See here

coenrollConfirm

coenroll_confirm

PS_CCTC_APPL_STG

CCTC_APPL_CENRL_CF

See here

gender

gender

PS_CCTC_APPL_STG

CCTC_GENDER

See here

pgFirstname

pg_firstname

PS_CCTC_APPL_STG

CCTC_PG1_FIRST_NMSee here

pgLastname

pg_lastname

PS_CCTC_APPL_STG

CCTC_PG1_LAST_NM

See here

pgRel

pg_rel

PS_CCTC_APPL_STG

CCTC_PG1_RELATION

See here

pg1Edu

pg1_edu

PS_CCTC_APPL_STG

CCTC_PG1_EDU_LVLSee here

pg2Edu

pg2_edu

PS_CCTC_APPL_STG

CCTC_PG2_EDU_LVL

See here

pgEduMis

pg_edu_mis

PS_CCTC_APPL_STG

CCTC_PG_EDU_MISSee here

under19Ind

under19_ind

PS_CCTC_APPL_STG

CCTC_APPL_UNDER19See here

dependentStatus

dependent_status

PS_CCTC_APPL_STG

CCTC_APPL_DPNDNT

See here

raceEthnic

race_ethnic

PS_CCTC_APPL_STG

CCTC_RACE_ETH_FLGS

See here

hispanic

hispanic

PS_CCTC_APPL_STG

CCTC_HISPANIC

See here

raceGroup

race_group

PS_CCTC_APPL_STG

CCTC_RACE_GROUPSee here

raceEthnicFull

race_ethnic_full

PS_CCTC_APPL_STG

CCTC_RACE_ETHNIC_FSee here

ssn

ssn

PS_CCTC_APPL_STG

CCTC_SSN

See here

birthdate

birthdate

PS_CCTC_APPL_STG

CCTC_BIRTHDATESee here

firstname

firstname

PS_CCTC_APPL_STG

CCTC_LGL_FIRST_NM

See here

middlename

middlename

PS_CCTC_APPL_STG

CCTC_LGL_MIDDLE_NMSee here

lastname

lastname

PS_CCTC_APPL_STG

CCTC_LGL_LAST_NMSee here

suffix

suffix

PS_CCTC_APPL_STG

CCTC_LGL_SUFFIX

See here

otherfirstname

otherfirstname

PS_CCTC_APPL_STG

CCTC_AKA_FIRST_NMSee here

othermiddlename

othermiddlename

PS_CCTC_APPL_STG

CCTC_AKA_MIDDLE_NM

See here

otherlastname

otherlastname

PS_CCTC_APPL_STG

CCTC_AKA_LAST_NMSee here

citizenshipStatus

citizenship_status

PS_CCTC_APPL_STG

CCTC_CITIZENSHIPSee here

alienRegNumber

alien_reg_number

PS_CCTC_APPL_STG

CCTC_ALIEN_REG_NBRSee here

visaType

visa_type

PS_CCTC_APPL_STG

CCTC_VISA_TYPE

See here

noDocuments

no_documents

PS_CCTC_APPL_STG

CCTC_NO_DOCS

See here

alienRegIssueDate

alien_reg_issue_date

PS_CCTC_APPL_STG

CCTC_ALIEN_REG_ISS

See here

alienRegExpireDate

alien_reg_expire_date

PS_CCTC_APPL_STG

CCTC_ALIEN_REG_EXP

See here

alienRegNoExpire

alien_reg_no_expire

PS_CCTC_APPL_STG

CCTC_ALIEN_NO_EXPSee here

militaryStatus

military_status

PS_CCTC_APPL_STG

CCTC_APPL_MIL_STAT

See here

militaryDischargeDate

military_discharge_date

PS_CCTC_APPL_STG

CCTC_APPL_MIL_DCDT

See here

militaryHomeState

military_home_state

PS_CCTC_APPL_STG

CCTC_APPL_MIL_HMSTSee here

militaryHomeCountry

military_home_country

PS_CCTC_APPL_STG

CCTC_APPL_MIL_HMCT

See here

militaryCaStationed

military_ca_stationed

PS_CCTC_APPL_STG

CCTC_APPL_MIL_CASee here

militaryLegalResidence

military_legal_residence

PS_CCTC_APPL_STG

CCTC_APPL_MIL_LGLRSee here

caRes2Years

ca_res_2_years

PS_CCTC_APPL_STG

CCTC_APPL_CA_2YRS

See here

caDateCurrent

ca_date_current

PS_CCTC_APPL_STG

CCTC_APPL_CA_BGNDT

See here

caNotArrived

ca_not_arrived

PS_CCTC_APPL_STG

CCTC_APPL_CA_NARVD

See here

caCollegeEmployee

ca_college_employee

PS_CCTC_APPL_STG

CCTC_APPL_CA_COL_ESee here

caSchoolEmployee

ca_school_employee

PS_CCTC_APPL_STG

CCTC_APPL_CA_SCH_ESee here

caSeasonalAg

ca_seasonal_ag

PS_CCTC_APPL_STG

CCTC_APPL_CA_AGR_E

See here

caFosterYouth

ca_foster_youth

PS_CCTC_APPL_STG

CCTC_APPL_CA_FOSTRSee here

caOutsideTax

ca_outside_tax

PS_CCTC_APPL_STG

CCTC_APPL_CA_OOSTX

See here

caOutsideTaxYear

ca_outside_tax_year

PS_CCTC_APPL_STG

CCTC_APPL_CA_TXYRSee here

caOutsideVoted

ca_outside_voted

PS_CCTC_APPL_STG

CCTC_APPL_CA_OOSVTSee here

caOutsideVotedYear

ca_outside_voted_year

PS_CCTC_APPL_STG

CCTC_APPL_CA_VTYR

See here

caOutsideCollege

ca_outside_college

PS_CCTC_APPL_STG

CCTC_APPL_CA_OOSEDSee here

caOutsideCollegeYear

ca_outside_college_year

PS_CCTC_APPL_STG

CCTC_APPL_CA_EDYR

See here

caOutsideLawsuit

ca_outside_lawsuit

PS_CCTC_APPL_STG

CCTC_APPL_CA_OOSLSSee here

caOutsideLawsuitYear

ca_outside_lawsuit_year

PS_CCTC_APPL_STG

CCTC_APPL_CA_LSYRSee here

resStatus

res_status

PS_CCTC_APPL_STG

CCTC_APPL_RESI_STSSee here

resStatusChange

res_status_change

PS_CCTC_APPL_STG

CCTC_APPL_RESI_CHG

See here

resPrevDate

res_prev_date

PS_CCTC_APPL_STG

CCTC_APPL_RESI_PRV

See here

admIneligible

adm_ineligible

PS_CCTC_APPL_STG

CCTC_APPL_ADM_NELG

See here

eligAb540

elig_ab540

PS_CCTC_APPL_STG

CCTC_APPL_ELGAB540

See here

resAreaA

res_area_a

PS_CCTC_APPL_STG

CCTC_APPL_RESI_ASee here

resAreaB

res_area_b

PS_CCTC_APPL_STG

CCTC_APPL_RESI_B

See here

resAreaC

res_area_c

PS_CCTC_APPL_STG

CCTC_APPL_RESI_C

See here

resAreaD

res_area_d

PS_CCTC_APPL_STG

CCTC_APPL_RESI_DSee here

experience

experience

PS_CCTC_APPL_STG

CCTC_APPL_EXPERNCE

See here

recommend

recommend

PS_CCTC_APPL_STG

CCTC_APPL_RECMMENDSee here

comments

comments

PS_CCTC_APPL_STG

CCTC_APPL_COMMENTSSee here

comfortableEnglish

comfortable_english

PS_CCTC_APPL_STG

CCTC_APPL_ENG_CMFT

See here

financialAssistance

financial_assistance

PS_CCTC_APPL_STG

CCTC_APPL_INT_FINA

See here

tanfSsiGa

tanf_ssi_ga

PS_CCTC_APPL_STG

CCTC_APPL_TANF_SSI

See here

fosterYouths

foster_youths

PS_CCTC_APPL_STG

CCTC_APPL_FOSTERSSee here

athleticIntercollegiate

athletic_intercollegiate

PS_CCTC_APPL_STG

CCTC_APPL_INT_ATHLSee here

athleticIntramural

athletic_intramural

PS_CCTC_APPL_STG

CCTC_APPL_INT_MURL

See here

athleticNotInterested

athletic_not_interested

PS_CCTC_APPL_STG

CCTC_APPL_INT_SPRTSee here

academicCounseling

academic_counseling

PS_CCTC_APPL_STG

CCTC_APPL_INT_ACAD

See here

basicSkills

basic_skills

PS_CCTC_APPL_STG

CCTC_APPL_INT_BASCSee here

calworks

calworks

PS_CCTC_APPL_STG

CCTC_APPL_INT_CLWKSee here

careerPlanning

career_planning

PS_CCTC_APPL_STG

CCTC_APPL_INT_CPLN

See here

childCare

child_care

PS_CCTC_APPL_STG

CCTC_APPL_INT_CHLDSee here

counselingPersonal

counseling_personal

PS_CCTC_APPL_STG

CCTC_APPL_INT_CNSL

See here

dsps

dsps

PS_CCTC_APPL_STG

CCTC_APPL_INT_DSPSSee here

eops

eops

PS_CCTC_APPL_STG

CCTC_APPL_INT_EOPSSee here

esl

esl

PS_CCTC_APPL_STG

CCTC_APPL_INT_ESLSee here

healthServices

health_services

PS_CCTC_APPL_STG

CCTC_APPL_INT_HLTH

See here

housingInfo

housing_info

PS_CCTC_APPL_STG

CCTC_APPL_INT_HOUS

See here

employmentAssistance

employment_assistance

PS_CCTC_APPL_STG

CCTC_APPL_INT_EMPL

See here

onlineClasses

online_classes

PS_CCTC_APPL_STG

CCTC_APPL_INT_ICLS

See here

reentryProgram

reentry_program

PS_CCTC_APPL_STG

CCTC_APPL_INT_RTRYSee here

scholarshipInfo

scholarship_info

PS_CCTC_APPL_STG

CCTC_APPL_INT_SCHL

See here

studentGovernment

student_government

PS_CCTC_APPL_STG

CCTC_APPL_INT_GVMT

See here

testingAssessment

testing_assessment

PS_CCTC_APPL_STG

CCTC_APPL_INT_TESTSee here

transferInfo

transfer_info

PS_CCTC_APPL_STG

CCTC_APPL_INT_TRSF

See here

tutoringServices

tutoring_services

PS_CCTC_APPL_STG

CCTC_APPL_INT_TUTRSee here

veteransServices

veterans_services

PS_CCTC_APPL_STG

CCTC_APPL_INT_VASee here

integrityFg01

integrity_fg_01

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_01

See here

integrityFg02

integrity_fg_02

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_02

See here

integrityFg03

integrity_fg_03

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_03

See here

integrityFg04

integrity_fg_04

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_04See here

integrityFg11

integrity_fg_11

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_11See here

integrityFg47

integrity_fg_47

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_47

See here

integrityFg48

integrity_fg_48

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_48See here

integrityFg49

integrity_fg_49

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_49

See here

integrityFg50

integrity_fg_50

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_50See here

integrityFg51

integrity_fg_51

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_51See here

integrityFg52

integrity_fg_52

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_52

See here

integrityFg53

integrity_fg_53

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_53See here

integrityFg54

integrity_fg_54

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_54

See here

integrityFg55

integrity_fg_55

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_55See here

integrityFg56

integrity_fg_56

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_56See here

integrityFg57

integrity_fg_57

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_57See here

integrityFg58

integrity_fg_58

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_58

See here

integrityFg59

integrity_fg_59

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_59

See here

integrityFg60

integrity_fg_60

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_60

See here

integrityFg61

integrity_fg_61

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_61

See here

integrityFg62

integrity_fg_62

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_62See here

integrityFg63

integrity_fg_63

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_63

See here

integrityFg70

integrity_fg_70

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_70

See here

integrityFg80

integrity_fg_80

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_80See here

col1Ceeb

col1_ceeb

PS_CCTC_APPL_STG

CCTC_APPL_CL1_CEEB

See here

col1Cds

col1_cds

PS_CCTC_APPL_STG

CCTC_APPL_CL1_CDSSee here

col1NotListed

col1_not_listed

PS_CCTC_APPL_STG

CCTC_APPL_CL1_NLSee here

col1Name

col1_name

PS_CCTC_APPL_STG

CCTC_APPL_CL1_NAME

See here

col1City

col1_city

PS_CCTC_APPL_STG

CCTC_APPL_CL1_CITY

See here

col1State

col1_state

PS_CCTC_APPL_STG

CCTC_APPL_CL1_STTE

See here

col1Country

col1_country

PS_CCTC_APPL_STG

CCTC_APPL_CL1_CTRYSee here

col1StartDate

col1_start_date

PS_CCTC_APPL_STG

CCTC_APPL_CL1_STRTSee here

col1EndDate

col1_end_date

PS_CCTC_APPL_STG

CCTC_APPL_CL1_END

See here

col1DegreeDate

col1_degree_date

PS_CCTC_APPL_STG

CCTC_APPL_CL1_DGDTSee here

col1DegreeObtained

col1_degree_obtained

PS_CCTC_APPL_STG

CCTC_APPL_CL1_DGRE

See here

col2Ceeb

col2_ceeb

PS_CCTC_APPL_STG

CCTC_APPL_CL2_CEEBSee here

col2Cds

col2_cds

PS_CCTC_APPL_STG

CCTC_APPL_CL2_CDSSee here

col2NotListed

col2_not_listed

PS_CCTC_APPL_STG

CCTC_APPL_CL2_NL

See here

col2Name

col2_name

PS_CCTC_APPL_STG

CCTC_APPL_CL2_NAMESee here

col2City

col2_city

PS_CCTC_APPL_STG

CCTC_APPL_CL2_CITY

See here

col2State

col2_state

PS_CCTC_APPL_STG

CCTC_APPL_CL2_STTESee here

col2Country

col2_country

PS_CCTC_APPL_STG

CCTC_APPL_CL2_CTRYSee hereCTRY

col2StartDate

col2_start_date

PS_CCTC_APPL_STG

CCTC_APPL_CL2_STRTSee here

col2EndDate

col2_end_date

PS_CCTC_APPL_STG

CCTC_APPL_CL2_END

See here

col2DegreeDate

col2_degree_date

PS_CCTC_APPL_STG

CCTC_APPL_CL2_DGDT

See here

col2DegreeObtained

col2_degree_obtained

PS_CCTC_APPL_STG

CCTC_APPL_CL2_DGRE

See here

col3Ceeb

col3_ceeb

PS_CCTC_APPL_STG

CCTC_APPL_CL3_CEEBSee here

col3Cds

col3_cds

PS_CCTC_APPL_STG

CCTC_APPL_CL3_CDS

See here

col3NotListed

col3_not_listed

PS_CCTC_APPL_STG

CCTC_APPL_CL3_NL

See here

col3Name

col3_name

PS_CCTC_APPL_STG

CCTC_APPL_CL3_NAMESee here

col3City

col3_city

PS_CCTC_APPL_STG

CCTC_APPL_CL3_CITY

See here

col3State

col3_state

PS_CCTC_APPL_STG

CCTC_APPL_CL3_STTESee here

col3Country

col3_country

PS_CCTC_APPL_STG

CCTC_APPL_CL3_CTRY

See here

col3StartDate

col3_start_date

PS_CCTC_APPL_STG

CCTC_APPL_CL3_STRTSee here

col3EndDate

col3_end_date

PS_CCTC_APPL_STG

CCTC_APPL_CL3_END

See here

col3DegreeDate

col3_degree_date

PS_CCTC_APPL_STG

CCTC_APPL_CL3_DGDT

See here

col3DegreeObtained

col3_degree_obtained

PS_CCTC_APPL_STG

CCTC_APPL_CL3_DGRESee here

col4Ceeb

col4_ceeb

PS_CCTC_APPL_STG

CCTC_APPL_CL4_CEEB

See here

col4Cds

col4_cds

PS_CCTC_APPL_STG

CCTC_APPL_CL4_CDSSee here

col4NotListed

col4_not_listed

PS_CCTC_APPL_STG

CCTC_APPL_CL4_NLSee here

col4Name

col4_name

PS_CCTC_APPL_STG

CCTC_APPL_CL4_NAME

See here

col4City

col4_city

PS_CCTC_APPL_STG

CCTC_APPL_CL4_CITYSee here

col4State

col4_state

PS_CCTC_APPL_STG

CCTC_APPL_CL4_STTE

See here

col4Country

col4_country

PS_CCTC_APPL_STG

CCTC_APPL_CL4_CTRYSee here

col4StartDate

col4_start_date

PS_CCTC_APPL_STG

CCTC_APPL_CL4_STRTSee here

col4EndDate

col4_end_date

PS_CCTC_APPL_STG

CCTC_APPL_CL4_END

See here

col4DegreeDate

col4_degree_date

PS_CCTC_APPL_STG

CCTC_APPL_CL4_DGDTSee here

col4DegreeObtained

col4_degree_obtained

PS_CCTC_APPL_STG

CCTC_APPL_CL4_DGRE

See here

collegeName

college_name

PS_CCTC_APPL_STG

CCTC_APPL_COL_NMSee here

districtName

district_name

PS_CCTC_APPL_STG

CCTC_APPL_DIS_NMSee here

termCode

term_code

PS_CCTC_APPL_STG

CCTC_TERM_CD

See here

termDescription

term_description

PS_CCTC_APPL_STG

CCTC_TERM_DS

See here

majorCode

major_code

PS_CCTC_APPL_STG

CCTC_APPL_MJR_CD

See here

majorDescription

major_description

PS_CCTC_APPL_STG

CCTC_APPL_MJR_DSSee here

tstmpSubmit

tstmp_submit

PS_CCTC_APPL_STG

CCTC_APPL_SBMT_TS

See here

tstmpCreate

tstmp_create

PS_CCTC_APPL_STG

CCTC_APPL_CRTE_TS

See here

tstmpUpdate

tstmp_update

PS_CCTC_APPL_STG

CCTC_APPL_UPDT_TSSee here

ssnDisplay

ssn_display

PS_CCTC_APPL_STG

CCTC_APPL_SSNDSPLY

See here

fosterYouthStatus

foster_youth_status

PS_CCTC_APPL_STG

CCTC_APPL_FSTRY_STSee here

fosterYouthPreference

foster_youth_preference

PS_CCTC_APPL_STG

CCTC_APPL_FSTRY_PF

See here

fosterYouthMis

foster_youth_mis

PS_CCTC_APPL_STG

CCTC_APPL_FSTRY_MSSee here

fosterYouthPriority

foster_youth_priority

PS_CCTC_APPL_STG

CCTC_APPL_FSTRY_PR

See here

tstmpDownload

tstmp_download

PS_CCTC_APPL_STG

CCTC_APPL_DWNLD_TS

See here

addressValidation

address_validation

PS_CCTC_APPL_STG

CCTC_MADDR_VALID

See hereaddressValidationOverride

addressValidationOverrideaddress_validation_override

PS_CCTC_APPL_STG

CCTC_MADDR_VOVR

See hereaddressValidationOverrideTimestamp

addressValidationOverrideTimestampaddress_validation_override_timestamp

PS_CCTC_APPL_STG

CCTC_MADDR_VOVR_TSSee here

zip4

zip4

PS_CCTC_APPL_STG

CCTC_MADDR_ZIP4

See here

permAddressValidation

perm_address_validation

PS_CCTC_APPL_STG

CCTC_PADDR_VALIDSee here

permZip4

perm_zip4

PS_CCTC_APPL_STG

CCTC_PADDR_ZIP4See here

dischargeType

discharge_type

PS_CCTC_APPL_STG

CCTC_APPL_MIL_DCTP

See here

collegeExpelledSummary

college_expelled_summary

PS_CCTC_APPL_STG

CCTC_APPL_COL_EXPSee here

col1ExpelledStatus

col1_expelled_status

PS_CCTC_APPL_STG

CCTC_APPL_CL1_EXPSee here

col2ExpelledStatus

col2_expelled_status

PS_CCTC_APPL_STG

CCTC_APPL_CL2_EXP

See here

col3ExpelledStatus

col3_expelled_status

PS_CCTC_APPL_STG

CCTC_APPL_CL3_EXP

See here

col4ExpelledStatus

col4_expelled_status

PS_CCTC_APPL_STG

CCTC_APPL_CL4_EXP

See here

integrityFlags

integrity_flags

PS_CCTC_APPL_STG

CCTC_APPL_IFLAGSSee here

rdd

rdd

PS_CCTC_APPL_STG

CCTC_APPL_RDD

See here

ssnType

ssn_type

PS_CCTC_APPL_STG

CCTC_APPL_SSN_TYPE

See here

militaryStationedCaEd

military_stationed_ca_ed

PS_CCTC_APPL_STG

CCTC_APPL_MIL_CAED

See here

integrityFg65

integrity_fg_65

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_65See here

integrityFg64

integrity_fg_64

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_64See here

ipAddress

ip_address

PS_CCTC_APPL_STG

CCTC_IP_ADDRESS

See here

campaign1

campaign1

PS_CCTC_APPL_STG

CCTC_APPL_CAMPGN1See here

campaign2

campaign2

PS_CCTC_APPL_STG

CCTC_APPL_CAMPGN2

See here

campaign3

campaign3

PS_CCTC_APPL_STG

CCTC_APPL_CAMPGN3

See here

orientation

orientation

PS_CCTC_APPL_STG

CCTC_APPL_SXORIENTSee here

transgender

transgender

PS_CCTC_APPL_STG

CCTC_APPL_TRNGNDR

See here

ssnException

ssn_exception

PS_CCTC_APPL_STG

CCTC_APPL_SSN_EXCPSee here

integrityFg71

integrity_fg_71

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_71

See here

preferredFirstname

preferred_firstname

PS_CCTC_APPL_STG

CCTC_PRF_FIRST_NMSee here

preferredMiddlename

preferred_middlename

PS_CCTC_APPL_STG

CCTC_PRF_MIDDLE_NM

See hereNo Longer Used

preferredLastname

preferred_lastname

PS_CCTC_APPL_STG

CCTC_PRF_LAST_NM

See hereNo Longer Used

preferredName

preferred_name

PS_CCTC_APPL_STG

CCTC_PRF_NM_SET

See hereNo Longer Used

ssnNo

ssn_no

PS_CCTC_APPL_STG

CCTC_APPL_SSN_NONESee here

completedEleventhGrade

completed_eleventh_grade

PS_CCTC_APPL_STG

CCTC_APPL_11G

See here

gradePointAverage

grade_point_average

PS_CCTC_APPL_STG

CCTC_APPL_HS_GPASee here

highestEnglishCourse

highest_english_course

PS_CCTC_APPL_STG

CCTC_APPL_ENG_HCCSee here

highestEnglishGrade

highest_english_grade

PS_CCTC_APPL_STG

CCTC_APPL_ENG_GRD

See here

highestMathCourseTaken

highest_math_course_taken

PS_CCTC_APPL_STG

CCTC_APPL_MTH_HCC

See here

highestMathTakenGrade

highest_math_taken_grade

PS_CCTC_APPL_STG

CCTC_APPL_MTHCGRD

See here

highestMathCoursePassed

highest_math_course_passed

PS_CCTC_APPL_STG

CCTC_APPL_MTH_HCPSee here

highestMathPassedGrade

highest_math_passed_grade

PS_CCTC_APPL_STG

CCTC_APPL_MTHPGRD

See here

integrityFg30

integrity_fg_30

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_30

See here

hsCdsFull

hs_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_HS_FCDS

See here

col1CdsFull

col1_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_CL1_FCDSSee here

col2CdsFull

col2_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_CL2_FCDSSee here

col3CdsFull

col3_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_CL3_FCDS

See here

col4CdsFull

col4_cds_full

PS_CCTC_APPL_STG

CCTC_APPL_CL4_FCDSSee here

ssid

ssid

PS_CCTC_APPL_STG

CCTC_SSID

See here

noPermAddressHomeless

no_perm_address_homeless

PS_CCTC_APPL_STG

CCTC_PADDR_HOMELSS

See here

noMailingAddressHomeless

no_mailing_address_homeless

PS_CCTC_APPL_STG

CCTC_MADDR_HOMELSSSee here

termStart

term_start

PS_CCTC_APPL_STG

CCTC_TERM_START_DT

See here

termEnd

term_end

PS_CCTC_APPL_STG

CCTC_TERM_END_DTSee here

homelessYouth

homeless_youth

PS_CCTC_APPL_STG

CCTC_APPL_HL_YOUTH

See here

integrityFg40

integrity_fg_40

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_40See here

cipCode

cip_code

PS_CCTC_APPL_STG

CCTC_APPL_MJR_CIPSee here

majorCategory

major_category

PS_CCTC_APPL_STG

CCTC_APPL_MJR_CAT

See here

mainphoneintl

mainphoneintl

PS_CCTC_APPL_STG

CCTC_PHONE_MAININTSee here

secondphoneintl

secondphoneintl

PS_CCTC_APPL_STG

CCTC_PHONE_SCNDINT

See hereNo Longer Used

nonCredit

non_credit

PS_CCTC_APPL_STG

CCTC_APPL_NOCREDIT

See here

integrityFg81

integrity_fg_81

PS_CCTC_APPL_STG

CCTC_APPL_IFLAG_81See here

highestGradeCompleted

highest_grade_completed

PS_CCTC_APPL_STG

CCTC_APPL_HGCSee here



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

...

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