ROLEUSERBCNAMEEOEC_RULENAMEY/N Table Edit
Y/N Table Edit
EOEC_MP_USRRULE(SQL Table) |
Index Back |
|---|---|
Data Dist. Rules by Userstores the customized dataset rules for a given user. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLEUSER |
Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 2 | BCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Component Name (see PSBCDEFN). |
| 3 | EOEC_RULENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table |
| 4 | EOEC_DATASETNAME | Character(30) | VARCHAR2(30) NOT NULL | The name of one or more rules that will be used to filter a rowset. |
| 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_UPDATE | Character(1) | VARCHAR2(1) NOT NULL | came with the crm import. |