Account limits report files

The account limits report contains all consolidated account balances from the previous day. The report is in the parquet format and is part of the scheduled report files.

The job that generates the account limits report file runs daily at 04:00:00 UTC 0. The files for this job are saved in the customer S3 bucket in the reports/accounts_limits/ path and are partitioned by date in the YYYY/MM/DD format.

πŸ“˜

The date partition values correspond to the last available data date, not when the job is executed. For example, if a daily job runs on 2022/03/11, the date partition values correspond to 2022/03/10.

To start receiving this file, contact the data team to configure access to the S3 bucket.

The following table lists and describes the account limits report fields.

πŸ“˜

The report's decimal values are rounded to the hundredths.

Field

Type

Description

Org_ID

String

Organization ID.

RefDate

Date

Date that the account limits report file was generated.

Account_ID

Integer

Account ID.

ProgramName

String

Account program name.

Program_ID

Integer

Account program ID.

AccountStatus

String

Account status.

MaxCreditLimit

Decimal

Maximum issuer-granted account credit limit.

AvailableCreditLimit

Decimal

Current balance available for account spending.

TotalCreditLimit

Decimal

Maximum amount that the user can indicate for the available limit to be used for purchases.

TotalOverDraftLimit

Decimal

Maximum issuer-granted limit for over draft spending on debit accounts.

AvailableSavingsAccountLimit

Decimal

Current balance applied to an interest-bearing account.

PercentageOverLimit

Decimal

Percentage of the maximum limit - MaxCreditLimit - for purchases over the limit on credit accounts.


Did this page help you?