WM_WO_ATLS2_VW (SQL View)	Index Back
Tools View This view is used for Entering Tools usage entry

WM_WO_ATLS2_VW

(SQL View)

Tools View

This view is used for Entering Tools usage entry

SELECT T.BUSINESS_UNIT , T.WO_ID , T.WO_TASK_ID , T.RES_LN_NBR , T.RQMT_LN_NBR , T.ASSET_TYPE , T.ASSET_SUBTYPE , T.MODEL , T.BUSINESS_UNIT_AM , T.MFG_ID , T.ASSET_ID , T.SCHED_START_DT , T.SCHED_START_TIME , T.SCHED_END_DT , T.SCHED_END_TIME , T.SCHED_COST_TLS , T.SCHED_DURATION , T.SCHED_USAGE , T.ACTL_START_DT , T.ACTL_START_TIME , T.ACTL_END_DT , T.ACTL_END_TIME , T.ACTL_DURATION , T.ACTL_COST_TLS , T.ACTL_USAGE , T.TOOL_COST_RATE , T.TOOL_BILL_RATE , T.CURRENCY_CD , T.TOOL_COST_RATE_ACT , T.TOOL_BILL_RATE_ACT , T.TOOL_UOM , T.TRANS_DT , T.ACCOUNTING_DT , T.ASSIGNMENT_ID , T.PROCURE_STATUS , T.MAX_DISTRIB_LINE , '2' , TSK.INTERNAL_STATUS , TSK.STATUS_CD FROM PS_WM_WO_SCHED_TLS T , PS_WM_WO_TSK TSK WHERE %Join(COMMON_KEYS, WM_WO_SCHED_TLS T, WM_WO_TSK TSK)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: WM_WOE_WRK.BUSINESS_UNIT
Prompt Table: SP_BU_WM_NONVW

2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
Prompt Table: WM_OPEN_WO_DV

3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
Prompt Table: WM_OPEN_TSK_DV

4 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
Default Value: 0
Prompt Table: %EDIT_RES_LINE

5 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number
Prompt Table: WM_WO_RQMT_TOOL

6 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

7 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
Prompt Table: AM_SUBTYPE

8 MODEL Character(30) VARCHAR2(30) NOT NULL Model
Prompt Table: WM_ASSET_VW3

9 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
Prompt Table: SP_BU_AM_NONVW

10 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

11 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
Prompt Table: %EDITTABLE4

12 SCHED_START_DT Date(10) DATE Scheduled Start Date

13 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time

14 SCHED_END_DT Date(10) DATE Scheduled End Date

15 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time

16 SCHED_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Schedule Tools Cost

17 SCHED_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Scheduled Duration

18 SCHED_USAGE Signed Number(9,2) DECIMAL(7,2) NOT NULL Scheduled Usage

19 ACTL_START_DT Date(10) DATE Actual Start Date

20 ACTL_START_TIME Time(15) TIMESTAMP Actual Start Time

21 ACTL_END_DT Date(10) DATE Actual End Date

22 ACTL_END_TIME Time(15) TIMESTAMP Actual End Time

23 ACTL_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Actual Duration

24 ACTL_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Tools Cost

25 ACTL_USAGE Signed Number(9,2) DECIMAL(7,2) NOT NULL Actual Usage

26 TOOL_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate

27 TOOL_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate

28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY

29 TOOL_COST_RATE_ACT Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
Default Value: WM_WO_ATLS_VW.TOOL_COST_RATE

30 TOOL_BILL_RATE_ACT Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
Default Value: WM_WO_ATLS_VW.TOOL_BILL_RATE

31 TOOL_UOM Character(3) VARCHAR2(3) NOT NULL Tools Unit of Measure

32 TRANS_DT Date(10) DATE Transaction Date
Default Value: %DATE

33 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %DATE

34 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

35 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

36 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line

37 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
Default Value: 2

38 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: WM_WOE_WRK.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW
2	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Prompt Table: WM_OPEN_WO_DV
3	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number Prompt Table: WM_OPEN_TSK_DV
4	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No. Default Value: 0 Prompt Table: %EDIT_RES_LINE
5	RQMT_LN_NBR	Number(5,0)	INTEGER NOT NULL	Requirement Line Number Prompt Table: WM_WO_RQMT_TOOL
6	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
7	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	Asset Subtype Prompt Table: AM_SUBTYPE
8	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model Prompt Table: WM_ASSET_VW3
9	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Prompt Table: SP_BU_AM_NONVW
10	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
11	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Prompt Table: %EDITTABLE4
12	SCHED_START_DT	Date(10)	DATE	Scheduled Start Date
13	SCHED_START_TIME	Time(15)	TIMESTAMP	Schedule Start Time
14	SCHED_END_DT	Date(10)	DATE	Scheduled End Date
15	SCHED_END_TIME	Time(15)	TIMESTAMP	Schedule End Time
16	SCHED_COST_TLS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Schedule Tools Cost
17	SCHED_DURATION	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Scheduled Duration
18	SCHED_USAGE	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Scheduled Usage
19	ACTL_START_DT	Date(10)	DATE	Actual Start Date
20	ACTL_START_TIME	Time(15)	TIMESTAMP	Actual Start Time
21	ACTL_END_DT	Date(10)	DATE	Actual End Date
22	ACTL_END_TIME	Time(15)	TIMESTAMP	Actual End Time
23	ACTL_DURATION	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Actual Duration
24	ACTL_COST_TLS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Tools Cost
25	ACTL_USAGE	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Actual Usage
26	TOOL_COST_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Rate
27	TOOL_BILL_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Billing Rate
28	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY
29	TOOL_COST_RATE_ACT	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Rate Default Value: WM_WO_ATLS_VW.TOOL_COST_RATE
30	TOOL_BILL_RATE_ACT	Number(27,3)	DECIMAL(26,3) NOT NULL	Billing Rate Default Value: WM_WO_ATLS_VW.TOOL_BILL_RATE
31	TOOL_UOM	Character(3)	VARCHAR2(3) NOT NULL	Tools Unit of Measure
32	TRANS_DT	Date(10)	DATE	Transaction Date Default Value: %DATE
33	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple Default Value: %DATE
34	ASSIGNMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Assignment ID
35	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
36	MAX_DISTRIB_LINE	Number(5,0)	INTEGER NOT NULL	Highest Distribution Line
37	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material Default Value: 2
38	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
39	STATUS_CD	Character(4)	VARCHAR2(4) NOT NULL	User defined Status Code