UPG_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	PTIA_UPG_PATH	Character(15)	VARCHAR2(15) NOT NULL	Definition of supported upgrade paths
5	UPG_PI_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	PUM Image Level
6	UPG_RENAME_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Rename Type
7	UPG_GROUP_SEQ_NUM	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.
8	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
9	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
10	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
11	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name
12	AE_SQLROWS	Number(10,0)	DECIMAL(10) NOT NULL	Rows affected by last SQL stmt
13	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive
14	UPG_DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
15	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag
16	UPG_ORIG_TBLNAME	Character(18)	VARCHAR2(18) NOT NULL	Original Record Name
17	UPG_NEW_TBLNAME	Character(18)	VARCHAR2(18) NOT NULL	Original Record Name
18	UPG_ORIG_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Original Record Name
19	UPG_NEW_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Original Record Name
20	UPG_ORIG_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Original Field Name
21	UPG_NEW_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	New Field Name
22	UPG_INDEX_NAME	Character(18)	VARCHAR2(18) NOT NULL	Index Name
23	UPG_VIEW_NAME	Character(30)	VARCHAR2(30) NOT NULL	View Name