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
Set Control Field: BUSINESS_UNIT

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