UPG_RS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	UPG_RELEASE	Character(4)	VARCHAR2(4) NOT NULL	Upgrade Application Release 751=7.51 Release 752=7.52 Release 753=7.53 Release 801=8 SP1 Release 803=8 SP3 Release 840=8.40 Release 841=8.40 SP1 880=8.80 Release
3	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
4	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	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.
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
9	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
11	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
12	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
13	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
14	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
15	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
16	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
17	RS_CM_HRMS_INSTALL	Character(1)	VARCHAR2(1) NOT NULL	Use to determine the source for employee and non-employee data. 1=PeopleSoft HCM 8.0+ 2=HCM 8.0+ and RS 3=PeopleSoft Resource Management
18	POOL_ID	Character(10)	VARCHAR2(10) NOT NULL	Pool ID field.
19	LAST_MEMBER_ID	Number(6,0)	INTEGER NOT NULL	Last Member ID
20	COUNT_ATTR_VAL	Number(6,0)	INTEGER NOT NULL	Attribute value count
21	COUNT_GRP_FL	Number(6,0)	INTEGER NOT NULL	Headcount Default Value: 0
22	EMPLID_INPUT	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
23	EFFDT_FROM	Date(10)	DATE	Effective Date From
24	AE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Exists
25	SO_ID_LAST_USED	Number(8,0)	INTEGER NOT NULL	Last Service Order ID Used