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 - |
Updated about 1 month ago