WM_LBR_ASGN_VW

(SQL View)
 Index Back

Labor Assignment View

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.SHOP_ID , C.SHIFT_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 , 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 , %subrec(WM_CREW_SBR, B) , B.REQ_START_DT , B.REQ_START_TIME , B.REQ_END_DT , B.REQ_END_TIME , B.SCHED_START_DT , B.SCHED_START_TIME , B.SCHED_END_DT , B.SCHED_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 , C.MAX_DISTRIB_LINE , A.STANDING_WO_FLG , D.HAZARDOUS_SW , D.ASSET_CRITICALITY , D.SERIAL_ID , D.TAG_NUMBER , D.DESCR , D.DESCR_LONG , D.ASSET_TYPE , D.ASSET_SUBTYPE , D.MFG_ID , D.MODEL , D.COMPONENT_OF_ID , ( SELECT COUNT(*) FROM PS_ASSET_WARRANTY X WHERE X.BUSINESS_UNIT = B.BUSINESS_UNIT_AM AND X.ASSET_ID = B.ASSET_ID AND %EffdtCheck(ASSET_WARRANTY Y, X, B.REQ_START_DT) AND X.EFF_STATUS = 'A' AND (X.END_DT >= B.REQ_START_DT OR X.END_DT IS NULL)) FROM PS_WM_WO_TSK B LEFT OUTER JOIN PS_ASSET D ON B.BUSINESS_UNIT_AM = D.BUSINESS_UNIT AND B.ASSET_ID = D.ASSET_ID, PS_WM_WO_HDR A , PS_WM_WO_SCHED_LBR C 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.WO_APPROVAL_STATUS = 'A' AND B.INTERNAL_STATUS NOT IN('05', '06', '07', '09') AND C.PROCURE_STATUS <> '2' AND NOT (C.EMPLID <> ' ' AND C.ASSIGNMENT_ID = ' ')

# 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
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 RES_SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
8 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID
9 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_CRAFT_DETAIL

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

Prompt Table: WM_ELGBL_WRKR

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

Prompt Table: WM_WO_TYPE

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

Prompt Table: WM_PRIORITY

13 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

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

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

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

Prompt Table: WM_PC_PRJ_DVW

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

Prompt Table: PROJ_ACT_FS

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

Default Value: WM_WO_HDR.DESCR254

22 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
23 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_TSK

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

Prompt Table: BUS_UNIT_AM_VW

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

Prompt Table: WM_ASSET_VWA

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

Prompt Table: LOCATION_VW

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

Prompt Table: AM_AREA_TBL

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

Prompt Table: LOCATION_TBL

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

Y/N Table Edit

Default Value: N

32 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

33 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

34 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

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

Default Value: 1

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

Prompt Table: WM_SHOP_RES_VW2

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

Prompt Table: WM_SCHEDULER_VW

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

Prompt Table: WM_OPRID_VW

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

Prompt Table: WM_PCR_CLSF_DVW

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

Prompt Table: WM_PCR_PRBAC_VW

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

Prompt Table: WM_PCR_CSEAC_VW

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

Prompt Table: WM_PCR_RESAC_VW

43 CREW_BU_TSK Character(5) VARCHAR2(5) NOT NULL Crew Business Unit
44 CREW_SHOP_TSK Character(10) VARCHAR2(10) NOT NULL Crew Shop ID
45 CREW_ID_TSK Character(10) VARCHAR2(10) NOT NULL Crew Name
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 TASK_SCHD_START_DT Date(10) DATE Scheduled Start Date
51 TASK_SCHD_STRT_TM Time(15) TIMESTAMP Schedule Start Time
52 TASK_SCHD_END_DT Date(10) DATE Scheduled End Date
53 TASK_SCHD_END_TM Time(15) TIMESTAMP Schedule End Time
54 SCHED_START_DT Date(10) DATE Scheduled Start Date

Default Value: WM_WO_TSK.SCHED_START_DT

55 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time

Default Value: WM_WO_TSK.SCHED_START_TIME

56 SCHED_END_DT Date(10) DATE Scheduled End Date

Default Value: WM_WO_TSK.SCHED_END_DT

57 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time

Default Value: WM_WO_TSK.SCHED_END_TIME

58 SCHED_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Scheduled Duration
59 CREW_BU Character(5) VARCHAR2(5) NOT NULL Crew Business Unit

Prompt Table: SP_BU_WM_NONVW

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

Prompt Table: WM_CREWSHOP_VW

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

Prompt Table: WM_PREFCREW_VW

62 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
63 ACTL_START_DT Date(10) DATE Actual Start Date
64 ACTL_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Actual Duration
65 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

66 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line
67 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

68 HAZARDOUS_SW Character(1) VARCHAR2(1) NOT NULL Hazardous Asset
69 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality
70 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
71 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
72 DESCR Character(30) VARCHAR2(30) NOT NULL Description
73 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
74 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
75 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

Prompt Table: AM_SUBTYPE

76 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
77 MODEL Character(30) VARCHAR2(30) NOT NULL Model
78 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
79 WM_WARRANTY_COUNT Number(5,0) INTEGER NOT NULL Warranty Count