WM_CREW_SCHD_VW(SQL View) |
Index Back |
---|---|
Crew Scheduling View |
SELECT A.BUSINESS_UNIT , A.WO_ID , B.WO_TASK_ID , C.RQMT_LN_NBR , A.SHOP_ID , A.WO_TYPE , A.PRIORITY_CD , A.SRVC_GRP_ID , A.REQ_START_DT , A.ENTERED_DTTM , A.MAINT_TYPE , A.PM_SCHD_ID , A.BUSINESS_UNIT_PC , A.PROJECT_ID , B.ACTIVITY_ID , B.DESCR254 , A.DESCR254 , B.STATUS_CD , B.INTERNAL_STATUS , B.BUSINESS_UNIT_AM , B.ASSET_ID , B.ASSET_LOCATION , B.AREA_ID , B.ASSET_UP_FLG , B.LOCATION , B.RES_LBR_EXIST , B.RES_TLS_EXIST , B.RES_MAT_EXIST , B.RES_PO_EXIST , B.LAST_SCHEDLN_LBR , B.SUPERVISOR , B.SCHEDULER_CODE , B.LEAD_PERSON , B.PROBLEM_GROUP , B.PROBLEM_CD , B.CAUSE_CD , B.RESOLUTION_CD , B.SCHED_START_DT , B.SCHED_START_TIME , B.SCHED_END_DT , B.SCHED_END_TIME , %subrec(WM_CREW_SBR, B) , C.SCHED_GENERATED , C.REQ_START_DT , C.REQ_START_TIME , C.REQ_END_DT , C.REQ_END_TIME , C.SCHED_START_DT , C.SCHED_START_TIME , C.SCHED_END_DT , C.SCHED_END_TIME , C.LABOR_COST_RATE , C.LABOR_BILL_RATE , C.CURRENCY_CD , C.CRAFT_ID , C.RQMT_QTY , C.REQ_DURATION , C.RQMT_QTY * C.REQ_DURATION , %subrec(WM_CREW_SBR, C) , C.CREW_SCHED_STATUS , C.SCHED_PATTERN , C.PERIOD_START_DT , C.WO_SCHED_HRS , C.REMAINING_MAN_HRS , C.COMPLETE_HRS , C.COMPLTED_DT , A.STANDING_WO_FLG FROM PS_WM_WO_HDR A , PS_WM_WO_TSK B , PS_WM_WO_RQMT_LBR C , PS_WM_SHOP_HDR S WHERE %Join(COMMON_KEYS, WM_WO_HDR A, WM_WO_TSK B) AND %Join(COMMON_KEYS, WM_WO_TSK B, WM_WO_RQMT_LBR C) AND A.BUSINESS_UNIT = S.BUSINESS_UNIT AND A.SHOP_ID = S.SHOP_ID AND %EffdtCheck(WM_SHOP_HDR SAUX, S, %CurrentDateIn) AND S.EFF_STATUS = 'A' AND S.SCHED_CREW_FLG = 'Y' AND A.WO_APPROVAL_STATUS = 'A' AND B.INTERNAL_STATUS NOT IN('05', '06', '07', '09') |
# | 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 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
3 | WO_TASK_ID | Number(5,0) | INTEGER NOT NULL |
Task Number
Default Value: 1 |
4 | RQMT_LN_NBR | Number(5,0) | INTEGER NOT NULL |
Requirement Line Number
Default Value: WM_WO_TSK.LAST_RQMTLN_LBR |
5 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Default Value: OPR_DEF_TBL_WM.SHOP_ID Prompt Table: WM_SHOP_LOC_VW |
6 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table: WM_WO_TYPE |
7 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table: WM_PRIORITY |
8 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Group
Default Value: OPR_DEF_TBL_WM.SRVC_GRP_ID Prompt Table: WM_SRVC_GRP_BU |
9 | HDR_REQ_START_DT | Date(10) | DATE | Required Start |
10 | ENTERED_DTTM | DateTime(26) | TIMESTAMP | Entered Datetime |
11 | MAINT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
This field is used for maintenance type
Prompt Table:
MAINT_TYPE_TBL
|
12 | PM_SCHD_ID | Character(10) | VARCHAR2(10) NOT NULL | Preventive Maintenance Schedule ID |
13 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Default Value: BUS_UNIT_TBL_WM.BUSINESS_UNIT_PC Prompt Table: BUS_UNIT_TBL_PC |
14 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: WM_PC_PRJ_DVW |
15 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_FS |
16 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL |
Description of length 254
Default Value: WM_WO_HDR.DESCR254 |
17 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
18 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table: WM_STATUS_TSK |
19 | INTERNAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Internal Status
01=Open 02=Awaiting Schedule 03=Scheduled 04=Work In Progress 05=Complete 06=Closed 07=Canceled 08=On Hold 09=Work Order Created |
20 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: BUS_UNIT_AM_VW |
21 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: WM_ASSET_VWA |
22 | ASSET_LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Asset Location
Prompt Table: LOCATION_VW |
23 | AREA_ID | Character(10) | VARCHAR2(10) NOT NULL |
Area ID
Prompt Table: AM_AREA_TBL |
24 | ASSET_UP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Asset in Production Flag |
25 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
26 | RES_LBR_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Labor exists flag - used on WO
Y/N Table Edit Default Value: N |
27 | RES_TLS_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Tools exists flag - indicates if Tools exists on a WO
Y/N Table Edit Default Value: N |
28 | RES_MAT_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Inventory exists flag - indicates if inventory exists on WO
Y/N Table Edit Default Value: N |
29 | RES_PO_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Procurement exists flag - indicates if Procurement exists in WO
Y/N Table Edit Default Value: N |
30 | LAST_SCHEDLN_LBR | Number(8,0) | INTEGER NOT NULL |
Requirement Line Number
Default Value: 1 |
31 | SUPERVISOR | Character(30) | VARCHAR2(30) NOT NULL |
Supervisor
Prompt Table: WM_SHOP_RES_VW2 |
32 | SCHEDULER_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Scheduler Code
Prompt Table: WM_SCHEDULER_VW |
33 | LEAD_PERSON | Character(30) | VARCHAR2(30) NOT NULL |
Lead Person
Prompt Table: WM_OPRID_VW |
34 | PROBLEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL |
Problem Group
Prompt Table: WM_PCR_CLSF_DVW |
35 | PROBLEM_CD | Character(15) | VARCHAR2(15) NOT NULL |
Problem code
Prompt Table: WM_PCR_PRBAC_VW |
36 | CAUSE_CD | Character(15) | VARCHAR2(15) NOT NULL |
Cause Code
Prompt Table: WM_PCR_CSEAC_VW |
37 | RESOLUTION_CD | Character(15) | VARCHAR2(15) NOT NULL |
Resolution code
Prompt Table: WM_PCR_RESAC_VW |
38 | TASK_SCHD_START_DT | Date(10) | DATE | Scheduled Start Date |
39 | TASK_SCHD_STRT_TM | Time(15) | TIMESTAMP | Schedule Start Time |
40 | TASK_SCHD_END_DT | Date(10) | DATE | Scheduled End Date |
41 | TASK_SCHD_END_TM | Time(15) | TIMESTAMP | Schedule End Time |
42 | CREW_BU_TSK | Character(5) | VARCHAR2(5) NOT NULL | Crew Business Unit |
43 | CREW_SHOP_TSK | Character(10) | VARCHAR2(10) NOT NULL | Crew Shop ID |
44 | CREW_ID_TSK | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
45 | SCHED_GENERATED | Number(11,0) | DECIMAL(11) NOT NULL | Schedules Generated |
46 | REQ_START_DT | Date(10) | DATE |
Required Start
Default Value: WM_WO_TSK.REQ_START_DT |
47 | REQ_START_TIME | Time(15) | TIMESTAMP |
Required Start Time
Default Value: WM_WO_TSK.REQ_START_TIME |
48 | REQ_END_DT | Date(10) | DATE |
Required End
Default Value: WM_WO_TSK.REQ_END_DT |
49 | REQ_END_TIME | Time(15) | TIMESTAMP |
Required End Time
Default Value: WM_WO_TSK.REQ_END_TIME |
50 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
51 | SCHED_START_TIME | Time(15) | TIMESTAMP | Schedule Start Time |
52 | SCHED_END_DT | Date(10) | DATE | Scheduled End Date |
53 | SCHED_END_TIME | Time(15) | TIMESTAMP | Schedule End Time |
54 | LABOR_COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
55 | LABOR_BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
56 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY |
57 | CRAFT_ID | Character(16) | VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table: RS_CRAFT_DETAIL |
58 | RQMT_QTY | Signed Number(12,0) | DECIMAL(11) NOT NULL | Required Quantity |
59 | REQ_DURATION | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Schedule Duration |
60 | REQ_MAN_HRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Estimated Man Hours |
61 | CREW_BU | Character(5) | VARCHAR2(5) NOT NULL |
Crew Business Unit
Prompt Table: SP_BU_WM_NONVW |
62 | CREW_SHOP | Character(10) | VARCHAR2(10) NOT NULL |
Crew Shop ID
Prompt Table: WM_CREWSHOP_VW |
63 | CREW_ID | Character(10) | VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table: WM_PREFCREW_VW |
64 | CREW_SCHED_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Crew Schedule Status
1=Unscheduled 2=Scheduled 3=Unplanned / Emergency 4=Schedule Confirmed Default Value: 1 |
65 | SCHED_PATTERN | Character(5) | VARCHAR2(5) NOT NULL | Schedule Pattern |
66 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
67 | WO_SCHED_HRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Scheduled Hours |
68 | REMAINING_MAN_HRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Carryover Hours |
69 | COMPLETE_HRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Completed hours |
70 | COMPLTED_DT | Date(10) | DATE | Completed Date |
71 | STANDING_WO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Standing Work Order indicator
N=Non-Standing Y=Standing Y/N Table Edit Default Value: N |