RSF_TR_REASSIGN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REASSIGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Reassignment ID Default Value: NEXT
2	REASSIGN_DATE	Date(10)	DATE	Reassignment Date Default Value: %date
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Default Value: RSF_OPR_DEF_VW.TREE_NAME Prompt Table: RSF_OPR_TREE_VW
4	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
5	SRCH_ALL_CONTACTS	Character(1)	VARCHAR2(1) NOT NULL	Search All Contacts Y/N Table Edit Default Value: N
6	FROM_USER	Character(15)	VARCHAR2(15) NOT NULL	Current Owner Prompt Table: RSF_ACC_FROM_VW
7	TO_TREE	Character(18)	VARCHAR2(18) NOT NULL	New Tree Name Default Value: RSF_TR_REASSIGN.TREE_NAME Prompt Table: RSF_OPR_TREE_VW
8	TO_USER	Character(15)	VARCHAR2(15) NOT NULL	New Sales Rep Prompt Table: RSF_ACC_TO_VW
9	FROM_TERRITORY	Character(20)	VARCHAR2(20) NOT NULL	Current Territory Prompt Table: RSF_TERR_DSC_VW
10	TO_TERRITORY	Character(20)	VARCHAR2(20) NOT NULL	New Territory Prompt Table: RSF_TERR_DS2_VW
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
13	REASSIGN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Reassigment Status. I=In Progress N=New P=Processing R=Reviewed S=Submitted Default Value: N
14	REASSIGN_OPTION	Character(3)	VARCHAR2(3) NOT NULL	Reassign Option LOA=Leads, Opportunities, Accounts LOX=Leads, Opportunities LXX=Leads XOX=Opportunities XXA=Accounts Default Value: LOA
15	REASSIGN_FROM	Character(3)	VARCHAR2(3) NOT NULL	Reassign From MUL=Multiple Reps SGL=Single Rep UNA=Unassigned Default Value: SGL
16	OPTION_ACCOUNTS	Character(1)	VARCHAR2(1) NOT NULL	Accounts Y/N Table Edit Default Value: Y
17	OPTION_LEADS	Character(1)	VARCHAR2(1) NOT NULL	Leads Y/N Table Edit Default Value: Y
18	OPTION_OPPS	Character(1)	VARCHAR2(1) NOT NULL	Opportunities Y/N Table Edit Default Value: Y
19	LEAD_STATUS_OPTS	Signed Number(6,0)	DECIMAL(5) NOT NULL	Lead Status Options
20	OPP_STATUS_OPTS	Signed Number(6,0)	DECIMAL(5) NOT NULL	Opportunity Status Options
21	START_DT_LE_CREA	Date(10)	DATE	Lead Created Start Date
22	START_DT_LE_MOD	Date(10)	DATE	Lead Modified Start Date
23	START_DT_OP_CREA	Date(10)	DATE	Opportunity Created Start Date
24	START_DT_OP_MOD	Date(10)	DATE	Opportunity Modified Start Dt
25	START_DT_OP_EST	Date(10)	DATE	Opportunity Est Close Start Dt
26	END_DT_LE_CREA	Date(10)	DATE	Lead Created End Date
27	END_DT_LE_MOD	Date(10)	DATE	Lead Modified End Date
28	END_DT_OP_CREA	Date(10)	DATE	Opportunity Created End Date
29	END_DT_OP_MOD	Date(10)	DATE	Opportunity Modified End Date
30	END_DT_OP_EST	Date(10)	DATE	Opportunity Est Close End Date
31	UNASSIGNED	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if unassigned loctions should be displayed. Y/N Table Edit Default Value: N
32	RB_PRESERVE	Character(1)	VARCHAR2(1) NOT NULL	Indicates how a sales representatives territories should be configured. D=Use Rep's Default Territory P=Preserve Existing Territory S=Use Specified Territory Default Value: D
33	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
34	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
35	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
36	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
37	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.
38	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time