| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TRAVEL_AUTH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
EX_EE_AUTH_VW
|
| 3 |
TRAVEL_AUTH_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Describes the current status of the travel authorization - whether pending, submitted or approved. This field is associated with the header record of travel authorizations and is found on many records and panels within travel authorization objects. The status will change depending on the action taken upon the travel authorization. PeopleCode is used to update the status.
APR=Approved
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
HDA=On Hold, with Approver
HDU=On Hold, with Auditor
HLD=On Hold
PAR=Approvals in Process
PND=Pending
PRO=In Process
RCN=Reconciled
RRT=Transaction Rerouted
SFA=Submission in Process
STG=Staged
SUB=Submitted for Approval
XML=Submitted, Pending Validation
|
| 4 |
TIP_STAGE |
Character(7) |
VARCHAR2(7) NOT NULL |
Transactions In Progress
|
| 5 |
APPROVAL_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Level
A=Approver Only
B=Pre- and Post-Pay Audit
E=Approver & Pre-Pay Auditor
I=Approve, Pre- & Post-Pay Audit
N=None
S=Approver & Post-Pay Auditor
T=Auditor Only - Post-Payment
U=Auditor Only - Pre-Payment
|
| 6 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 7 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
|
| 8 |
AUDIT_DT |
Date(10) |
DATE |
Date of Audit
|
| 9 |
SUBMISSION_DATE |
Date(10) |
DATE |
Submission Date
|
| 10 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|
| 11 |
DAYS_INACTIVE |
Number(4,0) |
SMALLINT NOT NULL |
Days Inactive
|
| 12 |
DAYS_INACT_RANGE |
Character(3) |
VARCHAR2(3) NOT NULL |
Days Inactive Range
-30=< 31
30=31 to 60
60=61 to 90
90+=> 90
A=All
|
| 13 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 14 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 15 |
TRAVEL_AUTH_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Field used to give a descriptive name to each travel authorization. Associated with the header information of a travel authorization and found on many records and panels within travel authorization objects.
|