EMPLIDPrompt Table: PEOPLE_SRCH
HEALTH_TESTPrompt Table: HEALTH_TEST
HEALTH_SEQPrompt Table: HEALTH_TEST
HLTH_CRITERIA_NBRA=Does Not Apply
N=Test Not Taken
T=Test Taken
Default Value: A
NEG=Negative
NTR=Neutral/Non-contagious
POS=Positive
HEALTH_TST_CRIT(SQL Table) |
Index Back |
|---|---|
Health Test CriteriaHEALTH_TST_CRIT storesfficial (Institution determined) Health Test information detail. |
| # | 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 | HEALTH_TEST |
Character(5) | VARCHAR2(5) NOT NULL |
Health Test
Prompt Table: HEALTH_TEST |
| 3 | HEALTH_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Health Test Nbr
Prompt Table: HEALTH_TEST |
| 4 | HLTH_CRITERIA_NBR |
Number(2,0) | SMALLINT NOT NULL | Criteria Nbr |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DATE_TAKEN | Date(10) | DATE | Health Test Date |
| 7 | DATE_RECEIVED | Date(10) | DATE | Date Received |
| 8 | TEST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Test Status
A=Does Not Apply N=Test Not Taken T=Test Taken Default Value: A |
| 9 | TEST_VALUE | Number(8,3) | DECIMAL(7,3) NOT NULL | Test Value |
| 10 | TEST_RESULT | Character(3) | VARCHAR2(3) NOT NULL |
Test Result
NEG=Negative NTR=Neutral/Non-contagious POS=Positive |