REQ_CATALOG_EVW

(SQL View)
Index Back

Requester Catalog

Requester Catalog

SELECT A.REQUESTOR_ID , A.SETID , A.CATALOG_ID , 'N' FROM PS_REQUESTOR_CAT A

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

Prompt Table: REQUESTOR_VW

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: PV_HR8_DEFAULTS.DEFAULT_SETID

Prompt Table: SP_SETID_NONVW

3 CATALOG_ID Character(18) VARCHAR2(18) NOT NULL Catalog ID

Prompt Table: CATALOG_VW

4 DEFAULT_IND Character(1) VARCHAR2(1) NOT NULL Default Election
N=No
Y=Yes

Y/N Table Edit

Default Value: N