REQUESTER_EVW

(SQL View)
 Index Back

Requester EIP View

Requester view for Requestor_Load EIP

SELECT A.REQUESTOR_ID , A.ACTIVE_FLG , A.REQ_STATUS , A.SHIPTO_SETID , A.SHIPTO_ID , A.LOCATION_SETID , A.LOCATION , A.ORIGIN_PO_SETID , A.ORIGIN , A.PHONE , A.FAX , A.USE_ASSGN_CAT_ONLY , A.CURRENCY_CD , A.CONSOLIDATE_FLG , A.PRICE_CAN_CHANGE , A.DEFAULT_IN_BU , B.OPRDEFNDESC , B.EMPLID , B.EMAILID , B.OPRCLASS , B.ROWSECCLASS , B.PRCSPRFLCLS , B.DEFAULTNAVHP , B.OPERPSWD , B.ENCRYPTED , B.SYMBOLICID , B.LANGUAGE_CD , B.MULTILANG , C.BUSINESS_UNIT , C.SETID FROM PS_REQUESTOR_TBL A , PSOPRDEFN B , PS_OPR_DEF_TBL_FS C WHERE A.REQUESTOR_ID = B.OPRID AND C.OPRID = B.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Prompt Table: PO_OPRDEFN_VW

2 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active

Y/N Table Edit

Default Value: Y

3 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled

Default Value: O

4 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

5 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Default Value: PV_HR8_DEFAULTS.SHIPTO_ID

Prompt Table: SHIP_SHIPSET_VW

6 LOCATION_SETID Character(5) VARCHAR2(5) NOT NULL Location Set ID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Default Value: PV_HR8_DEFAULTS.LOCATION

Prompt Table: LOC_LOCSET_VW

8 ORIGIN_PO_SETID Character(5) VARCHAR2(5) NOT NULL PO Origin Setid

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

9 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

Default Value: PV_HR8_DEFAULTS.ORIGIN

Prompt Table: ORGN_ORGNSET_VW

10 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
11 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
12 USE_ASSGN_CAT_ONLY Character(1) VARCHAR2(1) NOT NULL Use Only Assigned Catalogs

Y/N Table Edit

Default Value: N

13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: PV_HR8_DEFAULTS.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

14 CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidate with other Reqs
N=No
Y=Yes

Y/N Table Edit

Default Value: N

15 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

16 DEFAULT_IN_BU Character(1) VARCHAR2(1) NOT NULL Defaults Inventory BU

Y/N Table Edit

Default Value: N

17 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
18 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
19 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
20 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

Default Value: PV_HR8_DEFAULTS.OPRCLASS

Prompt Table: PSCLASSDEFN

21 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

Default Value: PV_HR8_DEFAULTS.ROWSECCLASS

Prompt Table: PSCLASSDEFN

22 PRCSPRFLCLS Character(30) VARCHAR2(30) NOT NULL A class that determines a user's process profile

Default Value: PV_HR8_DEFAULTS.PRCSPRFLCLS

Prompt Table: PSCLASSDEFN

23 DEFAULTNAVHP Character(30) VARCHAR2(30) NOT NULL Default Navigator Home Page

Default Value: PV_HR8_DEFAULTS.DEFAULTNAVHP

Prompt Table: PSCLASSDEFN

24 OPERPSWD Character(32) VARCHAR2(32) NOT NULL An user's password
25 ENCRYPTED Number(1,0) SMALLINT NOT NULL Encrypted Flag
26 SYMBOLICID Character(8) VARCHAR2(8) NOT NULL The foreign key linking the PSOPRDEFN table to PSACCESSPRFL

Default Value: PV_HR8_DEFAULTS.SYMBOLICID

Prompt Table: PSACCESSPRFL

27 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default Value: PV_HR8_DEFAULTS.LANGUAGE_CD

28 MULTILANG Number(1,0) SMALLINT NOT NULL Used to determine if user is Multi-Lingual

Default Value: PV_HR8_DEFAULTS.MULTILANG

29 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default SetID

Default Value: PV_HR8_DEFAULTS.DEFAULT_SETID

Prompt Table: SP_SETID_NONVW

30 DEFAULT_BU Character(5) VARCHAR2(5) NOT NULL Default Business Unit

Default Value: PV_HR8_DEFAULTS.DEFAULT_BU

Prompt Table: SP_BUS_FS_NONVW