Circle V2 API Docs
    Preparing search index...

    Variable utilizationServicesTableConst

    utilizationServicesTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    attendedMinutes: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgNumeric";
                            data: string;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "attended_minutes";
                            notNull: false;
                            tableName: "utilization_services";
                        },
                        {},
                        {},
                    >;
                    billable: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBoolean";
                            data: boolean;
                            dataType: "boolean";
                            driverParam: boolean;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "billable";
                            notNull: true;
                            tableName: "utilization_services";
                        },
                        {},
                        {},
                    >;
                    derivedAt: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgTimestampString";
                            data: Generated;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "derived_at";
                            notNull: true;
                            tableName: "utilization_services";
                        },
                        {},
                        { $type: Generated },
                    >;
                    leaderName: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgText";
                            data: string;
                            dataType: "string";
                            driverParam: string;
                            enumValues: [string, ...string[]];
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "leader_name";
                            notNull: false;
                            tableName: "utilization_services";
                        },
                        {},
                        {},
                    >;
                    patientChartId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBigInt53";
                            data: PatientChartId;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: true;
                            name: "patient_chart_id";
                            notNull: true;
                            tableName: "utilization_services";
                        },
                        {},
                        { $type: PatientChartId },
                    >;
                    patientId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBigInt53";
                            data: PatientId;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "patient_id";
                            notNull: true;
                            tableName: "utilization_services";
                        },
                        {},
                        { $type: PatientId },
                    >;
                    present: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBoolean";
                            data: boolean;
                            dataType: "boolean";
                            driverParam: boolean;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "present";
                            notNull: true;
                            tableName: "utilization_services";
                        },
                        {},
                        {},
                    >;
                    serviceType: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgText";
                            data: UtilizationServiceType;
                            dataType: "string";
                            driverParam: string;
                            enumValues: [string, ...string[]];
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "service_type";
                            notNull: true;
                            tableName: "utilization_services";
                        },
                        {},
                        { $type: UtilizationServiceType },
                    >;
                    source: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgEnumColumn";
                            data: | "kipu_evaluation"
                            | "kipu_consent_form"
                            | "kipu_ciwa_ar"
                            | "kipu_ciwa_b"
                            | "kipu_group_session"
                            | "lightningstep_formdata"
                            | "lightningstep_txplan"
                            | "kipu_vital_signs"
                            | "kipu_orthostatic_vital_signs"
                            | "kipu_patient_orders"
                            | "kipu_glucose_logs"
                            | "kipu_program_history"
                            | "kipu_diagnosis_history"
                            | "kipu_appointment"
                            | "lightningstep_admissions"
                            | "kipu_episode_outcome"
                            | "sunwave_form"
                            | "sunwave_diagnosis"
                            | "sunwave_group_note"
                            | "sunwave_program"
                            | "sunwave_lab_result"
                            | "sunwave_assessment"
                            | "emr_insurance_information"
                            | "insync_episode_summary"
                            | "insync_condition"
                            | "insync_vital_signs"
                            | "insync_lab_result"
                            | "insync_observation"
                            | "insync_allergy"
                            | "insync_immunization"
                            | "insync_medication_request"
                            | "insync_diagnostic_report"
                            | "insync_procedure"
                            | "insync_rpa_locadtr"
                            | "insync_rpa_treatment_plan"
                            | "insync_rpa_biopsychosocial"
                            | "synthetic_biopsychosocial"
                            | "synthetic_asam"
                            | "synthetic_consent"
                            | "synthetic_nursing_intake"
                            | "synthetic_diagnosis"
                            | "synthetic_treatment_plan"
                            | "synthetic_group_note"
                            | "synthetic_progress_note"
                            | "synthetic_ur_review"
                            | "synthetic_discharge_summary"
                            | "insync_rpa_encounter_note"
                            | "insync_rpa_consent_form"
                            | "insync_rpa_lab_result"
                            | "insync_rpa_insurance"
                            | "insync_rpa_document";
                            dataType: "string";
                            driverParam: string;
                            enumValues: [
                                "kipu_evaluation",
                                "kipu_consent_form",
                                "kipu_ciwa_ar",
                                "kipu_ciwa_b",
                                "kipu_group_session",
                                "lightningstep_formdata",
                                "lightningstep_txplan",
                                "kipu_vital_signs",
                                "kipu_orthostatic_vital_signs",
                                "kipu_patient_orders",
                            ];
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "source";
                            notNull: true;
                            tableName: "utilization_services";
                        },
                        {},
                        {},
                    >;
                    sourceUpdatedAt: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgTimestampString";
                            data: DbDate;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "source_updated_at";
                            notNull: false;
                            tableName: "utilization_services";
                        },
                        {},
                        { $type: DbDate },
                    >;
                    startedAt: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgTimestampString";
                            data: DbDate;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "started_at";
                            notNull: true;
                            tableName: "utilization_services";
                        },
                        {},
                        { $type: DbDate },
                    >;
                    timeZone: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgText";
                            data: string;
                            dataType: "string";
                            driverParam: string;
                            enumValues: [string, ...string[]];
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "time_zone";
                            notNull: true;
                            tableName: "utilization_services";
                        },
                        {},
                        {},
                    >;
                    title: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgText";
                            data: string;
                            dataType: "string";
                            driverParam: string;
                            enumValues: [string, ...string[]];
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "title";
                            notNull: false;
                            tableName: "utilization_services";
                        },
                        {},
                        {},
                    >;
                    treatmentEpisodeId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgUUID";
                            data: TreatmentEpisodeId;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "treatment_episode_id";
                            notNull: false;
                            tableName: "utilization_services";
                        },
                        {},
                        { $type: TreatmentEpisodeId },
                    >;
                    windowEnd: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgTimestampString";
                            data: DbDate;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "window_end";
                            notNull: false;
                            tableName: "utilization_services";
                        },
                        {},
                        { $type: DbDate },
                    >;
                    windowStart: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgTimestampString";
                            data: DbDate;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "window_start";
                            notNull: false;
                            tableName: "utilization_services";
                        },
                        {},
                        { $type: DbDate },
                    >;
                };
                dialect: "pg";
                name: "utilization_services";
                schema: undefined;
            },
        >,
        "enableRLS",
    > = ...

    One documented service per synced EMR note, derived from patient_charts.raw_document off the request path so the Utilization roll-ups never parse stored notes. Every column is a copy or a derivation of its chart; utilizationServicesRepo.syncServicesFromChangedCharts is the only writer, and a chart that stops qualifying loses its row there. Nothing from the group roster is stored.