EP_PG_USER_PATH (SQL Table)	Index Back
EP_PG_USER_PATH Used in Document status pivot chart published in Manager Dash Board as a pagelet. Change Settings Hierarchical Path table.

EP_PG_USER_PATH

(SQL Table)

EP_PG_USER_PATH

Used in Document status pivot chart published in Manager Dash Board as a pagelet. Change Settings Hierarchical Path table.

# 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 LEVEL_NBR Number(3,0) SMALLINT NOT NULL This field is used by the record SEN_PAY_COMPRT.

3 EP_MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager/Mentor ID.

4 SUPERVISOR_ERN Number(3,0) SMALLINT NOT NULL This is used to hold the Employment Record Number of a supervisor.

#	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	LEVEL_NBR	Number(3,0)	SMALLINT NOT NULL	This field is used by the record SEN_PAY_COMPRT.
3	EP_MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager/Mentor ID.
4	SUPERVISOR_ERN	Number(3,0)	SMALLINT NOT NULL	This is used to hold the Employment Record Number of a supervisor.