FE_LOC_APPR_VW (SQL View)	Index Back
Approver Search View Approver Search View to display pending name change requests. OPRID is one of the keys for this view. So, the join with the current sign-on operator id happens at the run time.

FE_LOC_APPR_VW

(SQL View)

Approver Search View

Approver Search View to display pending name change requests. OPRID is one of the keys for this view. So, the join with the current sign-on operator id happens at the run time.

SELECT A.TRANSACTION_NBR , O.OPRID , B.EMPLID_CURR_APPR , B.STEP , B.CURRENT_STEP FROM PS_FE_MGR_LOC_DAT A , PS_FE_MGR_LOC_STA B , PSOPRDEFN O WHERE A.TRANSACTION_NBR=B.TRANSACTION_NBR AND B.STEP > 0 AND B.FE_APPRSTEP_ACTION = 'P' AND (B.EMPLID_CURR_APPR = O.EMPLID OR (O.OPRID IN ( SELECT C.ROLEUSER FROM PSROLEUSER C WHERE C. ROLENAME = B.ROLENAME_CURR_APPR)))

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 EMPLID_CURR_APPR Character(11) VARCHAR2(11) NOT NULL Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.

4 STEP Number(2,0) SMALLINT NOT NULL Step

5 CURRENT_STEP Number(3,0) SMALLINT NOT NULL Current Step Number

#	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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	EMPLID_CURR_APPR	Character(11)	VARCHAR2(11) NOT NULL	Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.
4	STEP	Number(2,0)	SMALLINT NOT NULL	Step
5	CURRENT_STEP	Number(3,0)	SMALLINT NOT NULL	Current Step Number