Variable greendotSettlementBatchTable`Const`

greendotSettlementBatchTable: Omit<
    PgTableWithColumns<
        {
            columns: {
                adviceObjectKey: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                adviceTotalAmount: PgBuildColumn<
                    "greendot_settlement_batch",
                    PgNumericBuilder,
                    {
                        data: string;
                        dataType: "string numeric";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "greendot_settlement_batch";
                    },
                >;
                createdAt: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                detailObjectKey: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                entryCount: PgBuildColumn<
                    "greendot_settlement_batch",
                    SetHasDefault<SetNotNull<PgIntegerBuilder>>,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "greendot_settlement_batch";
                    },
                >;
                externalId: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                fileDate: PgBuildColumn<
                    "greendot_settlement_batch",
                    SetNotNull<PgDateStringBuilder>,
                    {
                        data: string;
                        dataType: "string date";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "greendot_settlement_batch";
                    },
                >;
                id: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                partner: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                processor: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                program: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                settlementAccount: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                status: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                totalAmount: PgBuildColumn<
                    "greendot_settlement_batch",
                    SetHasDefault<SetNotNull<PgNumericBuilder>>,
                    {
                        data: string;
                        dataType: "string numeric";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "greendot_settlement_batch";
                    },
                >;
                transmissionId: PgBuildColumn<
                    "greendot_settlement_batch",
                    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: "greendot_settlement_batch";
                    },
                >;
                updatedAt: PgBuildColumn<
                    "greendot_settlement_batch",
                    SetHasDefault<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: "greendot_settlement_batch";
                    },
                >;
            };
            dialect: "pg";
            isAlias: false;
            name: "greendot_settlement_batch";
            schema: "b2b";
        },
    >,
    "enableRLS",
> = ...

One Green Dot settlement transmission: one TransmissionID, one detail file. totalAmount and entryCount are derived from the entries and are the authority; adviceTotalAmount is what the advice file asserted, null on the dates it never arrived. The table indexes the bucket: each object key names the file a batch was read from, unique, so a key resolves to one batch. Both are written by whichever ingest reads that file, live or backfill; the detail key is null only until a detail file has arrived.

dbmate owns the DDL: 20261017173109_greendot_settlement_tables.sql.

Variable greendotSettlementBatchTableConst

Settings

Variable greendotSettlementBatchTable`Const`