RC_ER_ACCESS_VW

(SQL View)
Index Back

ER Access View

All alias access view for Employee Relations Cases

SELECT DISP_TMPL_FAM_CD ,ROLENAME ,RC_CASE_ACCESS FROM PS_RC_ER_ROLE_MAP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
2 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
3 RC_CASE_ACCESS Character(4) VARCHAR2(4) NOT NULL Case access field for employee relations cases
AGT1=Agent: Read/Write All Pages
PNL1=Panelist: Read/Write Case Note