SPB_REQUESTR_VW (SQL View)	Index Back
SP Time Entry Approvers Selects all the users that are associated with the role action of SP_APPROVER or SP_REQUESTER. SELECT A.REQUESTOR_ID FROM PS_OPR_DEF_TBL_PM A , PS_REQUESTOR_TBL B WHERE A.REQUESTOR_ID = B.REQUESTOR_ID AND B.ACTIVE_FLG = 'Y' AND A.ALL_REQUESTORS_FLG = 'Y' UNION SELECT D.REQUESTOR_ID FROM PS_OPR_PO_RQSTR D , PS_REQUESTOR_TBL E WHERE D.REQUESTOR_ID = E.REQUESTOR_ID AND E.ACTIVE_FLG = 'Y' AND D.ADD_AUTH = 'Y'

SPB_REQUESTR_VW

(SQL View)

SP Time Entry Approvers

Selects all the users that are associated with the role action of SP_APPROVER or SP_REQUESTER. SELECT A.REQUESTOR_ID FROM PS_OPR_DEF_TBL_PM A , PS_REQUESTOR_TBL B WHERE A.REQUESTOR_ID = B.REQUESTOR_ID AND B.ACTIVE_FLG = 'Y' AND A.ALL_REQUESTORS_FLG = 'Y' UNION SELECT D.REQUESTOR_ID FROM PS_OPR_PO_RQSTR D , PS_REQUESTOR_TBL E WHERE D.REQUESTOR_ID = E.REQUESTOR_ID AND E.ACTIVE_FLG = 'Y' AND D.ADD_AUTH = 'Y'

SELECT A.REQUESTOR_ID ,O.SERVICE_METHOD ,B.OPRDEFNDESC FROM PS_REQUESTOR_TBL A ,PSOPRDEFN B ,PS_OPR_DEF_TBL_SP O WHERE A.REQUESTOR_ID = B.OPRID AND A.ACTIVE_FLG = 'Y' AND O.OPRID = A.REQUESTOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: SP_REQUESTER_VW

2 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource

3 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: SP_REQUESTER_VW
2	SERVICE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Service Method D=Deliverable M=Multi Resource R=Resource
3	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user