PV_ROLEXLAT_TAO

(SQL Table)
Index Back

PS_ROLEXLATOPR Temp Record

PS_ROLEXLATOPR Temp Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
6 FORMID Character(70) VARCHAR2(70) NOT NULL Form ID
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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
11 ROLEUSER_ALT Character(30) VARCHAR2(30) NOT NULL Alternate Role User
12 ROLEUSER_SUPR Character(30) VARCHAR2(30) NOT NULL Supervisor Role User
13 EFFDT_FROM Date(10) DATE Effective Date From
14 EFFDT_TO Date(10) DATE Effective Date To