FA_FEE_STR_DET (SQL Table)	Index Back
Fee Analysis Structure Detail Fee Structure Control Data Detail rjb 6/23/2000 Set FA_FEE_BASE_FEE and PRICE to 0 if FA_FEE_CODE = T.

FA_FEE_STR_DET

(SQL Table)

Fee Analysis Structure Detail

Fee Structure Control Data Detail rjb 6/23/2000 Set FA_FEE_BASE_FEE and PRICE to 0 if FA_FEE_CODE = T.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

3 FA_FEE_STRUCT_CD Character(10) VARCHAR2(10) NOT NULL Structure Code for Fee Analysis
Prompt Table: FA_FEE_STR_HDR

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

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_FEE_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Used to determine how the fee will be calculated. Driven off translates since we should support a finite amount of calc types
B=Base Fee
D=Discounted Price
F=Flat Fee
H=Threshold Price
M=Minimum Fee
R=Rate Based Charge
T=Tiered Price
X=Maximum Fee
Z=Total/Balance

7 FA_FEE_BASE_FEE Number(9,2) DECIMAL(8,2) NOT NULL This is the base fee for calculating the service charges.

8 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.

9 FA_FEE_MIN_FEE Number(9,2) DECIMAL(8,2) NOT NULL This is the minimum fee for calculating the service charge.

10 FA_FEE_MAX_FEE Number(9,2) DECIMAL(8,2) NOT NULL This is the maximum fee for calculating the service charge.

11 RATE Number(8,5) DECIMAL(7,5) NOT NULL Rate

12 FA_RECONCILE_SW Character(1) VARCHAR2(1) NOT NULL This switch determines whether the fee analysis recon is run against this fee code or not.
Y/N Table Edit
Default Value: Y

13 INT_BASIS Character(2) VARCHAR2(2) NOT NULL Day Count Basis
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
3	FA_FEE_STRUCT_CD	Character(10)	VARCHAR2(10) NOT NULL	Structure Code for Fee Analysis Prompt Table: FA_FEE_STR_HDR
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
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_FEE_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used to determine how the fee will be calculated. Driven off translates since we should support a finite amount of calc types B=Base Fee D=Discounted Price F=Flat Fee H=Threshold Price M=Minimum Fee R=Rate Based Charge T=Tiered Price X=Maximum Fee Z=Total/Balance
7	FA_FEE_BASE_FEE	Number(9,2)	DECIMAL(8,2) NOT NULL	This is the base fee for calculating the service charges.
8	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
9	FA_FEE_MIN_FEE	Number(9,2)	DECIMAL(8,2) NOT NULL	This is the minimum fee for calculating the service charge.
10	FA_FEE_MAX_FEE	Number(9,2)	DECIMAL(8,2) NOT NULL	This is the maximum fee for calculating the service charge.
11	RATE	Number(8,5)	DECIMAL(7,5) NOT NULL	Rate
12	FA_RECONCILE_SW	Character(1)	VARCHAR2(1) NOT NULL	This switch determines whether the fee analysis recon is run against this fee code or not. Y/N Table Edit Default Value: Y
13	INT_BASIS	Character(2)	VARCHAR2(2) NOT NULL	Day Count Basis 30=30/360 3E=30E/360 A0=Actual/360 A5=Actual/365 AA=Actual/Actual