RSF_ACC_PROFILE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACCESS_PROFILE_ID	Character(15)	VARCHAR2(15) NOT NULL	Access Profile ID
2	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	ACCESS_LE_REASSIGN	Character(1)	VARCHAR2(1) NOT NULL	this is field added for dashboard project by Sales DB team Y/N Table Edit Default Value: N
5	ACCESS_DD_CUST	Character(1)	VARCHAR2(1) NOT NULL	Customer Name Y/N Table Edit Default Value: N
6	ACCESS_DD_LAST	Character(1)	VARCHAR2(1) NOT NULL	Last Name Optional Y/N Table Edit Default Value: N
7	ACCESS_DD_FIRST	Character(1)	VARCHAR2(1) NOT NULL	First Name Optional Y/N Table Edit Default Value: N
8	ACCESS_DD_PHONE	Character(1)	VARCHAR2(1) NOT NULL	Phone Optional Y/N Table Edit Default Value: N
9	ACCESS_DD_ADDR_LIN	Character(1)	VARCHAR2(1) NOT NULL	Address Line 1 Optional Y/N Table Edit Default Value: N
10	ACCESS_DD_CITY	Character(1)	VARCHAR2(1) NOT NULL	City Optional Y/N Table Edit Default Value: N
11	ACCESS_DD_STATE	Character(1)	VARCHAR2(1) NOT NULL	State Optional Y/N Table Edit Default Value: N
12	ACCESS_DD_ZIP	Character(1)	VARCHAR2(1) NOT NULL	Zip Code Optional Y/N Table Edit Default Value: N
13	ACCESS_DD_EMAIL	Character(1)	VARCHAR2(1) NOT NULL	Email Y/N Table Edit Default Value: N
14	ACCESS_DD_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Allow Override of Dup Checking Y/N Table Edit Default Value: N
15	ACCESS_OP_REASSIGN	Character(1)	VARCHAR2(1) NOT NULL	this is field added for sales dashboard by sales dashboard team Y/N Table Edit Default Value: N
16	ACCESS_OP_REVENUE	Character(1)	VARCHAR2(1) NOT NULL	View & Edit Revenue Allocation Y/N Table Edit Default Value: N
17	ACCESS_OP_SHADOW	Character(1)	VARCHAR2(1) NOT NULL	View & Edit Shadow Allocation Y/N Table Edit Default Value: N
18	ACCESS_FC_EDITALL	Character(1)	VARCHAR2(1) NOT NULL	Edit Staff Forecast Data Y/N Table Edit Default Value: N
19	ACCESS_FC_EDITOWN	Character(1)	VARCHAR2(1) NOT NULL	Edit Own Forecast Data Y/N Table Edit Default Value: N
20	ACCESS_FC_AUTOALL	Character(1)	VARCHAR2(1) NOT NULL	Auto Forecast All Staff Y/N Table Edit Default Value: N
21	ACCESS_FC_AUTOOWN	Character(1)	VARCHAR2(1) NOT NULL	Auto Forecast Own Staff Y/N Table Edit Default Value: N
22	ACCESS_FC_ADJUST	Character(1)	VARCHAR2(1) NOT NULL	Adjust Forecasts Y/N Table Edit Default Value: N
23	ACCESS_FC_UNSUBMIT	Character(1)	VARCHAR2(1) NOT NULL	View Unsubmitted Forecasts Y/N Table Edit Default Value: N
24	ACCESS_TR_REASSIGN	Character(1)	VARCHAR2(1) NOT NULL	Submit Reassignment Y/N Table Edit Default Value: N
25	ACCESS_TR_REORG	Character(1)	VARCHAR2(1) NOT NULL	Submit Reorganization Y/N Table Edit Default Value: N
26	ACCESS_CL_ASMGR	Character(1)	VARCHAR2(1) NOT NULL	View Calendar as Manager Y/N Table Edit Default Value: N
27	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
28	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
29	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
30	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
31	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.
32	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time