| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ADVANCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Advance ID
Default Value: NEXT
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
ADV_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Advance Status
APY=Approved for Payment
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
PD=Paid
PND=Pending
PRO=In Process
PST=Past Due Balance
RAP=Approved
RCN=Reconciled
RRT=Reroute Transaction
SFA=Submission in Process
STG=Staged
SUB=Submitted for Approval
XML=Submitted, Pending Validation
Default Value: PND
|
| 4 |
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
|
| 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
Default Value: %date
|
| 7 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
|
| 8 |
AUDIT_DT |
Date(10) |
DATE |
Date of Audit
|
| 9 |
AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 10 |
SUBMISSION_DATE |
Date(10) |
DATE |
Submission Date
|
| 11 |
SUBMIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Submitted By - Character (30)
|
| 12 |
RESUBMISSION_DT |
Date(10) |
DATE |
Resubmission Date
|
| 13 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|
| 14 |
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
|
| 15 |
REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference ID
Prompt Table:
EX_REFERENCE
|
| 16 |
ADVANCE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Advance Description
|
| 17 |
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.
|
| 18 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 19 |
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
|
| 20 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 21 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL
|
| 22 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Default Value: EX_AA_EE_ORG_VW.EMPL_RCD
|
| 23 |
POST_STATUS_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses Post Status
C=Closed
M=Marked for Unpost
N=Not Applied
O=Unpost In Process
P=Posted
S=Close In Process
U=Unposted
Default Value: N
|
| 24 |
UNPOST_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
|
| 25 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 26 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table:
DOC_TYPE_A_VW
|
| 27 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 28 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 29 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 30 |
REVERSAL_DATE |
Date(10) |
DATE |
Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
|
| 31 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 32 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All
S=Only purge items with at least
Default Value: N
|
| 33 |
BUSINESS_PURPOSE |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Purpose
Prompt Table:
EX_PURPOSE_TBL
|
| 34 |
RECEIPTS_RECEIVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipts Received
Y/N Table Edit
|
| 35 |
RCPT_VERIFY_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Verification UserID
|
| 36 |
RCPT_VERIFY_DT |
Date(10) |
DATE |
Date of Verification
|
| 37 |
BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance
|
| 38 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
|
| 39 |
REOCCURRING_ADV |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Cash Advance
Y/N Table Edit
Default Value: N
|
| 40 |
INTERVAL_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Cyc Interval (days)
|
| 41 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 42 |
END_DT |
Date(10) |
DATE |
End Date
|
| 43 |
RECREATE_DATE |
Date(10) |
DATE |
Auto Submission Date
|
| 44 |
RECREATE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate the status of an Automatic Cash Advance during it's processing cycle.
|
| 45 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 46 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 47 |
ORIG_ACCT_DT |
Date(10) |
DATE |
Original Accouting Date
|
| 48 |
RECONCILE_DT |
Date(10) |
DATE |
The transaction reconciliation date.
|
| 49 |
APPR_PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval in Process Flag
Y/N Table Edit
Default Value: N
|
| 50 |
DATE_TIME_HM |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 51 |
OPRID_LAST_ACTION |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Take Action
|
| 52 |
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
|
| 53 |
RISK_EXISTS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Exists
Y/N Table Edit
Default Value: N
|
| 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.
Default Value: %datetime
|