WM_CLOSE_AET (SQL Table)	Index Back
WM Close AE State Table

WM_CLOSE_AET

(SQL Table)

WM Close AE State Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 SELECT_COUNT Number(10,0) DECIMAL(10) NOT NULL SQL Select Count

4 ERROR_COUNT Number(9,0) DECIMAL(9) NOT NULL Error Count

5 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine

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

7 MANUAL_CLOSE_DT Date(10) DATE Manual Close Date

8 WO_PROC_OPTION Character(1) VARCHAR2(1) NOT NULL WO processing options
A=All
B=Business unit
G=Service Group
L=WO Task
S=Shop
T=Work order Type
W=Work Order

9 PROCESS_TXN_TYPE Character(1) VARCHAR2(1) NOT NULL Process transaction type
A=All (Work Order and Request)
O=Work Order
R=Service Request

10 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

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

12 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

13 LASTUPDDTTM 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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	SELECT_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	SQL Select Count
4	ERROR_COUNT	Number(9,0)	DECIMAL(9) NOT NULL	Error Count
5	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	MANUAL_CLOSE_DT	Date(10)	DATE	Manual Close Date
8	WO_PROC_OPTION	Character(1)	VARCHAR2(1) NOT NULL	WO processing options A=All B=Business unit G=Service Group L=WO Task S=Shop T=Work order Type W=Work Order
9	PROCESS_TXN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Process transaction type A=All (Work Order and Request) O=Work Order R=Service Request
10	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
11	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
12	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	LASTUPDDTTM	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.