CCCApply Standard SuperGlue Data Mappings - PeopleSoft
The tables below pertain to the CCCApply Standard & Noncredit Applications.
On This Page:
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 |