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 table
Payable Time Approval table
Reported Time table
Reported Time Approval table
Xref_table
Xref_Cost table

You use the same prompts to archive Payable Time and Reported Time.

The following video provides an overview of archiving payable time approval data:

Video: Image Highlights, PeopleSoft HCM Update Image 29: Archive Payable Time Data Including Approvals

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 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.

Term	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.

Term

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.

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	EO_SUMM	EO Summary and detail tables are archived.
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.

Archiving Reported Time Approvals

The archive Template TLRPAPPR is available for archiving Reported time approval-related tables. The tables that are archived as part of this template, are listed below.

Base Table/Record Name	Archive Table/Record Name	Archive Object	Comments
TL_APP_RPTD_XRF	TL_APP_RPXR_HST	TL_RPT_TIME_EOAPPR	Reported time XRF table and related EO tables are archived based on the rows from TL_APP_RPTD_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_RPT_LINE	TL_APP_RPLN_HST	TL_APP_RPT_LINE_APPR	Reported time Line level table is archived based on the rows from TL_APP_RPTD_XRF for the given dates specified as input parameters.
TL_APP_HDR	TL_APP_HDR_HST	TL_RPT_HDR_APPR	Reported time header level table is archived based on the rows from TL_APP_RPTD_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	EO_SUMM	EO Summary and detail tables are archived.
PSWORKLIST	HCSC_WRKLST_HST		These tables are archived using the post process AE based on the data archived in TL_APP_RPTD_XRF.
EOAW_WL	EOAW_WL_HIST
HCSC_AWE_TXNLOG	HCSC_AWETLG_HST
EOAW_USER_ESCAL	EOAW_ESCAL_ARC
EOAW_USERINST	EOAW_USRIST_HST

Manage Archive Templates page for Reported Time Approval archive

Term	Definition
Archive Template Objects	The archive objects related to reported time approval is configured here.
Selective Archiving Queries	TL_RPT_APPR_ARCHIVE_QRY is configured with this template as selective archiving query. This query fetches data from PS_TL_APP_RPTD_XRF as a base table for archiving data related to approval tables for reported 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.