SID Degrees Awarded

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		Academic term (YYYYMM) to which the reported data applies.
dbo.SID_Degrees_Awarded	REPT_INST	varchar	4	DWHOUSE	degrees_awarded_vw	REPT_INST		01045 - Reporting Institution
dbo.SID_Degrees_Awarded	FEE_CLASS_KIND	varchar	1	DWHOUSE	degrees_awarded_vw	FEE_CLASS_KIND		01107 - Fee Classification - Kind
dbo.SID_Degrees_Awarded	TERM_DEG_GRANT	varchar	6	DWHOUSE	degrees_awarded_vw	TERM_DEG_GRANT		01412 - Term Degree Granted
dbo.SID_Degrees_Awarded	DEG_LEVEL_GRANT	varchar	1	DWHOUSE	degrees_awarded_vw	DEG_LEVEL_GRANT		01081 - Degree - Level Granted
dbo.SID_Degrees_Awarded	CIP_DEGREE	varchar	6	DWHOUSE	degrees_awarded_vw	CIP_DEGREE		01082 - Degree Program Category
dbo.SID_Degrees_Awarded	MAJOR_IND	numeric		DWHOUSE	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_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_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_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_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_awarded_vw	TCHR_EDU_PGM_METHOD		01436 - Teacher Education Program Method
dbo.SID_Degrees_Awarded	CIP_FRAC_DEG	numeric		DWHOUSE	degrees_awarded_vw	CIP_FRAC_DEG		01083 - Degree Program Fraction of Degree Granted
dbo.SID_Degrees_Awarded	DOC_CLASS	varchar	1	DWHOUSE	degrees_awarded_vw	DOC_CLASS		IPEDS Reclassificaiton of First-Professional Degree Level Granted
dbo.SID_Degrees_Awarded	BE_CD	varchar	1	DWHOUSE	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_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_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	HUB_DEGREES_USF_V -- OR -- SGBSTDN	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_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	HUB_DEGREES_USF_V -- OR – SGBSTDN	major_code -- OR -- SGBSTDN_MAJR_CODE_1	IF NULL use conc_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_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_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