File Naming Formats

This topic provides details concerning how DataConnect extract files are named.

Master Data and Billing Data Extracts

Extract files for master data and billing data extracts (except extracts for Bill Segment Lines and Service Quantities, see below) use the following naming format:

<provided_​file_​name><data_​source_​indicator><batch_​number><batch_​thread_​number><sysdate date/time>.dat

where:

  • <provided_​file_​name> is the file name as specified for the Flat File Name parameter on the batch control.
  • <data_​source_​indicator>is the Data Source Indicator value, which comes from the Environment ID field on the Installation Options table (CI_​INSTALLATION.ENV_​ID). This field is 6 digits, with left padded zeros as appropriate.
  • <batch_​number> is the batch number of the batch process that created the file. This field is 10 digits, with left padded zeros as appropriate.
  • <batch_​thread_​number> is the thread number of the process that created the file. This field is 3 digits, with left padded zeros as appropriate.
  • <sysdate date/time> is the date and time at which the file was created, if the Include Run Date/Time on Flat File Name parameter on the batch control was set to "Y", displayed as YYYYMMDDHHMMSS.

Example: If run with the following parameters and values:

  • D_​ACCT_​EXT is the value in the Flat File Name parameter
  • 000004 is the Data Source Indicator value
  • 0000000003 is the batch number
  • 001 is the thread number
  • 20141001123020 is the system date/time (2014-10-01.12.30.20)

the extract file name would be as follows:

D_ACCT_EXT000004000000000300120141001123020.DAT

This file naming format is used for extracts created using the following batch controls:

  • Account Characteristic Data Extract for DataConnect (C1-ACCHX)
  • Bill Data Extract for DataConnect (C1-BLDTX)
  • Bill Segment Data Extract for DataConnect (C1-BSDTX)
  • Characteristic Type Data Extract for DataConnect (C1-CHTYX)
  • Customer Data Extract for DataConnect (C1-CUDTX)
  • Mailing Address Extract for DataConnect (C1-MADTX)
  • Person Characteristic Data Extract for DataConnect (C1-PECHX)
  • Premise Characteristic Data Extract for DataConnect (C1-PRCHX)
  • SA/SP Data Extract for DataConnect (C1-SSDTX)
  • SA Characteristic Data Extract for DataConnect (C1-SACHX)
  • SP and Meter Data Extract for DataConnect (C1-SPMSY)
  • SP - CCB Characteristic Data Extract for DataConnect (C1-SPCHX)
  • SP - MDM Characteristic Data Extract for DataConnect (X1-SPCHX)
  • Billing Data Extract for Legacy DataConnect (C1-BSYEX)
  • Meter History Extract for Legacy DataConnect (C1-SMSYX)
  • SA-Based Extract for Legacy DataConnect (C1-SASYX)
  • SP-Based Extract for Legacy DataConnect (C1-SPSYX)

Bill Segment Line and Service Quantity Extracts

Extract files for for bill segment lines and service quantities use a naming format as specified on the File Name parameter. This can include the following system variables

  • {BC} or {batchCode}: the batch code for the batch control.
  • {BN} or {batchNumber}: the batch number of the batch process that created the file. This field is 4 digits, with left padded zeros as appropriate.
  • {RN} or {rerunNumber}: the rerun number of the batch process that created the file if rerun. This field is 2 digits, with left padded zeros as appropriate.
  • {TN} or {threadNumber}: the thread number of the process that created the file. This field is3 digits, with left padded zeros as appropriate. For multi-threaded runs, {threadNumber} will be inserted if not supplied.
  • {RDT} or {runDateTime}: the date and time at which the file was created, displayed as yyyyMMddHHmmss.
  • {RD} or {runDate}: the date on which the file was created, displayed as yyyyMMdd.
  • {RT} or {runTime}: the time at which the file was created, displayed as HHmmss.

Example: Specifting 'EXTRACT_​FILE_​{BN}_​{RN}_​{TN}.zip' as the File Name will create the following files for batch number 10, rerun number 0, with 3 threads:

EXTRACT_FILE_0010_00_001.zip
EXTRACT_FILE_0010_00_002.zip
EXTRACT_FILE_0010_00_003.zip

This file naming format is used for extracts created using the following batch controls:

  • Bill Segment Lines Extract for DataConnect (C1-BSLDX)
  • Bill Segment SQ Extract for DataConnect Extract (C1-BSSQX)