WM_LBR_ASGN_VW1

(SQL View)
 Index Back

Labor Assignment View


SELECT A.BUSINESS_UNIT , A.WO_ID , B.WO_TASK_ID , C.RES_LN_NBR , C.RQMT_LN_NBR , A.SHOP_ID , C.CRAFT_ID , C.EMPLID , 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 , 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 , %subrec(WM_CREW_SBR, B) , B.REQ_START_DT , B.REQ_START_TIME , B.REQ_END_DT , B.REQ_END_TIME , C.SCHED_START_DT , C.SCHED_START_TIME , C.SCHED_END_DT , C.SCHED_END_TIME , C.SCHED_DURATION , %subrec(WM_CREW_SBR, C) , C.ASSIGNMENT_ID , C.ACTL_START_DT , C.ACTL_DURATION , C.PROCURE_STATUS , S.MAN_OVERBOOK_FLG FROM PS_WM_WO_HDR A , PS_WM_WO_TSK B , PS_WM_WO_SCHED_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_SCHED_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 A.WO_APPROVAL_STATUS = 'A' AND B.INTERNAL_STATUS NOT IN('05', '06', '07', '09') AND C.PROCURE_STATUS = '1'

# 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 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Default Value: WM_WO_TSK.LAST_SCHEDLN_LBR

5 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number

Default Value: WM_WO_TSK.LAST_RQMTLN_LBR

6 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Default Value: OPR_DEF_TBL_WM.SHOP_ID

Prompt Table: WM_SHOP_LOC_VW

7 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_CRAFT_DETAIL

8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_ELGBL_WRKR

9 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE

10 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

Prompt Table: WM_PRIORITY

11 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

12 HDR_REQ_START_DT Date(10) DATE Required Start
13 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime
14 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

15 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID
16 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

17 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: WM_PC_PRJ_DVW

18 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACT_FS

19 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

Default Value: WM_WO_HDR.DESCR254

20 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_TSK

21 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
22 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: BUS_UNIT_AM_VW

23 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VWA

24 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location

Prompt Table: LOCATION_VW

25 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: AM_AREA_TBL

26 ASSET_UP_FLG Character(1) VARCHAR2(1) NOT NULL Asset in Production Flag
27 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

28 RES_LBR_EXIST Character(1) VARCHAR2(1) NOT NULL Labor exists flag - used on WO

Y/N Table Edit

Default Value: N

29 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

30 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

31 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

32 LAST_SCHEDLN_LBR Number(8,0) INTEGER NOT NULL Requirement Line Number

Default Value: 1

33 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor

Prompt Table: WM_SHOP_RES_VW2

34 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code

Prompt Table: WM_SCHEDULER_VW

35 LEAD_PERSON Character(30) VARCHAR2(30) NOT NULL Lead Person

Prompt Table: WM_OPRID_VW

36 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

Prompt Table: WM_PCR_CLSF_DVW

37 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code

Prompt Table: WM_PCR_PRBAC_VW

38 CAUSE_CD Character(15) VARCHAR2(15) NOT NULL Cause Code

Prompt Table: WM_PCR_CSEAC_VW

39 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code

Prompt Table: WM_PCR_RESAC_VW

40 CREW_BU_TSK Character(5) VARCHAR2(5) NOT NULL Crew Business Unit
41 CREW_SHOP_TSK Character(10) VARCHAR2(10) NOT NULL Crew Shop ID
42 CREW_ID_TSK Character(10) VARCHAR2(10) NOT NULL Crew Name
43 REQ_START_DT Date(10) DATE Required Start

Default Value: WM_WO_TSK.REQ_START_DT

44 REQ_START_TIME Time(15) TIMESTAMP Required Start Time

Default Value: WM_WO_TSK.REQ_START_TIME

45 REQ_END_DT Date(10) DATE Required End

Default Value: WM_WO_TSK.REQ_END_DT

46 REQ_END_TIME Time(15) TIMESTAMP Required End Time

Default Value: WM_WO_TSK.REQ_END_TIME

47 SCHED_START_DT Date(10) DATE Scheduled Start Date
48 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
49 SCHED_END_DT Date(10) DATE Scheduled End Date
50 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time
51 SCHED_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Scheduled Duration
52 CREW_BU Character(5) VARCHAR2(5) NOT NULL Crew Business Unit

Prompt Table: SP_BU_WM_NONVW

53 CREW_SHOP Character(10) VARCHAR2(10) NOT NULL Crew Shop ID

Prompt Table: WM_CREWSHOP_VW

54 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name

Prompt Table: WM_PREFCREW_VW

55 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
56 ACTL_START_DT Date(10) DATE Actual Start Date
57 ACTL_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Actual Duration
58 PROCURE_STATUS Character(2) VARCHAR2(2) NOT NULL Indicates whether or not a Labor or a Tools resource in Maintenance Management is being procured.
1=No Procurement
2=Being Procured

Default Value: 1

59 MAN_OVERBOOK_FLG Character(1) VARCHAR2(1) NOT NULL Require Manual Override