UPG_EX_UPG2_AET (SQL Table)	Index Back
Expenses Upgrade State Record Used in Expenses upgrade as a State Record

UPG_EX_UPG2_AET

(SQL Table)

Expenses Upgrade State Record

Used in Expenses upgrade as a State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

3 RECNAME_18 Character(18) VARCHAR2(18) NOT NULL used in table CFOBJECT_TMP for App Engine FS_CFUPDATE.ViewSrch to look for view/table dependencies.

4 SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name

5 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	RECNAME_18	Character(18)	VARCHAR2(18) NOT NULL	used in table CFOBJECT_TMP for App Engine FS_CFUPDATE.ViewSrch to look for view/table dependencies.
4	SQLTABLENAME	Character(18)	VARCHAR2(18) NOT NULL	SQL Table Name
5	COUNT_1	Number(3,0)	SMALLINT NOT NULL	Count Work Field