WM_EIP_INS_VW (SQL View)	Index Back
Work Order Task Instruction Work Order Task Instruction

WM_EIP_INS_VW

(SQL View)

Work Order Task Instruction

SELECT BUSINESS_UNIT , WO_ID , WO_TASK_ID , SEQ_NBR_5 , STEP , DESCRLONG , LAST_UPDATED_BY , LAST_UPDATE_DTTM FROM PS_WM_TSK_INST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

4 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long

5 STEP Number(2,0) SMALLINT NOT NULL Step

6 DESCRLONG Long Character CLOB Long Description

7 LAST_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL LastUpdatedUser

8 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
3	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
4	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long
5	STEP	Number(2,0)	SMALLINT NOT NULL	Step
6	DESCRLONG	Long Character	CLOB	Long Description
7	LAST_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	LastUpdatedUser
8	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.