| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
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.
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
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
Default Value: PND
|
| 6 |
EX_ORIGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Origin of Entry (Expenses)
A=Asset Lifecycle Management
H=Mobile Hand Held Device
M=Mobile Time and Expense
N=NUI
P=Primavera P6
W=Web
Default Value: W
|
| 7 |
USER_CANCEL_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
User Cancel Request
A=Active
C=Closed Out
D=Mark for Delete
H=Hold from Budget Checking
I=Admin Cancel
U=User Cancel
Default Value: A
|
| 8 |
REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference ID
|
| 9 |
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
Default Value: A
|
| 10 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
Default Value: %date
|
| 11 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
|
| 12 |
SUBMISSION_DATE |
Date(10) |
DATE |
Submission Date
|
| 13 |
SUBMIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Submitted By - Character (30)
|
| 14 |
RESUBMISSION_DT |
Date(10) |
DATE |
Resubmission Date
|
| 15 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|
| 16 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Default Value: BUS_UNIT_TBL_EX.DST_CNTRL_ID
Prompt Table:
DST_CNTRL_TBL
|
| 17 |
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.
|
| 18 |
TXN_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Expense Location
Prompt Table:
EX_LOCATION_VW
|
| 19 |
TRAVEL_FROM |
Character(5) |
VARCHAR2(5) NOT NULL |
Used to indicate the starting point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_TO field to track the cost of flights to and from various locals.
|
| 20 |
TEMPLATE |
Character(8) |
VARCHAR2(8) NOT NULL |
Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash advances, expense sheets and travel authorizations.
|
| 21 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 22 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 23 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL
|
| 24 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Default Value: EX_AA_EE_ORG_VW.EMPL_RCD
|
| 25 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 26 |
DATE_FROM |
Date(10) |
DATE NOT NULL |
Date From
|
| 27 |
DATE_TO |
Date(10) |
DATE NOT NULL |
Date To
|
| 28 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
Default Value: V
|
| 29 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No
Y=Yes
Y/N Table Edit
|
| 30 |
KK_TRAN_OVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Commitment Control source transaction override operator
|
| 31 |
KK_TRAN_OVER_DTTM |
DateTime(26) |
TIMESTAMP |
Commitment Control source transaction override datetime
|
| 32 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
|
| 33 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 34 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 35 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All
S=Only purge items with at least
Default Value: N
|
| 36 |
BUSINESS_PURPOSE |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Purpose
Prompt Table:
EX_PURPOSE_TBL
|
| 37 |
ADVANCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Advance ID
|
| 38 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 39 |
PROJ_MGR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Manager Review
|
| 40 |
COPY_TRAVEL_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to select a travel authorization to copy into a new travel authorization. Found on the EX_TAUTH_HDR record as well as the EX_TA_HDR_VW and EX_TA_HDR_WRK records. Used on the EX_COPY_TAUTH panel and EX_TAUTH_HDR_INQ panel.
Y/N Table Edit
Default Value: N
|
| 41 |
ORIG_ACCT_DT |
Date(10) |
DATE |
Original Accouting Date
|
| 42 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 43 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 44 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 45 |
PREF_MRCH_NOT_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Preferred Merchant
Default Value: N
|
| 46 |
OUT_OF_POLICY |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized Amount Exceeded
Default Value: N
|
| 47 |
MULT_PER_DIEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Multip Per Diem Exist Per Day
|
| 48 |
RISK_EXISTS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Exists
Y/N Table Edit
Default Value: N
|
| 49 |
ROLLOVER_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Rollover Status
A=All
C=Rollover Process Completed
N=Never Processed
P=Rollover in Progress
|
| 50 |
APPR_PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval in Process Flag
Y/N Table Edit
Default Value: N
|
| 51 |
DATE_TIME_HM |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 52 |
OPRID_LAST_ACTION |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Take Action
|
| 53 |
ACTION_NAME |
Character(3) |
VARCHAR2(3) NOT NULL |
Action taken on a transaction
APR=Approved
AUT=Auto Approved
BUD=Budget Checked
DEL=Deleted
DNY=Denied
HLD=On Hold
PAS=Post Approval Submit
REC=Receipt Verified
RES=Resubmitted
REV=Reviewed
RSN=Reassigned
SBR=Sent Back For Revision
SUB=Submitted
WDR=Withdrawn
|
| 54 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 55 |
BILL_CODE_EX |
Character(3) |
VARCHAR2(3) NOT NULL |
Expense Billing Code
|