HR_REP_CHG_PNDG (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

HR_REP_CHG_PNDG

(SQL View)

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 , C.EOAWSTEP_STATUS , D.OPRID , D.EOAWORIG_OPRID FROM PS_HR_MGR_REP_DAT A , PS_HR_REPORT_XREF B , PS_EOAW_STEPINST C , PS_EOAW_USERINST D WHERE A.WF_STATUS IN ('S', 'I') AND 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

#	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