ST v13 required local input schema — column names/types only, no patient rows

{
  "supplied_parquet_inputs": {
    "data/cohort_v2.parquet": {
      "patientunitstayid": "integer ICU stay ID; nonmissing and unique",
      "patienthealthsystemstayid": "integer hospitalization ID",
      "uniquepid": "patient identifier string; nonmissing",
      "hospitalid": "integer deidentified hospital ID",
      "age_num": "numeric age in years; supplied adult cohort",
      "gender": "recorded sex string",
      "unittype": "ICU type string",
      "hospitaldischargeyear": "integer discharge year,2014/2015",
      "unitdischargeoffset": "numeric minutes from ICU admission to ICU exit",
      "hospitaldischargeoffset": "numeric minutes from ICU admission to hospital exit",
      "hospitaldischargestatus": "Alive/Expired/unknown string",
      "unitdischargestatus": "ICU discharge status string",
      "unitvisitnumber": "first-unit-visit code; supplied cohort all1"
    },
    "data/st_qc.parquet": {
      "stay_id": "integer ICU stay ID",
      "off": "numeric observation offset in minutes from ICU admission",
      "x": "numeric operational channel-median ST on archived scale; physical units unresolved",
      "n_ch": "number of retained ST channels",
      "range_flag": "Boolean operational between-channel range flag"
    }
  },
  "local_raw_csv_gz_required_columns": {
    "apachePatientResult.csv.gz": [
      "patientunitstayid",
      "apachescore",
      "predictedhospitalmortality",
      "acutephysiologyscore",
      "apacheversion"
    ],
    "lab.csv.gz": [
      "patientunitstayid",
      "labname",
      "labresult",
      "labresultoffset",
      "labresultrevisedoffset",
      "labmeasurenamesystem",
      "labmeasurenameinterface"
    ],
    "pastHistory.csv.gz": [
      "patientunitstayid",
      "pasthistorypath",
      "pasthistoryoffset",
      "pasthistoryenteredoffset"
    ],
    "diagnosis.csv.gz": [
      "patientunitstayid",
      "diagnosisstring",
      "diagnosisoffset"
    ],
    "treatment.csv.gz": [
      "patientunitstayid",
      "treatmentstring",
      "treatmentoffset"
    ],
    "infusionDrug.csv.gz": [
      "patientunitstayid",
      "drugname",
      "infusionoffset"
    ],
    "respiratoryCare.csv.gz": [
      "patientunitstayid",
      "ventstartoffset",
      "respcarestatusoffset"
    ],
    "vitalPeriodic.csv.gz": [
      "patientunitstayid",
      "observationoffset",
      "st1",
      "st2",
      "st3"
    ]
  },
  "timing_and_types": "Offsets are minutes relative to ICU admission. IDs join ICU stays, not independent patients. CSV columns are read by DuckDB with auto-detection; numeric score/risk/lab/channel fields use numeric casts where present. Missing/negative APACHE sentinels are not valid scores/risks. Unknown hospital outcomes are not survival. Troponin revised-entry bounds are an archival proxy, not verified bedside availability. Extra columns may be present. Exact variable names/case are shown; no example patient rows are supplied.",
  "raw_ST_scope": "vitalPeriodic is read only for the32-stay original-channel verification sample. Full-cohort strict24 features use supplied st_qc.parquet. No full raw-ST re-extraction is claimed.",
  "local_derivatives": "01 writes LOCAL_ONLY_all_stays.parquet,LOCAL_ONLY_selected_full.parquet,LOCAL_ONLY_primary.parquet;02 and02b write LOCAL_ONLY_predictions_*.parquet. These are private patient-level files and are excluded from this code package."
}

Observed input CSV header inventory (no record values):
{
  "lab": [
    "labid",
    "patientunitstayid",
    "labresultoffset",
    "labtypeid",
    "labname",
    "labresult",
    "labresulttext",
    "labmeasurenamesystem",
    "labmeasurenameinterface",
    "labresultrevisedoffset"
  ],
  "apachePatientResult": [
    "apachepatientresultsid",
    "patientunitstayid",
    "physicianspeciality",
    "physicianinterventioncategory",
    "acutephysiologyscore",
    "apachescore",
    "apacheversion",
    "predictedicumortality",
    "actualicumortality",
    "predictediculos",
    "actualiculos",
    "predictedhospitalmortality",
    "actualhospitalmortality",
    "predictedhospitallos",
    "actualhospitallos",
    "preopmi",
    "preopcardiaccath",
    "ptcawithin24h",
    "unabridgedunitlos",
    "unabridgedhosplos",
    "actualventdays",
    "predventdays",
    "unabridgedactualventdays"
  ],
  "diagnosis": [
    "diagnosisid",
    "patientunitstayid",
    "activeupondischarge",
    "diagnosisoffset",
    "diagnosisstring",
    "icd9code",
    "diagnosispriority"
  ],
  "treatment": [
    "treatmentid",
    "patientunitstayid",
    "treatmentoffset",
    "treatmentstring",
    "activeupondischarge"
  ],
  "infusionDrug": [
    "infusiondrugid",
    "patientunitstayid",
    "infusionoffset",
    "drugname",
    "drugrate",
    "infusionrate",
    "drugamount",
    "volumeoffluid",
    "patientweight"
  ],
  "respiratoryCare": [
    "respcareid",
    "patientunitstayid",
    "respcarestatusoffset",
    "currenthistoryseqnum",
    "airwaytype",
    "airwaysize",
    "airwayposition",
    "cuffpressure",
    "ventstartoffset",
    "ventendoffset",
    "priorventstartoffset",
    "priorventendoffset",
    "apneaparms",
    "lowexhmvlimit",
    "hiexhmvlimit",
    "lowexhtvlimit",
    "hipeakpreslimit",
    "lowpeakpreslimit",
    "hirespratelimit",
    "lowrespratelimit",
    "sighpreslimit",
    "lowironoxlimit",
    "highironoxlimit",
    "meanairwaypreslimit",
    "peeplimit",
    "cpaplimit",
    "setapneainterval",
    "setapneatv",
    "setapneaippeephigh",
    "setapnearr",
    "setapneapeakflow",
    "setapneainsptime",
    "setapneaie",
    "setapneafio2"
  ],
  "pastHistory": [
    "pasthistoryid",
    "patientunitstayid",
    "pasthistoryoffset",
    "pasthistoryenteredoffset",
    "pasthistorynotetype",
    "pasthistorypath",
    "pasthistoryvalue",
    "pasthistoryvaluetext"
  ]
}