CCCApply Standard SuperGlue Data Mappings - PeopleSoft

CCCApply/PeopleSoft Main Table Mapping

College Adaptor Payload Name	CCC Field Name	PeopleSoft DB Staging Table	PeopleSoft Field Name	Explanation
appId	app_id	PS_CCTC_APPL_STG	CCTC_APPL_ID	See here
cccId	ccc_id	PS_CCTC_APPL_STG	CCTC_CCCID	See here
status	status	PS_CCTC_APPL_STG	CCTC_APPL_STATUS	See 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_ID	See here
intendedMajor	intended_major	PS_CCTC_APPL_STG	CCTC_MAJOR_NAME	See here
eduGoal	edu_goal	PS_CCTC_APPL_STG	CCTC_EDU_GOAL	See here
highestEduLevel	highest_edu_level	PS_CCTC_APPL_STG	CCTC_HIGHEST_EDU	See here
consentIndicator	consent_indicator	PS_CCTC_APPL_STG	CCTC_INFO_CONSENT	See here
appLang	app_lang	PS_CCTC_APPL_STG	CCTC_APPL_LANG_CD	See 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_FA	See 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_CD	See here
lastPage	last_page	PS_CCTC_APPL_STG	CCTC_APPL_LAST_PG	See here
streetaddress1	streetaddress1	PS_CCTC_APPL_STG	CCTC_MADDR_LINE1	See here
streetaddress2	streetaddress2	PS_CCTC_APPL_STG	CCTC_MADDR_LINE2	See here
city	city	PS_CCTC_APPL_STG	CCTC_MADDR_CITY	See 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_COUNTRY	See here
nonUsAddress	non_us_address	PS_CCTC_APPL_STG	CCTC_MADDR_USA	See here
email	email	PS_CCTC_APPL_STG	CCTC_EMAIL	See here
emailVerified	email_verified	PS_CCTC_APPL_STG	CCTC_EMAIL_VER	See here
emailVerifiedTimestamp	email_verified_timestamp	PS_CCTC_APPL_STG	CCTC_EMAIL_VER_TS	See here
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_CITY	See here
permPostalcode	perm_postalcode	PS_CCTC_APPL_STG	CCTC_PADDR_POSTCD	See here
permState	perm_state	PS_CCTC_APPL_STG	CCTC_PADDR_STATE	See here
permNonusaprovince	perm_nonusaprovince	PS_CCTC_APPL_STG	CCTC_PADDR_PRVINCE	See here
permCountry	perm_country	PS_CCTC_APPL_STG	CCTC_PADDR_COUNTRY	See here
addressSame	address_same	PS_CCTC_APPL_STG	CCTC_PERM_EQ_MAIL	See here
mainphone	mainphone	PS_CCTC_APPL_STG	CCTC_PHONE_MAIN	See here
mainphoneExt	mainphone_ext	PS_CCTC_APPL_STG	CCTC_PHONE_MAIN_EX	See here
mainphoneAuthText	mainphone_auth_text	PS_CCTC_APPL_STG	CCTC_PHONE_MAINSMS	See here
mainphoneVerified	mainphone_verified	PS_CCTC_APPL_STG	CCTC_PHONE_MN_VER	See here
mainphoneVerifiedTimestamp	mainphone_verified_timestamp	PS_CCTC_APPL_STG	CCTC_PHONE_MN_VRTS	See here
secondphone	secondphone	PS_CCTC_APPL_STG	CCTC_PHONE_SCND	See here
secondphoneExt	secondphone_ext	PS_CCTC_APPL_STG	CCTC_PHONE_SCND_EX	See here
secondphoneAuthText	secondphone_auth_text	PS_CCTC_APPL_STG	CCTC_PHONE_SCNDSMS	See here
preferredMethodOfContact	preferred_method_of_contact	PS_CCTC_APPL_STG	CCTC_PRF_CNCT_MTHD	See 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_HREDULVL	See here
higherCompDate	higher_comp_date	PS_CCTC_APPL_STG	CCTC_APPL_HRCOMPDT	See 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_CA	See here
cahs3year	cahs_3year	PS_CCTC_APPL_STG	CCTC_APPL_HS_CA3YR	See here
hsName	hs_name	PS_CCTC_APPL_STG	CCTC_APPL_HS_NAME	See here
hsCity	hs_city	PS_CCTC_APPL_STG	CCTC_APPL_HS_CITY	See here
hsState	hs_state	PS_CCTC_APPL_STG	CCTC_APPL_HS_STATE	See here
hsCountry	hs_country	PS_CCTC_APPL_STG	CCTC_APPL_HS_CNTRY	See here
hsCds	hs_cds	PS_CCTC_APPL_STG	CCTC_APPL_HS_CDS	See here
hsCeeb	hs_ceeb	PS_CCTC_APPL_STG	CCTC_APPL_HS_CEEB	See here
hsNotListed	hs_not_listed	PS_CCTC_APPL_STG	CCTC_APPL_HS_NL	See here
homeSchooled	home_schooled	PS_CCTC_APPL_STG	CCTC_APPL_HOME_EDU	See 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_NM	See 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_LVL	See 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_MIS	See here
under19Ind	under19_ind	PS_CCTC_APPL_STG	CCTC_APPL_UNDER19	See 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_GROUP	See here
raceEthnicFull	race_ethnic_full	PS_CCTC_APPL_STG	CCTC_RACE_ETHNIC_F	See here
ssn	ssn	PS_CCTC_APPL_STG	CCTC_SSN	See here
birthdate	birthdate	PS_CCTC_APPL_STG	CCTC_BIRTHDATE	See here
firstname	firstname	PS_CCTC_APPL_STG	CCTC_LGL_FIRST_NM	See here
middlename	middlename	PS_CCTC_APPL_STG	CCTC_LGL_MIDDLE_NM	See here
lastname	lastname	PS_CCTC_APPL_STG	CCTC_LGL_LAST_NM	See here
suffix	suffix	PS_CCTC_APPL_STG	CCTC_LGL_SUFFIX	See here
otherfirstname	otherfirstname	PS_CCTC_APPL_STG	CCTC_AKA_FIRST_NM	See here
othermiddlename	othermiddlename	PS_CCTC_APPL_STG	CCTC_AKA_MIDDLE_NM	See here
otherlastname	otherlastname	PS_CCTC_APPL_STG	CCTC_AKA_LAST_NM	See here
citizenshipStatus	citizenship_status	PS_CCTC_APPL_STG	CCTC_CITIZENSHIP	See here
alienRegNumber	alien_reg_number	PS_CCTC_APPL_STG	CCTC_ALIEN_REG_NBR	See 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_EXP	See 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_HMST	See 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_CA	See here
militaryLegalResidence	military_legal_residence	PS_CCTC_APPL_STG	CCTC_APPL_MIL_LGLR	See 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_E	See here
caSchoolEmployee	ca_school_employee	PS_CCTC_APPL_STG	CCTC_APPL_CA_SCH_E	See 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_FOSTR	See 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_TXYR	See here
caOutsideVoted	ca_outside_voted	PS_CCTC_APPL_STG	CCTC_APPL_CA_OOSVT	See 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_OOSED	See 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_OOSLS	See here
caOutsideLawsuitYear	ca_outside_lawsuit_year	PS_CCTC_APPL_STG	CCTC_APPL_CA_LSYR	See here
resStatus	res_status	PS_CCTC_APPL_STG	CCTC_APPL_RESI_STS	See 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_A	See 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_D	See here
experience	experience	PS_CCTC_APPL_STG	CCTC_APPL_EXPERNCE	See here
recommend	recommend	PS_CCTC_APPL_STG	CCTC_APPL_RECMMEND	See here
comments	comments	PS_CCTC_APPL_STG	CCTC_APPL_COMMENTS	See 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_FOSTERS	See here
athleticIntercollegiate	athletic_intercollegiate	PS_CCTC_APPL_STG	CCTC_APPL_INT_ATHL	See 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_SPRT	See here
academicCounseling	academic_counseling	PS_CCTC_APPL_STG	CCTC_APPL_INT_ACAD	See here
basicSkills	basic_skills	PS_CCTC_APPL_STG	CCTC_APPL_INT_BASC	See here
calworks	calworks	PS_CCTC_APPL_STG	CCTC_APPL_INT_CLWK	See here
careerPlanning	career_planning	PS_CCTC_APPL_STG	CCTC_APPL_INT_CPLN	See here
childCare	child_care	PS_CCTC_APPL_STG	CCTC_APPL_INT_CHLD	See here
counselingPersonal	counseling_personal	PS_CCTC_APPL_STG	CCTC_APPL_INT_CNSL	See here
dsps	dsps	PS_CCTC_APPL_STG	CCTC_APPL_INT_DSPS	See here
eops	eops	PS_CCTC_APPL_STG	CCTC_APPL_INT_EOPS	See here
esl	esl	PS_CCTC_APPL_STG	CCTC_APPL_INT_ESL	See 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_RTRY	See 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_TEST	See here
transferInfo	transfer_info	PS_CCTC_APPL_STG	CCTC_APPL_INT_TRSF	See here
tutoringServices	tutoring_services	PS_CCTC_APPL_STG	CCTC_APPL_INT_TUTR	See here
veteransServices	veterans_services	PS_CCTC_APPL_STG	CCTC_APPL_INT_VA	See 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_04	See here
integrityFg11	integrity_fg_11	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_11	See 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_48	See 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_50	See here
integrityFg51	integrity_fg_51	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_51	See 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_53	See 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_55	See here
integrityFg56	integrity_fg_56	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_56	See here
integrityFg57	integrity_fg_57	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_57	See 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_62	See 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_80	See here
col1Ceeb	col1_ceeb	PS_CCTC_APPL_STG	CCTC_APPL_CL1_CEEB	See here
col1Cds	col1_cds	PS_CCTC_APPL_STG	CCTC_APPL_CL1_CDS	See here
col1NotListed	col1_not_listed	PS_CCTC_APPL_STG	CCTC_APPL_CL1_NL	See 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_CTRY	See here
col1StartDate	col1_start_date	PS_CCTC_APPL_STG	CCTC_APPL_CL1_STRT	See 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_DGDT	See 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_CEEB	See here
col2Cds	col2_cds	PS_CCTC_APPL_STG	CCTC_APPL_CL2_CDS	See 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_NAME	See here
col2City	col2_city	PS_CCTC_APPL_STG	CCTC_APPL_CL2_CITY	See here
col2State	col2_state	PS_CCTC_APPL_STG	CCTC_APPL_CL2_STTE	See here
col2Country	col2_country	PS_CCTC_APPL_STG	CCTC_APPL_CL2_CTRY	See here
col2StartDate	col2_start_date	PS_CCTC_APPL_STG	CCTC_APPL_CL2_STRT	See 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_CEEB	See 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_NAME	See here
col3City	col3_city	PS_CCTC_APPL_STG	CCTC_APPL_CL3_CITY	See here
col3State	col3_state	PS_CCTC_APPL_STG	CCTC_APPL_CL3_STTE	See 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_STRT	See 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_DGRE	See here
col4Ceeb	col4_ceeb	PS_CCTC_APPL_STG	CCTC_APPL_CL4_CEEB	See here
col4Cds	col4_cds	PS_CCTC_APPL_STG	CCTC_APPL_CL4_CDS	See here
col4NotListed	col4_not_listed	PS_CCTC_APPL_STG	CCTC_APPL_CL4_NL	See here
col4Name	col4_name	PS_CCTC_APPL_STG	CCTC_APPL_CL4_NAME	See here
col4City	col4_city	PS_CCTC_APPL_STG	CCTC_APPL_CL4_CITY	See here
col4State	col4_state	PS_CCTC_APPL_STG	CCTC_APPL_CL4_STTE	See here
col4Country	col4_country	PS_CCTC_APPL_STG	CCTC_APPL_CL4_CTRY	See here
col4StartDate	col4_start_date	PS_CCTC_APPL_STG	CCTC_APPL_CL4_STRT	See 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_DGDT	See 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_NM	See here
districtName	district_name	PS_CCTC_APPL_STG	CCTC_APPL_DIS_NM	See 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_DS	See 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_TS	See here
ssnDisplay	ssn_display	PS_CCTC_APPL_STG	CCTC_APPL_SSNDSPLY	See here
fosterYouthStatus	foster_youth_status	PS_CCTC_APPL_STG	CCTC_APPL_FSTRY_ST	See 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_MS	See 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 here
addressValidationOverride	address_validation_override	PS_CCTC_APPL_STG	CCTC_MADDR_VOVR	See here
addressValidationOverrideTimestamp	address_validation_override_timestamp	PS_CCTC_APPL_STG	CCTC_MADDR_VOVR_TS	See here
zip4	zip4	PS_CCTC_APPL_STG	CCTC_MADDR_ZIP4	See here
permAddressValidation	perm_address_validation	PS_CCTC_APPL_STG	CCTC_PADDR_VALID	See here
permZip4	perm_zip4	PS_CCTC_APPL_STG	CCTC_PADDR_ZIP4	See 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_EXP	See here
col1ExpelledStatus	col1_expelled_status	PS_CCTC_APPL_STG	CCTC_APPL_CL1_EXP	See 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_IFLAGS	See 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_65	See here
integrityFg64	integrity_fg_64	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_64	See here
ipAddress	ip_address	PS_CCTC_APPL_STG	CCTC_IP_ADDRESS	See here
campaign1	campaign1	PS_CCTC_APPL_STG	CCTC_APPL_CAMPGN1	See 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_SXORIENT	See here
transgender	transgender	PS_CCTC_APPL_STG	CCTC_APPL_TRNGNDR	See here
ssnException	ssn_exception	PS_CCTC_APPL_STG	CCTC_APPL_SSN_EXCP	See 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_NM	See here
preferredMiddlename	preferred_middlename	PS_CCTC_APPL_STG	CCTC_PRF_MIDDLE_NM	See here
preferredLastname	preferred_lastname	PS_CCTC_APPL_STG	CCTC_PRF_LAST_NM	See here
preferredName	preferred_name	PS_CCTC_APPL_STG	CCTC_PRF_NM_SET	See here
ssnNo	ssn_no	PS_CCTC_APPL_STG	CCTC_APPL_SSN_NONE	See 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_GPA	See here
highestEnglishCourse	highest_english_course	PS_CCTC_APPL_STG	CCTC_APPL_ENG_HCC	See 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_HCP	See 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_FCDS	See here
col2CdsFull	col2_cds_full	PS_CCTC_APPL_STG	CCTC_APPL_CL2_FCDS	See 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_FCDS	See 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_HOMELSS	See here
termStart	term_start	PS_CCTC_APPL_STG	CCTC_TERM_START_DT	See here
termEnd	term_end	PS_CCTC_APPL_STG	CCTC_TERM_END_DT	See 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_40	See here
cipCode	cip_code	PS_CCTC_APPL_STG	CCTC_APPL_MJR_CIP	See here
majorCategory	major_category	PS_CCTC_APPL_STG	CCTC_APPL_MJR_CAT	See here
mainphoneintl	mainphoneintl	PS_CCTC_APPL_STG	CCTC_PHONE_MAININT	See here
secondphoneintl	secondphoneintl	PS_CCTC_APPL_STG	CCTC_PHONE_SCNDINT	See here
nonCredit	non_credit	PS_CCTC_APPL_STG	CCTC_APPL_NOCREDIT	See here
integrityFg81	integrity_fg_81	PS_CCTC_APPL_STG	CCTC_APPL_IFLAG_81	See here
highestGradeCompleted	highest_grade_completed	PS_CCTC_APPL_STG	CCTC_APPL_HGC	See 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

CCCApply Supplemental Questions Data Fields Mappings - PeopleSoft

College Adaptor Payload Name	CCC Field Name	PeopleSoft DB Staging Table	PeopleSoft Field Name	Explanation
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