EOPM_ROLEORIGIN (SQL View)	Index Back
Role Creation Tracking vw Track Role Creation (New, Save As, Customer).

EOPM_ROLEORIGIN

(SQL View)

Role Creation Tracking vw

Track Role Creation (New, Save As, Customer).

SELECT ' ' ,' ' ,' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN

2 EOPM_ORIGINTYPE Character(1) VARCHAR2(1) NOT NULL rename or clone. used for update automation where release < 8.55
C=Cloned Object
R=Renamed Object

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: PSROLEDEFN
2	EOPM_ORIGINTYPE	Character(1)	VARCHAR2(1) NOT NULL	rename or clone. used for update automation where release < 8.55 C=Cloned Object R=Renamed Object
3	EOPM_ORIGINNAME	Character(30)	VARCHAR2(30) NOT NULL	origininal name of permission lists, roles or menus that were cloned or renmaed