PSI Risk Sequencing - Patient Safety Analysis

CareKate Analytics Logo
Batch Processing Mode - Upload CSV File
Switch to Single Patient

Upload CSV File for Batch PSI Risk Analysis

Upload a CSV file containing multiple patients' diagnosis codes for PSI risk variable analysis using Elixhauser comorbidity methodology.

CSV Format Requirements:
  • Required columns: patient_id, sequence, icd_code, poa_status
  • Each row represents one diagnosis for a patient
  • Sequence numbers must include 1 for primary diagnosis
  • POA status must be one of: Y, N, E, W, U
  • ICD-10 codes can be entered with or without decimals
  • Primary diagnoses (sequence 1) will not receive risk variable assignments
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
Maximum file size: 1MB | Maximum rows: 20,000
Back to Single Patient Form

Sample CSV Format

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

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

Note: Primary diagnoses (sequence 1) do not receive risk variable assignments in PSI methodology. Secondary diagnoses will be analyzed for Elixhauser comorbidity risk variables based on POA status and trigger rules.

This website uses cookies to enhance your browsing experience and analyze site traffic. By clicking "Accept", you consent to our use of cookies. For more information, please visit our Privacy Policy.