Delivered Data Archive Templates
Data archiving is an important part of any data management system. Specific archiving dependencies exist for Time and Labor. Data should be archived in the following order of precedence:
Payable Time Approval table.
Payable Time table.
Reported Time table.
Xref_table.
Xref_Cost table.
You use the same prompts to archive Payable Time and Reported Time.
|
Base Table/Record Name |
Archive Table/Record Name |
Template Name |
Input Parameter |
Comments |
|---|---|---|---|---|
|
TL_PAYABLE_TIME |
TL_PAYABLE_HST |
TL_PYTM1 TL_PYTM2 |
Begin Date End Date |
TL_PYTM1 – Archives processed Payable Time ('PD','CL','DL')TL_PYTM2 – Archives unprocessed Payable Time ('ES','NA','RP','IG') |
|
TL_PAYABLE_HIST |
TL_PAYABLE_HIST |
TL_PYTM1 TL_PYTM2 |
Begin Date End Date |
|
|
TL_RPTD_TIME |
TL_RPT_TIME_HST |
TL_RPDTM |
No Parameter |
Reported_Time table is archived based on the Payable Time rows that are archived. |
|
TL_EXCEPTION |
TL_EXCEPTN_HST |
TL EXCEP |
Begin Date End Date |
|
|
TL_XREF_TBL |
TL_XREF_TBL_HST |
TL_XREF |
No Parameter |
Xref_Table is archived based on Payable Time rows that are archived. |
|
TL_XREF_COST |
TL_XREF_COST_HST |
TL_XCOST |
No Parameter |
Xref_Cost is archived based on Xref_Table rows that are archived |
|
TL_COMPLEAVE_TBL |
TL_COMPLEAVE_HST |
TL_COMP |
Begin Date End Date |
|
|
TL_COMP_DAY_BAL |
TL_COMP_DAY_HST |
TL_CMPBA |
Begin Date End Date |
|
|
TL_IPT1_CNT |
TL_IPT1_CNT_HST |
TL_PYTM1TL_PYTM2 |
Begin Date End Date |
|
|
TL_RULE_OVRD |
TL_RULEOVRD_HST |
TL_RLOVR |
Begin Date End Date |
|
|
AUDIT_TLRPTTIME |
AUDIT_TLRPT_HST |
TLR_AUDT |
Begin Date End Date |
|
|
SCH_MNG_SCHTBL |
SCH_MNG_SCH_HST |
SCH_MNG_SCH_HST |
Begin Date End Date |
|
|
SCH_ADHOC_DTL |
SCH_ADHODTL_HST |
TL_SCADH |
Begin Date End Date |
|
|
SCH_EXT_DTL |
SCH_EXT_DTL_HST |
TL_SCXDT |
Begin Date End Date |
|
|
TL_FRCS_PYBL_TM |
TL_FRCSPYBL_HST |
TL_FRCPA |
Begin Date End Date |
|
|
TL_OT_DATA |
TL_OT_DATA_HST |
TL_OTDAT |
Begin Date End Date |
|
|
TL_OT_STATUS |
TL_OTSTATUS_HST |
TL_OTDAT |
Begin Date End Date |
|
|
TL_TR_COMMENTS |
TL_COMMENTS_HST |
TL_COMMT |
Begin Date End Date |
Archiving Payable Time Approvals
The new archive Template TLPYAPPR is available for archiving Payable time approval related tables. For a list of tables that are archived as part of this template, refer the below table.
Image: Manage Archive Templates page
This example illustrates the fields and controls on the Manage Archive Templates page for Payable Time approval tables.
|
Field or Control |
Definition |
|---|---|
| Archive Template Objects |
Insert from the list of archive objects previously defined in the database. |
| Selective Archiving Queries |
TL_PAY_APPR_ARCHIVE_QRY is configured with this template as selective archiving query. This query fetches data from PS_TL_APP_PAY_XRF as a base table for archiving data related to approval tables for payable time. The query has two bind parameters Begin Date and End Date which are used to fetch data. |
| AE Processes |
The Post AE Progam TL_ARCHIVE application engine process archives the following tables (PSWORKLIST, EOAW_WL, HCSC_AWE_TXNLOG, EOAW_USER_ESCAL and EOAW_USERINS) as part of this template. You can define different Application Engine (AE) programs to run for each of the archiving processes. |
Note: This is a delivered template for archiving payable time approval related tables. If you are adding custom AE, then the logic to populate the aforesaid tables needs to be taken care of.
See “Using PeopleSoft Data Archive Manager” and “Managing Archive Template” in PeopleTools: Data Management product documentation.
|
Base Table/Record Name |
Archive Table/Record Name |
Archive Object |
Comments |
|---|---|---|---|
|
TL_APP_PAY_XRF |
TL_APP_PYXR_HST |
TL_PAY_TIME_EOAPPR |
Payable time XRF table and related EO tables are archived based on the rows from TL_APP_PAY_XRF for the given dates specified as input parameters |
|
EOAW_COMMENTS |
EOAW_COMM_HST |
||
|
EOAW_HIS_COMM |
EOAW_HISCOM_HST |
||
|
EOAW_TO_LOG |
EOAW_TO_LG_HST |
||
|
HCSC_USTEP_ATRB |
HCSC_USTPAT_HST |
||
|
EOAW_STEPINST |
EOAW_STPIST_HST |
||
|
TL_APP_PAY_LINE |
TL_APP_PYLN_HST |
TL_PAY_LINE_APPR |
Payable time Line level table is archived based on the rows from TL_APP_PAY_XRF for the given dates specified as input parameters |
|
TL_APP_PAY_HDR |
TL_APP_PYHD_HST |
TL_PAY_HDR_APPR |
Payable time header level table is archived based on the rows from TL_APP_PAY_XRF for the given dates specified as input parameters |
|
EOAW_SUMMARY |
EOAW_SUMMRY_HST |
EO_SUMM |
EO Summary and detail tables are archived |
|
EOAW_SUMM_DTL |
EOAW_SUMDTL_HST |
||
|
PSWORKLIST |
HCSC_WRKLST_HST |
These tables are archived using the post process AE based on the data archived in TL_APP_PYXR_HST |
|
|
EOAW_WL |
EOAW_WL_HIST |
||
|
HCSC_AWE_TXNLOG |
HCSC_AWETLG_HST |
||
|
EOAW_USER_ESCAL |
EOAW_ESCAL_ARC |
||
|
EOAW_USERINST |
EOAW_USRIST_HST |
For more information, See “Using PeopleSoft Data Archive Manager” in PeopleTools: Data Management product documentation.