HR_REP_XREF_VW

(SQL View)
 Index Back

Reporting Change XRef View

This view is used to generate notifications initiated by the transaction's component interface. This view was specifically created for this purpose so that the common Notification logic provided via the framework could be used to generate line level notifications for individual employees even though the transaction is set up at the header level. This record is used in the HR_TRANSACTIONS app packAge in the ApplySelfServiceData class.

SELECT %subrec(EOAW_XREF_SBR, A) , A.TRANSACTION_NBR , B.EMPLID , B.EMPL_RCD , B.JOB_DESCR_SS , B.POSITION_FLAG , B.TRANSACTION_NAME , B.UPD_BY_USERID , B.UPD_DTTM , B.MANUAL_UPD_USERID , B.MANUAL_UPD_DTTM , B.SS_STAT_INDICATOR , B.SS_WARNING_FLG , B.SS_FUTURE_FLG FROM PS_HR_REPORT_XREF A , PS_HR_REPORT_TRANS B WHERE A.TRANSACTION_NBR = B.TRANSACTION_NBR

# 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 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
13 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
14 JOB_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Job Title
15 POSITION_FLAG Character(1) VARCHAR2(1) NOT NULL Position Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

16 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
17 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
18 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
19 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
20 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
21 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
A=Approved
B=CI failed - Errors & Warnings
C=Cancelled
D=Denied
E=Errors Encountered
I=In Approval Process
M=Administrator Action Required
S=Success
W=Warnings Encountered

Default Value: I

22 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

Y/N Table Edit

Default Value: N

23 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

Y/N Table Edit

Default Value: N