| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
EX_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Documentation ID
|
| 4 |
EX_DOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization
|
| 5 |
EX_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number
|
| 6 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 8 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 9 |
GROSSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross Up Indicator
|
| 10 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate Check Indicator
|
| 11 |
ACCEPTANCE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Acceptance Message Status
R=Message Rejected
T=Message Taken
|
| 12 |
REJECTED_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
Rejected Reason
01=Invalid Earnings Code
02=Invalid Empl. ID or Empl. Rec#
03=Invalid Currency Code
04=Problem Loading Transaction
05=Transaction Already Exist
06=Other line(s) rejected.
|
| 13 |
DATE_ACKNOWLEDGE |
DateTime(26) |
TIMESTAMP |
Acknowledgment Datetime stamp
|
| 14 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 15 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|