Delivered Archive Procedures for Commitment Control

Three archive procedures are delivered for the archiving of commitment control records and tables:

CC Activity Archive
CC Journals Archive
CC Ledgers Archive

Archive Procedure	Tables Archived	Prompts and Inclusion or Exclusion Rules
CC Activity Archive: The Archive Preprocess Application Engine process (KK_AR_AC_PRE) must be run to update the Process Instance of the KK_SOURCE_HDR for rows that are to be archived, based on the Archive Query selection criteria, which can be user-defined, and the implicit rules described for the commitment control activity tables. No post-process is necessary.	KK_SOURCE_HDR KK_SOURCE_LN KK_ACTIVITY_LOG KK_ACT_LOG_FS KK_TRANS_LOG KK_REFERENCED KK_EXCPTN_TBL KK_OVERRIDE_TBL KK_LIQUIDATION Product KK Source Header Tables (see list below)	Archive Query prompt selection criteria: Business unit from and to. Transaction date. Inclusion and Exclusion Rules: The Archive Preprocess Application Engine program (KK_AR_AC_PRE) must be used to select source transactions and their related transactions that are to be archived. Source documents must be fully liquidated to be available for archive. Other user-defined rules can be imposed in the associated Archive Query.
Commitment Control Journals: The KK_BUDGET_HDR is the base table and the KK_BUDGET_LN is the nonbase table. No preprocess or post-process are required.	KK_BUDGET_HDR KK_BUDGET_LN	Archive Query prompt selection criteria: Business unit from and to. Ledger group from and to. Journal Date (on or before). Inclusion and Exclusion Rules (user-configurable through the Archive Queries), for example, you require that all journals have a status of posted or unposted.
Commitment Control Ledgers: No preprocess or post-process is necessary. The LEDGER_KK rows that are to be archived are based on the Archive Query selection criteria, which can be user-defined.	LEDGER_KK LEDGER_KK_FS	Archive Query prompt selection criteria: Business unit from and to. Ledger group from and to. Fiscal year (data on or before the specified year). Inclusion and Exclusion Rules (all are user-configurable through the Archive Queries): Related commitment control activity tables must already be archived (as addressed in delivered Query KK_ARCHIVE_LEDGER_EXCL2). Budget must be closed (as addressed in delivered Query KK_ARCHIVE_LEDGER_EXCL1).

Archive Procedure

Tables Archived

Prompts and Inclusion or Exclusion Rules

CC Activity Archive: The Archive Preprocess Application Engine process (KK_AR_AC_PRE) must be run to update the Process Instance of the KK_SOURCE_HDR for rows that are to be archived, based on the Archive Query selection criteria, which can be user-defined, and the implicit rules described for the commitment control activity tables. No post-process is necessary.

KK_SOURCE_HDR
KK_SOURCE_LN
KK_ACTIVITY_LOG
KK_ACT_LOG_FS
KK_TRANS_LOG
KK_REFERENCED
KK_EXCPTN_TBL
KK_OVERRIDE_TBL
KK_LIQUIDATION
Product KK Source Header Tables (see list below)

Archive Query prompt selection criteria:

Business unit from and to.
Transaction date.

Inclusion and Exclusion Rules:

The Archive Preprocess Application Engine program (KK_AR_AC_PRE) must be used to select source transactions and their related transactions that are to be archived.
Source documents must be fully liquidated to be available for archive.
Other user-defined rules can be imposed in the associated Archive Query.

Commitment Control Journals: The KK_BUDGET_HDR is the base table and the KK_BUDGET_LN is the nonbase table. No preprocess or post-process are required.

KK_BUDGET_HDR
KK_BUDGET_LN

Archive Query prompt selection criteria:

Business unit from and to.
Ledger group from and to.
Journal Date (on or before).

Inclusion and Exclusion Rules (user-configurable through the Archive Queries), for example, you require that all journals have a status of posted or unposted.

Commitment Control Ledgers: No preprocess or post-process is necessary. The LEDGER_KK rows that are to be archived are based on the Archive Query selection criteria, which can be user-defined.

LEDGER_KK
LEDGER_KK_FS

Archive Query prompt selection criteria:

Business unit from and to.
Ledger group from and to.
Fiscal year (data on or before the specified year).

Inclusion and Exclusion Rules (all are user-configurable through the Archive Queries):

Related commitment control activity tables must already be archived (as addressed in delivered Query KK_ARCHIVE_LEDGER_EXCL2).
Budget must be closed (as addressed in delivered Query KK_ARCHIVE_LEDGER_EXCL1).

These commitment control archive procedures are delivered as sample data with all the necessary history tables, preprocesses, archive object definitions, query definitions, and template definitions necessary to archive commitment control activity, ledgers, and journals.

If other archiving needs should arise, you can modify or create new objects using the Data Archive Manager and Application Designer as described in PeopleSoft PeopleTools documentation.

See PeopleTools: Data Administration Tools, "Using PeopleSoft Data Archive Manager"

The following lists the product KK Source Header Table name for each Source Transaction.

Source Transaction	Product KK Source Header Table
AP_VOUCHER	KK_SHDR_APVCHR
AP_ACCT_LN	KK_SHDR_APACTLN
AP_ACCTDSE	KK_SHDR_APACTLN
AP_ACTDSEC	KK_SHDR_APACTLN
AP_VCHR_NP	KK_SHDR_APVCHR
AR_MISCPAY	KK_SHDR_ARMPAY
AR_REVEST	KK_SHDR_ARRVEST
BI_INVOICE	KK_SHDR_BIINV
CM_TRNXTN	KK_SHDR_CMTRN
EX_EXCLOSE	KK_SHDR_EXSHEET
EX_EXSHEET	KK_SHDR_EXSHEET
EX_TRVAUTH	KK_SHDR_EXTRATH
GENERIC	KK_SHDR_GEN
GL_BD_JRNL	KK_SHDR_GLJRNL
GL_JOURNAL	KK_SHDR_GLJRNL
GM_FA	KK_SHDR_GMFA
GM_FA_UPG	KK_SHDR_GMFA
HR_PAYROLL	KK_SHDR_HRPAY
PC_BUDGET	KK_SHDR_PCJRNL
PC_JOURNAL	KK_SHDR_PCJRNL
PO_POENC	KK_SHDR_POENC
PO_POENCNP	KK_SHDR_POENC
PO_PROCARD	KK_SHDR_POCARD
PO_RAENC	KK_SHDR_PORA
PO_RAEXP	KK_SHDR_PORA
REQ_PRECNP	KK_SHDR_REQ
PEQ_PREENC	KK_SHDR_REQ