Applicant table
- Jordan Lamb
Each record holds the data entered on a student application. Some data is “looked-up” by the Banner system when the application is processed and placed in this table. If SZRCCAP_TERM_CODE is a combined Summer and Fall application, an application record is created in the Data Warehouse table for the Summer and Fall terms.
This table holds records for applications entered via CCCApply and manually entered into Banner. The paper application does not have as many questions/fields as the CCCApply application, so some fields in this table will not be populated for a paper application. Also, some paper application questions are not entered into Banner (such as MILI_%, CA_RES_2_YEARS).
CCCApply has their Data Dictionaries that describes valid codes for their system.
Oracle source: REPORTSNET.Applicant_CCCApply view (from Banner’s SZRCCAP table)
REPORTSNET.Applicant_PaperApps view (from Banner’s SARADAP where application doesn’t exist in SZRCCAP)
Oracle objects: SARADAP, SPRIDEN, SPBPERS, SPRADDR, SPRTELE, SORHSCH, SOBSBGI, GORVISA
Updated: nightly (All terms >= 200800 loaded into temp table; all <> 200800 loaded into Applicant; left-overs loaded into Applicant with term of 200730 and again with term 200810)
DW Field | Oracle Field/Calculation | Description (Sample) |
|---|---|---|
TERM |
| |
SEQNO |
| Unique number for the application. In the case of term 200800 where 2 records are created, both records have the same SEQNO |
PIDM |
| |
STUDENTID |
| |
CAMPUS_CODE |
|
|
FIRST_PASS_IND |
| Processing flag |
DUPE_OK |
| Processing flag |
CCCAPPLY_LOADED |
| When record was downloaded from CCCApply |
BANNER_UPDATED |
| When processing completed |
MAJR_CODE_1 |
Saturn.STVMAJR.STVMAJR_CODE | Unique code for MAJOR |
EGOL_CODE |
| |
LASTNAME |
| |
NAME_SUFFIX |
|
|
FIRSTNAME |
| |
NO_FIRST_IND |
| Indicator of no first name: 1 or null |
MIDINIT |
| |
OTHER_LAST_NAME |
|
|
OTHER_FIRST_NAME |
|
|
SSN_SOURCE |
| SSN as entered |
SSN |
| |
NO_SSN_IND |
| Applicant has no social security number or taxpayer identification number or declines to provide it at time of application. |
BIRTHDATE |
| |
SEX_SOURCE |
|
|
SEX |
|
|
ETHN_CODE_SOURCE |
| Ethnicity code as entered (no longer used) |
ETHN_CODE |
| See Ethnicity code in Appendix (no longer used)
|
STREET_LINE1_MA |
| Mailing address (all MA fields) |
CITY_MA |
|
|
STAT_CODE_MA |
| State code (see Appendix) |
ZIP_MA |
|
|
NATN_CODE_MA |
| 2 letter nation code. See STVNATN table in Banner |
INTL_CODE_MA |
| Not in use |
PARENT_LAST |
|
|
PARENT_FIRST |
|
|
RELT_CODE |
| Relationship to Parent: A: An Ex-spouse B: Brother C: Child D: Doctor E: Employer F: Father G: Grandparent M: Mother N: Neighbor O: Relative P: Spouse R: Friend S: Sister U: Guardian W: Domestic Partner X: Significant Other |
PR_SAME_AS_MA |
| Primary address same as Mailing address |
STREET_LINE1_PR |
| Primary address info (all PR fields) |
CITY_PR |
|
|
STAT_CODE_PR |
| State code (see Appendix) |
ZIP_PR |
|
|
NATN_CODE_PR |
| 2 letter nation code. See STVNATN table in Banner |
INTL_CODE_PR |
| Not in use |
PHONE_SOURCE |
| Phone as entered |
PHONE_AREA |
|
|
PHONE_NUMBER |
|
|
PHONE_EXT |
|
|
EMAIL_ADDRESS |
|
|
STYP_CODE_SOURCE |
| Student Type Code as entered. |
STYP_CODE |
| See Student Type Code in Appendix. |
EDLV_CODE_SOURCE |
| Educational Level as entered |
EDLV_YEAR |
| Year Educational Level achieved |
EDLV_CODE |
| See Educational Level in Appendix |
NAME_HSCH |
| Name of High School |
NO_HSCH_ATTEND |
| No high School attended: 1 or null |
CITY_HSCH |
|
|
STAT_CODE_HSCH |
| State code (see Appendix) |
NATN_CODE_HSCH |
| 2 letter nation code. See STVNATN table in Banner |
SBGI_CODE_HSCH |
| Source Background Institution Code for High School. See STVSBGI table in Banner. |
CEEB_CODE_HSCH |
| College Entrance Examination Board code |
NAME_COLL_1 |
| Name of previous college attended |
CITY_COLL_1 |
|
|
STAT_CODE_COLL_1 |
| State code (see Appendix) |
NATN_CODE_COLL_1 |
| 2 letter nation code. See STVNATN table in Banner |
SBGI_CODE_COLL_1 |
| Source Background Institution Code for High School. See STVSBGI table in Banner. |
CEEB_CODE_COLL_1 |
| College Entrance Examination Board code (not in use) |
FROM_DATE_COLL_1 |
|
|
TO_DATE_COLL_1 |
|
|
NAME_COLL_2 |
|
|
CITY_COLL_2 |
|
|
STAT_CODE_COLL_2 |
| State code (see Appendix) |
NATN_CODE_COLL_2 |
| 2 letter nation code. See STVNATN table in Banner |
SBGI_CODE_COLL_2 |
| Source Background Institution Code for High School. See STVSBGI table in Banner. |
CEEB_CODE_COLL_2 |
| College Entrance Examination Board code |
FROM_DATE_COLL_2 |
|
|
TO_DATE_COLL_2 |
|
|
NAME_COLL_3 |
|
|
CITY_COLL_3 |
|
|
STAT_CODE_COLL_3 Not populated for a paper application. |
| State code (see Appendix) |
NATN_CODE_COLL_3 |
| 2 letter nation code. See STVNATN table in Banner |
SBGI_CODE_COLL_3 |
| Source Background Institution Code for High School. See STVSBGI table in Banner. |
CEEB_CODE_COLL_3 |
| College Entrance Examination Board code (not in use) |
FROM_DATE_COLL_3 |
|
|
TO_DATE_COLL_3 |
|
|
NAME_COLL_4 |
|
|
CITY_COLL_4 |
|
|
STAT_CODE_COLL_4 |
| State code (see Appendix) |
NATN_CODE_COLL_4 |
| 2 letter nation code. See STVNATN table in Banner |
SBGI_CODE_COLL_4 |
| Source Background Institution Code for High School. See STVSBGI table in Banner. |
CEEB_CODE_COLL_4 |
| College Entrance Examination Board code |
FROM_DATE_COLL_4 |
|
|
TO_DATE_COLL_4 |
|
|
MORE_COLL_IND |
| Attended more than 4 other colleges: 1 or null |
INELIG_IND |
| ? 0, 1, 2 or null |
CITZ_CODE |
| See Citizen Code in Appendix |
VISA_NUMBER |
|
|
VTYP_CODE_SOURCE |
| VISA type code as entered |
VTYP_CODE_CURRENT |
| see VISA type code in Appendix |
VISA_ISSUE_DATE |
|
|
VISA_EXPIRE_DATE |
|
|
VISA_NO_EXP_DATE |
| 1 or null |
MILI_STATUS |
| Refer to COS_GEN.STVMILI_STATUShttps://sequoias.atlassian.net/browse/AP-186 |
MILI_HOME_RECORD |
|
|
MILI_HOME_NATN |
|
|
MILI_IN_CA |
|
|
MILI_IN_CA_ED |
|
|
OVER_19_OR_MARR |
| Age 19 or married: 0, 1, null |
CA_RES_2_YEARS |
| California resident for 2 or more years: 0, 1, null |
CA_RES_DATE |
|
|
NOT_CA_RES |
| 1 or null |
INTEND_PR_CA_RES |
| 0, 1, null |
CCC_EMP_DEPEND |
| Dependent of California Community College employee: 0, 1, null |
PUB_SCH_CRED_EMP |
| Public School Credential Employee: 0, 1, null |
SEAS_AGR_EMP_DEP |
| Seasonal Agricultural Employee Dependent: 0, 1, null |
CA_NONRES_TAX |
| 0, 1, null |
REG_VOTE_NON_CA |
| 0, 1, null |
RES_STD_NON_CA |
| 0, 1, null |
LAWSUIT_NON_CA |
| 0, 1, null |
RESD_CODE_SOURCE |
| Residency code as entered |
RESD_CODE |
| See Residency code in Appendix |
RESD_STAT_CHANGE |
| Residency Status Change: Null |
PREV_RESD_DATE |
| Previous Residency Date: Null |
LANG_CODE_SOURCE |
| Language code as entered |
LANG_CODE |
| Language code: E: English N: NOT English X: Unknown |
FIN_AID_INFO |
| Null, 1 |
TANF_SSI_GENASST |
| Welfare flag: Null, 1 |
INT_ACAD_COUNS |
| Interested in academic counseling: Null, 1 |
INT_ATHLETICS |
| Null, 1 |
INT_BASIC_SKILLS |
| Null, 1 |
INT_CALWORKS |
| Null, 1 |
INT_CAREER_PLNG |
| Null, 1 |
INT_CHILD_CARE |
| Null, 1 |
INT_COUNS_PERS |
| Null, 1 |
INT_DSPS |
| Disable Student Services: Null, 1 |
INT_EOPS |
| Null, 1 |
INT_ESL |
| Null, 1 |
INT_HEALTH_SVCS |
| Null, 1 |
INT_HOUSING |
| Null, 1 |
INT_JOB_PLCMNT |
| Null, 1 |
INT_ONLINE_CLS |
| Null, 1 |
INT_RE_ENTRY |
| Null, 1 |
INT_SCHOLARSHIPS |
| Null, 1 |
INT_STUDENT_GOVT |
| Null, 1 |
INT_TESTING |
| Null, 1 |
INT_TRANSFER |
| Null, 1 |
INT_TUTORING |
| Null, 1 |
INT_VET_SVCS |
| Veteran Services: Null, 1 |
FIN_AID_REFER |
| Financial aid referral: Null, 1 |
CONSENT_IND |
| Null, 0 ,1 |
CITZ_RESD_OVER |
| Citizen Residence Override (processing flag): Null, Y, N |
MORE_DATA_IND |
| More data indicator: N, Y, null |
MORE_EMAIL_SENT |
| Y, null |
PROC_EMAIL_SENT |
| Old flag: not used |
REVIEW_IND |
| N, Y |
ERR_SPRIDEN |
| Errors / Statuses in processing. Codes come from GTVSDAX. |
ERR_SPBPERS |
|
|
ERR_SPRADDR_MA |
|
|
ERR_SPRADDR_PR |
|
|
ERR_SPRTELE |
|
|
ERR_SPRINTL |
|
|
ERR_SORFOLK |
|
|
ERR_SARADAP |
|
|
ERR_SGBSTDN |
|
|
ERR_SORHSCH |
|
|
ERR_SORPCOL_1 |
|
|
ERR_SORPCOL_2 |
|
|
ERR_SORPCOL_3 |
|
|
ERR_SORPCOL_4 |
|
|
ERR_GOREMAL |
|
|
ERR_GOBTPAC |
|
|
DISPLACED_HOM |
| Null, 1 |
CALWORKS |
| Null, 1 |
SSI |
| Null, 1 |
GEN_ASSIST |
| Null, 1 |
SINGLE_PARENT |
| Null, 1 |
WORK_AREA_CODE |
|
|
WORK_PHONE |
|
|
WORK_EXT |
|
|
FOREST_SER |
| Null, 0, 1 |
LIVE_FOREST |
| Null, 0, 1 |
FULL_TIME |
| Attending Full-time: Null, 0, 1 |
GRAD_CA_HS |
| Null, 0, 1 |
ATTEND_CA_HS |
| Null, 0, 1 |
HS_GRAD_DATE |
|
|
AB540_ELIG |
| Null, 0, 1 |
MARITAL_STAT |
| I: M: married U: unmarried X: Null |
ORA_ERR_NUM |
| Oracle error |
ORA_ERR_MESG |
| Oracle error |
ORA_ERR_LOC |
| Oracle error |
HS_ED_LEVEL |
|
|
HIGHER_ED_LEVEL |
|
|
HIGHER_ED_DATE |
|
|
PHONE_2_SOURCE |
| Phone number as entered |
PHONE_2_AREA |
|
|
PHONE_2_NUMBER |
|
|
PHONE_2_EXT |
|
|
MA_NON_US_ST |
| Mailing non-U.S. State |
MA_INTL_CODE |
|
|
PR_NON_US_ST |
| Primary non-U.S. State |
PR_INTL_CODE |
|
|
CONFIRM_NUMBER |
| Number given to applicant for applying using CCCApply |
COLL_1_DEGR_TYPE |
| First college degree type: A: Associates Degree (AA or AS) B: Bachelor’s Degree or higher (this includes BA, BS, Masters, Doctorates)C: Certificate |
COLL_1_DEGR_DATE |
| First college degree date |
COLL_2_DEGR_TYPE |
|
|
COLL_2_DEGR_DATE |
|
|
COLL_3_DEGR_TYPE |
|
|
COLL_3_DEGR_DATE |
|
|
COLL_4_DEGR_TYPE |
|
|
COLL_4_DEGR_DATE |
|
|
ENROLL_STATUS |
|
|
INTEGRITY_FLAGS |
| Processing flags that CCCApply uses |
PAPERAPP_FLAG |
| True if this is a paper application, null for a CCCApply application |
APDC_CODE | substr(baninst1.cos_fv_get_apdc_code(szrccap.SZRCCAP_PIDM,
szrccap.SZRCCAP_TERM_CODE),1,2) | Application Decision Code: AA: Applicant Acceptance AR: Application Rejected NM: Non-matriculated QE: Quick Entry |
ETHNICITY | DECODE(szrccap_pidm, 99999999, '', SUBSTR ( f_get_desc_fnc ('STVETCT', (SUBSTR(
f_get_ethn_category(REPORTSNET.f_get_ethnicity(SZRCCAP_PIDM), 'ETCT'), 1, 1)), 30), 1, 30) )
| Ethnicity description (old) 40 character description of SPBPERS_ETHN_CODE coming from STVETCT_DESC |
NEW_ETHNICITY | SUBSTR(REPORTSNET.f_get_new_ethnicity_desc(
SZRCCAP_PIDM),1, 20)References | Ethnicity description using new values established in 2009. ‘Hispanic or Latino’, ‘Not Hispanic or Latino’, or ‘None’ |
RACES |
F_get_races takes in the PIDM and searches both GORPRAC and GORRACE and returns the race codes inside of those tables for the PIDM. | 20 possible race codes, each separated by a pipe (|). Each code is up to 2 characters in length, with a period (.) being used as the 2nd character when the code has only one character (like W. for White) |
RACES_DESC |
f_get_races_desc takes in the PIDM returns the race description found in GORPRAC and GORRACE | Descriptions of the codes in the RACES field. Again, separated by a pipe. |
CALC_RACE_ETHN | An ethnicity derived from Ethnicity, New Ethnicity, Visa Type, and Race information of the student. This is a calculation provided by Tim Garner and Ryan Barry-Souza of the Research department. | |
CALC_RACE_ETHN_CDE |
| The Result of the above logic. The first letter of the result. Existing values: NULL 2 A B H N P W X |