Variable routeFusionProgramTable`Const`

routeFusionProgramTable: Omit<
    PgTableWithColumns<
        {
            columns: {
                active: PgBuildColumn<
                    "route_fusion_program",
                    SetHasDefault<SetNotNull<PgBooleanBuilder>>,
                    {
                        data: boolean;
                        dataType: "boolean";
                        driverParam: boolean;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_fusion_program";
                    },
                >;
                bankId: PgBuildColumn<
                    "route_fusion_program",
                    SetNotNull<PgIntegerBuilder>,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_fusion_program";
                    },
                >;
                createdAt: PgBuildColumn<
                    "route_fusion_program",
                    SetHasDefault<SetNotNull<PgTimestampBuilder>>,
                    {
                        data: Date;
                        dataType: "object date";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_fusion_program";
                    },
                >;
                deletedAt: PgBuildColumn<
                    "route_fusion_program",
                    PgTimestampBuilder,
                    {
                        data: Date;
                        dataType: "object date";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "route_fusion_program";
                    },
                >;
                description: PgBuildColumn<
                    "route_fusion_program",
                    PgTextBuilder<[string, ...string[]]>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "route_fusion_program";
                    },
                >;
                externalId: PgBuildColumn<
                    "route_fusion_program",
                    SetHasRuntimeDefault<SetNotNull<PgTextBuilder<[string, ...string[]]>>>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_fusion_program";
                    },
                >;
                id: PgBuildColumn<
                    "route_fusion_program",
                    HasIdentity<SetIsPrimaryKey<PgIntegerBuilder>, "byDefault">,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: "byDefault";
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_fusion_program";
                    },
                >;
                name: PgBuildColumn<
                    "route_fusion_program",
                    SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_fusion_program";
                    },
                >;
                routeFusionProgramId: PgBuildColumn<
                    "route_fusion_program",
                    SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_fusion_program";
                    },
                >;
                updatedAt: PgBuildColumn<
                    "route_fusion_program",
                    SetHasDefault<SetNotNull<PgTimestampBuilder>>,
                    {
                        data: Date;
                        dataType: "object date";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "route_fusion_program";
                    },
                >;
            };
            dialect: "pg";
            name: "route_fusion_program";
            schema: "b2b";
        },
    >,
    "enableRLS",
> = ...

Admin-curated registry of RouteFusion virtual-account programs.

A program pairs a RouteFusion program id (routeFusionProgramId, sent as platform_id on entity mutations) with an operator label. Assigning a program writes its routeFusionProgramId into customer.data.routeFusionProgramId, which is the VA-route eligibility gate (routeFusionProgramId is_set).

The RouteFusion org credential is NOT stored here — the worker holds a single org JWT (from env) and derives user_id from its id claim.

active = false pauses a program from new customer assignment (it stays listed) — distinct from deletedAt, which soft-deletes the row.

Variable routeFusionProgramTableConst

Settings

Variable routeFusionProgramTable`Const`