OPRIDDefault Value: OPR_DEF_TBL_FS.OPRID
Prompt Table: OPRID_VW
Prompt Table: SP_BU_WM_NONVW
Prompt Table: SP_BU_AM_NONVW
Prompt Table: WM_SRVC_GRP
Prompt Table: WM_SHOP_VW3
WM_USERPREF_VW(SQL View) |
Index Back |
|---|---|
Mobile User Preferences |
| SELECT U.OPRID , U.BUSINESS_UNIT , U.BUSINESS_UNIT_AM , U.SRVC_GRP_ID , U.SHOP_ID , O. EMPLID , P.NAME , ' ' FROM PS_OPR_DEF_TBL_WM U , PSOPRDEFN O , PS_PERSONAL_DATA P WHERE %Join(COMMON_KEYS, OPR_DEF_TBL_WM U, PSOPRDEFN O) AND P.EMPLID = O.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPRID_VW |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_WM_NONVW |
| 3 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 4 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Group
Prompt Table: WM_SRVC_GRP |
| 5 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table: WM_SHOP_VW3 |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 8 | VALID_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Valid XLAT flag |