Variable rpaRunsTable`Const`

rpaRunsTable: 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: "rpa_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: "rpa_runs";
                    },
                    {},
                    { $type: Generated },
                >;
                currentStep: 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: "current_step";
                        notNull: false;
                        tableName: "rpa_runs";
                    },
                    {},
                    {},
                >;
                documentCount: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgInteger";
                        data: number;
                        dataType: "number";
                        driverParam: string
                        | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "document_count";
                        notNull: false;
                        tableName: "rpa_runs";
                    },
                    {},
                    { $type: number },
                >;
                dryRun: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgBoolean";
                        data: Generated;
                        dataType: "boolean";
                        driverParam: boolean;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "dry_run";
                        notNull: true;
                        tableName: "rpa_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: "rpa_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: "rpa_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: "rpa_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: "rpa_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: "rpa_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: "rpa_runs";
                    },
                    {},
                    { $type: IntegrationId },
                >;
                lastStepAt: 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: "last_step_at";
                        notNull: false;
                        tableName: "rpa_runs";
                    },
                    {},
                    { $type: DbDate },
                >;
                liveViewUrl: 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: "live_view_url";
                        notNull: false;
                        tableName: "rpa_runs";
                    },
                    {},
                    {},
                >;
                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: "rpa_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: "rpa_runs";
                    },
                    {},
                    { $type: TType },
                >;
                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: false;
                        tableName: "rpa_runs";
                    },
                    {},
                    { $type: DbDate },
                >;
                status: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgText";
                        data: "success"
                        | "failed"
                        | "pending"
                        | "running"
                        | "stopped";
                        dataType: "string";
                        driverParam: string;
                        enumValues: [string, ...string[]];
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "status";
                        notNull: true;
                        tableName: "rpa_runs";
                    },
                    {},
                    { $type: "success"
                    | "failed"
                    | "pending"
                    | "running"
                    | "stopped" },
                >;
                stepHistory: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgJsonb";
                        data: { at: string; step: string }[];
                        dataType: "json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "step_history";
                        notNull: false;
                        tableName: "rpa_runs";
                    },
                    {},
                    { $type: { at: string; step: string }[] },
                >;
                syncType: 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: "sync_type";
                        notNull: false;
                        tableName: "rpa_runs";
                    },
                    {},
                    {},
                >;
                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: "rpa_runs";
                    },
                    {},
                    { $type: TreatmentEpisodeId },
                >;
                triggeredBy: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgUUID";
                        data: UserId;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "triggered_by";
                        notNull: false;
                        tableName: "rpa_runs";
                    },
                    {},
                    { $type: UserId },
                >;
            };
            dialect: "pg";
            name: "rpa_runs";
            schema: undefined;
        },
    >,
    "enableRLS",
> = ...

One row per logical RPA run. Only columns we filter/sort/scope by are typed; everything else (provider, workflow id, etc.) lives in raw_payload, which stores the provider webhook exactly as received so the superadmin portal can render it without a bespoke schema. Runs are standalone — not linked to job_executions — so queue-row purging never affects run history. Optional facility_id / treatment_episode_id scope patient-specific runs.

Variable rpaRunsTableConst

Settings

Variable rpaRunsTable`Const`