CACHE_RECNAMEPrompt Table: RECDEFN_VW
RB_MDDR_USER_VW(SQL View) |
Index Back |
|---|---|
Mobile DDR - Cache Table UsersMobile DDR - Cache Table Users.......... |
| SELECT DISTINCT R.CACHE_RECNAME , U.ROLEUSER FROM PS_RB_MDDR_ROLE R , PSROLEUSER U WHERE R.ROLENAME = U.ROLENAME |
| # | 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 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |