WM_CSINQ_SRCH(SQL Table) |
Index Back |
|---|---|
Crew Schedule Inquiry Search |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW |
| 2 | SHOP_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Default Value: BUS_UNIT_TBL_WM.SHOP_ID Prompt Table: WM_SHOP_BU_VW |
| 3 | CREW_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Crew Name
Default Value: WM_CREW_DEFN_VW.CREW_ID Prompt Table: WM_CREW_DEFN_VW |
| 4 | PERIOD_STARTDT_BGN |
Date(10) | DATE NOT NULL | First Period Start Date |
| 5 | PERIOD_STARTDT_END | Date(10) | DATE | Last Period Start Date |
| 6 | SUPERVISOR | Character(30) | VARCHAR2(30) NOT NULL |
Supervisor
Default Value: WM_SUPER_VW.SUPERVISOR Prompt Table: WM_SUPER_VW |
| 7 | CRAFT_ID | Character(16) | VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table: WM_CS_CRAFT_VW |