EOPM_REFSES_VW (SQL View)	Index Back
PUM reference list Reference list, permissions

EOPM_REFSES_VW

(SQL View)

PUM reference list

Reference list, permissions

SELECT PTSF_SRCHGRP_NAME , ' ' , CLASSID FROM PS_SCRTY_SRCHGRP UNION SELECT ' ' , EOPM_ORIGINNAME , CLASSID FROM PS_EOPM_PERMORIGIN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTSF_SRCHGRP_NAME Character(65) VARCHAR2(65) NOT NULL Search Group Name
Prompt Table: PTUS_GROUPS_VW

2 EOPM_ORIGINNAME Character(30) VARCHAR2(30) NOT NULL origininal name of permission lists, roles or menus that were cloned or renmaed

3 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSF_SRCHGRP_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Group Name Prompt Table: PTUS_GROUPS_VW
2	EOPM_ORIGINNAME	Character(30)	VARCHAR2(30) NOT NULL	origininal name of permission lists, roles or menus that were cloned or renmaed
3	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).