TEST_IDPrompt Table: SA_TEST_TBL
EFFDTDefault Value: %date
TEST_COMPONENTPrompt Table: SA_TEST_CMP_TBL
Default Value: SA_TCMP_REL_TBL.DESCR
SA_TCMP_REL_TBL(SQL Table) |
Index Back |
|---|---|
Test Component RelationshipsUse SA_TCMP_REL_TBL to define the valid components for an academic test. The component id prompts, but does not edit, on the Test Components Table. This allows for entering components that aren't on the Test Components Table. You may do this if a component is unique to a test. Use SA_TEST_TBL to assign codes to tests and enter descriptions. A test can be any type of skill test that an person must take to qualify for admission or qualification assessment or certification, etc.. |
| # | 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 | 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 |
| 6 | MAX_SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Maximum Score |
| 7 | MIN_SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Minimum Score |
| 8 | EDI_SPEEDE_TST_CD | Character(5) | VARCHAR2(5) NOT NULL | SPEEDE Subtest Code |