...
COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | Notes_Logic | Meta Mart Description |
TERMID | varchar | 8 | DWHOUSE | APPLICANTS_ADMITS_vw | rept_time_Frame | Academic term (YYYYMM) to which the reported data applies. | |
BENCH | varchar | 1 | Run-time parameter | N/A | @BENCH' (B, F, D, E) | Entered / passed through at run-time in ETL | |
UID | varchar | 9 | DWHOUSE | APPLICANTS_ADMITS_vw | USF_ID | IF NULL then LEFT(U_RESV_1,9) | This field holds the OASIS U-ID. |
CIP_APP_ADM | varchar | 6 | DWHOUSE | APPLICANTS_ADMITS_vw | CIP_APP_ADM | 01242 - Admissions Application Program Category (ADM) and 01062 - Student Program Category (TEF,LAP) | |
STU_TYP | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | STU_TYP | 01117 - Type of Student at Time of Application (ADM), 01413 - Type of Student at Time of Most Recent Admission (TEF) and 01142 - Limited Access Category (LAP) | |
APP_ADM_SOURCE | varchar | 8 | DWHOUSE | APPLICANTS_ADMITS_vw | APP_ADM_SOURCE | Source of the application/admission information contained in the current record: ADM, LAP, IEP | |
DEMO_TIME_FRAME | varchar | 8 | DWHOUSE | APPLICANTS_ADMITS_vw | rept_time_Frame | Academic term (YYYYMM) to which the reported data applies. | |
DEMO_DATA_SOURCE | varchar | 8 | Literal | Via Query | ADM' | via PROCEDURE Proc_DataLoad_SID | |
GENDER | varchar | 1 | DWHOUSE | Person_Demo_VW | gender | IF NULL, set to 'X' | 01048 - Gender |
ETHNICITY | varchar | 1 | DWHOUSE | Person_Demo_VW | race_ethnicity | IF NULL, set to 'X' | 01044 - Racial/Ethnic Group |
CAMPUS_H | varchar | 4 | DWHOUSE | APPLICANTS_ADMITS_vw | campus_cd_admin or CAMPUS or '0001' (default) | IF CAMPUS_H NULL 02050 - Campus code responsible for student's registration. use CAMPUS from FUC_SIDDecode | |
COLLEGE | varchar | 2 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'RX' or U_RESV_2 | As per STU_TYP | ** See STU_TYP for further details ** |
MAJOR | varchar | 5 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'MED', 'PRY', 'MPT' or U_RESV_2 | As per STU_TYP | ** See STY_TYP for further details ** |
FINAL_ADM_ACTION | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | FINAL_ADM_ACTION | 01135 - Final Admission Action (ADM) and 01143 - Limited Access Action (LAP) | |
REGISTERED_CD | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | REGISTERED_CD | 01136 - Registered Code (ADM, LAP) | |
COUNTY_OF_RES | varchar | 4 | DWHOUSE | APPLICANTS_ADMITS_vw | COUNTY_OF_RES | 01055 - County of Residence, SUS | |
FEE_CLASS_RES | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | FEE_CLASS_RES | 01106 - Fee Classification - Residency | |
ADM_DEPOSIT_IND | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | ADM_DEPOSIT_IND | 01151 - Admissions Deposit Indicator | |
STU_CLASS_LEVEL | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | STU_CLASS_LEVEL | 01060 - Student Classification Level | |
DISPLACED_STU_IND | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | DISPLACED_STU_IND | 01809 - Displaced Student Indicator | |
LAST_INST_CD | varchar | 8 | DWHOUSE | APPLICANTS_ADMITS_vw | LAST_INST_CD | 01067 - Last Institution Code | |
INST_GRNT_HIDEG_CD | varchar | 8 | DWHOUSE | APPLICANTS_ADMITS_vw | INST_GRNT_HIDEG_CD | 01411 - Institution Granting Highest Degree (built from old 5-digit code by prefixing one zero and suffixing two zeroes) | |
DEG_HIGHEST_HELD | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | DEG_HIGHEST_HELD | 01112 - Degree - Highest Level Held | |
LAST_POSTSEC_DT | varchar | 6 | DWHOUSE | APPLICANTS_ADMITS_vw | LAST_POSTSEC_DT | 01169 - Date of Last Attendance YYYYMM | |
GPA_COLLEGE | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | GPA_COLLEGE | 01270 - College GPA | ||
HS_ETS_CD | varchar | 6 | DWHOUSE | APPLICANTS_ADMITS_vw | HS_ETS_CD | 01069 - High School Code | |
LAST_SECONDARY_DT | varchar | 6 | DWHOUSE | APPLICANTS_ADMITS_vw | LAST_SECONDARY_DT | 01169 - Date of Last Attendance YYYYMM | |
GPA_HIGH_SCHOOL | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | GPA_HIGH_SCHOOL | 01139 - High School GPA | ||
GPA_GED_COMPONENT | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | GPA_GED_COMPONENT | 01275 - GPA - General Education Component = (IEP) | ||
GPA_BACHELORS | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | GPA_BACHELORS | 01241 - GPA - Completed Bachelors Degree Pgm = (IEP) | ||
ESOL_UNITS | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | ESOL_UNITS | 01438 - English As A Second Language Units | ||
DEPOSIT_AMT | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | DEPOSIT_AMT | 01152 - Admissions Deposit Amount | ||
FLA_PUBLIC_HS_FLG | varchar | 1 | All values are NULL | ||||
HS_PCT_RANK | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: o or Substring(U_RESV_2, 34, 5) | As Per STU_TYP | ** See STY_TYP and U_RESV_2 for further details ** | |
REPT_INST | varchar | 4 | DWHOUSE | APPLICANTS_ADMITS_vw | REPT_INST | 01045 - Reporting Institution | |
DECISION_CODE | varchar | 2 | DWHOUSE | HUB_APPLICANTS_ADMITS_V | DECISION_CODE | The full USF application decision code. | |
DEGREE_LEVEL_SOUGHT | varchar | 50 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'B' or Substring(U_RESV_2, 33, 1) | ** See U_RESV_2 for further details ** | |
OASIS_PIDM | float | DWHOUSE | APPLICANTS_ADMITS_vw | OASIS_PIDM | This field holds the OASIS internal identification number. | ||
ADMT_CODE | varchar | 50 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculate: Substring(U_RESV_211,2) or blank | As per STU_TYP | ** See STY_TYP for further details ** |
Stu_Typ_Rpt | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'B' or STU_CLASS_LEVEL | As pr STU_CLASS_LEVEL | ** See STU_CLASS_LEVEL for further details ** |
Stu_Class_Level_Rpt | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'B' or STU_TYP | As per STU_TYP | ** See STY_TYP for further details ** |
Dept | varchar | 4 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'PHA', 'PHT', or U_RESV_2 | As per STU_TYP | ** See STY_TYP for further details ** |
Stu_Load_Level | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'U', 'G' | As per Substring(U_RESV_2, 33, 1) | ** See U_RESV_2 for further details ** |
College_Rpt | varchar | 2 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'ED', 'EP' or COLLEGE | As per COLLEGE | Reporting College |
ZIP_APP | varchar | 10 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: Substring(U_RESV_2, 13, 10) | ** See U_RESV_2 for further details ** | |
ZIP_CURR | varchar | 10 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: Substring(U_RESV_2, 23, 10) | ** See U_RESV_2 for further details ** | |
Timestamp | datetime | SQL | Database | Timestamp | |||
Military_Status | nvarchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | military_status | 02059 - The BOG derived self reported response to the admission application Veteran Status questions | |
Acad_Success_Factor | varchar | 5 | DWHOUSE | HUB_APPLICANTS_ADMITS_V | ACAD_SUCCESS_FACTOR | The status of the interview with the applicant | |
CITZ_CODE | varchar | 2 | DWHOUSE | PersonHUB_PERSON_DemoCURRENT_VWV | CITZ_CODE | The current citizenship code for the person on OASIS or GEMS | |
CONC_CODE | varchar | 4 | DWHOUSE | HUB_APPLICANTS_ADMITS_vw V | CONC_CODE | The Concentration Code of the admit- For reporting purposes | |
DEGC_CODE_SOUGHT | varchar | 6 | DWHOUSE | HUB_APPLICANTS_ADMITS_vw V | DEGC_CODE_SOUGHT | The Degree Sought of the admit- For reporting purposes |