EX_PY_STG_SUB

(SQL Table)
Index Back

Expenses payment subscr. stg.

Expenses payment subscription staging table.

# 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 PAYCHECK_STATUS Character(1) VARCHAR2(1) NOT NULL Check Type
A=Adjusted Check
C=Calculated Check
F=Confirmed Check
R=Reversed Check
9 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck Number
10 CHECK_DT Date(10) DATE Check Date
11 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
12 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
13 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
14 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance