...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Info |
---|
The tables below pertain to the CCCApply Standard & Noncredit Applications. |
On This Page:
Table of Contents | ||||
---|---|---|---|---|
|
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 |
---|---|---|---|---|
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 |
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 |