Archiving Extract Table Data
After you submit the flat files to the government, you can archive the data in the reports extract archive tables. This process takes the data in the extract tables and saves it to archive tables. The report date acts as an effective date; so you can store multiple report periods in the applicable archive tables. After you run the archive process for a particular report and report period, you cannot run the archive process again. If you attempt to do so, the archive program writes a message in the log file.
The system archives your data in the following tables:
CAN_ARC_ESIS_IC
CAN_ARC_ESIS_ID
CAN_ARC_ESIS_IP
CAN_ARC_ESIS_SC
CAN_ARC_ESIS_SD
CAN_ARC_ESIS_SP
CAN_ARC_ESIS_ST
CAN_ARCH_USISE
CAN_ARCH_USMET
CAN_ARCH_CIS
CAN_ARCH_OUAC
|
Page Name |
Definition Name |
Navigation |
Usage |
|---|---|---|---|
|
Archive Extract File |
RUNCTL_CAN_ARCHIVE |
|
All: Define run parameters for the Canada Report Archive process (SRARCH). |
Access the Archive Extract File page ().
|
Field or Control |
Definition |
|---|---|
| Academic Institution |
Enter the institution that you want to archive. |
| Report Type |
Enter the report type that you want to archive. |
| Report Period |
Enter the report period that you want to archive. |
Click Run to run the SRARCH report using PeopleSoft Process Scheduler.