This page describes the data-items in the SID_Degrees_Awarded table, in addition to providing a link to the Meta Mart Data Warehouse or Production documentation.
TableName | COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | Notes_Logic | Meta Mart Description |
dbo.SID_Degrees_Awarded | Termid | varchar | 8 | DWHOUSE | degrees_awarded_vw | REPT_TIME_FRAME | ||
dbo.SID_Degrees_Awarded | REPT_INST | varchar | 4 | DWHOUSE | degrees_awarded_vw | REPT_INST | ||
dbo.SID_Degrees_Awarded | FEE_CLASS_KIND | varchar | 1 | DWHOUSE | degrees_awarded_vw | FEE_CLASS_KIND | ||
dbo.SID_Degrees_Awarded | TERM_DEG_GRANT | varchar | 6 | DWHOUSE | degrees_awarded_vw | TERM_DEG_GRANT | ||
dbo.SID_Degrees_Awarded | DEG_LEVEL_GRANT | varchar | 1 | DWHOUSE | degrees_awarded_vw | DEG_LEVEL_GRANT | ||
dbo.SID_Degrees_Awarded | CIP_DEGREE | varchar | 6 | DWHOUSE | degrees_awarded_vw | CIP_DEGREE | ||
dbo.SID_Degrees_Awarded | MAJOR_IND | numeric | DWHOUSE | degrees_awarded_vw | MAJOR_IND | |||
dbo.SID_Degrees_Awarded | TCHR_PREP_DOE_CD | varchar | 3 | DWHOUSE | degrees_awarded_vw | TCHR_PREP_DOE_CD | ||
dbo.SID_Degrees_Awarded | DEMO_TIME_FRAME | varchar | 8 | DWHOUSE | degrees_awarded_vw | REPT_TIME_FRAME | ||
dbo.SID_Degrees_Awarded | DEMO_DATA_SOURCE | varchar | 8 | Literal | Via Query | 'SIFD' | via PROCEDURE Proc_DataLoad_SID | |
dbo.SID_Degrees_Awarded | AWARD_SOURCE | varchar | 4 | DWHOUSE | degrees_awarded_vw | AWARD_SOURCE | ||
dbo.SID_Degrees_Awarded | TCHR_PREP_DOE_LEVEL | varchar | 1 | DWHOUSE | degrees_awarded_vw | TCHR_PREP_DOE_LEVEL | ||
dbo.SID_Degrees_Awarded | TCHR_EDU_PGM_METHOD | varchar | 1 | DWHOUSE | degrees_awarded_vw | TCHR_EDU_PGM_METHOD | ||
dbo.SID_Degrees_Awarded | CIP_FRAC_DEG | numeric | DWHOUSE | degrees_awarded_vw | CIP_FRAC_DEG | |||
dbo.SID_Degrees_Awarded | DOC_CLASS | varchar | 1 | DWHOUSE | degrees_awarded_vw | DOC_CLASS | ||
dbo.SID_Degrees_Awarded | BE_CD | varchar | 1 | DWHOUSE | degrees_awarded_vw | BE_CD | ||
dbo.SID_Degrees_Awarded | U_RESV_1 | varchar | 50 | ? | ? | ? | All NULL values | |
dbo.SID_Degrees_Awarded | IPEDS_RPTD_FLG | varchar | 1 | ? | ? | ? | All NULL values | |
dbo.SID_Degrees_Awarded | DEG_LEVEL_GRANT_GRP | varchar | 50 | ? | ? | ? | All NULL values | |
dbo.SID_Degrees_Awarded | UID | varchar | 15 | DWHOUSE | degrees_awarded_vw | USF_ID | If NULL use USF_ID from DWHOUSE/Person_Demo_VW | |
dbo.SID_Degrees_Awarded | Oasis_PIDM | float | DWHOUSE | degrees_awarded_vw | OASIS_PIDM | |||
dbo.SID_Degrees_Awarded | Catalog_Year_Grant | varchar | 6 | DWHOUSE | HUB_DEGREES_USF_V | catalog_year_grant | ||
dbo.SID_Degrees_Awarded | Degree_Code | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | degree_code | ||
dbo.SID_Degrees_Awarded | College_Code | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | coll_code | ||
PROD | SGBSTDN | sgbstdn_coll_code_1 | IF NULL, set to '00' | |||||
dbo.SID_Degrees_Awarded | Major_Code | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | Major_Code | ||
dbo.SID_Degrees_Awarded | Conc_Code_1 | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | Conc_Code_1 | ||
dbo.SID_Degrees_Awarded | Conc_Code_2 | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | Conc_Code_2 | ||
dbo.SID_Degrees_Awarded | Degree_Status | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | degree_status | ||
dbo.SID_Degrees_Awarded | Acat_Code | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | acat_code | ||
dbo.SID_Degrees_Awarded | Campus_Code | varchar | 5 | DWHOUSE | degrees_awarded_vw | u_resv_1 | ||
dbo.SID_Degrees_Awarded | DSS_Major_Code | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | major_code | IF NULL use conc_code_1 | |
PROD | SGBSTDN | SGBSTDN_MAJR_CODE_1 | IF still NULL and SGBSTDN_LEVL_CODE Not Like 'ND' | |||||
dbo.SID_Degrees_Awarded | Seq_Nbr | int | DWHOUSE | degrees_awarded_vw | major_ind | |||
dbo.SID_Degrees_Awarded | Gender | varchar | 1 | DWHOUSE | Person_Demo_VW | gender | IF NULL, set to 'X' | |
dbo.SID_Degrees_Awarded | Ethnicity | varchar | 1 | DWHOUSE | Person_Demo_VW | race_ethnicity | IF NULL, set to 'X' | |
dbo.SID_Degrees_Awarded | Dept | varchar | 4 | DWHOUSE | HUB_DEGREES_USF_V | dept_code | ||
PROD | SGBSTDN | SGBSTDN_DEPT_CODE | If NULL, set to 'DEA' | |||||
dbo.SID_Degrees_Awarded | College_Rpt | varchar | 2 | DWHOUSE | HUB_DEGREES_USF_V | Calculated: ED, EP | college_code | |
dbo.SID_Degrees_Awarded | Deg_Level_Grant_Rpt | varchar | 1 | DWHOUSE | degrees_awarded_vw | Calculated: K, I | Per CASE on CIP_DEGREE, DEG_LEVEL_GRANT | |
dbo.SID_Degrees_Awarded | Timestamp | datetime | SQL | Database | Timestamp |