EOCM_UNSPS_RQST (SQL Table)	Index Back
RQST record for load UNSPSC Request record for load UNSPSC used by Application Engine program

EOCM_UNSPS_RQST

(SQL Table)

RQST record for load UNSPSC

Request record for load UNSPSC used by Application Engine program

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 EOCM_CAT_HIER_ID Character(32) VARCHAR2(32) NOT NULL Catalog Hierarchy ID

4 EOCM_CAT_HIER_NM Character(32) VARCHAR2(32) NOT NULL Category Hierarchy Name

5 EOCM_INDUS_CAT Character(1) VARCHAR2(1) NOT NULL Industry standard hierarchies
P=PS Tree
U=UNSPSC

6 EOCM_INDUS_CAT_NM Character(150) VARCHAR2(150) NOT NULL Industry standard Category NM

7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

8 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: EOCM_TREENM_VW

9 EOCM_CATEGORY_CD Character(32) VARCHAR2(32) NOT NULL Category Code
Prompt Table: EOCM_TREE_FIELD

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

11 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EOCM_CAT_HIER_ID	Character(32)	VARCHAR2(32) NOT NULL	Catalog Hierarchy ID
4	EOCM_CAT_HIER_NM	Character(32)	VARCHAR2(32) NOT NULL	Category Hierarchy Name
5	EOCM_INDUS_CAT	Character(1)	VARCHAR2(1) NOT NULL	Industry standard hierarchies P=PS Tree U=UNSPSC
6	EOCM_INDUS_CAT_NM	Character(150)	VARCHAR2(150) NOT NULL	Industry standard Category NM
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
8	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: EOCM_TREENM_VW
9	EOCM_CATEGORY_CD	Character(32)	VARCHAR2(32) NOT NULL	Category Code Prompt Table: EOCM_TREE_FIELD
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.