TEST_IDPrompt Table: SA_TEST_TBL
EFFDTDefault Value: %date
TEST_COMPONENTPrompt Table: SA_TEST_CMP_TBL
SA_TCMP_REL_VW(SQL View) |
Index Back |
|---|---|
Test Comp Relationships VWSA_TCMP_REL_VW is used within the test score suspense panels to assist in the score validation. |
| Select Test_ID, Effdt, Test_Component, Max_Score, Min_Score From PS_SA_TCMP_REL_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEST_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Test ID
Prompt Table: SA_TEST_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | TEST_COMPONENT |
Character(5) | VARCHAR2(5) NOT NULL |
Test Component
Prompt Table: SA_TEST_CMP_TBL |
| 4 | MAX_SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Maximum Score |
| 5 | MIN_SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Minimum Score |