...
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 | ||
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) | |
CIP_APP_ADM | varchar | 6 | DWHOUSE | APPLICANTS_ADMITS_vw | CIP_APP_ADM | ||
STU_TYP | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | STU_TYP | ||
APP_ADM_SOURCE | varchar | 8 | DWHOUSE | APPLICANTS_ADMITS_vw | APP_ADM_SOURCE | ||
DEMO_TIME_FRAME | varchar | 8 | DWHOUSE | APPLICANTS_ADMITS_vw | rept_time_Frame | ||
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' | |
ETHNICITY | varchar | 1 | DWHOUSE | Person_Demo_VW | race_ethnicity | IF NULL, set to 'X' | |
CAMPUS_H | varchar | 4 | DWHOUSE | APPLICANTS_ADMITS_vw | campus_cd_admin or CAMPUS or '0001' (default) | IF CAMPUS_H NULL use CAMPUS from FUC_SIDDecode | |
COLLEGE | varchar | 2 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'RX' or U_RESV_2 | As per STU_TYP | |
MAJOR | varchar | 5 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'MED', 'PRY', 'MPT' or U_RESV_2 | As per STU_TYP | |
FINAL_ADM_ACTION | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | FINAL_ADM_ACTION | ||
REGISTERED_CD | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | REGISTERED_CD | ||
COUNTY_OF_RES | varchar | 4 | DWHOUSE | APPLICANTS_ADMITS_vw | COUNTY_OF_RES | ||
FEE_CLASS_RES | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | FEE_CLASS_RES | ||
ADM_DEPOSIT_IND | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | ADM_DEPOSIT_IND | ||
STU_CLASS_LEVEL | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | STU_CLASS_LEVEL | ||
DISPLACED_STU_IND | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | DISPLACED_STU_IND | ||
LAST_INST_CD | varchar | 8 | DWHOUSE | APPLICANTS_ADMITS_vw | LAST_INST_CD | ||
INST_GRNT_HIDEG_CD | varchar | 8 | DWHOUSE | APPLICANTS_ADMITS_vw | INST_GRNT_HIDEG_CD | ||
DEG_HIGHEST_HELD | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | DEG_HIGHEST_HELD | ||
LAST_POSTSEC_DT | varchar | 6 | DWHOUSE | APPLICANTS_ADMITS_vw | LAST_POSTSEC_DT | ||
GPA_COLLEGE | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | GPA_COLLEGE | |||
HS_ETS_CD | varchar | 6 | DWHOUSE | APPLICANTS_ADMITS_vw | HS_ETS_CD | ||
LAST_SECONDARY_DT | varchar | 6 | DWHOUSE | APPLICANTS_ADMITS_vw | LAST_SECONDARY_DT | ||
GPA_HIGH_SCHOOL | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | GPA_HIGH_SCHOOL | |||
GPA_GED_COMPONENT | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | GPA_GED_COMPONENT | |||
GPA_BACHELORS | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | GPA_BACHELORS | |||
ESOL_UNITS | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | ESOL_UNITS | |||
DEPOSIT_AMT | numeric | DWHOUSE | APPLICANTS_ADMITS_vw | DEPOSIT_AMT | |||
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 | ||
REPT_INST | varchar | 4 | DWHOUSE | APPLICANTS_ADMITS_vw | REPT_INST | ||
DECISION_CODE | varchar | 2 | DWHOUSE | HUB_APPLICANTS_ADMITS_V | DECISION_CODE | ||
DEGREE_LEVEL_SOUGHT | varchar | 50 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'B' or Substring(U_RESV_2, 33, 1) | ||
OASIS_PIDM | float | DWHOUSE | APPLICANTS_ADMITS_vw | OASIS_PIDM | |||
ADMT_CODE | varchar | 50 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculate: Substring(U_RESV_211,2) or blank | As per STU_TYP | |
Stu_Typ_Rpt | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'B' or STU_CLASS_LEVEL | As pr STU_CLASS_LEVEL | |
Stu_Class_Level_Rpt | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'B' or STU_TYP | As per STU_TYP | |
Dept | varchar | 4 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'PHA', 'PHT', or U_RESV_2 | As per STU_TYP | |
Stu_Load_Level | varchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'U', 'G' | As per Substring(U_RESV_2, 33, 1) | |
College_Rpt | varchar | 2 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: 'ED', 'EP' or COLLEGE | As per COLLEGE | |
ZIP_APP | varchar | 10 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: Substring(U_RESV_2, 13, 10) | ||
ZIP_CURR | varchar | 10 | DWHOUSE | APPLICANTS_ADMITS_vw | Calculated: Substring(U_RESV_2, 23, 10) | ||
Timestamp | datetime | SQL | Database | Timestamp | |||
Military_Status | nvarchar | 1 | DWHOUSE | APPLICANTS_ADMITS_vw | military_status | ||
Acad_Success_Factor | varchar | 5 | DWHOUSE | HUB_APPLICANTS_ADMITS_V | ACAD_SUCCESS_FACTOR | ||
CITZ_CODE | varchar | 2 | DWHOUSE | Person_Demo_VW | CITZ_CODE | ||
CONC_CODE | varchar | 4 | DWHOUSE | HUB_APPLICANTS_ADMITS_Vvw | CONC_CODE | ||
DEGC_CODE_SOUGHT | varchar | 6 | DWHOUSE | HUB_APPLICANTS_ADMITS_Vvw | DEGC_CODE_SOUGHT |