EOEC_MP_ORUL_VW (SQL View)	Index Back
Data Dist. New Rules by User SELECT DISTINCT B.ROLEUSER , C.EOEC_DATASETNAME , C.EOEC_RULENAME , E.SEARCHRECNAME , MAX(C.EOEC_MP_LAPTOP) , MAX(C.EOEC_MP_PDA) , X.EOEC_MP_LAPTOP , X.EOEC_MP_PDA FROM PSROLEDEFN A , PSROLEUSER B , PS_EOEC_MP_ROLRULE C , PS_EOEC_MP_RULE E , PS_EOEC_MP_USRRULE X WHERE A.ROLENAME = B.ROLENAME AND A.ROLENAME = C.ROLENAME AND C.EOEC_RULENAME = E.EOEC_RULENAME AND A.ROLESTATUS = 'A' AND E.STATUS = 'A' AND E.EOEC_MP_VALIDRULE = 'Y' AND X.ROLEUSER = B.ROLEUSER AND X.EOEC_DATASETNAME = C.EOEC_DATASETNAME AND X.EOEC_RULENAME = C.EOEC_RULENAME GROUP BY B.ROLEUSER, C.EOEC_DATASETNAME, C.EOEC_RULENAME, E.SEARCHRECNAME, X.EOEC_MP_LAPTOP, X.EOEC_MP_PDA

EOEC_MP_ORUL_VW

(SQL View)

Data Dist. New Rules by User

SELECT DISTINCT B.ROLEUSER , C.EOEC_DATASETNAME , C.EOEC_RULENAME , E.SEARCHRECNAME , MAX(C.EOEC_MP_LAPTOP) , MAX(C.EOEC_MP_PDA) , X.EOEC_MP_LAPTOP , X.EOEC_MP_PDA FROM PSROLEDEFN A , PSROLEUSER B , PS_EOEC_MP_ROLRULE C , PS_EOEC_MP_RULE E , PS_EOEC_MP_USRRULE X WHERE A.ROLENAME = B.ROLENAME AND A.ROLENAME = C.ROLENAME AND C.EOEC_RULENAME = E.EOEC_RULENAME AND A.ROLESTATUS = 'A' AND E.STATUS = 'A' AND E.EOEC_MP_VALIDRULE = 'Y' AND X.ROLEUSER = B.ROLEUSER AND X.EOEC_DATASETNAME = C.EOEC_DATASETNAME AND X.EOEC_RULENAME = C.EOEC_RULENAME GROUP BY B.ROLEUSER, C.EOEC_DATASETNAME, C.EOEC_RULENAME, E.SEARCHRECNAME, X.EOEC_MP_LAPTOP, X.EOEC_MP_PDA

SELECT DISTINCT B.ROLEUSER , C.EOEC_DATASETNAME , C.EOEC_RULENAME , E.SEARCHRECNAME , MAX(C.EOEC_MP_LAPTOP) , MAX(C.EOEC_MP_PDA) , X.EOEC_MP_LAPTOP , X.EOEC_MP_PDA FROM PSROLEDEFN A , PSROLEUSER B , PS_EOEC_MP_ROLRULE C , PS_EOEC_MP_RULE E , PS_EOEC_MP_USRRULE X WHERE A.ROLENAME = B.ROLENAME AND A.ROLENAME = C.ROLENAME AND C.EOEC_DATASETNAME = E.EOEC_DATASETNAME AND C.EOEC_RULENAME = E.EOEC_RULENAME AND A.ROLESTATUS = 'A' AND E.STATUS = 'A' AND E.EOEC_MP_VALIDRULE = 'Y' AND X.ROLEUSER = B.ROLEUSER AND X.EOEC_DATASETNAME = C.EOEC_DATASETNAME AND X.EOEC_RULENAME = C.EOEC_RULENAME GROUP BY B.ROLEUSER, C.EOEC_DATASETNAME, C.EOEC_RULENAME, E.SEARCHRECNAME, X.EOEC_MP_LAPTOP, X.EOEC_MP_PDA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

2 EOEC_DATASETNAME Character(30) VARCHAR2(30) NOT NULL The name of one or more rules that will be used to filter a rowset.

3 EOEC_RULENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table

4 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name

5 EOEC_MP_LAPTOP Character(1) VARCHAR2(1) NOT NULL Yes/No Field to indicate that the rule is used for a laptop.
Y/N Table Edit

6 EOEC_MP_PDA Character(1) VARCHAR2(1) NOT NULL Yes/No Field to indicate that the rule is used for a pda.
Y/N Table Edit

7 EOEC_MP_LAPTOP_USR Character(1) VARCHAR2(1) NOT NULL came with the crm import.
Y/N Table Edit

8 EOEC_MP_PDA_USER Character(1) VARCHAR2(1) NOT NULL came with the crm import.
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROLEUSER	Character(30)	VARCHAR2(30) NOT NULL	Role User
2	EOEC_DATASETNAME	Character(30)	VARCHAR2(30) NOT NULL	The name of one or more rules that will be used to filter a rowset.
3	EOEC_RULENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table
4	SEARCHRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Search Record Name
5	EOEC_MP_LAPTOP	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Field to indicate that the rule is used for a laptop. Y/N Table Edit
6	EOEC_MP_PDA	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Field to indicate that the rule is used for a pda. Y/N Table Edit
7	EOEC_MP_LAPTOP_USR	Character(1)	VARCHAR2(1) NOT NULL	came with the crm import. Y/N Table Edit
8	EOEC_MP_PDA_USER	Character(1)	VARCHAR2(1) NOT NULL	came with the crm import. Y/N Table Edit