RY_EE_USRDM_VW

(SQL View)
 Index Back

User-dimension security view

View of dimension visibility and defaults by User ID and Survey Type

SELECT UR.ROLEUSER , RD.RY_SVY_TYPE , RD.ACEDIMNAME , D.ACEDIMSEQUENCE , D.FIELDNAME , MAX(RD.VISIBLE_FLG) , MAX(RD.DEFAULT_FLG) FROM PSROLEUSER UR , PS_RY_SVY_ROLE_DIM RD , PS_RY_SVY_DIM_VW D WHERE UR.ROLENAME = RD.ROLENAME AND D.ACEMODELID = 'RY_EE_ACE_RPT' AND D.ACECOLLNAME = 'DASHBOARD_SCORE_RANGE' AND D.PNLNAME = 'RY_EE_SCR_RPT' AND RD.ACEDIMNAME = D.ACEDIMNAME GROUP BY UR.ROLEUSER , RD.RY_SVY_TYPE, RD.ACEDIMNAME, D.ACEDIMSEQUENCE, D.FIELDNAME

# 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 RY_SVY_TYPE Character(1) VARCHAR2(1) NOT NULL Survey Type
1=Workforce
3 ACEDIMNAME Character(30) VARCHAR2(30) NOT NULL Dimension Name
4 ACEDIMSEQUENCE Number(3,0) SMALLINT NOT NULL Dimension Sequence
5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
6 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Visible Flag
N=No
Y=Yes

Y/N Table Edit

7 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

Y/N Table Edit