Upload CSV File for Batch Processing

Upload a CSV file containing multiple patients' diagnosis codes for analysis.

CSV Format Requirements:

Required columns: patient_id, sequence, icd_code, poa_status
Optional column: dx_pr (values: DX for diagnosis, PR for procedure, or blank defaults to DX)
Each row represents one diagnosis or procedure code for a patient
Sequence numbers must include 1 for primary diagnosis
POA status must be one of: Y, N, E, W, U (can be blank for procedure codes)
ICD-10 codes can be entered with or without decimals
Procedure codes (ICD-10-PCS) are analyzed for risk variables but not for MCC/CC or HCC

File Size Limits:

Maximum file size: 1MB
Maximum rows: 20,000
If your file exceeds these limits, consider splitting it into smaller batches

HIPAA Compliance - No PHI:

Patient IDs must be de-identified (no names, SSNs, MRNs, or other PHI)
Use anonymous patient numbers or study IDs only
Do not include patient names, dates of birth, addresses, or any identifiable information
This tool processes diagnosis codes only - no PHI is stored or transmitted

Sample CSV Formats

Important: Patient IDs below are examples of de-identified numbers. Do not use real patient identifiers.

Basic Format (Diagnoses Only):

patient_id,sequence,icd_code,poa_status
12345,1,I50.1,Y
12345,2,I10,Y
12345,3,E11.9,Y
67890,1,I50.9,Y
67890,2,J44.1,Y
67890,3,N18.3,Y

With Procedure Codes (Optional dx_pr Column):

patient_id,dx_pr,sequence,icd_code,poa_status
12345,DX,1,I50.1,Y
12345,DX,2,I10,Y
12345,PR,1,0W1P0Z4,
12345,PR,2,02HV33Z,
67890,DX,1,I50.9,Y
67890,DX,2,J44.1,Y

Note: The dx_pr column is optional. Use "DX" for diagnosis codes and "PR" for procedure codes. POA can be blank for procedure codes.

Heart Failure Diagnosis Analysis