UPG_RSF_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EFFDT	Date(10)	DATE	Effective Date
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	SALES_MODEL	Character(18)	VARCHAR2(18) NOT NULL	Sales Model Id
6	SALES_STAGE	Character(24)	VARCHAR2(24) NOT NULL	Sales Stage Identifier
7	SALES_TASK	Character(24)	VARCHAR2(24) NOT NULL	Sales Stage Task Identifier
8	SALES_STAGE_TASK	Character(24)	VARCHAR2(24) NOT NULL	Sales Stage Identifier
9	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
10	SEQNUMSTAGE	Number(3,0)	SMALLINT NOT NULL	Sequence Number
11	SEQNUMTASK	Number(3,0)	SMALLINT NOT NULL	Sequence Number to keep track of the task number from the sales model, stage.
12	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
13	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
14	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
15	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
16	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
17	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
18	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
19	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
20	CELL_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Cell Phone
21	HOME_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Home Phone
22	WORK_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Work Phone
23	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
24	FAX	Character(24)	VARCHAR2(24) NOT NULL	This is the fax number field.
25	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
26	PROFILE_CM_SEQ_CEL	Number(31,0)	DECIMAL(31) NOT NULL	Cust Address ID...........................................
27	PROFILE_CM_SEQ_EML	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for a email address.
28	PROFILE_CM_SEQ_FAX	Number(31,0)	DECIMAL(31) NOT NULL	CM Profile Detail ID................................................
29	PROFILE_CM_SEQ_HM	Number(31,0)	DECIMAL(31) NOT NULL	CM Profile Detail ID.............................................
30	PROFILE_CM_SEQ_WK	Number(31,0)	DECIMAL(31) NOT NULL	CM Profile Detail ID.............................................
31	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
32	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
33	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
34	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
35	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
36	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
37	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
38	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
39	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
40	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
41	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
42	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
43	NOTE_SEQ_NBR	Number(6,0)	INTEGER NOT NULL	Note ID
44	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
45	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
46	UPG_ALLNC_PTNR_TYP	Character(15)	VARCHAR2(15) NOT NULL	Partner Type ID (Alliance)
47	UPG_CHNL_PTNR_TYP	Character(15)	VARCHAR2(15) NOT NULL	Partner Type ID (Channel)
48	UPG_TR_REA_FLG	Character(1)	VARCHAR2(1) NOT NULL	Copy Reassign History
49	UPG_TR_REO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Copy Reorg History
50	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	This is a Temp field.
51	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN).
52	DATASETNAME	Character(30)	VARCHAR2(30) NOT NULL	Dataset Name
53	INSERT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	insert flag
54	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
55	NUMROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.