WM_INSP_ROL_DTL(SQL Table) |
Index Back |
|---|---|
Inspection Alert Role Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: WM_INSP_ROL_EFF.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Default Value: WM_INSP_ROL_EFF.ROLENAME Prompt Table: WM_ROLENAME_VW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: WM_INSP_ROL_EFF.EFFDT |
| 4 | ROLEUSER |
Character(30) | VARCHAR2(30) NOT NULL |
Role User
Prompt Table: WM_INROL_USR_VW |
| 5 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table: WM_INSPL_BU_VW |
| 6 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Group
Prompt Table: %EDITTABLE |
| 7 | MAINT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
This field is used for maintenance type
Prompt Table: WM_MNTTP_EFF_VW |
| 8 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table: %EDITTABLE2 |
| 9 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table: WM_WO_TYPE |
| 10 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |