Transferred files must be renamed on ACF Titan

[ADPennington]

Description

All files transferred to ACFTitan have a fixed name: ADS.E2J.FTP8.TSNone which was introduced in #1736. Evidence is captured here. The file-renaming logic starting here needs refinement to match the standard file naming conventions expected by the legacy system.

Acceptance Criteria

• all files submitted through TDP are renamed to match standard TDRS file naming conventions included in STT model filenames field.
• Testing Checklist has been run and all tests pass
• README is updated, if necessary

Tasks

• Update stt models.py
• Update create_filename function
• Run Testing Checklist and confirm all tests pass

Notes:

• SECTION value in renamed file should be 1, 2, 3, or 4 only (not 8) and can be mapped from the section name associated with the original file as follows:

  • 1: =Active Case Data
  • 2:=Closed Case Data
  • 3:= Aggregate Data
  • 4:= Stratum Data

  Note: TDP is currently only using these section names, since we are not yet distinguishing between SSP and TANF and Tribal TANF data reports.

• FTP and TS are not standard parts of the renamed file convention. All of the exact file names, by section name, can be pulled from the STT model's filenames field, but will need some conditional logic since the section names in this field do not exist yet in TDP. For example:

  • if Indiana, submits a section 1 file of SSP data using TDP today, this file will have a section name == Active Case Data but should be SSP Active Case Data.
    

  • Similarly, if Tulalip Tribes submits a section 1 of Tribal TANF data using TDP today, this file a section name == Active Case Data but should be Tribal Active Case Data.
    

• STT_CODE must be 2 digits for states and territories, and 3 digits for tribes in the renamed file (leading zeros included). this is currently not the way this code is saved in the STT Model. see below.
  

[ADPennington]

@stevenino please add this ticket as a dependency to closing out the sftp epic.

[raftmsohani]

As per our conversation, the decision is to use the first 4 values in stt.filenames field using section value for the time being.