EMPLIDTEST_IDTEST_COMPONENTPrompt Table: SA_TEST_CMP_TBL
TEST_DTDATA_SOURCEAE=Ad-Hoc Employee
AO=Ad-Hoc Organizational
E=Extract
SAD_NCEA_SC_NZL(SQL Table) |
Index Back |
|---|---|
Record for NCEA resultsHolds additional fields relevant to UEBS test results. Sibling record of STDNT_TEST_COMP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | TEST_ID |
Character(11) | VARCHAR2(11) NOT NULL | Test ID |
| 3 | TEST_COMPONENT |
Character(5) | VARCHAR2(5) NOT NULL |
Test Component
Prompt Table: SA_TEST_CMP_TBL |
| 4 | TEST_DT |
Date(10) | DATE | Test Date |
| 5 | DATA_SOURCE |
Character(2) | VARCHAR2(2) NOT NULL |
Data Source
AE=Ad-Hoc Employee AO=Ad-Hoc Organizational E=Extract |
| 6 | SAD_NCEA_TOTCR_ACH | Number(3,0) | SMALLINT NOT NULL | New Zealand NCEA processing |
| 7 | SAD_NCEA_TTCRN_ACH | Number(3,0) | SMALLINT NOT NULL | New Zealand NCEA processing |