EOEC_MP_ROLRULE(SQL Table) |
Index Back |
---|---|
Dataset Role RulesStores the dataset rules for each mobile distribution role. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
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
Prompt Table: EOEC_MP_RULE |
4 | 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 Default Value: N |
5 | 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 Default Value: N |