...
| 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 degrees_awarded_vw | REPT_TIME_FRAME | Academic term (YYYYMM) to which the reported data applies. | ||||||||||
| dbo.SID_Degrees_Awarded | REPT_INST | varchar | 4 | DWHOUSE | degrees degrees_awarded_vw | REPT_INST | 01045 - Reporting Institution | ||||||||||
| dbo.SID_Degrees_Awarded | FEE_CLASS_KIND | varchar | 1 | DWHOUSE | degrees degrees_awarded_vw | FEE_CLASS_KIND | 01107 - Fee Classification - Kind | ||||||||||
| dbo.SID_Degrees_Awarded | TERM_DEG_GRANT | varchar | 6 | DWHOUSE | degrees degrees_awarded_vw | TERM_DEG_GRANT | 01412 - Term Degree Granted | ||||||||||
| dbo.SID_Degrees_Awarded | DEG_LEVEL_GRANT | varchar | 1 | DWHOUSE | degrees degrees_awarded_vw | DEG_LEVEL_GRANT | 01081 - Degree - Level Granted | ||||||||||
| dbo.SID_Degrees_Awarded | CIP_DEGREE | varchar | 6 | DWHOUSE | degrees degrees_awarded_vw | CIP_DEGREE | 01082 - Degree Program Category | ||||||||||
| dbo.SID_Degrees_Awarded | MAJOR_IND | numeric | DWHOUSE | degrees degrees_awarded_vw | MAJOR_IND | Major Indicator (1=First, 2=Second, 3=Third, etc.) | |||||||||||
| dbo.SID_Degrees_Awarded | TCHR_PREP_DOE_CD | varchar | 3 | DWHOUSE | degrees degrees_awarded_vw | TCHR_PREP_DOE_CD | 01425 - State-Approved Teacher Prep Pgm - DOE Code (Default to '999') | ||||||||||
| dbo.SID_Degrees_Awarded | DEMO_TIME_FRAME | varchar | 8 | DWHOUSE | degrees degrees_awarded_vw | REPT_TIME_FRAME | Academic term (YYYYMM) to which the reported data applies | ||||||||||
| 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 degrees_awarded_vw | AWARD_SOURCE | Source of the award contained in the current record: SIF, HTD, TEF, DEG | ||||||||||
| dbo.SID_Degrees_Awarded | TCHR_PREP_DOE_LEVEL | varchar | 1 | DWHOUSE | degrees degrees_awarded_vw | TCHR_PREP_DOE_LEVEL | 01423 - State-Approved Teacher Prep Pgm - DOE Level | ||||||||||
| dbo.SID_Degrees_Awarded | TCHR_EDU_PGM_METHOD | varchar | 1 | DWHOUSE | degrees degrees_awarded_vw | TCHR_EDU_PGM_METHOD | 01436 - Teacher Education Program Method | ||||||||||
| dbo.SID_Degrees_Awarded | CIP_FRAC_DEG | numeric | DWHOUSE | degrees degrees_awarded_vw | CIP_FRAC_DEG | 01083 - Degree Program Fraction of Degree Granted | |||||||||||
| dbo.SID_Degrees_Awarded | DOC_CLASS | varchar | 1 | DWHOUSE | degrees degrees_awarded_vw | DOC_CLASS | IPEDS Reclassificaiton of First-Professional Degree Level Granted | ||||||||||
| dbo.SID_Degrees_Awarded | BE_CD | varchar | 1 | DWHOUSE | degrees degrees_awarded_vw | BE_CD | 01007 - Budget Entity Code, SUS | ||||||||||
| dbo.SID_Degrees_Awarded | U_RESV_1 | varchar | 50 | ? ? | ? | All NULL values | ** New Univ Reserved Area (variable data depending on context) ** | ||||||||||
| dbo.SID_Degrees_Awarded | IPEDS_RPTD_FLG | varchar | 1 | ? ? | ? | All NULL values | ** No column with this name exists in Meta Mart ** | ||||||||||
| dbo.SID_Degrees_Awarded | DEG_LEVEL_GRANT_GRP | varchar | 50 | ? ? | ? | All NULL values | ** No column with this name exists in Meta Mart ** | ||||||||||
| dbo.SID_Degrees_Awarded | UID | varchar | 15 | DWHOUSE | degrees degrees_awarded_vw | USF_ID | If NULL use USF_ID from DWHOUSE/Person_Demo_VW | This field defines the identification number used to access the person on-line, which is a randomly assigned, alpha-numeric USFID. The USFID is the primary identifier in OASIS | |||||||||
| dbo.SID_Degrees_Awarded | Oasis_PIDM | float | DWHOUSE | degrees degrees_awarded_vw | OASIS_PIDM | This field holds the OASIS internal identification number. | |||||||||||
| dbo.SID_Degrees_Awarded | Catalog_Year_Grant | varchar | 6 | DWHOUSE | HUB_DEGREES_USF_V | catalog_year_grant | 01476 - Catalog term of the degree | ||||||||||
| dbo.SID_Degrees_Awarded | Degree_Code | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | degree_code | Degree Code | ||||||||||
| dbo.SID_Degrees_Awarded | College_Code | varchar | 5 | DWHOUSE -- OR - PROD | coll_code |
| PROD | SGBSTDN -- OR -- | coll_code -- OR -- sgbstdn_coll_code_1 |
IF NULL, set to '00' | College of the awarded degree -- OR -- This field identifies the college associated with the primary curriculum for the effective term. | ||||||
| dbo.SID_Degrees_Awarded | Major_Code | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | Major_Code | Major of the awarded degree | ||||||||||
| dbo.SID_Degrees_Awarded | Conc_Code_1 | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | Conc_Code_1 | First concentration of the awarded degree | ||||||||||
| dbo.SID_Degrees_Awarded | Conc_Code_2 | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | Conc_Code_2 | Second concentration of the awarded degree | ||||||||||
| dbo.SID_Degrees_Awarded | Degree_Status | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | degree_status | This field holds the OASIS SHRDGMR Table degree status | ||||||||||
| dbo.SID_Degrees_Awarded | Acat_Code | varchar | 5 | DWHOUSE | HUB_DEGREES_USF_V | acat_code | This field holds the STVDEGC_ACAT_CODE | ||||||||||
| dbo.SID_Degrees_Awarded | Campus_Code | varchar | 5 | DWHOUSE | degrees degrees_awarded_vw | u_resv_1 | New Univ Reserved Area (variable data depending on context) | ||||||||||
| dbo.SID_Degrees_Awarded | DSS_Major_Code | varchar | 5 | DWHOUSE -- OR -- PROD | -- OR – | major_code -- OR -- SGBSTDN_MAJR_CODE_1 | IF NULL use conc_code_1 | PROD | SGBSTDN | SGBSTDN_MAJR_CODE_1 | -- OR -- IF still NULL and SGBSTDN_LEVL_CODE Not Like 'ND' | Major of the awarded degree / First concentration of the awarded degree -- OR - This field identifies the primary major within the primary curriculum for the effective term. | |||||
| dbo.SID_Degrees_Awarded | Seq_Nbr | int | DWHOUSE | degrees degrees_awarded_vw | major_ind | Major Indicator (1=First, 2=Second, 3=Third, etc.) | |||||||||||
| dbo.SID_Degrees_Awarded | Gender | varchar | 1 | DWHOUSE | Person_Demo_VW | gender | IF NULL, set to 'X' | 01048 - Gender | |||||||||
| dbo.SID_Degrees_Awarded | Ethnicity | varchar | 1 | DWHOUSE | Person_Demo_VW | race_ethnicity | IF NULL, set to 'X' | 01044 - Racial/Ethnic Group | |||||||||
| dbo.SID_Degrees_Awarded | Dept | varchar | 4 | DWHOUSE | HUB_DEGREES_USF_V | dept_code | Department of the awarded degree | ||||||||||
| PROD | SGBSTDN | SGBSTDN_DEPT_CODE | If NULL, set to 'DEA' | Department Code. | |||||||||||||
| dbo.SID_Degrees_Awarded | College_Rpt | varchar | 2 | DWHOUSE | HUB_DEGREES_USF_V | Calculated: ED, EP | college_code | Derived from coll_code - College of the awarded degree | |||||||||
| dbo.SID_Degrees_Awarded | Deg_Level_Grant_Rpt | varchar | 1 | DWHOUSE | degrees degrees_awarded_vw | Calculated: K, I | Per CASE on CIP_DEGREE, DEG_LEVEL_GRANT | 01082 - Degree Program Category 01081 - Degree - Level Granted | |||||||||
| dbo.SID_Degrees_Awarded | Timestamp | datetime | SQL | Database | Timestamp |