HR_REPCHG_APRVW

(SQL View)
 Index Back

EE Rep Chg Pending txn vw

This view is intended to select all rows that are in the approval process that have not yet reached final approval as well as the associated Approval Process Id

SELECT A.TRANSACTION_NBR , A.ACTION_DT_SS , A.ACTION , A.ACTION_REASON , A.WF_STATUS , A.HR_REPCHNG_REASON , A.SUPERVISOR_ID , A.REPORTS_TO , A.APPROVAL_REQUIRED , A.COMMENTS , D.EOAWSTEP_STATUS , D.OPRID , D.EOAWORIG_OPRID ,%DatePart(D.EOAWDTTM_MODIFIED) ,C.EOAWTHREAD_ID ,D.EOAWDTTM_COMPLETE ,B.EOAWREQUESTOR_ID ,B.EOAWTHREAD_STATUS ,B.EOAWDTTM_MODIFIED ,C.EOAWPRCS_ID ,C.EOAWDEFN_ID ,C.EFFDT FROM PS_HR_MGR_REP_DAT A , PS_HR_REPORT_XREF B , PS_EOAW_STEPINST C , PS_EOAW_USERINST D WHERE A.TRANSACTION_NBR = B.TRANSACTION_NBR AND B.EOAWPRCS_ID = C.EOAWPRCS_ID AND B.EOAWDEFN_ID = C.EOAWDEFN_ID AND B.EOAWTHREAD_ID = C.EOAWTHREAD_ID AND D.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.
2 ACTION_DT_SS Date(10) DATE NOT NULL Reporting Change Date
3 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Default Value: DTA

Prompt Table: ACTION_TBL

4 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
5 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
6 HR_REPCHNG_REASON Character(3) VARCHAR2(3) NOT NULL Action / Reason
DTA=Reporting Change

Default Value: DTA

7 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

Prompt Table: HR_ACTIVE_DVW

8 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

Prompt Table: POSITION_DATA

9 APPROVAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
N=No Approval Required
Y=Approval Required
10 COMMENTS Long Character CLOB Comment
11 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
13 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
14 EOAWSTART_DT Date(10) DATE Start Date
15 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
16 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
17 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
18 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
19 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
20 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
21 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
22 EFFDT Date(10) DATE Effective Date

Default Value: %date