| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | This field identifies the last date the SORTEST record was updated. |
| Appl_No Indexed - no
Format - Number
May be Null? Y | Internal application id. Source field: SORTEST_APPL_NO |
| Equiv_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicator to show if the test score is an equivalency for the actual test taken. Source field: SORTEST_EQUIV_IND. |
| Instr_Id Indexed - no
Format - Varchar2(10)
May be Null? Y | Not currently used at Penn. Source field: SORTEST_INSTR_ID |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | The Penn_ID of the student. Source field: SPRIDEN_ID. |
| Pidm Indexed - yes
Format - Number
May be Null? Y | This field identifies the internal identification number of the student. Source field: SORTEST_PIDM. |
| Recentered Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether SAT score has been Recentered and/or Revised. Source field: SORTEST_RCRV_IND. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this test record was updated in the source. |
| Release_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Not currently used at Penn. Source field: SORTEST_RELEASE_IND |
| Sat_Orig Indexed - no
Format - Varchar2(5)
May be Null? Y | The original SAT score. Source field: SORTEST_SAT_ORIG_SCORE. |
| St_Adm_Test_Score_Pk Indexed - yes
Format - Varchar2(52)
May be Null? N | warehouse primary key, based on PIDM, TESC_CODE, and TEST_DATE |
| Term_Entry Indexed - no
Format - Varchar2(6)
May be Null? Y | tbd. Source field: SORTEST_TERM_CODE_ENTRY |
| Test_Accom Indexed - no
Format - Varchar2(5)
May be Null? Y | Test accomodation code. Source field: SORTEST_TEAC_CODE. |
| Test_Admr_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | The admissions checklist item code. Source field: SORTEST_ADMR_CODE. |
| Test_Adm_Type Indexed - no
Format - Varchar2(2)
May be Null? Y | The administrative type a particular test, ie., locally or nationally administered. Source field: SORTEST_TADM_CODE. |
| Test_Code Indexed - yes
Format - Varchar2(6)
May be Null? Y | The Test Score Code associated with various tests, for example, SAT, ACT, placement scores. Source field: SORTEST_TESC_CODE. Source validation table: STVTESC. Data Warehouse validation table: V_TEST. |
| Test_Date Indexed - no
Format - Date
May be Null? Y | The date a particular test was taken. Source field: SORTEST_TEST_DATE. |
| Test_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the code found in Test_Code. Source field: STVTESC_DESC |
| Test_Form Indexed - no
Format - Varchar2(2)
May be Null? Y | Test form code. Source field: SORTEST_TEFR_CODE. |
| Test_Instr Indexed - no
Format - Varchar2(6)
May be Null? Y | Test instrument code. Source field: SORTEST_TEIN_CODE. |
| Test_Purpose Indexed - no
Format - Varchar2(2)
May be Null? Y | Test purpose code. Source field: SORTEST_TEPR_CODE. |
| Test_Score Indexed - no
Format - Varchar2(15)
May be Null? Y | The reported score for a particular test. Source field: SORTEST_TEST_SCORE. |
| Test_Score_Source Indexed - no
Format - Varchar2(4)
May be Null? Y | The source, or how the test score was entered, ie., magnetic tape, self reported. Source field: SORTEST_TSRC_CODE. Source validation table: STVTSRC. |
