| # |
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 |
APPR_TRANS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Approval Transaction Type.
CA=Cash Advance
ER=Expense Report
TA=Travel Authorization
TJ=Time Adjustment
TR=Time Report
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EOAWPRCS_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Process ID
|
| 5 |
STAGE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Unique stage identifier
Prompt Table:
EX_AWE_STAGE_VW
|
| 6 |
APPRVR_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Approver type used to cross reference an AWE process id and stage.
Prompt Table:
EX_APPRVR_TYPE
|
| 7 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Y/N Table Edit
Default Value: N
|
| 8 |
APPROVE_BILL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve for Billing.
Y/N Table Edit
Default Value: N
|
| 9 |
APPROVE_PAY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve for Payment.
Y/N Table Edit
Default Value: N
|
| 10 |
AMOUNT_ROUTING_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Based Routing Switch. Determines if the transaction is routed based on the transaction amount.
Y/N Table Edit
Default Value: N
|
| 11 |
AUTO_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Approve
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 12 |
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: N
|
| 13 |
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
|
| 14 |
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
|
| 15 |
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
|
| 16 |
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
|
| 17 |
REROUTE_TO_MGR |
Character(1) |
VARCHAR2(1) NOT NULL |
Route to supervisor
Default Value: N
|
| 18 |
APPROVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approver Oprid
Prompt Table:
EX_OPRID_VW
|
| 19 |
ALLOW_RECVER_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Receipt Verifier Switch. Determines if the receipt verify button is displayed to Expenses approver depending on its approver category.
Y/N Table Edit
Default Value: N
|