PTUPG_STATE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	PTUPG_PATH	Character(4)	VARCHAR2(4) NOT NULL	Definition of supported upgrade paths 7084=PeopleTools 7.0x to 8.4x 7584=PeopleTools 7.5x to 8.4x 8184=PeopleTools 8.1x to 8.4x 8484=PeopleTools 8.4x to 8.4x
5	PTUPG_GROUP_SEQNUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
6	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
7	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
8	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
9	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name
10	AE_SQLROWS	Number(10,0)	DECIMAL(10) NOT NULL	Rows affected by last SQL stmt
11	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive
12	PTUPG_DTTMSTAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
13	PTUPG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag
14	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
15	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
16	PTUPG_NULL_DATE	Date(10)	DATE	Null Work Date
17	PTUPG_NULL_DTTM	DateTime(26)	TIMESTAMP	Null Work Date Time