SID_Tests_Reqs

This page documents the SID_Tests_Reqs reporting table and its columns, noting the ultimate data source of each data-item (DWHOUSE or PROD).

In addition, Meta Mart descriptions are provided for each column, along with a direct link to the source tables/views documentation in Meta Mart.

The primary data source for this data set is the HUB_TESTS_REQS_INTERNAL_V view which, according to Meta Mart is: used internally for e-profiles application, and represents results of placement tests for prospective undergraduate and graduate students.

 

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameNotes_LogicMeta Mart Description
dbo.SID_Tests_ReqsTERMIDvarchar8DWHOUSEHUB_TESTS_REQS_INTERNAL_VREPT_TIME_FRAME Academic term (YYYYMM) to which the reported data applies
dbo.SID_Tests_ReqsBENCHchar1Run-time parameterN/A@BENCH' (B, F, D, E)Entered / passed through at run-time in ETL 
dbo.SID_Tests_ReqsUIDvarchar50DWHOUSEHUB_TESTS_REQS_INTERNAL_VUSF_ID This field holds the OASIS U-ID
dbo.SID_Tests_ReqsCIP_APP_ADMvarchar6DWHOUSEHUB_TESTS_REQS_INTERNAL_VCIP_APP_ADM 01242 - Admissions Application Program Category
dbo.SID_Tests_ReqsSTU_TYPvarchar1DWHOUSEHUB_TESTS_REQS_INTERNAL_VSTU_TYP 01117 - Type of Student at Time of Application
dbo.SID_Tests_ReqsTEST_REQ_CDvarchar2DWHOUSEHUB_TESTS_REQS_INTERNAL_VTEST_REQ_CD Test or Requirement Code
dbo.SID_Tests_ReqsTEST_SCORE_TYPvarchar2DWHOUSEHUB_TESTS_REQS_INTERNAL_Vtest_score_typ Type of score reported
dbo.SID_Tests_ReqsTEST_SCORE_Nnumeric DWHOUSEHUB_TESTS_REQS_INTERNAL_VTEST_SCORE_N 01168 - Verbal/Other Score
dbo.SID_Tests_ReqsTEST_SCORE_Avarchar4DWHOUSEHUB_TESTS_REQS_INTERNAL_VTEST_SCORE_A P/F/K (Pass or Fail or Presumed Pass with valid educator certification [Educator Prep only])
dbo.SID_Tests_ReqsTCHR_PREP_DOE_CDvarchar3DWHOUSEHUB_TESTS_REQS_INTERNAL_VTCHR_PREP_DOE_CD 01425 - State-Approved Teacher Prep Pgm - DOE Code
dbo.SID_Tests_ReqsREQ_METvarchar1DWHOUSEHUB_TESTS_REQS_INTERNAL_VREQ_MET Was the requirement met ? Y/N/I ( I=Incomplete)
dbo.SID_Tests_ReqsDEMO_DATA_SOURCEvarchar8LiteralVia QueryADM'via PROCEDURE Proc_DataLoad_SID 
dbo.SID_Tests_ReqsAPP_ADM_SOURCEvarchar8LiteralVia QueryADM'via PROCEDURE Proc_DataLoad_SID 
dbo.SID_Tests_ReqsREPT_INSTvarchar4LiteralVia QueryUSF'via PROCEDURE Proc_DataLoad_SID 
dbo.SID_Tests_ReqsOasis_PIDMfloat DWHOUSEHUB_TESTS_REQS_INTERNAL_VOasis_PIDM This field holds the OASIS internal identification number