HS_TEST_XREF

(SQL Table)
Index Back

Cross Reference for HS Tests

AWE uses this record as its only link between itself and the Health and Safety Test transaction. This record is used solely by AWE.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
2 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
3 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
4 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
5 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
A=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Awaiting Further Approvals
T=Terminated
W=Canceled
X=Suspended/Pending Denial

Default Value: N

8 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
9 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
10 COMMENTS Long Character CLOB Comment
11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
12 ACTION_DT_SS Date(10) DATE Termination Date
13 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
14 HS_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID for Health and Safety
15 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
16 TEST_CODE Character(4) VARCHAR2(4) NOT NULL Code for type of test
17 START_DATE Date(10) DATE Start Date for Gen Standing PO