Transaction date filters
Data is extracted from PeopleSoft in to IRC using the Process Insights for PeopleSoft and analyzed. Transaction date filters are used for scoping during extraction and analysis.
The following table lists the objects, date fields for full extraction,
date fields for Incremental extraction, and additional filters.
| Object Name | Date field for full extraction | Date field for incremental extraction | Additional filters |
|---|---|---|---|
| PS_GL_ACCOUNT_
TBL |
NA | NA | NA |
| PS_LEDGER | NA | NA | NA |
| PS_CUST_MICR_TBL | NA | NA | NA |
| PS_VNDR_BANK_
ACCT |
NA | NA | NA |
| PS_CUSTOMER | NA | NA | NA |
| PS_CUST_CREDIT | NA | NA | NA |
| PS_CUST_ADDRESS | NA | NA | NA |
| PS_MASTER_ITEM_
TBL |
NA | NA | NA |
| PS_ITM_VNDR_
UOM_PR |
NA | NA | NA |
| PSOPRDEFN | NA | NA | NA |
| PS_VENDOR | NA | NA | NA |
| PS_VENDOR_CNTCT | NA | NA | NA |
| PS_VENDOR_LOC | NA | NA | NA |
| PS_BI_HDR | ADD_DTTM | LAST_UPDATE_DTTM | NA |
| PS_BI_LINE | ADD_DTTM | LAST_UPDATE_DTTM | NA |
| PS_IN_DEMAND | DEMAND_DATE | DATE_LAST_MAINT | NA |
| PS_RECV_HDR | RECEIPT_DT | LAST_DTTM_UPDATE | NA |
| PS_RECV_LN_SHIP | PS_RECV_HDR.RECEIPT_DT | PS_RECV_HDR.LAST_DTTM_UPDATE | NA |
| PS_VOUCHER | ENTERED_DT | LAST_UPDATE_DT | NA |
| PS_VOUCHER_LINE | PS_VOUCHER.ENTERED_DT | PS_VOUCHER.LAST_UPDATE_DT | NA |
| PS_VCHR_ACCTG_
LINE |
PS_VOUCHER.ENTERED_DT | PS_VOUCHER.LAST_UPDATE_DT | NA |
| PS_DISTRIB_LINE | PS_VOUCHER.ENTERED_DT | PS_VOUCHER.LAST_UPDATE_DT | NA |
| PS_PYMNT_VCHR_
XREF |
PS_VOUCHER.ENTERED_DT | PS_VOUCHER.LAST_UPDATE_DT | NA |
| PS_JRNL_HEADER | JRNL_CREATE_
DTTM |
DTTM_STAMP_SEC | NA |
| PS_JRNL_LN | PS_JRNL_HEADER.JRNL_CREATE_
DTTM |
PS_JRNL_HEADER.DTTM_STAMP_SEC | NA |
| PS_ORD_HEADER | DATETIME_ADDED | LASTUPDDTTM | NA |
| PS_ORD_LINE | DATETIME_ADDED | LASTUPDDTTM | NA |
| PS_PAYMENT_TBL | CREATION_DT | NA | NA |
| PS_PO_HDR | ENTERED_DT | LAST_DTTM_UPDATE | NA |
| PS_PO_LINE | PS_PO_HDR.ENTERED_DT | PS_PO_HDR.LAST_DTTM_UPDATE | NA |
| PS_PO_LINE_DISTRIB | PS_PO_HDR.ENTERED_DT | PS_PO_HDR.LAST_DTTM_UPDATE | NA |
| PS_REQ_HDR | ENTERED_DT | LAST_DTTM_UPDATE | NA |
| PS_REQ_LINE | PS_REQ_HDR.ENTERED_DT |
PS_REQ_HDR. LAST_DTTM_UPDATE |
NA |