FA_STMT_RTEDTL (SQL Table)	Index Back
Fee Analysis Statement/Rates Bank Fee Analysis Statement Rate Detail Section RJB 9/29/00 - Added ADJUST_DT to record

FA_STMT_RTEDTL

(SQL Table)

Fee Analysis Statement/Rates

Bank Fee Analysis Statement Rate Detail Section RJB 9/29/00 - Added ADJUST_DT to record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

3 FA_FEE_CYCLE_NUM Character(10) VARCHAR2(10) NOT NULL RJB 4/5/01 Added Analysis ID to label

4 FA_FEE_CD_SEQ_NUM Number(9,0) DECIMAL(9) NOT NULL This sequence number is used for preserving the order in the bank statement.

5 FA_FEE_CODE Character(20) VARCHAR2(20) NOT NULL Fee code mapped to Bank Fee code used for Fee Analysis.
Prompt Table: FA_FEE_CD_TBL

6 FA_SPEC_RATE Signed Number(9,4) DECIMAL(7,4) NOT NULL The value of the fee analysis statement specified rate expressed as a percentage. The number of decimal places shown should reflect the number of decimal places used in calculations.

7 FA_RATE_MULTIPLIER Signed Number(8,2) DECIMAL(6,2) NOT NULL The balance required to offset $1.00 of balance compensable service charges. This factor can be used to calculate the balance equivalent of balance compensable service charges. This multiplier is only relevant to earnings allowance rates.

8 FA_DAYS_IN_PERIOD Number(3,0) SMALLINT NOT NULL The number of days in the analysis period. (E.G. 31, 30 or 28 for monthly periods).

9 FA_DAYS_IN_YEAR Number(3,0) SMALLINT NOT NULL The number of days in the year. (E.G. 360, 365).

10 RATE_DATE Date(10) DATE Exchange Rate Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
3	FA_FEE_CYCLE_NUM	Character(10)	VARCHAR2(10) NOT NULL	RJB 4/5/01 Added Analysis ID to label
4	FA_FEE_CD_SEQ_NUM	Number(9,0)	DECIMAL(9) NOT NULL	This sequence number is used for preserving the order in the bank statement.
5	FA_FEE_CODE	Character(20)	VARCHAR2(20) NOT NULL	Fee code mapped to Bank Fee code used for Fee Analysis. Prompt Table: FA_FEE_CD_TBL
6	FA_SPEC_RATE	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	The value of the fee analysis statement specified rate expressed as a percentage. The number of decimal places shown should reflect the number of decimal places used in calculations.
7	FA_RATE_MULTIPLIER	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	The balance required to offset $1.00 of balance compensable service charges. This factor can be used to calculate the balance equivalent of balance compensable service charges. This multiplier is only relevant to earnings allowance rates.
8	FA_DAYS_IN_PERIOD	Number(3,0)	SMALLINT NOT NULL	The number of days in the analysis period. (E.G. 31, 30 or 28 for monthly periods).
9	FA_DAYS_IN_YEAR	Number(3,0)	SMALLINT NOT NULL	The number of days in the year. (E.G. 360, 365).
10	RATE_DATE	Date(10)	DATE	Exchange Rate Date