PV_ROLEDEFN_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
3	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
4	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
5	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
6	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
7	WORKLIST_USER_SW	Character(1)	VARCHAR2(1) NOT NULL	Used to determine if the user gets a worklist generated
8	EMAIL_USER_SW	Character(1)	VARCHAR2(1) NOT NULL	Used to determine if the user gets workflow email generated
9	FORMS_USER_SW	Character(1)	VARCHAR2(1) NOT NULL	Used to determine if the user gets workflow Lotus forms generated
10	FORMID	Character(70)	VARCHAR2(70) NOT NULL	Form ID
11	ROLEUSER_ALT	Character(30)	VARCHAR2(30) NOT NULL	Alternate Role User
12	EFFDT_FROM	Date(10)	DATE	Effective Date From
13	EFFDT_TO	Date(10)	DATE	Effective Date To
14	ROLEUSER_SUPR	Character(30)	VARCHAR2(30) NOT NULL	Supervisor Role User
15	CATALOG_SETID	Character(5)	VARCHAR2(5) NOT NULL	Catalog Setid Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
16	CATALOG_ID	Character(18)	VARCHAR2(18) NOT NULL	Catalog ID
17	REQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	Requester Flag Default Value: Y
18	REQ_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Req status A=Approved C=Complete D=Denied I=Initial LA=Line Approved O=Open P=Pending Approval V=Preview X=Canceled Default Value: P