EE_TEST_DTL (SQL Table)	Index Back
EE - Test Details Table This is the Employee related Test Details Table. It is used to maintain allergy codes by REG_REGION.

EE_TEST_DTL

(SQL Table)

EE - Test Details Table

This is the Employee related Test Details Table. It is used to maintain allergy codes by REG_REGION.

Related Language Record: EE_TEST_DTL_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Prompt Table: REG_REGION_TBL

3 TEST_CODE Character(4) VARCHAR2(4) NOT NULL Code for type of test
Prompt Table: HS_TEST_TBL

4 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO

5 END_DATE Date(10) DATE End Date

6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

7 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

8 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

9 HS_TEST_LOCATION Character(1) VARCHAR2(1) NOT NULL Test Location
1=Workplace
2=Other

10 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
Prompt Table: SET_VLD_HR_03

11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: HS_LOCATION_VW

12 HS_LOCATION Character(50) VARCHAR2(50) NOT NULL Test Location

13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

18 CITY Character(30) VARCHAR2(30) NOT NULL City

19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference

22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

25 COUNTY Character(30) VARCHAR2(30) NOT NULL County

26 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

28 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

30 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

31 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_REGION_TBL
3	TEST_CODE	Character(4)	VARCHAR2(4) NOT NULL	Code for type of test Prompt Table: HS_TEST_TBL
4	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO
5	END_DATE	Date(10)	DATE	End Date
6	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
7	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
8	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
9	HS_TEST_LOCATION	Character(1)	VARCHAR2(1) NOT NULL	Test Location 1=Workplace 2=Other
10	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID Prompt Table: SET_VLD_HR_03
11	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: HS_LOCATION_VW
12	HS_LOCATION	Character(50)	VARCHAR2(50) NOT NULL	Test Location
13	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
14	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
15	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
16	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
17	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
18	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
19	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
20	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
21	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
22	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
23	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
24	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
25	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
26	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
27	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
28	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
29	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
30	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
31	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.