Circle V2 API Docs
    Preparing search index...

    Variable extendRunsTableConst

    extendRunsTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    completedAt: 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: "completed_at";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        { $type: DbDate },
                    >;
                    createdAt: 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: "created_at";
                            notNull: true;
                            tableName: "extend_runs";
                        },
                        {},
                        { $type: Generated },
                    >;
                    entityId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgInteger";
                            data: EntityId;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "entity_id";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        { $type: EntityId },
                    >;
                    externalRunId: 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: "external_run_id";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        {},
                    >;
                    facilityId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgUUID";
                            data: FacilityId;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "facility_id";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        { $type: FacilityId },
                    >;
                    failureReason: 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: "failure_reason";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        {},
                    >;
                    fileName: 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: "file_name";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        {},
                    >;
                    id: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBigInt53";
                            data: Generated;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: "byDefault";
                            isAutoincrement: false;
                            isPrimaryKey: true;
                            name: "id";
                            notNull: true;
                            tableName: "extend_runs";
                        },
                        {},
                        { $type: Generated },
                    >;
                    integrationId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgUUID";
                            data: IntegrationId;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "integration_id";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        { $type: IntegrationId },
                    >;
                    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: false;
                            name: "patient_chart_id";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        { $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: false;
                            tableName: "extend_runs";
                        },
                        {},
                        { $type: PatientId },
                    >;
                    rawPayload: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgJsonb";
                            data: TData;
                            dataType: "json";
                            driverParam: unknown;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "raw_payload";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        { $type: TType },
                    >;
                    rpaRunId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBigInt53";
                            data: RpaRunId;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "rpa_run_id";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        { $type: RpaRunId },
                    >;
                    source: 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: "source";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        {},
                    >;
                    status: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgText";
                            data: | "processing"
                            | "failed"
                            | "rejected"
                            | "needs_review"
                            | "pending"
                            | "completed";
                            dataType: "string";
                            driverParam: string;
                            enumValues: [string, ...string[]];
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "status";
                            notNull: true;
                            tableName: "extend_runs";
                        },
                        {},
                        {
                            $type: | "processing"
                            | "failed"
                            | "rejected"
                            | "needs_review"
                            | "pending"
                            | "completed";
                        },
                    >;
                    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: "extend_runs";
                        },
                        {},
                        { $type: TreatmentEpisodeId },
                    >;
                    workflowId: 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: "workflow_id";
                            notNull: false;
                            tableName: "extend_runs";
                        },
                        {},
                        {},
                    >;
                };
                dialect: "pg";
                name: "extend_runs";
                schema: undefined;
            },
        >,
        "enableRLS",
    > = ...

    One row per Extend workflow run. Correlated to the provider by external_run_id (Extend's workflowRun id). When the run was spawned from an RPA result, rpa_run_id points back at the originating rpaRunsTable. raw_payload stores the Extend webhook exactly as received. Optional facility_id / treatment_episode_id scope patient-specific runs.

    Settings

    Member Visibility