Class FedParticipantDirService

new FedParticipantDirService(args: { sqlClient: Sql }): FedParticipantDirService

get(
    args: { id: string } | { routingNumber: string },
): Promise<
    {
        ok: true;
        value: | {
            bookEntrySecuritiesStatus: boolean;
            city: string;
            createdAt: Date;
            customerName: string;
            dateOfLastRevision: Date
            | null;
            fundsSettlementOnlyStatus: boolean;
            fundsTransferStatus: boolean;
            id: string;
            routingNumber: string;
            stateCode: string;
            telegraphicName: string;
            updatedAt: Date;
        }
        | null;
    },
>

search(
    args: {
        createdAt?: DbTimestampCriteria;
        id?: string[];
        nameLike?: string;
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            bookEntrySecuritiesStatus: 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: "bookEntrySecuritiesStatus";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            city: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "city";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            createdAt: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "createdAt";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            customerName: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "customerName";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            dateOfLastRevision: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "dateOfLastRevision";
                                    notNull: false;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            externalId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: true;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "externalId";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            fundsSettlementOnlyStatus: 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: "fundsSettlementOnlyStatus";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            fundsTransferStatus: 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: "fundsTransferStatus";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            id: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgInteger";
                                    data: number;
                                    dataType: "number";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: "byDefault";
                                    isAutoincrement: false;
                                    isPrimaryKey: true;
                                    name: "id";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            routingNumber: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "routingNumber";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            stateCode: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "stateCode";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            telegraphicName: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "telegraphicName";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                            updatedAt: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "updatedAt";
                                    notNull: true;
                                    tableName: "fed_participant_directory";
                                },
                                {},
                                {},
                            >;
                        };
                        dialect: "pg";
                        name: "fed_participant_directory";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        routingNumber?: string[];
        updatedAt?: DbTimestampCriteria;
    },
): Promise<
    {
        ok: true;
        value: {
            bookEntrySecuritiesStatus: boolean;
            city: string;
            createdAt: Date;
            customerName: string;
            dateOfLastRevision: Date
            | null;
            fundsSettlementOnlyStatus: boolean;
            fundsTransferStatus: boolean;
            id: string;
            routingNumber: string;
            stateCode: string;
            telegraphicName: string;
            updatedAt: Date;
        }[];
    },
>