EMPLIDPrompt Table: PEOPLE_SRCH
HEALTH_TESTPrompt Table: HEALTH_TST_TBL
HEALTH_SEQNEG=Negative
NTR=Neutral/Non-contagious
POS=Positive
HEALTH_TEST(SQL Table) |
Index Back |
|---|---|
Health TestUse HEALTH_TEST to record Official (Institution determined) Health Test information. |
| # | 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_TST_TBL |
| 3 | HEALTH_SEQ |
Number(3,0) | SMALLINT NOT NULL | Health Test Nbr |
| 4 | DATE_TAKEN | Date(10) | DATE | Health Test Date |
| 5 | DATE_RECEIVED | Date(10) | DATE | Date Received |
| 6 | TEST_VALUE | Number(8,3) | DECIMAL(7,3) NOT NULL | Test Value |
| 7 | TEST_RESULT | Character(3) | VARCHAR2(3) NOT NULL |
Test Result
NEG=Negative NTR=Neutral/Non-contagious POS=Positive |
| 8 | COMMENTS | Long Character | CLOB | Comment |