CCCApply Standard SuperGlue Data Mappings - PeopleSoft

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

Standard Data Fields Table Mapping - PeopleSoft

For more details, see the CCCApply Standard & Noncredit Application data dictionary.

College Adaptor Payload Name	CCC Field Name	PeopleSoft DB Staging Table	PeopleSoft Field Name	Notes

College Adaptor Payload Name	CCC Field Name	PeopleSoft DB Staging Table	PeopleSoft Field Name	Notes
raceAIANOtherDescription	race_aian_other_description	PS_CCTC_APPL_STG	CCTC_RACE_AIAN_OD	SG v.4.10
studentDeps18Over	student_deps_18over	PS_CCTC_APPL_STG	CCTC_APPL_DEPS_18O	SG v.4.10
studentDepsUnder18	student_deps_under18	PS_CCTC_APPL_STG	CCTC_APPL_DEPS_U18	SG v.4.10
idmeConfirmationTimestamp	idme_confirmation_timestamp	PS_CCTC_APPL_STG	CCTC_IDME_CNFRM_TS	SG v.4.9
idmeOptinTimestamp	idme_optin_timestamp	PS_CCTC_APPL_STG	CCTC_IDME_OPTIN_TS	SG v.4.9
idmeWorkflowStatus	idme_workflow_status	PS_CCTC_APPL_STG	CCTC_IDME_WKFL_STS	SG v.4.9
studentParent	student_parent	PS_CCTC_APPL_STG	CCTC_APPL_STD_PAR	SG v.4.7
acceptedTerms	accepted_terms	PS_CCTC_APPL_STG	CCTC_APPL_ACC_TRMS	SG v.4.6
acceptedTermsTimestamp	accepted_terms_timestamp	PS_CCTC_APPL_STG	CCTC_APPL_ATRMS_TS	SG v.4.6
ipAddressAtAccountCreation	ip_address_at_account_creation	PS_CCTC_APPL_STG	CCTC_APPL_IP_ACCT	SG v.4.7
ipAddressAtAppCreation	ip_address_at_app_creation	PS_CCTC_APPL_STG	CCTC_APPL_IP_APP	SG v.4.7
mailingAddressValidationOverride	mailing_address_validation_override	PS_CCTC_APPL_STG	CCTC_MADDR_VOVR2	SG v.4.7
phoneType	phone_type	PS_CCTC_APPL_STG	CCTC_PHONE_MN_TYPE	SG v.4.7
appId	app_id	PS_CCTC_APPL_STG	CCTC_APPL_ID
cccId	ccc_id	PS_CCTC_APPL_STG	CCTC_CCCID
status	status	PS_CCTC_APPL_STG	CCTC_APPL_STATUS
collegeId	college_id	PS_CCTC_APPL_STG	CCTC_MIS_CD
termId	term_id	PS_CCTC_APPL_STG	CCTC_TERM_ID
majorId	major_id	PS_CCTC_APPL_STG	CCTC_MAJOR_ID
intendedMajor	intended_major	PS_CCTC_APPL_STG	CCTC_MAJOR_NAME
eduGoal	edu_goal	PS_CCTC_APPL_STG	CCTC_EDU_GOAL
highestEduLevel	highest_edu_level	PS_CCTC_APPL_STG	CCTC_HIGHEST_EDU
consentIndicator	consent_indicator	PS_CCTC_APPL_STG	CCTC_INFO_CONSENT
appLang	app_lang	PS_CCTC_APPL_STG	CCTC_APPL_LANG_CD
ackFinAid	ack_fin_aid	PS_CCTC_APPL_STG	CCTC_APPL_ACK_FA
finAidRef	fin_aid_ref	PS_CCTC_APPL_STG	CCTC_APPL_REF_FA
confirmation	confirmation	PS_CCTC_APPL_STG	CCTC_APPL_CFRM_NBR
supPageCode	sup_page_code	PS_CCTC_APPL_STG	CCTC_APPL_SQ_PG_CD
lastPage	last_page	PS_CCTC_APPL_STG	CCTC_APPL_LAST_PG
streetaddress1	streetaddress1	PS_CCTC_APPL_STG	CCTC_MADDR_LINE1
streetaddress2	streetaddress2	PS_CCTC_APPL_STG	CCTC_MADDR_LINE2
city	city	PS_CCTC_APPL_STG	CCTC_MADDR_CITY
postalcode	postalcode	PS_CCTC_APPL_STG	CCTC_MADDR_POSTCD
state	state	PS_CCTC_APPL_STG	CCTC_MADDR_STATE
nonusaprovince	nonusaprovince	PS_CCTC_APPL_STG	CCTC_MADDR_PRVINCE
country	country	PS_CCTC_APPL_STG	CCTC_MADDR_COUNTRY
nonUsAddress	non_us_address	PS_CCTC_APPL_STG	CCTC_MADDR_USA
email	email	PS_CCTC_APPL_STG	CCTC_EMAIL
emailVerified	emailVerified	PS_CCTC_APPL_STG	CCTC_EMAIL_VER	New
emailVerifiedTimestamp	emailVerifiedTimestamp	PS_CCTC_APPL_STG	CCTC_EMAIL_VER_TS	New
permStreetaddress1	perm_streetaddress1	PS_CCTC_APPL_STG	CCTC_PADDR_LINE1
permStreetaddress2	perm_streetaddress2	PS_CCTC_APPL_STG	CCTC_PADDR_LINE2
permCity	perm_city	PS_CCTC_APPL_STG	CCTC_PADDR_CITY
permPostalcode	perm_postalcode	PS_CCTC_APPL_STG	CCTC_PADDR_POSTCD
permState	perm_state	PS_CCTC_APPL_STG	CCTC_PADDR_STATE
permNonusaprovince	perm_nonusaprovince	PS_CCTC_APPL_STG	CCTC_PADDR_PRVINCE
permCountry	perm_country	PS_CCTC_APPL_STG	CCTC_PADDR_COUNTRY
addressSame	address_same	PS_CCTC_APPL_STG	CCTC_PERM_EQ_MAIL
mainphone	mainphone	PS_CCTC_APPL_STG	CCTC_PHONE_MAIN
mainphoneExt	mainphone_ext	PS_CCTC_APPL_STG	CCTC_PHONE_MAIN_EX	No Longer Used
mainphoneAuthText	mainphone_auth_text	PS_CCTC_APPL_STG	CCTC_PHONE_MAINSMS	No Longer Used
mainphoneVerified	mainphoneVerified	PS_CCTC_APPL_STG	CCTC_PHONE_MN_VER	New
mainphoneVerifiedTimestamp	mainphoneVerifiedTimestamp	PS_CCTC_APPL_STG	CCTC_PHONE_MN_VRTS	New
secondphone	secondphone	PS_CCTC_APPL_STG	CCTC_PHONE_SCND	No Longer Used
secondphoneExt	secondphone_ext	PS_CCTC_APPL_STG	CCTC_PHONE_SCND_EX	No Longer Used
secondphoneAuthText	secondphone_auth_text	PS_CCTC_APPL_STG	CCTC_PHONE_SCNDSMS	No Longer Used
preferredMethodOfContact	preferredMethodOfContact	PS_CCTC_APPL_STG	CCTC_PRF_CNCT_MTHD
enrollStatus	enroll_status	PS_CCTC_APPL_STG	CCTC_APPL_ENR_STAT
hsEduLevel	hs_edu_level	PS_CCTC_APPL_STG	CCTC_APPL_HSEDULVL
hsCompDate	hs_comp_date	PS_CCTC_APPL_STG	CCTC_APPL_HSCOMPDT
higherEduLevel	higher_edu_level	PS_CCTC_APPL_STG	CCTC_APPL_HREDULVL
higherCompDate	higher_comp_date	PS_CCTC_APPL_STG	CCTC_APPL_HRCOMPDT
hsNotAttended	hs_not_attended	PS_CCTC_APPL_STG	CCTC_APPL_HS_NA
cahsGraduated	cahs_graduated	PS_CCTC_APPL_STG	CCTC_APPL_HS_CA
cahs3year	cahs_3year	PS_CCTC_APPL_STG	CCTC_APPL_HS_CA3YR
hsName	hs_name	PS_CCTC_APPL_STG	CCTC_APPL_HS_NAME
hsCity	hs_city	PS_CCTC_APPL_STG	CCTC_APPL_HS_CITY
hsState	hs_state	PS_CCTC_APPL_STG	CCTC_APPL_HS_STATE
hsCountry	hs_country	PS_CCTC_APPL_STG	CCTC_APPL_HS_CNTRY
hsCds	hs_cds	PS_CCTC_APPL_STG	CCTC_APPL_HS_CDS
hsCeeb	hs_ceeb	PS_CCTC_APPL_STG	CCTC_APPL_HS_CEEB
hsNotListed	hs_not_listed	PS_CCTC_APPL_STG	CCTC_APPL_HS_NL
homeSchooled	home_schooled	PS_CCTC_APPL_STG	CCTC_APPL_HOME_EDU
collegeCount	college_count	PS_CCTC_APPL_STG	CCTC_APPL_CLG_CNT
hsAttendance	hs_attendance	PS_CCTC_APPL_STG	CCTC_APPL_HS_ATTND
coenrollConfirm	coenroll_confirm	PS_CCTC_APPL_STG	CCTC_APPL_CENRL_CF
gender	gender	PS_CCTC_APPL_STG	CCTC_GENDER
pgFirstname	pg_firstname	PS_CCTC_APPL_STG	CCTC_PG1_FIRST_NM
pgLastname	pg_lastname	PS_CCTC_APPL_STG	CCTC_PG1_LAST_NM
pgRel	pg_rel	PS_CCTC_APPL_STG	CCTC_PG1_RELATION
pg1Edu	pg1_edu	PS_CCTC_APPL_STG	CCTC_PG1_EDU_LVL
pg2Edu	pg2_edu	PS_CCTC_APPL_STG	CCTC_PG2_EDU_LVL
pgEduMis	pg_edu_mis	PS_CCTC_APPL_STG	CCTC_PG_EDU_MIS
under19Ind	under19_ind	PS_CCTC_APPL_STG	CCTC_APPL_UNDER19
dependentStatus	dependent_status	PS_CCTC_APPL_STG	CCTC_APPL_DPNDNT
raceEthnic	race_ethnic	PS_CCTC_APPL_STG	CCTC_RACE_ETH_FLGS
hispanic	hispanic	PS_CCTC_APPL_STG	CCTC_HISPANIC
raceGroup	race_group	PS_CCTC_APPL_STG	CCTC_RACE_GROUP
raceEthnicFull	race_ethnic_full	PS_CCTC_APPL_STG	CCTC_RACE_ETHNIC_F
ssn	ssn	PS_CCTC_APPL_STG	CCTC_SSN
birthdate	birthdate	PS_CCTC_APPL_STG	CCTC_BIRTHDATE
firstname	firstname	PS_CCTC_APPL_STG	CCTC_LGL_FIRST_NM
middlename	middlename	PS_CCTC_APPL_STG	CCTC_LGL_MIDDLE_NM
lastname	lastname	PS_CCTC_APPL_STG	CCTC_LGL_LAST_NM
suffix	suffix	PS_CCTC_APPL_STG	CCTC_LGL_SUFFIX
otherfirstname	otherfirstname	PS_CCTC_APPL_STG	CCTC_AKA_FIRST_NM
othermiddlename	othermiddlename	PS_CCTC_APPL_STG	CCTC_AKA_MIDDLE_NM
otherlastname	otherlastname	PS_CCTC_APPL_STG	CCTC_AKA_LAST_NM
citizenshipStatus	citizenship_status	PS_CCTC_APPL_STG	CCTC_CITIZENSHIP
alienRegNumber	alien_reg_number	PS_CCTC_APPL_STG	CCTC_ALIEN_REG_NBR
visaType	visa_type	PS_CCTC_APPL_STG	CCTC_VISA_TYPE
noDocuments	no_documents	PS_CCTC_APPL_STG	CCTC_NO_DOCS
alienRegIssueDate	alien_reg_issue_date	PS_CCTC_APPL_STG	CCTC_ALIEN_REG_ISS
alienRegExpireDate	alien_reg_expire_date	PS_CCTC_APPL_STG	CCTC_ALIEN_REG_EXP
alienRegNoExpire	alien_reg_no_expire	PS_CCTC_APPL_STG	CCTC_ALIEN_NO_EXP
militaryStatus	military_status	PS_CCTC_APPL_STG	CCTC_APPL_MIL_STAT
militaryDischargeDate	military_discharge_date	PS_CCTC_APPL_STG	CCTC_APPL_MIL_DCDT
militaryHomeState	military_home_state	PS_CCTC_APPL_STG	CCTC_APPL_MIL_HMST
militaryHomeCountry	military_home_country	PS_CCTC_APPL_STG	CCTC_APPL_MIL_HMCT
militaryCaStationed	military_ca_stationed	PS_CCTC_APPL_STG	CCTC_APPL_MIL_CA
militaryLegalResidence	military_legal_residence	PS_CCTC_APPL_STG	CCTC_APPL_MIL_LGLR
caRes2Years	ca_res_2_years	PS_CCTC_APPL_STG	CCTC_APPL_CA_2YRS
caDateCurrent	ca_date_current	PS_CCTC_APPL_STG	CCTC_APPL_CA_BGNDT
caNotArrived	ca_not_arrived	PS_CCTC_APPL_STG	CCTC_APPL_CA_NARVD
caCollegeEmployee	ca_college_employee	PS_CCTC_APPL_STG	CCTC_APPL_CA_COL_E
caSchoolEmployee	ca_school_employee	PS_CCTC_APPL_STG	CCTC_APPL_CA_SCH_E
caSeasonalAg	ca_seasonal_ag	PS_CCTC_APPL_STG	CCTC_APPL_CA_AGR_E
caFosterYouth	ca_foster_youth	PS_CCTC_APPL_STG	CCTC_APPL_CA_FOSTR
caOutsideTax	ca_outside_tax	PS_CCTC_APPL_STG	CCTC_APPL_CA_OOSTX
caOutsideTaxYear	ca_outside_tax_year	PS_CCTC_APPL_STG	CCTC_APPL_CA_TXYR
caOutsideVoted	ca_outside_voted	PS_CCTC_APPL_STG	CCTC_APPL_CA_OOSVT
caOutsideVotedYear	ca_outside_voted_year	PS_CCTC_APPL_STG	CCTC_APPL_CA_VTYR
caOutsideCollege	ca_outside_college	PS_CCTC_APPL_STG	CCTC_APPL_CA_OOSED
caOutsideCollegeYear	ca_outside_college_year	PS_CCTC_APPL_STG	CCTC_APPL_CA_EDYR
caOutsideLawsuit	ca_outside_lawsuit	PS_CCTC_APPL_STG	CCTC_APPL_CA_OOSLS
caOutsideLawsuitYear	ca_outside_lawsuit_year	PS_CCTC_APPL_STG	CCTC_APPL_CA_LSYR
resStatus	res_status	PS_CCTC_APPL_STG	CCTC_APPL_RESI_STS
resStatusChange	res_status_change	PS_CCTC_APPL_STG	CCTC_APPL_RESI_CHG
resPrevDate	res_prev_date	PS_CCTC_APPL_STG	CCTC_APPL_RESI_PRV
admIneligible	adm_ineligible	PS_CCTC_APPL_STG	CCTC_APPL_ADM_NELG
eligAb540	elig_ab540	PS_CCTC_APPL_STG	CCTC_APPL_ELGAB540
resAreaA	res_area_a	PS_CCTC_APPL_STG	CCTC_APPL_RESI_A
resAreaB	res_area_b	PS_CCTC_APPL_STG	CCTC_APPL_RESI_B
resAreaC	res_area_c	PS_CCTC_APPL_STG	CCTC_APPL_RESI_C
resAreaD	res_area_d	PS_CCTC_APPL_STG	CCTC_APPL_RESI_D
experience	experience	PS_CCTC_APPL_STG	CCTC_APPL_EXPERNCE
recommend	recommend	PS_CCTC_APPL_STG	CCTC_APPL_RECMMEND
comments	comments	PS_CCTC_APPL_STG	CCTC_APPL_COMMENTS
comfortableEnglish	comfortable_english	PS_CCTC_APPL_STG	CCTC_APPL_ENG_CMFT
financialAssistance	financial_assistance	PS_CCTC_APPL_STG	CCTC_APPL_INT_FINA
tanfSsiGa	tanf_ssi_ga	PS_CCTC_APPL_STG	CCTC_APPL_TANF_SSI
fosterYouths	foster_youths	PS_CCTC_APPL_STG	CCTC_APPL_FOSTERS
athleticIntercollegiate	athletic_intercollegiate	PS_CCTC_APPL_STG	CCTC_APPL_INT_ATHL
athleticIntramural	athletic_intramural	PS_CCTC_APPL_STG	CCTC_APPL_INT_MURL
athleticNotInterested	athletic_not_interested	PS_CCTC_APPL_STG	CCTC_APPL_INT_SPRT
academicCounseling	academic_counseling	PS_CCTC_APPL_STG	CCTC_APPL_INT_ACAD
basicSkills	basic_skills	PS_CCTC_APPL_STG	CCTC_APPL_INT_BASC
calworks	calworks	PS_CCTC_APPL_STG	CCTC_APPL_INT_CLWK
careerPlanning	career_planning	PS_CCTC_APPL_STG	CCTC_APPL_INT_CPLN
childCare	child_care	PS_CCTC_APPL_STG	CCTC_APPL_INT_CHLD
counselingPersonal	counseling_personal	PS_CCTC_APPL_STG	CCTC_APPL_INT_CNSL
dsps	dsps	PS_CCTC_APPL_STG	CCTC_APPL_INT_DSPS
eops	eops	PS_CCTC_APPL_STG	CCTC_APPL_INT_EOPS
esl	esl	PS_CCTC_APPL_STG	CCTC_APPL_INT_ESL
healthServices	health_services	PS_CCTC_APPL_STG	CCTC_APPL_INT_HLTH
housingInfo	housing_info	PS_CCTC_APPL_STG	CCTC_APPL_INT_HOUS
employmentAssistance	employment_assistance	PS_CCTC_APPL_STG	CCTC_APPL_INT_EMPL
onlineClasses	online_classes	PS_CCTC_APPL_STG	CCTC_APPL_INT_ICLS
reentryProgram	reentry_program	PS_CCTC_APPL_STG	CCTC_APPL_INT_RTRY
scholarshipInfo	scholarship_info	PS_CCTC_APPL_STG	CCTC_APPL_INT_SCHL
studentGovernment	student_government	PS_CCTC_APPL_STG	CCTC_APPL_INT_GVMT
testingAssessment	testing_assessment	PS_CCTC_APPL_STG	CCTC_APPL_INT_TEST
transferInfo	transfer_info	PS_CCTC_APPL_STG	CCTC_APPL_INT_TRSF
tutoringServices	tutoring_services	PS_CCTC_APPL_STG	CCTC_APPL_INT_TUTR
veteransServices	veterans_services	PS_CCTC_APPL_STG	CCTC_APPL_INT_VA
integrityFg01	integrity_fg_01	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_01
integrityFg02	integrity_fg_02	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_02
integrityFg03	integrity_fg_03	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_03
integrityFg04	integrity_fg_04	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_04
integrityFg11	integrity_fg_11	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_11
integrityFg47	integrity_fg_47	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_47
integrityFg48	integrity_fg_48	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_48
integrityFg49	integrity_fg_49	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_49
integrityFg50	integrity_fg_50	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_50
integrityFg51	integrity_fg_51	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_51
integrityFg52	integrity_fg_52	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_52
integrityFg53	integrity_fg_53	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_53
integrityFg54	integrity_fg_54	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_54
integrityFg55	integrity_fg_55	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_55
integrityFg56	integrity_fg_56	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_56
integrityFg57	integrity_fg_57	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_57
integrityFg58	integrity_fg_58	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_58
integrityFg59	integrity_fg_59	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_59
integrityFg60	integrity_fg_60	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_60
integrityFg61	integrity_fg_61	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_61
integrityFg62	integrity_fg_62	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_62
integrityFg63	integrity_fg_63	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_63
integrityFg70	integrity_fg_70	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_70
integrityFg80	integrity_fg_80	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_80
col1Ceeb	col1_ceeb	PS_CCTC_APPL_STG	CCTC_APPL_CL1_CEEB
col1Cds	col1_cds	PS_CCTC_APPL_STG	CCTC_APPL_CL1_CDS
col1NotListed	col1_not_listed	PS_CCTC_APPL_STG	CCTC_APPL_CL1_NL
col1Name	col1_name	PS_CCTC_APPL_STG	CCTC_APPL_CL1_NAME
col1City	col1_city	PS_CCTC_APPL_STG	CCTC_APPL_CL1_CITY
col1State	col1_state	PS_CCTC_APPL_STG	CCTC_APPL_CL1_STTE
col1Country	col1_country	PS_CCTC_APPL_STG	CCTC_APPL_CL1_CTRY
col1StartDate	col1_start_date	PS_CCTC_APPL_STG	CCTC_APPL_CL1_STRT
col1EndDate	col1_end_date	PS_CCTC_APPL_STG	CCTC_APPL_CL1_END
col1DegreeDate	col1_degree_date	PS_CCTC_APPL_STG	CCTC_APPL_CL1_DGDT
col1DegreeObtained	col1_degree_obtained	PS_CCTC_APPL_STG	CCTC_APPL_CL1_DGRE
col2Ceeb	col2_ceeb	PS_CCTC_APPL_STG	CCTC_APPL_CL2_CEEB
col2Cds	col2_cds	PS_CCTC_APPL_STG	CCTC_APPL_CL2_CDS
col2NotListed	col2_not_listed	PS_CCTC_APPL_STG	CCTC_APPL_CL2_NL
col2Name	col2_name	PS_CCTC_APPL_STG	CCTC_APPL_CL2_NAME
col2City	col2_city	PS_CCTC_APPL_STG	CCTC_APPL_CL2_CITY
col2State	col2_state	PS_CCTC_APPL_STG	CCTC_APPL_CL2_STTE
col2Country	col2_country	PS_CCTC_APPL_STG	CCTC_APPL_CL2_CTRY
col2StartDate	col2_start_date	PS_CCTC_APPL_STG	CCTC_APPL_CL2_STRT
col2EndDate	col2_end_date	PS_CCTC_APPL_STG	CCTC_APPL_CL2_END
col2DegreeDate	col2_degree_date	PS_CCTC_APPL_STG	CCTC_APPL_CL2_DGDT
col2DegreeObtained	col2_degree_obtained	PS_CCTC_APPL_STG	CCTC_APPL_CL2_DGRE
col3Ceeb	col3_ceeb	PS_CCTC_APPL_STG	CCTC_APPL_CL3_CEEB
col3Cds	col3_cds	PS_CCTC_APPL_STG	CCTC_APPL_CL3_CDS
col3NotListed	col3_not_listed	PS_CCTC_APPL_STG	CCTC_APPL_CL3_NL
col3Name	col3_name	PS_CCTC_APPL_STG	CCTC_APPL_CL3_NAME
col3City	col3_city	PS_CCTC_APPL_STG	CCTC_APPL_CL3_CITY
col3State	col3_state	PS_CCTC_APPL_STG	CCTC_APPL_CL3_STTE
col3Country	col3_country	PS_CCTC_APPL_STG	CCTC_APPL_CL3_CTRY
col3StartDate	col3_start_date	PS_CCTC_APPL_STG	CCTC_APPL_CL3_STRT
col3EndDate	col3_end_date	PS_CCTC_APPL_STG	CCTC_APPL_CL3_END
col3DegreeDate	col3_degree_date	PS_CCTC_APPL_STG	CCTC_APPL_CL3_DGDT
col3DegreeObtained	col3_degree_obtained	PS_CCTC_APPL_STG	CCTC_APPL_CL3_DGRE
col4Ceeb	col4_ceeb	PS_CCTC_APPL_STG	CCTC_APPL_CL4_CEEB
col4Cds	col4_cds	PS_CCTC_APPL_STG	CCTC_APPL_CL4_CDS
col4NotListed	col4_not_listed	PS_CCTC_APPL_STG	CCTC_APPL_CL4_NL
col4Name	col4_name	PS_CCTC_APPL_STG	CCTC_APPL_CL4_NAME
col4City	col4_city	PS_CCTC_APPL_STG	CCTC_APPL_CL4_CITY
col4State	col4_state	PS_CCTC_APPL_STG	CCTC_APPL_CL4_STTE
col4Country	col4_country	PS_CCTC_APPL_STG	CCTC_APPL_CL4_CTRY
col4StartDate	col4_start_date	PS_CCTC_APPL_STG	CCTC_APPL_CL4_STRT
col4EndDate	col4_end_date	PS_CCTC_APPL_STG	CCTC_APPL_CL4_END
col4DegreeDate	col4_degree_date	PS_CCTC_APPL_STG	CCTC_APPL_CL4_DGDT
col4DegreeObtained	col4_degree_obtained	PS_CCTC_APPL_STG	CCTC_APPL_CL4_DGRE
collegeName	college_name	PS_CCTC_APPL_STG	CCTC_APPL_COL_NM
districtName	district_name	PS_CCTC_APPL_STG	CCTC_APPL_DIS_NM
termCode	term_code	PS_CCTC_APPL_STG	CCTC_TERM_CD
termDescription	term_description	PS_CCTC_APPL_STG	CCTC_TERM_DS
majorCode	major_code	PS_CCTC_APPL_STG	CCTC_APPL_MJR_CD
majorDescription	major_description	PS_CCTC_APPL_STG	CCTC_APPL_MJR_DS
tstmpSubmit	tstmp_submit	PS_CCTC_APPL_STG	CCTC_APPL_SBMT_TS
tstmpCreate	tstmp_create	PS_CCTC_APPL_STG	CCTC_APPL_CRTE_TS
tstmpUpdate	tstmp_update	PS_CCTC_APPL_STG	CCTC_APPL_UPDT_TS
ssnDisplay	ssn_display	PS_CCTC_APPL_STG	CCTC_APPL_SSNDSPLY
fosterYouthStatus	foster_youth_status	PS_CCTC_APPL_STG	CCTC_APPL_FSTRY_ST
fosterYouthPreference	foster_youth_preference	PS_CCTC_APPL_STG	CCTC_APPL_FSTRY_PF
fosterYouthMis	foster_youth_mis	PS_CCTC_APPL_STG	CCTC_APPL_FSTRY_MS
fosterYouthPriority	foster_youth_priority	PS_CCTC_APPL_STG	CCTC_APPL_FSTRY_PR
tstmpDownload	tstmp_download	PS_CCTC_APPL_STG	CCTC_APPL_DWNLD_TS
addressValidation	address_validation	PS_CCTC_APPL_STG	CCTC_MADDR_VALID
addressValidationOverride	addressValidationOverride	PS_CCTC_APPL_STG	CCTC_MADDR_VOVR
addressValidationOverrideTimestamp	addressValidationOverrideTimestamp	PS_CCTC_APPL_STG	CCTC_MADDR_VOVR_TS
zip4	zip4	PS_CCTC_APPL_STG	CCTC_MADDR_ZIP4
permAddressValidation	perm_address_validation	PS_CCTC_APPL_STG	CCTC_PADDR_VALID
permZip4	perm_zip4	PS_CCTC_APPL_STG	CCTC_PADDR_ZIP4
dischargeType	discharge_type	PS_CCTC_APPL_STG	CCTC_APPL_MIL_DCTP
collegeExpelledSummary	college_expelled_summary	PS_CCTC_APPL_STG	CCTC_APPL_COL_EXP
col1ExpelledStatus	col1_expelled_status	PS_CCTC_APPL_STG	CCTC_APPL_CL1_EXP
col2ExpelledStatus	col2_expelled_status	PS_CCTC_APPL_STG	CCTC_APPL_CL2_EXP
col3ExpelledStatus	col3_expelled_status	PS_CCTC_APPL_STG	CCTC_APPL_CL3_EXP
col4ExpelledStatus	col4_expelled_status	PS_CCTC_APPL_STG	CCTC_APPL_CL4_EXP
integrityFlags	integrity_flags	PS_CCTC_APPL_STG	CCTC_APPL_IFLAGS
rdd	rdd	PS_CCTC_APPL_STG	CCTC_APPL_RDD
ssnType	ssn_type	PS_CCTC_APPL_STG	CCTC_APPL_SSN_TYPE
militaryStationedCaEd	military_stationed_ca_ed	PS_CCTC_APPL_STG	CCTC_APPL_MIL_CAED
integrityFg65	integrity_fg_65	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_65
integrityFg64	integrity_fg_64	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_64
ipAddress	ip_address	PS_CCTC_APPL_STG	CCTC_IP_ADDRESS
campaign1	campaign1	PS_CCTC_APPL_STG	CCTC_APPL_CAMPGN1
campaign2	campaign2	PS_CCTC_APPL_STG	CCTC_APPL_CAMPGN2
campaign3	campaign3	PS_CCTC_APPL_STG	CCTC_APPL_CAMPGN3
orientation	orientation	PS_CCTC_APPL_STG	CCTC_APPL_SXORIENT
transgender	transgender	PS_CCTC_APPL_STG	CCTC_APPL_TRNGNDR
ssnException	ssn_exception	PS_CCTC_APPL_STG	CCTC_APPL_SSN_EXCP
integrityFg71	integrity_fg_71	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_71
preferredFirstname	preferred_firstname	PS_CCTC_APPL_STG	CCTC_PRF_FIRST_NM
preferredMiddlename	preferred_middlename	PS_CCTC_APPL_STG	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

CCCApply Public Documentation

CCCApply Standard SuperGlue Data Mappings - PeopleSoft

On This Page:

Standard Data Fields Table Mapping - PeopleSoft

CCCApply Supplemental Questions Data Fields Mappings - PeopleSoft