Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

 

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. 

 

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameNotes_LogicMeta Mart Description
dbo.SID_Degrees_AwardedTermidvarchar8DWHOUSE degrees_awarded_vwREPT_TIME_FRAME  
dbo.SID_Degrees_AwardedREPT_INSTvarchar4DWHOUSE degrees_awarded_vwREPT_INST  
dbo.SID_Degrees_AwardedFEE_CLASS_KINDvarchar1DWHOUSE degrees_awarded_vwFEE_CLASS_KIND  
dbo.SID_Degrees_AwardedTERM_DEG_GRANTvarchar6DWHOUSE degrees_awarded_vwTERM_DEG_GRANT  
dbo.SID_Degrees_AwardedDEG_LEVEL_GRANTvarchar1DWHOUSE degrees_awarded_vwDEG_LEVEL_GRANT  
dbo.SID_Degrees_AwardedCIP_DEGREEvarchar6DWHOUSE degrees_awarded_vwCIP_DEGREE  
dbo.SID_Degrees_AwardedMAJOR_INDnumeric DWHOUSE degrees_awarded_vwMAJOR_IND  
dbo.SID_Degrees_AwardedTCHR_PREP_DOE_CDvarchar3DWHOUSE degrees_awarded_vwTCHR_PREP_DOE_CD  
dbo.SID_Degrees_AwardedDEMO_TIME_FRAMEvarchar8DWHOUSE degrees_awarded_vwREPT_TIME_FRAME  
dbo.SID_Degrees_AwardedDEMO_DATA_SOURCEvarchar8LiteralVia Query'SIFD'via PROCEDURE Proc_DataLoad_SID 
dbo.SID_Degrees_AwardedAWARD_SOURCEvarchar4DWHOUSE degrees_awarded_vwAWARD_SOURCE  
dbo.SID_Degrees_AwardedTCHR_PREP_DOE_LEVELvarchar1DWHOUSE degrees_awarded_vwTCHR_PREP_DOE_LEVEL  
dbo.SID_Degrees_AwardedTCHR_EDU_PGM_METHODvarchar1DWHOUSE degrees_awarded_vwTCHR_EDU_PGM_METHOD  
dbo.SID_Degrees_AwardedCIP_FRAC_DEGnumeric DWHOUSE degrees_awarded_vwCIP_FRAC_DEG  
dbo.SID_Degrees_AwardedDOC_CLASSvarchar1DWHOUSE degrees_awarded_vwDOC_CLASS  
dbo.SID_Degrees_AwardedBE_CDvarchar1DWHOUSE degrees_awarded_vwBE_CD  
dbo.SID_Degrees_AwardedU_RESV_1varchar50???All NULL values 
dbo.SID_Degrees_AwardedIPEDS_RPTD_FLGvarchar1???All NULL values 
dbo.SID_Degrees_AwardedDEG_LEVEL_GRANT_GRPvarchar50???All NULL values 
dbo.SID_Degrees_AwardedUIDvarchar15DWHOUSE degrees_awarded_vwUSF_IDIf NULL use USF_ID from DWHOUSE/Person_Demo_VW 
dbo.SID_Degrees_AwardedOasis_PIDMfloat DWHOUSE degrees_awarded_vwOASIS_PIDM  
dbo.SID_Degrees_AwardedCatalog_Year_Grantvarchar6DWHOUSEHUB_DEGREES_USF_Vcatalog_year_grant  
dbo.SID_Degrees_AwardedDegree_Codevarchar5DWHOUSEHUB_DEGREES_USF_Vdegree_code  
dbo.SID_Degrees_AwardedCollege_Codevarchar5DWHOUSEHUB_DEGREES_USF_Vcoll_code  
    PRODSGBSTDNsgbstdn_coll_code_1IF NULL, set to '00' 
dbo.SID_Degrees_AwardedMajor_Codevarchar5DWHOUSEHUB_DEGREES_USF_VMajor_Code  
dbo.SID_Degrees_AwardedConc_Code_1varchar5DWHOUSEHUB_DEGREES_USF_VConc_Code_1  
dbo.SID_Degrees_AwardedConc_Code_2varchar5DWHOUSEHUB_DEGREES_USF_VConc_Code_2  
dbo.SID_Degrees_AwardedDegree_Statusvarchar5DWHOUSEHUB_DEGREES_USF_Vdegree_status  
dbo.SID_Degrees_AwardedAcat_Codevarchar5DWHOUSEHUB_DEGREES_USF_Vacat_code  
dbo.SID_Degrees_AwardedCampus_Codevarchar5DWHOUSE degrees_awarded_vwu_resv_1  
dbo.SID_Degrees_AwardedDSS_Major_Codevarchar5DWHOUSEHUB_DEGREES_USF_Vmajor_codeIF NULL use conc_code_1  
    PRODSGBSTDNSGBSTDN_MAJR_CODE_1IF still NULL  and SGBSTDN_LEVL_CODE Not Like 'ND' 
dbo.SID_Degrees_AwardedSeq_Nbrint DWHOUSE degrees_awarded_vwmajor_ind  
dbo.SID_Degrees_AwardedGendervarchar1DWHOUSEPerson_Demo_VWgenderIF NULL, set to 'X' 
dbo.SID_Degrees_AwardedEthnicityvarchar1DWHOUSEPerson_Demo_VWrace_ethnicityIF NULL, set to 'X' 
dbo.SID_Degrees_AwardedDeptvarchar4DWHOUSEHUB_DEGREES_USF_Vdept_code  
    PRODSGBSTDNSGBSTDN_DEPT_CODEIf NULL, set to 'DEA' 
dbo.SID_Degrees_AwardedCollege_Rptvarchar2DWHOUSEHUB_DEGREES_USF_VCalculated: ED, EPcollege_code 
dbo.SID_Degrees_AwardedDeg_Level_Grant_Rptvarchar1DWHOUSE degrees_awarded_vwCalculated: K, IPer CASE on CIP_DEGREE, DEG_LEVEL_GRANT 
dbo.SID_Degrees_AwardedTimestampdatetime SQL DatabaseTimestamp  
  • No labels