WM_WO_TTMPL_INS (SQL Table)	Index Back
WO Task Tmplt Instructions WO Task Template -- Instructions

WM_WO_TTMPL_INS

(SQL Table)

WO Task Tmplt Instructions

WO Task Template -- Instructions

Related Language Record: WM_WO_TTINS_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

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

6 DESCRLONG Long Character CLOB NOT NULL 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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	WO_TEMPLATE_ID	Character(25)	VARCHAR2(25) NOT NULL	Work Order Task/Job Template ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long Default Value: 1
5	STEP	Number(2,0)	SMALLINT NOT NULL	Step
6	DESCRLONG	Long Character	CLOB NOT NULL	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.