BUSINESS_UNITPrompt Table: SP_BU_WM_NONVW
SHOP_IDCREW_IDCRAFT_IDPrompt Table: RS_RES_CRAFT
WM_CS_CRAFT_VW(SQL View) |
Index Back |
|---|---|
Crew Resources |
| SELECT DISTINCT A.BUSINESS_UNIT , A.SHOP_ID , A.CREW_ID , A.CRAFT_ID FROM PS_WM_CREW_RS A WHERE %EffdtCheck(WM_CREW_RS, A , %CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_WM_NONVW |
| 2 | SHOP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
| 3 | CREW_ID |
Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 4 | CRAFT_ID |
Character(16) | VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table: RS_RES_CRAFT |