idacd

Aggregated Credit Data (ACD) / Disaggregated Credit Data (DACD) To facilitate project management, project packaging and quality control on Equifax ACD and DACD projects.  Overview The idacd shell script has been design to facilitate project management, project packaging and quality control on Equifax ACD and DACD projects running on Red Hat Linux and Oracle database […]
Project Name
Aggregated Credit Data (ACD) / Disaggregated Credit Data (DACD)
Project Goal
To facilitate project management, project packaging and quality control on Equifax ACD and DACD projects.

Details

 Overview

The idacd shell script has been design to facilitate project management, project packaging and quality control on Equifax ACD and DACD projects running on Red Hat Linux and Oracle database environments. It requires no Linux or bash knowledge by the users.

At the command prompt, type ‘idacd’.


Documentation

The options are:

 i. OASIS Output Analysis

At the prompt, enter a valid OASIS id number. If an invalid OASIS id is entered, the program terminates and nothing is done. This option completes all 9 steps required for specialist packaging and qa verification.

 ii. OASIS Output Preparation

At the prompt, enter a valid OASIS id number, a PRD number and a client name. If an invalid OASIS id is entered, the program terminates and nothing is done. This option is client specific and it’s only for OASIS based projects

  • If the client entered is AMEX, then the program splits, compresses and moves the output files into a temporary folder and into the ${base_directory}/Telecom/Upload/sFTP directory ready to be transferred to AMEX server. Remember that we still need to ask the operator to run the ${apps_directory}/sftp_t7/send_dacd_t7.ksh script to transfer the files to American Express.
  • If the client entered is CITI, then the program splits, compresses and moves the output files into a temporary folder and into the ${base_directory}/Telecom/Upload/sFTP directory ready to be transferred to Citifinancial server. Remember that we still need to ask the operator to run the ${apps_directory}/sftp_t7/send_dacd_t7.ksh script to transfer the files to Citifinancial.
  • If the client entered is not AMEX and CITI, then the program only compress and moves the output files into a temporary folder. We, then, can download the files for burning of the DVD.

NOTE! The temporary folder created by the program is okay to be deleted. It is created only for QA purposes only.

 iii. Both 1 & 2

This option completes both i and ii above at the same time.

 iv. BATCH Output Analysis

At the prompt, enter a valid BATCH client. If an invalid BATCH client is entered, the program terminates and nothing is done. The only BATCH clients available at this moment are AMEX, BU and CITI. The projects for these clients are semi-automated and their output files are created automatically after each ACD/DACD database refresh. This option completes all 9 steps required for specialist packaging and qa verification.

 v. BATCH Output Preparation

At the prompt, enter a valid BATCH client and a PRD number. If an invalid BATCH client is entered, the program terminates and nothing is done. The only BATCH clients available at this moment are AMEX, BU and CITI. This option is client specific and it’s only for BATCH based projects.

  • If the client entered is AMEX, then the program moves the output files from ${base_directory}/batch/MCCYYMM batch directory to a permanent directory, split them, compress them and copy them into the ${base_directory}/Telecom/Upload/sFTP directory ready to be transferred to AMEX server. Remember that we still need to ask the operator to run the ${apps_directory}/sftp_t7/send_dacd_t7.ksh script to transfer the files to American Express.
  • If the client entered is BU, then the program moves the output files from ${base_directory}/batch/MCCYYMM batch directory to a permanent directory. This is the final directory we send to PSBI.
  • If the client entered is CITI, then the program moves the output files from ${base_directory}/batch/MCCYYMM batch directory to a permanent directory, split them, compress them and copy them into the ${base_directory}/Telecom/Upload/sFTP directory ready to be transferred to Citifinancial server. Remember that we still need to ask the operator to run the ${apps_directory}/sftp_t7/send_dacd_t7.ksh script to transfer the files to Citifinancial.
  • If the client entered is not AMEX, BU and CITI, then the program terminates and nothing is done.

NOTE! The permanent folder created by the program must NOT be deleted as it contains all original files.

 vi. Both 4 & 5

This option completes both iv and v above at the same time.

 vii. Interactive Analysis

This option covers the output analysis for all ACD/DACD projects in an interactive mode. It’s faster if you are only interested in checking only few checkpoints.

 viii. Server Maintenance

This option keeps track of projects that have been already performed by users. When this option is triggered a list of outstanding projects is displayed asking the user to take action. The purpose of this functionality is to keep the dspdb server clean.

 ix. Exit

Quits the program.


Development

 References

  1. Mastering Unix Shell Scripting, 2nd Edition
    Randal K. Michael
  2. Unix & Linux Visual QuickStart Guide, 5th Edition
    Deborah S. Ray and Eric J. Ray
  3. Pro Bash Programming
    Chris F. A. Johnson
  4. Unix and Linux System Administration and Shell Programming
    Milo