| Loan Date |
Stores the loan date in the date format 2/29/2012 |
|
| Start of Week |
The date of the first business day of the week |
|
| Week Number |
The number of the week of the year |
|
| Loan Month Key |
Stores the month of the date in number format such as 2 for February |
This field is useful when you want to sort by month |
| Loan Month |
Stores the month of the date in month description format such as February |
|
| Loan Fiscal Month Key |
Stores the fiscal month of the date in number format such as 2 for February |
|
| Loan Full Month |
Stores the month and the year of the date in a display format such as Feb 12 |
|
| Loan Quarter |
Stores the quarter of the date in a display format such as Q1 |
|
| Loan Year |
Stores the year of the date in string format such as 2012 |
|
| Loan Fiscal Year |
Stores the fiscal year of the date in string format such as 2012. |
|
| Loan Time |
Stores the time in the hours:minutes:seconds format for the loan date |
|
| Loan Date |
Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific loan date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy. |
|
