EMPLIDPrompt Table: PEOPLE_SRCH
TEST_IDPrompt Table: SA_TEST_TBL
TEST_COMPONENTPrompt Table: SA_TCMP_REL_TBL
TEST_DTSTDNT_TSCORE_VW(SQL View) |
Index Back |
|---|---|
Student Test Comp Score VwUse this view to select scores for test components. |
| Select Distinct a.Emplid, a.Test_Id, a.Test_Component, a.Test_Dt, a.Score from PS_STDNT_TEST_COMP a, PS_SA_TEST_CMP_TBL b where a.Test_Component = b.Test_Component and b.effdt = (select max(c.effdt) from PS_SA_TEST_CMP_TBL c where c.Test_Component = a.Test_Component and c.effdt <= a.Test_dt) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | TEST_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Test ID
Prompt Table: SA_TEST_TBL |
| 3 | TEST_COMPONENT |
Character(5) | VARCHAR2(5) NOT NULL |
Test Component
Prompt Table: SA_TCMP_REL_TBL |
| 4 | TEST_DT |
Date(10) | DATE | Test Date |
| 5 | SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Test Score |