| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
ENABLE_TRANS_PAGES |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Pages
Y/N Table Edit
Default Value: Y
|
| 3 |
ENABLE_OVRVW_PAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Overview and Error Pages
Y/N Table Edit
Default Value: Y
|
| 4 |
HIDE_ALL_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Make "All" page a worklist
Y/N Table Edit
Default Value: Y
|
| 5 |
ALLOW_APPROVE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow approve. Determines if the approve button is displayed to the approver.
Y/N Table Edit
Default Value: Y
|
| 6 |
ALLOW_REVIEW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Review Switch. Determines if the review button is displayed to the approver.
Y/N Table Edit
Default Value: N
|
| 7 |
ALLOW_SENDBACK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Send Back Switch. Determines if the Send Back button is displayed to the approver
Y/N Table Edit
Default Value: N
|
| 8 |
ALLOW_HOLD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Hold Switch. Determines if the hold button is displayed to the approver.
Y/N Table Edit
Default Value: N
|
| 9 |
ALLOW_DENY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Denial Switch. Determines if the deny button is displayed to the approver.
Y/N Table Edit
Default Value: N
|
| 10 |
ALLOW_BGTCHK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Budget Check Switch. Determines if the budget Check button is displayed to the approver.
Y/N Table Edit
Default Value: N
|
| 11 |
ALERT_OOP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses Out of Policy
Y/N Table Edit
Default Value: N
|
| 12 |
ALERT_OLDTXN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses Older Transaction
Y/N Table Edit
Default Value: N
|
| 13 |
ALERT_RCPT_VRFY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses not Receipt-Verified
Y/N Table Edit
Default Value: N
|
| 14 |
ALERT_BGTCHK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Errors
Y/N Table Edit
Default Value: N
|
| 15 |
ALERT_TR_OUT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Reports Outside Threshold
Y/N Table Edit
Default Value: N
|
| 16 |
ALERT_DUP_EXIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicates Exist
Y/N Table Edit
Default Value: N
|
| 17 |
ALERT_PREF_MRCH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Merchant Not Used
Y/N Table Edit
Default Value: N
|
| 18 |
SAME_AS_ALERTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Same as Alerts
Y/N Table Edit
Default Value: N
|
| 19 |
ALLOW_OOP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses Out of Policy
Y/N Table Edit
Default Value: N
|
| 20 |
ALLOW_OLDTXN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses Old Transaction
Y/N Table Edit
Default Value: N
|
| 21 |
ALLOW_RCPT_VRFY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses not Receipt-Verified
Y/N Table Edit
Default Value: N
|
| 22 |
ALLOW_BGTCHK_AL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Errors
Y/N Table Edit
Default Value: N
|
| 23 |
ALLOW_TR_OUT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Reports Outside Threshold
Y/N Table Edit
Default Value: N
|
| 24 |
ALLOW_DUP_EXIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicates Exist
Y/N Table Edit
Default Value: N
|
| 25 |
ALLOW_PREF_MRCH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Merchant Not Used
Y/N Table Edit
Default Value: N
|
| 26 |
ALLOW_RISK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Switch
Y/N Table Edit
Default Value: N
|