LeasePak Utilities

223 Credit Bureau Export Files

This Utility option will create the Credit Bureau Export files.

Below is an example of using this utility:

This Utility option will create the Credit Bureau Export files.
Do you wish to continue (Y/N)? 

Enter Y to continue. The program will display:

Client Password?

Enter the correct LeasePak client string password to proceed. The program will display:

Available extract types:

  M - Metro 2

  B - Business

  E - Exclusion

  A - All


Enter extract type (M/B/E/A), <RETURN> to exit: 

Enter M, B, E, or A to continue. The program will display: An invalid code will result in the message “Invalid extract type. ” and return the user to the same input . On entering correct code, the program will display:

Enter Metro 2 code, <RETURN> to exit: 

Enter a valid metro 2 code. An invalid code will result in the message “Invalid Metro 2 code.”. and return the user to the same input request. If user enter more than than 4 characters in length than that will result in “ The Metro 2 code must be no greater than <4> characters.” If the entered code is not found in RMO table that will result in the messages “Invalid Metro 2 code.” for the correct metro 2 code the program will display:

Enter reporting month in YYMM format, <RETURN> to exit:

Enter the reporting month in YYMM format. If the response is an invalid year/month than it will result in the message “Invalid reporting month.” The Program will display:

Enter multi-process count (1 - 40), <RETURN> to exit:

Enter a valid multi-process count value to continue. If another user is already running an extract on the same Metro 2 code, the utility will not run, instead displaying the message:

Another process is already running the extract on Metro 2 code <metro2Code>.

This message will appear because 2 users running the extract simultaneously would overwrite each other's files.

NOTE: Multiple users running same extract on Metro 2 code will result in error message. When 2 users running the extract simultaneously would overwrite each other's files.

Credit Bureau Export File Extracts:

This utility will result in three different extracts depending upon the input provided in the utility prompts. If user selects A- All the utility will result in three extracts. If user selects any of the option other than A - All the utility extract file will depend on the seclected option extract.

Metro 2 Extract:

If user selects M - Metro2 than the utility will generate an extracted output file in format of Metro 2 named as cb_metro2_<metro2Code>rm<YYMM>.ext
Where <metro2Code> is the 4-character Metro 2 Code assigned to the lease (rxl.metro2_s) and <YYMM> is the YYMM date on rxl.ym_rep_s and rxc.ym_rep_s matching the input parameter "Enter the reporting month in YYMM format".

Business Extract:

If user selects B - Business than the utility will generate an extracted output file in format of Metro 2 named as cb_business_<metro2Code>_rm<YYMM>.ext Where <metro2Code> is the 4-character Metro 2 Code assigned to the lease (rxl.metro2_s) and <reportingMonth> is the YYMM date on rxl.ym_rep_s and rxc.ym_rep_s matching the input parameter "Enter the reporting month in YYMM format".

Exclusion Extract:

If user selects E - Exclusion than the utility will generate an extracted output file in a Custom format named as cb_exclusion_<metro2Code>_rm<YYMM>.ext Where <metro2Code> is the 4-character Metro 2 Code assigned to the lease (rxl.metro2_s) and <reportingMonth> is the YYMM date on rxl.ym_rep_s and rxc.ym_rep_s matching the input parameter "Enter the reporting month in YYMM format"

Exclusion Reasons:

Following are the exclusion reasons:

• ACTIVSTAT - User set up the account to stop credit bureau reporting by way of a qualifying U0709 Activity Status/Substatus combination where the processing task "Include in Credit Bureau Extract" is set to 'N'.
  • rxl.excl_act_stat_c == 'Y'

• STOPCB - User marked the account to stop reporting by setting "Report to Credit Bureau" to 'N' (clearing the box) in U0239 Credit Bureau Lease.
  • rxl.excl_stop_rpt_c == 'Y'
  
  The extract will either display the first 10 characters of "Reason to Not Report", if any, or STOPCB as the reason.

• ECOATACCT - User set account to stop credit reporting by way of bankruptcy settings in U0241 Credit Bureau Bankruptcy.
  • rxc.excl_bankrupt_c == 'Y'
  The account has only one client attached, client ECOA is set to T and has already been reported.

• ECOATCUST - User set account to stop credit reporting by way of bankruptcy settings in U0241 Credit Bureau Bankruptcy.
  • rxc.excl_bankrupt_c == 'Y'
  Client has ECOA set to T and has already been reported.

• COLLSTAT - User marked the account to stop reporting by setting "Suppress Credit Bureau Extr" to 'Y' (checking the box) in U1151 Collection Status Defaults for the client's current collection status.
  • rxc.excl_col_stat_c == 'Y'

Extract Processing:

Each extract file is a fixed text file using the Metro 2 file layout standards (except for the change specified for Exclusion Extract), as defined in the CRRG. Each file contains the following:

• 1 Header Record
• 1 Base Segment per account/lease (includes information for main client)
• 1 J2 Segment per client (lessee, co-lessee, or guarantor) attached to the account/lease other than the client reported on the Base Segment
• 1 Trailer Record.

All of the extracts will be from RXL & RXC column values.

Credit Bureau Extract users: The U0462 Credit Bureau Extract, will run as an End of Month process, creates and updates the records in RXL and RXC tables.