How daniellepashayan/ccn-bulk-populate works
This Python application builds Northwell charge-correction Excel inputs from Electronic and Paper ETM exports. The main workflow selects an export and generation date, filters eligible invoices, maps CPT codes and fields into a template, excludes invoices present in recent outputs, and saves a formatted file. A separate resubmission workflow identifies prior bot results marked not worked and adds matching current invoices to an output. The README is empty; the graph reflects the supplied source excerpts, so unrelated database helpers are omitted.
Main entry points: file.py Raw file processor · resubmission.py Resubmission workflow · bulk_combine.py Bulk combine · date_functions.py Business date rules
Components 14
Run orchestration
- Main entry
main.py - Bulk combine
bulk_combine.py
Invoice processing
- Raw file processor
file.py
Resubmission
- Resubmission workflow
resubmission.py
Shared rules
- Column and CPT mappings
util/mappings.py - CPT conversion
util/utilitiy_functions.py - Business date rules
util/date_functions.py - Logging
util/logger_config.py
Other components
- Operator
- ETM exports
- CCN template
references/ccn_template.xlsx - Recent formatted files
- Formatted CCN files
- Prior bot results
Connections 20
- Operator → Main entry: starts
- Main entry → Bulk combine: runs both types
- Bulk combine → Business date rules: gets generation date
- Bulk combine → Raw file processor: creates processor
- Raw file processor → ETM exports: reads export
- Raw file processor → CCN template: reads template
- Raw file processor → Column and CPT mappings: uses mappings
- Raw file processor → CPT conversion: converts CPTs
- Raw file processor → Business date rules: gets generation date
- Raw file processor → Recent formatted files: checks recent invoices
- Raw file processor → Formatted CCN files: writes workbook
- Operator → Resubmission workflow: runs resubmission
- Resubmission workflow → ETM exports: reads current export
- Resubmission workflow → Prior bot results: reads prior results
- Resubmission workflow → Raw file processor: creates processor
- Resubmission workflow → Business date rules: gets generation date
- Resubmission workflow → Formatted CCN files: appends resubmissions
- Bulk combine → Logging: logs progress
- Raw file processor → Logging: logs processing
- Resubmission workflow → Logging: logs progress