FEE_DETAIL 
EntityType  Dependent 
Logical Entity Name  FEE_DETAIL 
Default Table Name  DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/LOANS/LOAN/FEE_INFORMATION/FEES/FEE/FEE_DETAIL 
Definition   
Note 
 

FEE_DETAIL Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
FeeBorrowerChosenProviderIndicator  MISMOIndicator  BIT  NO  When true, indicates the provider of the service for which the particular fee is charged was selected by the borrower independent of the lender or lender-provided list. 
FeeItemDescription  MISMOString  VARCHAR(0)  NO  The description of the Fee item. 
FeePaidToType  FeePaidToEnum  VARCHAR(0)  YES  Identifies the category or type of payee to which the fee will be paid
 
FeePaidToTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field to capture the description when Other is selected as Fee Paid To Type. 
FeePercentBasisType  FeePercentBasisEnum  VARCHAR(0)  YES  Defines the amount upon which the Fee Total Percent is calculated.
 
FeePercentBasisTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to collect additional information when Other is selected for Fee Percent Basis Type. 
FeeRequiredProviderOfServiceIndicator  MISMOIndicator  BIT  NO  When true, indicates a required Provider of Service is associated with this fee. 
FeeSpecifiedFixedAmount  MISMOAmount  DECIMAL(0, 2)  NO  The specified fixed dollar portion of the Fee Total Amount. This is used when the Fee Total Amount is made up of a percentage (stated in the Fee Total Percent) plus a specified fixed dollar amount. 
FeeSpecifiedHUD1LineNumberValue  MISMOValue  VARCHAR(0)  NO  HUD Line Number for fee items that pertain to miscellaneous sections of the HUD form where there is not a one-to-one mapping between the line number and the line description. 
FeeTotalAmount  MISMOAmount  DECIMAL(0, 2)  NO  The total dollar amount paid by all parties for the specified Fee or Specified HUD Line Number. 
FeeTotalPercent  MISMOPercent  DECIMAL(0, 2)  NO  The total percent paid by all parties for the specified Fee or Specified HUD Line Number. This is used in conjunction with the Fee Percent Basis Type to determine a dollar amount of the fee. May be used in conjunction with Specified Fixed Amount to determ 
FeeType  FeeEnum  VARCHAR(0)  YES  Specifies the general names (type) of fees associated with the Good Faith Estimate/HUD-1.
 
FeeTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form test field used to capture the description of Other fee from Fee Type. 
GFEAggregationType  GFEAggregationEnum  VARCHAR(0)  YES  Specifies the fee or charges group, combined fee or charges category, or compensation category, to which the individual fee or charge should be associated, as reflected on a single instance of the GFE.
 
GFEAggregationTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for GFE Aggregation Type. 
GFEDisclosedFeeAmount  MISMOAmount  DECIMAL(0, 2)  NO  The dollar amount, as disclosed on a single instance of the GFE, for the specified RESPA Fee or Specified HUD Line Number. 
SectionClassificationType  SectionClassificationEnum  VARCHAR(0)  YES  The section number on the Good Faith Estimate/HUD-1 associated with a fee type.
 

FEE_DETAIL Keys 
Key Name  Key Type  Keys 

FEE_DETAIL Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
FEE  Identifying  One to Zero or One          NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

FEE_DETAIL Check Constraints 
Check Constraint Name  CheckConstraint 

FEE_DETAIL Bound Attachments 
Name  Current Value 

FEE_DETAIL User-Defined Mappings 
Model  Name  Description 

FEE_DETAIL Data Movement Rules 
Name  Type  Rule Text/Value