|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimDate |
| Database Table Name | DimDate |
| Schema | dbo |
| Friendly Name | DimDate |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
DateSK |
DateSK |
System.Int32 | ||
 |
FullDate |
FullDate |
System.DateTime | ||
|
DateName |
DateName |
System.String(25) | ||
|
PayPeriodCode |
PayPeriodCode |
System.Int16 | ||
|
DayOfMonth |
DayOfMonth |
System.Byte | ||
|
DayOfWeek |
DayOfWeek |
System.Byte | ||
|
DayOfYear |
DayOfYear |
System.Int16 | ||
|
Day |
Day |
System.String(35) | ||
|
FiscalMonth |
FiscalMonth |
System.String(25) | ||
|
FiscalMonthOfYear |
FiscalMonthOfYear |
System.Byte | ||
|
FiscalQuarter |
FiscalQuarter |
System.String(25) | ||
|
FiscalYear |
FiscalYear |
System.String(15) | ||
|
IsCurrentFiscalYear |
IsCurrentFiscalYear |
System.String(1) | ||
|
IsPriorFiscalYear |
IsPriorFiscalYear |
System.String(1) | ||
|
IsNextFiscalYear |
IsNextFiscalYear |
System.String(1) | ||
|
MonthOfYear |
MonthOfYear |
System.Byte | ||
|
Month |
Month |
System.String(35) | ||
|
QuarterOfYear |
QuarterOfYear |
System.String(10) | ||
|
Quarter |
Quarter |
System.String(20) | ||
|
WeekOfYear |
WeekOfYear |
System.Byte | ||
|
Week |
Week |
System.String(25) | ||
|
WeekdayWeekend |
WeekdayWeekend |
System.String(10) | ||
|
Year |
Year |
System.String(15) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
RowChangeReason |
RowChangeReason |
System.String(200) | ||
|
AuditKey |
AuditKey |
System.Int32 | ||
|
FiscalPeriod |
System.String(20) | |||
|
CalendarPeriod |
System.String(15) | |||
|
CalendarPeriodSort |
System.Int32 | |||
|
CalendarMonthOfYear |
System.String(35) | |||
|
FiscalPeriodOfYear |
System.String(6) | |||
|
IsAvailableForFinance |
System.String(1) | |||
|
IsCurrentDay |
System.String(1) |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
CheckDateSK |
FactPositionExpense |
Table |
False |
||
StartDateSK |
FactPositionBudget |
Table |
False |
||
EndDateSK |
FactPositionBudget |
Table |
False |
||
StartDateSK |
FactHoursWorkedByWeek |
Table |
False |
||
EndDateSK |
FactHoursWorkedByWeek |
Table |
False |
||
DateReportedSK |
FactHoursReportedByDay |
Table |
False |
||
CheckDateSK |
FactCheckSummary |
Table |
False |
||
PayrollProcessedDateSK |
FactCheckSummary |
Table |
False |
||
CheckIssuedDateSK |
FactCheckSummary |
Table |
False |
||
CheckDateSK |
FactCheckComponent |
Table |
False |
||
DateSK |
FactStudentReceiptTotals |
Table |
False |
||
DateSK |
FactStudentReceiptPayments |
Table |
False |
||
FiscalYearDateSK |
FactPurchaseOrderAmounts |
Table |
False |
||
EntryDateSK |
FactPurchaseOrderAmounts |
Table |
False |
||
PayableDateSK |
FactPayableAmounts |
Table |
False |
||
PaymentDateSK |
FactPayableAmounts |
Table |
False |
||
PostedDateSK |
FactGlTransactions |
Table |
False |
||
DateSK |
FactGlTransactions |
Table |
False |
||
DateSK |
FactGlSummaryBalances |
Table |
False |
||
DateSK |
FactGlRollOverBalances |
Table |
False |
||
DateSK |
FactEnrollmentActivity |
Table |
False |
||
DateSK |
FactEnrollmentSnapshot |
Table |
False |
||
DateSK |
FactPriorEnrollmentSnapshot |
Table |
False |
||
DateSK |
FactEOTEnrollmentSnapshot |
Table |
False |
||
DateSK |
FactActiveEnrollmentSnapshot |
Table |
False |
| Powered by BI Documenter |
