Difference between revisions of "04 job es2j005d transaction file purging old data"
Jump to navigation
Jump to search
m (1 revision imported) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 10: | Line 10: | ||
'''Job Features and Functions''' | '''Job Features and Functions''' | ||
| + | <small>''' | ||
| + | *Identifies and deletes transaction file (Administrative, Quarterly and MOA) records | ||
| + | *Identification based on year/month/day transaction date | ||
| + | *Records deleted if transaction date is either older than the parameter date or older than oldest quarter on Micro File | ||
| + | *Serves as a tool to manage the size of transaction files'''</small> | ||
Job 005D deletes records from the Administrative, MOA, and Quarterly Transaction Files. The deletion process is based on date, allowing the user to limit the size of transaction files by selectively deleting records older than the date specified in the parameters. | Job 005D deletes records from the Administrative, MOA, and Quarterly Transaction Files. The deletion process is based on date, allowing the user to limit the size of transaction files by selectively deleting records older than the date specified in the parameters. | ||
| Line 24: | Line 29: | ||
* [[04_job_es2j007c_firm_listing_summary_report|Job ES2J007C - Firm Listing and Summary Report - Data Sharing (CIPSEA-Compliant)]] | * [[04_job_es2j007c_firm_listing_summary_report|Job ES2J007C - Firm Listing and Summary Report - Data Sharing (CIPSEA-Compliant)]] | ||
* [[04_batch_job_processing|Batch Job Processing Table of Contents]] | * [[04_batch_job_processing|Batch Job Processing Table of Contents]] | ||
| − | * [[ | + | * [[EXPO_Documentation|EXPO/EARS Documentation Home]] |
Latest revision as of 21:41, 10 April 2020
Job ES2J005D - Transaction File Purging of Old Data
RUN THIS JOB - As required. Not typically run.
This job executes the following programs (click to link to each program description):
Job Features and Functions
- Identifies and deletes transaction file (Administrative, Quarterly and MOA) records
- Identification based on year/month/day transaction date
- Records deleted if transaction date is either older than the parameter date or older than oldest quarter on Micro File
- Serves as a tool to manage the size of transaction files
Job 005D deletes records from the Administrative, MOA, and Quarterly Transaction Files. The deletion process is based on date, allowing the user to limit the size of transaction files by selectively deleting records older than the date specified in the parameters.
Default “pruning” of transaction data occurs in Job 001Q with a six-month limit on transaction history. Job 005D is only needed for supplemental runs when even less historical transaction data is required.
Note: No report of records deleted by Job 005D (or 001Q) is produced. Running Job 016D will produce a hard copy report of transaction records before deletion occurs.
Related Links
