BEN_APPR_XREF

(SQL Table)
Index Back

Benefits Attachment XRef

Cross Ref for benefits approvals used by the fluid approval frameowrk.

# 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

Prompt Table: W3EB_EMPL_VW

12 BEN_EVENT_TYPE Character(10) VARCHAR2(10) NOT NULL Benefits event types for attachments
D=Dependent
L=Life Event
O=Open Enrollment
13 BEN_EVENT_SEQ Number(3,0) SMALLINT NOT NULL Benefits attachment sequence
14 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number