EnterpriseDW
 dbo.FactCheckSummary (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  EnterpriseDW   Tables   dbo.FactCheckSummary
  Properties
Property Value
Name FactCheckSummary
Schema dbo
Row Count 954374
Data Size 212224 KB
Index Size 14240 KB
Create Date 3/9/2017 10:43 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Benefits
numeric(11, 2)
False
False
False
 
The total of all the benefit amounts processed for the pay check.
BenefitsAdjusted
numeric(11, 2)
False
False
False
 
The total of all the adjustments to benefits amounts processed for the pay check.
BenefitsTaxable
numeric(11, 2)
False
False
False
 
The total of all the taxable benefit amounts processed for the pay check.
BenefitsTaxableAdjusted
numeric(11, 2)
False
False
False
 
The total of all the adjustments to taxable benefit amounts processed for the pay check.
Foreign Key
CheckDateSK
int(10, 0)
False
False
False
 
Key identifier for the date the employee was paid or the check date, used to reference the date dimension.
Foreign Key
CheckIssuedDateSK
int(10, 0)
False
False
False
 
Key identifier for the employee's Position, used to reference the position dimension.
CheckNet
numeric(11, 2)
False
False
False
 
The net amount paid on the check to the employee.
CheckNumber
int(10, 0)
False
False
False
 
The unique heck number assigned to each check by the source system.
CheckProcessed
tinyint(3, 0)
False
False
False
 
Indication that the check has been processed into general ledger.
CheckReissued
tinyint(3, 0)
False
False
False
 
Indication that the check has been reissued.
In Primary Key
CheckSummarySK
int(10, 0)
False
False
False
(1 / 1)
Primary Key to the Fact.
Foreign Key
CheckTypeSK
int(10, 0)
False
False
False
 
Key identifier for the type of check the employee received, used to reference the check type dimension.
CheckVoidedCanclled
tinyint(3, 0)
False
False
False
 
Indication that the check has been 'voided'.
DeductionsPostTax
numeric(11, 2)
False
False
False
 
The total of all the posttax deduction amounts processed for the pay check.
DeductionsPostTaxAdjustments
numeric(11, 2)
False
False
False
 
The total of all the adjustments to posttax deduction amounts processed for the pay check.
DeductionsPreTax
numeric(11, 2)
False
False
False
 
The total of all the pretax deduction amounts processed for the pay check.
DeductionsPreTaxAdjustments
numeric(11, 2)
False
False
False
 
The total of all the adjusments to pretax deduction amounts processed for the pay check.
DirectDeposit
tinyint(3, 0)
False
False
False
 
Indication that the check was processed as a direct deposit to the employee.
Foreign Key
EmployeeSK
int(10, 0)
False
False
False
 
Key identifier for the Employee, used to reference the employee dimension.
Gross
numeric(11, 2)
False
False
False
 
The total of all the gross amounts processed for the pay check.
GrossAdjusted
numeric(11, 2)
False
False
False
 
The total of all the gross adjusted amounts processed for the pay check.
GrossMinusTaxes
numeric(11, 2)
False
False
False
 
The total of all the gross amounts minus all the taxes processed for the pay check.
GrossOvertime
numeric(11, 2)
False
False
False
 
The total of all the gross overtime amounts processed for the pay check.
GrossOvertimeAdjusted
numeric(11, 2)
False
False
False
 
The total of all the gross adjustments for overtime gross amounts processed for the pay check.
GrossRegular
numeric(11, 2)
False
False
False
 
The total of all the gross regular amounts processed for the pay check.
GrossRegularAdjusted
numeric(11, 2)
False
False
False
 
The total of all the gross adjustments for regular gross amounts processed for the pay check.
HoursNormal
numeric(11, 2)
False
False
False
 
The total normal hours paid on the check, if the employee is an hourly employee.
HoursOvertime
numeric(11, 2)
False
False
False
 
The total overtime hours paid on the check.
Foreign Key
PayrollProcessedDateSK
int(10, 0)
False
False
False
 
Key identifier for the employee's Assignment, used to reference the assignment dimension.
Taxes
numeric(11, 2)
False
False
False
 
The total of all the tax amounts processed for the pay check.
TaxesAdjusted
numeric(11, 2)
False
False
False
 
The total of all the adjustments for tax amounts processed for the pay check.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
CheckSummarySK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
CheckDateSK
DimDate
DateSK
True
CheckIssuedDateSK
DimDate
DateSK
True
CheckTypeSK
DimCheckType
CheckTypeSK
True
EmployeeSK
DimEmployee
EmployeeSK
True
PayrollProcessedDateSK
DimDate
DateSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactCheckSummary depends on)
Name Type
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactCheckSummary)
Name Type
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactCheckSummary
Display Name
CheckSummary
FactCheckSummary
Table Description
The fact will contain a row per Employee per pay check. This dimension will contain the dates, the dollars, the time and indica
FactCheckSummary
Table Type
Fact
Benefits
MS_Description
The total of all the benefit amounts processed for the pay check.
BenefitsAdjusted
MS_Description
The total of all the adjustments to benefits amounts processed for the pay check.
BenefitsTaxable
MS_Description
The total of all the taxable benefit amounts processed for the pay check.
BenefitsTaxableAdjusted
MS_Description
The total of all the adjustments to taxable benefit amounts processed for the pay check.
CheckDateSK
MS_Description
Key identifier for the date the employee was paid or the check date, used to reference the date dimension.
CheckIssuedDateSK
MS_Description
Key identifier for the employee's Position, used to reference the position dimension.
CheckNet
MS_Description
The net amount paid on the check to the employee.
CheckNumber
MS_Description
The unique heck number assigned to each check by the source system.
CheckProcessed
MS_Description
Indication that the check has been processed into general ledger.
CheckReissued
MS_Description
Indication that the check has been reissued.
CheckSummarySK
MS_Description
Primary Key to the Fact.
CheckTypeSK
MS_Description
Key identifier for the type of check the employee received, used to reference the check type dimension.
CheckVoidedCanclled
MS_Description
Indication that the check has been 'voided'.
DeductionsPostTax
MS_Description
The total of all the posttax deduction amounts processed for the pay check.
DeductionsPostTaxAdjustments
MS_Description
The total of all the adjustments to posttax deduction amounts processed for the pay check.
DeductionsPreTax
MS_Description
The total of all the pretax deduction amounts processed for the pay check.
DeductionsPreTaxAdjustments
MS_Description
The total of all the adjusments to pretax deduction amounts processed for the pay check.
DirectDeposit
MS_Description
Indication that the check was processed as a direct deposit to the employee.
EmployeeSK
MS_Description
Key identifier for the Employee, used to reference the employee dimension.
Gross
MS_Description
The total of all the gross amounts processed for the pay check.
GrossAdjusted
MS_Description
The total of all the gross adjusted amounts processed for the pay check.
GrossMinusTaxes
MS_Description
The total of all the gross amounts minus all the taxes processed for the pay check.
GrossOvertime
MS_Description
The total of all the gross overtime amounts processed for the pay check.
GrossOvertimeAdjusted
MS_Description
The total of all the gross adjustments for overtime gross amounts processed for the pay check.
GrossRegular
MS_Description
The total of all the gross regular amounts processed for the pay check.
GrossRegularAdjusted
MS_Description
The total of all the gross adjustments for regular gross amounts processed for the pay check.
HoursNormal
MS_Description
The total normal hours paid on the check, if the employee is an hourly employee.
HoursOvertime
MS_Description
The total overtime hours paid on the check.
PayrollProcessedDateSK
MS_Description
Key identifier for the employee's Assignment, used to reference the assignment dimension.
Taxes
MS_Description
The total of all the tax amounts processed for the pay check.
TaxesAdjusted
MS_Description
The total of all the adjustments for tax amounts processed for the pay check.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactCheckSummary] Script Date: 03/09/2017 17:14:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactCheckSummary](
    [CheckSummarySK] [int] IDENTITY(1,1) NOT NULL,
    [CheckDateSK] [int] NOT NULL,
    [EmployeeSK] [int] NOT NULL,
    [CheckIssuedDateSK] [int] NOT NULL,
    [PayrollProcessedDateSK] [int] NOT NULL,
    [CheckTypeSK] [int] NOT NULL,
    [CheckNumber] [int] NOT NULL,
    [CheckProcessed] [tinyint] NOT NULL,
    [CheckVoidedCanclled] [tinyint] NOT NULL,
    [DirectDeposit] [tinyint] NOT NULL,
    [CheckReissued] [tinyint] NOT NULL,
    [HoursNormal] [numeric](11, 2) NOT NULL,
    [HoursOvertime] [numeric](11, 2) NOT NULL,
    [Gross] [numeric](11, 2) NOT NULL,
    [GrossAdjusted] [numeric](11, 2) NOT NULL,
    [GrossRegular] [numeric](11, 2) NOT NULL,
    [GrossOvertime] [numeric](11, 2) NOT NULL,
    [GrossRegularAdjusted] [numeric](11, 2) NOT NULL,
    [GrossOvertimeAdjusted] [numeric](11, 2) NOT NULL,
    [GrossMinusTaxes] [numeric](11, 2) NOT NULL,
    [Benefits] [numeric](11, 2) NOT NULL,
    [BenefitsAdjusted] [numeric](11, 2) NOT NULL,
    [BenefitsTaxable] [numeric](11, 2) NOT NULL,
    [BenefitsTaxableAdjusted] [numeric](11, 2) NOT NULL,
    [DeductionsPreTax] [numeric](11, 2) NOT NULL,
    [DeductionsPreTaxAdjustments] [numeric](11, 2) NOT NULL,
    [DeductionsPostTax] [numeric](11, 2) NOT NULL,
    [DeductionsPostTaxAdjustments] [numeric](11, 2) NOT NULL,
    [Taxes] [numeric](11, 2) NOT NULL,
    [TaxesAdjusted] [numeric](11, 2) NOT NULL,
    [CheckNet] [numeric](11, 2) NOT NULL,
 CONSTRAINT [PK_dbo.FactCheckSummary] PRIMARY KEY NONCLUSTERED 
(
    [CheckSummarySK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[FactCheckSummary]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckSummary_CheckDateSK] FOREIGN KEY([CheckDateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactCheckSummary] CHECK CONSTRAINT [FK_dbo_FactCheckSummary_CheckDateSK]
ALTER TABLE [dbo].[FactCheckSummary]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckSummary_CheckIssuedDateSK] FOREIGN KEY([CheckIssuedDateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactCheckSummary] CHECK CONSTRAINT [FK_dbo_FactCheckSummary_CheckIssuedDateSK]
ALTER TABLE [dbo].[FactCheckSummary]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckSummary_CheckTypeSK] FOREIGN KEY([CheckTypeSK])
REFERENCES [DimCheckType] ([CheckTypeSK])
ALTER TABLE [dbo].[FactCheckSummary] CHECK CONSTRAINT [FK_dbo_FactCheckSummary_CheckTypeSK]
ALTER TABLE [dbo].[FactCheckSummary]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckSummary_EmployeeSK] FOREIGN KEY([EmployeeSK])
REFERENCES [DimEmployee] ([EmployeeSK])
ALTER TABLE [dbo].[FactCheckSummary] CHECK CONSTRAINT [FK_dbo_FactCheckSummary_EmployeeSK]
ALTER TABLE [dbo].[FactCheckSummary]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckSummary_PayrollProcessedDateSK] FOREIGN KEY([PayrollProcessedDateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactCheckSummary] CHECK CONSTRAINT [FK_dbo_FactCheckSummary_PayrollProcessedDateSK]


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'CheckSummary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The fact will contain a row per Employee per pay check. This dimension will contain the dates, the dollars, the time and indica' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary'


EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Fact' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the benefit amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'Benefits'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the adjustments to benefits amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'BenefitsAdjusted'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the taxable benefit amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'BenefitsTaxable'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the adjustments to taxable benefit amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'BenefitsTaxableAdjusted'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the date the employee was paid or the check date, used to reference the date dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'CheckDateSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the employee''s Position, used to reference the position dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'CheckIssuedDateSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The net amount paid on the check to the employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'CheckNet'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The unique heck number assigned to each check by the source system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'CheckNumber'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the check has been processed into general ledger.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'CheckProcessed'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the check has been reissued.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'CheckReissued'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key to the Fact.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'CheckSummarySK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the type of check the employee received, used to reference the check type dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'CheckTypeSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the check has been ''voided''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'CheckVoidedCanclled'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the posttax deduction amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'DeductionsPostTax'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the adjustments to posttax deduction amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'DeductionsPostTaxAdjustments'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the pretax deduction amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'DeductionsPreTax'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the adjusments to pretax deduction amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'DeductionsPreTaxAdjustments'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the check was processed as a direct deposit to the employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'DirectDeposit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Employee, used to reference the employee dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'EmployeeSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the gross amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'Gross'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the gross adjusted amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'GrossAdjusted'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the gross amounts minus all the taxes processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'GrossMinusTaxes'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the gross overtime amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'GrossOvertime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the gross adjustments for overtime gross amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'GrossOvertimeAdjusted'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the gross regular amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'GrossRegular'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the gross adjustments for regular gross amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'GrossRegularAdjusted'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total normal hours paid on the check, if the employee is an hourly employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'HoursNormal'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total overtime hours paid on the check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'HoursOvertime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the employee''s Assignment, used to reference the assignment dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'PayrollProcessedDateSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the tax amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'Taxes'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total of all the adjustments for tax amounts processed for the pay check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckSummary', @level2type=N'COLUMN',@level2name=N'TaxesAdjusted'
  Sample Data
Benefits BenefitsAdjusted BenefitsTaxable BenefitsTaxableAdjusted CheckDateSK CheckIssuedDateSK CheckNet CheckNumber CheckProcessed CheckReissued CheckSummarySK CheckTypeSK CheckVoidedCanclled DeductionsPostTax DeductionsPostTaxAdjustments DeductionsPreTax DeductionsPreTaxAdjustments DirectDeposit EmployeeSK Gross GrossAdjusted GrossMinusTaxes GrossOvertime GrossOvertimeAdjusted GrossRegular GrossRegularAdjusted HoursNormal HoursOvertime PayrollProcessedDateSK Taxes TaxesAdjusted
0.00 0.00 0.00 0.00 20020315 20020315 338.27 84110 1 0 130242 11 0 0.00 0.00 27.86 0.00 0 3031 371.52 0.00 338.27 0.00 0.00 371.52 0.00 24.00 0.00 20020315 5.39 0.00
0.00 0.00 0.00 0.00 20100915 20100915 378.35 914815 1 0 515638 11 0 0.00 0.00 0.00 0.00 1 12017 378.35 0.00 378.35 0.00 0.00 378.35 0.00 47.00 0.00 20100915 0.00 0.00
0.00 0.00 0.00 0.00 20070413 20070413 909.37 749540 1 0 593520 11 0 8.29 0.00 285.89 0.00 1 4400 1324.09 0.00 917.66 0.00 0.00 1324.09 0.00 0.00 0.00 20070413 120.54 0.00
0.00 0.00 0.00 0.00 20090615 20090615 911.92 850971 1 0 450882 11 0 0.00 0.00 11.77 0.00 1 10100 1124.08 0.00 911.92 0.00 0.00 1124.08 0.00 0.00 0.00 20090615 200.39 0.00
0.00 0.00 0.00 0.00 20070831 20070831 894.24 764519 1 0 363553 11 0 29.98 0.00 26.62 0.00 1 3621 1115.53 0.00 924.22 0.00 0.00 1115.53 0.00 0.00 0.00 20070831 164.69 0.00
0.00 0.00 0.00 0.00 20020430 20020430 206.50 87168 1 0 36819 11 0 0.00 0.00 0.00 0.00 0 5320 206.50 0.00 206.50 0.00 0.00 206.50 0.00 29.50 0.00 20020430 0.00 0.00
0.00 0.00 0.00 0.00 20011015 20011015 778.26 545166 1 0 569204 11 0 0.00 0.00 9.58 0.00 1 234 994.40 0.00 778.26 0.00 0.00 994.40 0.00 0.00 0.00 20011015 206.56 0.00
0.00 0.00 0.00 0.00 20011115 20011115 171.60 546358 1 0 114989 11 0 0.00 0.00 14.14 0.00 1 3943 188.47 0.00 171.60 0.00 0.00 188.47 0.00 0.00 0.00 20011115 2.73 0.00
0.00 0.00 0.00 0.00 20070515 20070515 1416.68 754226 1 0 353062 11 0 0.00 0.00 26.00 0.00 1 7574 1874.38 0.00 1416.68 0.00 0.00 1874.38 0.00 0.00 0.00 20070515 431.70 0.00
0.00 0.00 0.00 0.00 20060714 20060714 294.97 132925 1 0 314898 11 0 0.00 0.00 0.00 0.00 0 7869 300.24 0.00 294.97 0.00 0.00 300.24 0.00 36.00 0.00 20060714 5.27 0.00
Powered by BI Documenter