This page documents the SID_Tests_Reqs reporting table and its columns, noting the ultimate dat source of each data-item (DWHOUSE or PROD).
In addition, the Meta Mart description is provided and a direct link to the source tables/views in Meta Mart.
TableName | COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | Notes_Logic | Meta Mart Description |
dbo.SID_Tests_Reqs | TERMID | varchar | 8 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | REPT_TIME_FRAME | ||
dbo.SID_Tests_Reqs | BENCH | char | 1 | Run-time parameter | N/A | @BENCH' (B, F, D, E) | Entered / passed through at run-time in ETL | |
dbo.SID_Tests_Reqs | UID | varchar | 50 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | USF_ID | ||
dbo.SID_Tests_Reqs | CIP_APP_ADM | varchar | 6 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | CIP_APP_ADM | ||
dbo.SID_Tests_Reqs | STU_TYP | varchar | 1 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | STU_TYP | ||
dbo.SID_Tests_Reqs | TEST_REQ_CD | varchar | 2 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | TEST_REQ_CD | ||
dbo.SID_Tests_Reqs | TEST_SCORE_TYP | varchar | 2 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | test_score_typ | ||
dbo.SID_Tests_Reqs | TEST_SCORE_N | numeric | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | TEST_SCORE_N | |||
dbo.SID_Tests_Reqs | TEST_SCORE_A | varchar | 4 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | TEST_SCORE_A | ||
dbo.SID_Tests_Reqs | TCHR_PREP_DOE_CD | varchar | 3 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | TCHR_PREP_DOE_CD | ||
dbo.SID_Tests_Reqs | REQ_MET | varchar | 1 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | REQ_MET | ||
dbo.SID_Tests_Reqs | DEMO_DATA_SOURCE | varchar | 8 | Literal | Via Query | ADM' | via PROCEDURE Proc_DataLoad_SID | |
dbo.SID_Tests_Reqs | APP_ADM_SOURCE | varchar | 8 | Literal | Via Query | ADM' | via PROCEDURE Proc_DataLoad_SID | |
dbo.SID_Tests_Reqs | REPT_INST | varchar | 4 | Literal | Via Query | USF' | via PROCEDURE Proc_DataLoad_SID | |
dbo.SID_Tests_Reqs | Oasis_PIDM | float | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | Oasis_PIDM |