|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_FactCheckSummary |
| Database Table Name | FactCheckSummary |
| Schema | dbo |
| Friendly Name | FactCheckSummary |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
CheckSummarySK |
CheckSummarySK |
System.Int32 | ||
 |
CheckDateSK |
CheckDateSK |
System.Int32 | ||
|
EmployeeSK |
EmployeeSK |
System.Int32 | ||
|
CheckIssuedDateSK |
CheckIssuedDateSK |
System.Int32 | ||
|
PayrollProcessedDateSK |
PayrollProcessedDateSK |
System.Int32 | ||
|
CheckTypeSK |
CheckTypeSK |
System.Int32 | ||
|
CheckNumber |
CheckNumber |
System.Int32 | ||
|
CheckProcessed |
CheckProcessed |
System.Byte | ||
|
CheckVoidedCanclled |
CheckVoidedCanclled |
System.Byte | ||
|
DirectDeposit |
DirectDeposit |
System.Byte | ||
|
CheckReissued |
CheckReissued |
System.Byte | ||
|
HoursNormal |
HoursNormal |
System.Decimal | ||
|
HoursOvertime |
HoursOvertime |
System.Decimal | ||
|
Gross |
Gross |
System.Decimal | ||
|
GrossAdjusted |
GrossAdjusted |
System.Decimal | ||
|
GrossRegular |
GrossRegular |
System.Decimal | ||
|
GrossOvertime |
GrossOvertime |
System.Decimal | ||
|
GrossRegularAdjusted |
GrossRegularAdjusted |
System.Decimal | ||
|
GrossOvertimeAdjusted |
GrossOvertimeAdjusted |
System.Decimal | ||
|
GrossMinusTaxes |
GrossMinusTaxes |
System.Decimal | ||
|
Benefits |
Benefits |
System.Decimal | ||
|
BenefitsAdjusted |
BenefitsAdjusted |
System.Decimal | ||
|
BenefitsTaxable |
BenefitsTaxable |
System.Decimal | ||
|
BenefitsTaxableAdjusted |
BenefitsTaxableAdjusted |
System.Decimal | ||
|
DeductionsPreTax |
DeductionsPreTax |
System.Decimal | ||
|
DeductionsPreTaxAdjustments |
DeductionsPreTaxAdjustments |
System.Decimal | ||
|
DeductionsPostTax |
DeductionsPostTax |
System.Decimal | ||
|
DeductionsPostTaxAdjustments |
DeductionsPostTaxAdjustments |
System.Decimal | ||
|
Taxes |
Taxes |
System.Decimal | ||
|
TaxesAdjusted |
TaxesAdjusted |
System.Decimal | ||
|
CheckNet |
CheckNet |
System.Decimal |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
CheckDateSK |
DimDate |
Table |
False |
||
CheckTypeSK |
DimCheckType |
Table |
False |
||
PayrollProcessedDateSK |
DimDate |
Table |
False |
||
EmployeeSK |
DimEmployee |
Table |
False |
||
CheckIssuedDateSK |
DimDate |
Table |
False |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
| Powered by BI Documenter |
