Data Field Definitions - Deposit Files

There are many deposit fields used in Financial Performance Suite (FPS). These fields are set up on the File Layout Setup page for the daily update process or monthly update process.

On the File Layout Setup page, required fields are noted with an asterisk. Required fields can change based on the selected file layout and which modules the institution is licensed for. If a required field is not mapped, then exceptions can occur.

FPS Deposit Fields	Field Descriptions	Notes
Account Number	An identifier that is used to determine an account.	This number must be unique for each row in the file.
Adjustment Frequency	The frequency at which the interest rate can be adjusted on the account.	There can be two fields listed, one to identify the time value and one to define the time measurement (days or months). Provide a list of codes that your institution uses.
Analysis ID	An indicator for if an account uses the account analysis feature.	Provide a list of codes that your institution uses.
Average Balance	The average balance for the month.	If not available, this value can be calculated using the aggregate balance and number of days. If neither are available, then the ending balance is used.
Branch Number	An identifier for the specific branch or revenue center that owns this account.	Provide a list of codes that your institution uses.
Closed Date	The date that the account was closed.	N/A
Collected Balance	The balance before float.	N/A
Current Index	An identifier for the index that an account is tied to.	Provide a list of codes that your institution uses.
Customer ID	A unique value that identifies the customer.	Same identifier as provided in the customer file.
Ending Balance	The actual balance at the end of the month when the file is generated.	N/A
Funding Curve Date	The date that is used to determine the yield curve to use for funds transfer pricing.	Only required for time deposits. Typically, this date is derived from the last repricing date, renewal date, or origination date, whichever is most recent.
Interest Expense	The amount of interest expense for the month.	N/A
Interest Rate	The actual interest rate on a given deposit account.	N/A
Last Repricing Date	The last date on which the deposit had the interest rate adjusted.	N/A
Maturity Date	The date of the final maturity.	Only required for time deposits.
Next Repricing Date	The next date at which the account can have the interest rate adjusted.	N/A
Officer ID	An identifier for the employee who manages or is responsible for the account.	N/A
Original Balance	The amount deposited at the time of origination.	N/A
Original Interest Rate	The initial rate when the account was opened.	N/A
Origination Date	The date that the account was opened.	N/A
Product ID	An identifier for the type of deposit product for the account that is being downloaded. For example, a money market account (MMA).	Sometimes, more than one code must be included to distinguish one product from another. Include all codes that can be necessary and provide a list of codes that your institution uses.
Rate Type	An identifier that is used to determine if the account is fixed or variable.	Provide a list of codes that your institution uses.
Rate Variance	A rate that identifies the amount of spread above or below a rate index that is used to determine the interest rate on the account.	You can provide a separate field that indicates if the value is positive or negative.
Renewal Date	The date the account was last renewed.	N/A
Service Charge	The amount of service charges for the month on the account.	Provide a list of codes that your institution uses.
Status	A field used to exclude certain deposit accounts.	Sometimes, you need more than one code. Provide a list of codes that your institution uses.
Term	The term of the time deposit in months.	Only required for time deposits. There can be two fields listed, one to identify the time value and one to define the time measurement (days or months). If not available, this field can be computed from origination date and maturity date.

Additional CECL Fields	Field Descriptions	Notes
Total.Deposits	The total for the ending balance at the end of the month when the file is generated for the customer.	Provided by FPS.