| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Region
|
| 4 |
TEST_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Code for type of test
|
| 5 |
START_DATE |
Date(10) |
DATE |
Date
|
| 6 |
HS_TEST_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Test Result
1=Positive
10=Not Applicable
11=Normal
12=Abnormal
2=Negative
3=Pass
4=Fail
5=Detected
6=Not Detected
7=Test Invalid
8=Test Not Done
9=Test Not Performed
99=Not Reported
|
| 7 |
TEST_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Test
|
| 8 |
HS_TEST_RESULT |
Character(2) |
VARCHAR2(2) NOT NULL |
Test Result
1=Positive
10=Not Applicable
11=Normal
12=Abnormal
2=Negative
3=Pass
4=Fail
5=Detected
6=Not Detected
7=Test Invalid
8=Test Not Done
9=Test Not Performed
|
| 9 |
HS_TEST_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Test Method
1=Blood
10=Tissue
11=Urine
12=X-ray
13=MRI
14=CT Scan
15=Mammogram
16=Ultrasound
2=Mouth Swab
3=Nasal Swab
4=Nasopharynx Swab
5=Saliva
6=Skin
7=Spinal Fluid
8=Stool
9=Throat Swab
|
| 10 |
HS_TEST_LOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Location
1=Workplace
2=Other
|
| 11 |
HS_LOCATION |
Character(50) |
VARCHAR2(50) NOT NULL |
Location Name
|
| 12 |
HS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Last Updated
|
| 13 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|