SID_Tests_Reqs
- Michael Harvey (Deactivated)
Owned by Michael Harvey (Deactivated)
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.
| 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 | Academic term (YYYYMM) to which the reported data applies | |
| 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 | This field holds the OASIS U-ID | |
| dbo.SID_Tests_Reqs | CIP_APP_ADM | varchar | 6 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | CIP_APP_ADM | 01242 - Admissions Application Program Category | |
| dbo.SID_Tests_Reqs | STU_TYP | varchar | 1 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | STU_TYP | 01117 - Type of Student at Time of Application | |
| dbo.SID_Tests_Reqs | TEST_REQ_CD | varchar | 2 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | TEST_REQ_CD | Test or Requirement Code | |
| dbo.SID_Tests_Reqs | TEST_SCORE_TYP | varchar | 2 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | test_score_typ | Type of score reported | |
| dbo.SID_Tests_Reqs | TEST_SCORE_N | numeric | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | TEST_SCORE_N | 01168 - Verbal/Other Score | ||
| dbo.SID_Tests_Reqs | TEST_SCORE_A | varchar | 4 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | TEST_SCORE_A | P/F/K (Pass or Fail or Presumed Pass with valid educator certification [Educator Prep only]) | |
| dbo.SID_Tests_Reqs | TCHR_PREP_DOE_CD | varchar | 3 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | TCHR_PREP_DOE_CD | 01425 - State-Approved Teacher Prep Pgm - DOE Code | |
| dbo.SID_Tests_Reqs | REQ_MET | varchar | 1 | DWHOUSE | HUB_TESTS_REQS_INTERNAL_V | REQ_MET | Was the requirement met ? Y/N/I ( I=Incomplete) | |
| 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 | This field holds the OASIS internal identification number |