CACHE_RECNAMEPrompt Table: RECDEFN_VW
Prompt Table: RECDEFN_VW
A=Active
I=Inactive
Default Value: A
A=Download all Rows
C=Filter By Row Count
D=Filter By Dataset
Default Value: D
Prompt Table: EOEC_DATASET
RB_MDDR(SQL Table) |
Index Back |
|---|---|
New Mobile Dataset RulesNew Mobile Dataset Rules. Holds the dataset Rules for Mobile Cache tables. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CACHE_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Cache Record Name. Used for new Mobile.
Prompt Table: RECDEFN_VW |
| 2 | TXN_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Transaction Record Name. Used for new Mobile.
Prompt Table: RECDEFN_VW |
| 3 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: A |
| 4 | FILTER_BY | Character(1) | VARCHAR2(1) NOT NULL |
FILTER_BY
A=Download all Rows C=Filter By Row Count D=Filter By Dataset Default Value: D |
| 5 | EOEC_DATASETNAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of one or more rules that will be used to filter a rowset.
Prompt Table: EOEC_DATASET |
| 6 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |