Understanding Data Types

PeopleSoft Expenses enables you to archive the inactive data on the transaction tables to the history tables. If you need to access the data later, you can restore it.

Type of Data Description Tables

Travel authorization transaction data

Travel authorization data, such as general information, expense transaction lines, and accounting information.

  • EX_TAUTH_DIST

  • EX_TAUTH_HDR

  • EX_TAUTH_LINE

  • EX_TAUTH_SPLIT

Travel authorization approval data

Cross reference data used by approval framework to process the travel authorization approval actions.

EX_TAUTH_AW

Cash advance transaction data

Cash advance data, such as general information, approval details, document sequencing (if applicable), and cash advance payment information.

  • EX_ADV_CHK

  • EX_ADV_DIST

  • EX_ADV_DOCSEQ

  • EX_ADV_HDR

  • EX_ADV_LINE

  • EX_ADVNCE_PYMNT

Cash advance approval data

Cross reference data used by approval framework to process the cash advance approval actions.

EX_ADV_AW

Expense report transaction data

Expense report transaction data, such as general information, expense transaction lines, approval details, document sequencing (if applicable), attendee information, accounting details, expense report payment information.

  • EX_SHEET_ADV

  • EX_SHEET_ATT

  • EX_SHEET_DIST

  • EX_SHEET_DOCSEQ

  • EX_SHEET_HDR

  • EX_SHEET_LINE

  • EX_SHEET_LN_PD

  • EX_SHEET_PYMNT

  • EX_SHEET_SPLIT

Expense report approval data

Cross reference data used by approval framework to process the expense report approval actions.

EX_SHEET_AW

Time report transaction data

Time report transaction data, such as general information, personal and project-related details, prior period adjustment details, and approval details.

  • EX_TIME_DTL

  • EX_TIME_DTL_DLY

  • EX_TIME_HDR

  • EX_TIME_POL

  • EX_TIME_POL_DLY

Time report approval data

Cross reference data used by approval framework to process the time report approval actions.

EX_TIME_AW

DCAA audit data

DCAA audit log of entries, changes or violations made by employees, authorized reporters, approvers, and auditors.

EX_AUDIT_DCAA

Time report project resource data

Approved time entries that are staged for the PC_EX_TO_PC Application Engine process to pick them up.

EX_PROJ_RES_STG

My Wallet data

My Wallet data, such as expense transactions from a credit card feed or transactions that employees manually entered into My Wallet.

EX_TRANS

My Wallet enhanced data

Enhanced data used to create expense reports that was loaded from credit card suppliers or manually entered.

EX_ENHC_SUMM

EX_ENHC_DET

EX_ENHC_SUMM_AMX (for American Express)

EX_ENHC_DET_AMX (for American Express)

Account entry data

Expenses accounting line information.

EX_ACCTG_LINE

Approval history data

Expenses approval action history information.

EX_APRVL_HIST