EOEC_DATASETNAMEEOEC_RULENAMEA=Active
I=Inactive
Default Value: A
N=No
Y=Yes
Default Value: Y
Prompt Table: EOEC_MP_REC_VW
EOEC_MP_RULE(SQL Table) |
Index Back |
|---|---|
Dataset RuleEnterprise Components mobile dataset rule record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEC_DATASETNAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of one or more rules that will be used to filter a rowset. |
| 2 | EOEC_RULENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table |
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 4 | EOEC_MP_VALIDRULE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies if a rule is valid or not.
N=No Y=Yes Default Value: Y |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | SEARCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Search Record Name
Prompt Table: EOEC_MP_REC_VW |