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

CCCApply Standard SuperGlue Data Mappings - PeopleSoft

Contents

Standard Data Fields Table Mapping - PeopleSoft

CCCApply Supplemental Questions Data Fields Mappings - PeopleSoft