WM_EIP_TSK_VW

(SQL View)
 Index Back

Work Order Task header Table

Work Order task Header Table

SELECT BUSINESS_UNIT , WO_ID , WO_TASK_ID , BUSINESS_UNIT_AM , ASSET_ID , DESCR254 , STATUS_CD , INTERNAL_STATUS , ACTL_START_DT , ACTL_START_TIME , ACTL_END_DT , ACTL_END_TIME , SCHED_START_DT , SCHED_START_TIME , SCHED_END_DT , SCHED_END_TIME , PROBLEM_GROUP , PROBLEM_CD , CAUSE_CD , RESOLUTION_CD , ACTIVITY_ID , PROCESS_MAN_CLOSE FROM PS_WM_WO_TSK

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

Prompt Table: BUS_UNIT_AM_VW

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

Prompt Table: WM_ASSET_VWA

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

Default Value: WM_WO_HDR.DESCR254

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

Prompt Table: WM_STATUS_TSK

8 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
9 ACTL_START_DT Date(10) DATE Actual Start Date
10 ACTL_START_TIME Time(15) TIMESTAMP Actual Start Time
11 ACTL_END_DT Date(10) DATE Actual End Date
12 ACTL_END_TIME Time(15) TIMESTAMP Actual End Time
13 SCHED_START_DT Date(10) DATE Scheduled Start Date
14 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
15 SCHED_END_DT Date(10) DATE Scheduled End Date
16 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time
17 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

Prompt Table: WM_PCR_CLSF_DVW

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

Prompt Table: WM_PCR_PRBAC_VW

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

Prompt Table: WM_PCR_CSEAC_VW

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

Prompt Table: WM_PCR_RESAC_VW

21 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
22 PROCESS_MAN_CLOSE Character(1) VARCHAR2(1) NOT NULL Process Manual Close
N=No
P=Processed
Y=Yes