EOPM_REFACM_VW

(SQL View)
Index Back

PUM reference list ACM

Reference list, permissions for ACM. Used by Security Deployment tool

SELECT PTACM_TEMPL_NAME , ' ' , CLASSID FROM PS_PTACM_ACCESSTBL UNION SELECT ' ' , EOPM_ORIGINNAME , CLASSID FROM PS_EOPM_PERMORIGIN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTACM_TEMPL_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
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).