SAD_SAT_I_TEST_IDPrompt Table: SA_TEST_TBL
EFFDTDefault Value: %date
TEST_COMPONENTPrompt Table: SA_TEST_CMP_TBL
Default Value: SA_TCMP_REL_TBL.DESCR
SAD_SAT_I_C_VW(SQL View) |
Index Back |
|---|---|
SAT I Test Component ViewThis view will display the Test Components for SAT I Test ID |
| SELECT TEST_ID , EFFDT , TEST_COMPONENT , DESCR , DESCRSHORT FROM PS_SA_TCMP_REL_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_SAT_I_TEST_ID |
Character(11) | VARCHAR2(11) NOT NULL |
SAT I 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: SA_TCMP_REL_TBL.DESCR |