Department Home page

PeopleSoft Decision Support (PS DSS)

This information can also be accessed via Self Serve under the Administration Tab>Data Access>AP-PO PeopleSoft.

PeopleSoft Decisions Support System - Located on the APPO PeopleSoft Web Applications page in Self-Service, is a list of all the PeopleSoft tables available and documentation on the most used fields from those tables.

Click the table headers for descriptions of commonly used and most useful fields from these tables.

PeopleSoft Tables Available

Vendor Tables

VENDOR
VENDOR_LOC
VENDOR_TYPE
VENDOR_PAY
VENDOR_ADDR
VENDOR_WTHD

Voucher Tables

VOUCHER
VOUCHER_LINE
DISTRIB_LINE
PYMNT_VCHR_XREF
GRP_AP
UI_VCHR_TBL
UI_VCHR_ACCTG

Payment Tables

PAYMENT_TBL
PYMNT_ADVICE
UI_PAYMENT_TBL
UI_STALE_TBL

PO Tables

DEPT_TBL
REQUESTOR_TBL
LOCATION_TBL
ORIGIN_PROCURE
PO_HDR
PO_LINE
PO_LINE_DISTRIB
UI_REQ_INFO_TBL
UI_PO_INV_TBL
UI_PO_ID_TBL
UI_REQID_RPTTBL
PO_LINE_SHIP

Vendor History Tables

VNDR_HST
VNDR_LOC_HST
VNDR_TYPE_HST
VNDR_PAY_HST
VNDR_ADDR_HST

Voucher History Tables

VCHR_HST
VCHR_LN_HST
VCHR_DSTLN_HST
PYMNT_VCHR_HST
UI_VCHR_ACCTLN_HST

 

Payment History Tables

PYMNT_TBL_HST
PYMNT_ADV_HST

 

Installing Oracle for Data Warehouse Access - This is general instructions and documentation from the ITS Help pages.