| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
Prompt Table:
PV_JC_SETID_VW
|
| 2 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
PV_JOBCODE_VW
|
| 3 |
PV_JOBCODE_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code To
Prompt Table:
PV_JOBCODE_VW
|
| 4 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
PSROLEDEFN
|
| 5 |
OPRCLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator Class
Prompt Table:
PSCLASSDEFN
|
| 6 |
ROWSECCLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
The class used to determine row level security
Prompt Table:
PSCLASSDEFN
|
| 7 |
ROLEUSER_SUPR |
Character(30) |
VARCHAR2(30) NOT NULL |
Supervisor Role User
Prompt Table:
ROLEXLATOPR
|
| 8 |
WORKLIST_USER_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine if the user gets a worklist generated
Y/N Table Edit
Default Value: Y
|
| 9 |
EMAIL_USER_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine if the user gets workflow email generated
Y/N Table Edit
Default Value: Y
|
| 10 |
FORMS_USER_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine if the user gets workflow Lotus forms generated
Y/N Table Edit
Default Value: Y
|
| 11 |
FORMID |
Character(70) |
VARCHAR2(70) NOT NULL |
Form ID
|
| 12 |
ROLEUSER_ALT |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Role User
Prompt Table:
ROLEXLATOPR
|
| 13 |
EFFDT_FROM |
Date(10) |
DATE |
Effective Date From
|
| 14 |
EFFDT_TO |
Date(10) |
DATE |
Effective Date To
|
| 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
Prompt Table:
CATALOG_VW
|
| 17 |
REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Requester Flag
Y/N Table Edit
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: O
|