|
|
|
|
|
|
Each tuple in the fact table represents a credit transaction done by an individual.
Field Name |
Data Type |
Description |
Date_Key |
Integer |
Foreign Key reference Date Table |
Customer_Key |
Integer |
Foreign Key reference Customer table |
Institution_Key |
Integer |
Foreign Key reference Institution table |
Account_Key |
Integer |
Foreign Key reference AccountType Table |
Mortgage_Key |
Integer |
Foreign Key reference MortgageType Table |
Days_Overdue |
Integer |
This field represents the number of days credit is overdue. 99999 Represents Bad Debt. |
Outstanding_Amount |
Float |
Outstanding amount for a credit transaction |