DWStaging
 dbo.CHECK_SUMMARY_A (Table)
Home  Diagrams  Documents  Images  DWStaging  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:  DWStaging   Tables   dbo.CHECK_SUMMARY_A
  Properties
Property Value
Name CHECK_SUMMARY_A
Schema dbo
Row Count 954374
Data Size 262872 KB
Index Size 14288 KB
Create Date 11/2/2012 2:51 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ADD_DATE
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
ATTENDANCE_END_DATE
varchar(8)
True
False
False
 
ATTENDANCE_PAY_CHECK_DATE
varchar(8)
True
False
False
 
ATTENDANCE_START_DATE
varchar(8)
True
False
False
 
CHECK_NAME
varchar(78)
True
False
False
 
CHECK_NET
numeric(17, 2)
True
False
False
 
CHECK_TYPE
varchar(2)
True
False
False
 
CHECK_VOID_CANCEL_DATE
varchar(8)
True
False
False
 
CHECK_VOID_CANCEL_DATE_9C
int(10, 0)
True
False
False
 
CHECK_VOID_CANCEL_IND
bit(1, 0)
True
False
False
 
CHECK_VOID_CANCEL_PROC_DATE
varchar(8)
True
False
False
 
CHECK_VOID_CANCEL_PROC_DATE_9C
int(10, 0)
True
False
False
 
CHECK_VOID_CANCEL_PROCESSED
bit(1, 0)
True
False
False
 
COMMENT_CODE
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_CHECK_SUMMARY_A
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
MANUAL_REISSUE
bit(1, 0)
True
False
False
 
ORG_LEVEL_PAYROLL
varchar(28)
True
False
False
 
PAY_BANK_DIRECT_DEPOSIT_IND
bit(1, 0)
True
False
False
 
PAY_CHECK_DATE
varchar(8)
True
False
False
 
PAY_CHECK_DATE_9C
varchar(8)
True
False
False
 
PAY_CHECK_ISSUE_DATE
varchar(8)
True
False
False
 
PAY_CHECK_NUMBER
int(10, 0)
True
False
False
 
PAYROLL_PROCESS_DATE
varchar(8)
True
False
False
 
PAYROLL_PROCESS_DATE_9C
int(10, 0)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
REISSUE_CHECK_NUMBER
int(10, 0)
True
False
False
 
REISSUE_DATE
varchar(8)
True
False
False
 
REISSUE_DATE_9C
int(10, 0)
True
False
False
 
REISSUE_IND
bit(1, 0)
True
False
False
 
REISSUE_PROC_DATE
varchar(8)
True
False
False
 
REISSUE_PROC_DATE_9C
int(10, 0)
True
False
False
 
REISSUE_UNPROC_IND
bit(1, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SENT_TO_GL_DATE
varchar(8)
True
False
False
 
SENT_TO_GL_DATE_9C
int(10, 0)
True
False
False
 
SENT_TO_GL_IND
bit(1, 0)
True
False
False
 
SSN
varchar(9)
True
False
False
 
TOTAL_BENEFIT_ADJ
decimal(9, 2)
True
False
False
 
TOTAL_BENEFITS
decimal(9, 2)
True
False
False
 
TOTAL_GROSS
decimal(9, 2)
True
False
False
 
TOTAL_GROSS_ADJ
decimal(9, 2)
True
False
False
 
TOTAL_GROSS_MINUS_TAXES
decimal(9, 2)
True
False
False
 
TOTAL_GROSS_OT
decimal(9, 2)
True
False
False
 
TOTAL_GROSS_OT_ADJ
decimal(9, 2)
True
False
False
 
TOTAL_GROSS_REG
decimal(9, 2)
True
False
False
 
TOTAL_GROSS_REG_ADJ
decimal(9, 2)
True
False
False
 
TOTAL_NORMAL_HOURS
numeric(17, 2)
True
False
False
 
TOTAL_OVERTIME_HOURS
numeric(17, 2)
True
False
False
 
TOTAL_POST_TAX_DEDUCTION_ADJ
decimal(9, 2)
True
False
False
 
TOTAL_POST_TAX_DEDUCTIONS
decimal(9, 2)
True
False
False
 
TOTAL_PRE_TAX_DEDUCTION_ADJ
decimal(9, 2)
True
False
False
 
TOTAL_PRE_TAX_DEDUCTIONS
decimal(9, 2)
True
False
False
 
TOTAL_TAX_ADJ
decimal(9, 2)
True
False
False
 
TOTAL_TAXABLE_BENEFIT_ADJ
decimal(9, 2)
True
False
False
 
TOTAL_TAXABLE_BENEFITS
decimal(9, 2)
True
False
False
 
TOTAL_TAXES
decimal(9, 2)
True
False
False
 
UNPROCESSED_IND
bit(1, 0)
True
False
False
 
VOID_CANCEL_SENT_TO_GL_DATE
varchar(8)
True
False
False
 
VOID_CANCEL_SENT_TO_GL_DATE_9C
int(10, 0)
True
False
False
 
VOID_CANCEL_SENT_TO_GL_IND
bit(1, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_CHECK_SUMMARY_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.CHECK_SUMMARY_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.CHECK_SUMMARY_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[CHECK_SUMMARY_A] Script Date: 03/09/2017 16:45:08 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[CHECK_SUMMARY_A](
    [ISN_CHECK_SUMMARY_A] [int] NOT NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [PERSON_ID] [int] NULL,
    [PAY_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_CHECK_ISSUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_CHECK_NUMBER] [int] NULL,
    [PAY_CHECK_DATE_9C] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOTAL_NORMAL_HOURS] [numeric](17, 2) NULL,
    [TOTAL_OVERTIME_HOURS] [numeric](17, 2) NULL,
    [TOTAL_GROSS] [decimal](9, 2) NULL,
    [TOTAL_GROSS_ADJ] [decimal](9, 2) NULL,
    [TOTAL_GROSS_REG] [decimal](9, 2) NULL,
    [TOTAL_GROSS_OT] [decimal](9, 2) NULL,
    [TOTAL_GROSS_REG_ADJ] [decimal](9, 2) NULL,
    [TOTAL_GROSS_OT_ADJ] [decimal](9, 2) NULL,
    [TOTAL_TAXABLE_BENEFITS] [decimal](9, 2) NULL,
    [TOTAL_TAXABLE_BENEFIT_ADJ] [decimal](9, 2) NULL,
    [TOTAL_PRE_TAX_DEDUCTIONS] [decimal](9, 2) NULL,
    [TOTAL_PRE_TAX_DEDUCTION_ADJ] [decimal](9, 2) NULL,
    [TOTAL_TAXES] [decimal](9, 2) NULL,
    [TOTAL_TAX_ADJ] [decimal](9, 2) NULL,
    [TOTAL_GROSS_MINUS_TAXES] [decimal](9, 2) NULL,
    [TOTAL_POST_TAX_DEDUCTIONS] [decimal](9, 2) NULL,
    [TOTAL_POST_TAX_DEDUCTION_ADJ] [decimal](9, 2) NULL,
    [CHECK_NET] [numeric](17, 2) NULL,
    [TOTAL_BENEFITS] [decimal](9, 2) NULL,
    [TOTAL_BENEFIT_ADJ] [decimal](9, 2) NULL,
    [COMMENT_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTENDANCE_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTENDANCE_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_NAME] [varchar](78) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SENT_TO_GL_IND] [bit] NULL,
    [SENT_TO_GL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SENT_TO_GL_DATE_9C] [int] NULL,
    [ATTENDANCE_PAY_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_LEVEL_PAYROLL] [varchar](28) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_VOID_CANCEL_IND] [bit] NULL,
    [CHECK_VOID_CANCEL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_VOID_CANCEL_DATE_9C] [int] NULL,
    [PAYROLL_PROCESS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYROLL_PROCESS_DATE_9C] [int] NULL,
    [CHECK_VOID_CANCEL_PROCESSED] [bit] NULL,
    [CHECK_VOID_CANCEL_PROC_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_VOID_CANCEL_PROC_DATE_9C] [int] NULL,
    [UNPROCESSED_IND] [bit] NULL,
    [PAY_BANK_DIRECT_DEPOSIT_IND] [bit] NULL,
    [VOID_CANCEL_SENT_TO_GL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VOID_CANCEL_SENT_TO_GL_DATE_9C] [int] NULL,
    [VOID_CANCEL_SENT_TO_GL_IND] [bit] NULL,
    [REISSUE_IND] [bit] NULL,
    [REISSUE_UNPROC_IND] [bit] NULL,
    [REISSUE_CHECK_NUMBER] [int] NULL,
    [REISSUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REISSUE_DATE_9C] [int] NULL,
    [REISSUE_PROC_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REISSUE_PROC_DATE_9C] [int] NULL,
    [MANUAL_REISSUE] [bit] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ATTENDANCE_END_DATE ATTENDANCE_PAY_CHECK_DATE ATTENDANCE_START_DATE CHECK_NAME CHECK_NET CHECK_TYPE CHECK_VOID_CANCEL_DATE CHECK_VOID_CANCEL_IND CHECK_VOID_CANCEL_PROC_DATE CHECK_VOID_CANCEL_PROCESSED COMMENT_CODE HOLD ISN_CHECK_SUMMARY_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MANUAL_REISSUE ORG_LEVEL_PAYROLL PAY_BANK_DIRECT_DEPOSIT_IND PAY_CHECK_DATE PAY_CHECK_DATE_9C PAY_CHECK_ISSUE_DATE PAY_CHECK_NUMBER PAYROLL_PROCESS_DATE PAYROLL_PROCESS_DATE_9C PERSON_ID REISSUE_DATE REISSUE_IND REISSUE_PROC_DATE REISSUE_UNPROC_IND RowUpdatedOn SENT_TO_GL_DATE SENT_TO_GL_DATE_9C SENT_TO_GL_IND SSN TOTAL_GROSS TOTAL_GROSS_ADJ TOTAL_GROSS_MINUS_TAXES TOTAL_GROSS_OT_ADJ TOTAL_GROSS_REG TOTAL_POST_TAX_DEDUCTIONS TOTAL_NORMAL_HOURS TOTAL_PRE_TAX_DEDUCTIONS TOTAL_TAXES UNPROCESSED_IND VOID_CANCEL_SENT_TO_GL_DATE VOID_CANCEL_SENT_TO_GL_IND
20111214 PEY420N1 1041088 OPER2 RADZINS KEISHA N 65.46 RG false false 1041089 647069 20111214 PEY420N1 1137562 OPER2 false 15 true 20111216 79888783 20111216 986497 20111216 79888783 77467 false false 2017-02-06T10:11:28.268-05:00 20111216 79888783 true 820012234 71.89 65.46 71.89 3.50 5.39 1.04 false false
20030528 PEY420N1 1044523 OPER2 ROSS-VILLAFUERTE ERICA R 481.33 RG false false 1044524 182765 20030528 PEY420N1 1130108 OPER2 false 44 true 20030530 79969469 20030530 591600 20030530 79969469 6318 false false 2017-02-06T10:09:53.295-05:00 20030530 79969469 true 820004493 585.04 481.33 585.04 56.00 103.71 false false
20030212 PEY420N1 1308563 OPER2 RAIMOND SUSAN P 1499.80 RG false false 1308564 168398 20030212 PEY420N1 1500473 OPER2 false 55 true 20030214 79969785 20030214 580852 20030214 79969785 625 false false 2017-02-06T10:09:50.799-05:00 20030214 79969785 true 820000621 1865.40 1501.26 1865.40 1.46 55.84 308.30 false false
20051128 PEY420N1 1506077 OPER2 RONCO JENNIFER E 1261.60 RG false false 1506078 587124 20051128 PEY420N1 1557054 OPER2 false 03 true 20051130 79948869 20051130 688243 20051130 79948869 23875 false false 2017-02-06T10:11:16.397-05:00 20051130 79948869 true 820007542 1582.13 47.70 1261.60 47.70 1534.43 50.50 320.53 false false
20101124 PEY420N1 1200566 OPER2 FORD SHANNON E 987.71 RG false false 1200567 528441 20101124 PEY420N1 1315554 OPER2 false 45 true 20101130 79898869 20101130 927527 20101130 79898869 2437 false false 2017-02-06T10:11:04.447-05:00 20101130 79898869 true 820002410 1225.70 987.71 1225.70 2.93 235.06 false false
20140429 PEY420N1 1312016 OPER2 DEMSKY SABRINA MDR. 176.20 SP false false 1312017 790053 20140429 PEY420N1 1330293 OPER2 false true 20140430 79859569 20140430 1118761 20140430 79859569 87476 false false 2017-02-06T10:11:56.973-05:00 20140430 79859569 true 820013183 261.61 176.20 261.61 85.41 false false
20120127 PEY420N1 1227573 OPER2 STOFFER JULIA 1082.32 RG false false 1227574 652538 20120127 PEY420N1 1324193 OPER2 false 71 true 20120131 79879868 20120131 991960 20120131 79879868 52538 false false 2017-02-06T10:11:29.376-05:00 20120131 79879868 true 820010392 1315.90 1083.78 1315.90 1.46 46.96 185.16 false false
20080428 PEY420N1 1008012 OPER2 ROGGEN ANN MARIE 383.09 RG false false 1008013 396774 20080428 PEY420N1 1037218 OPER2 false 23 true 20080430 79919569 20080430 796435 20080430 79919569 52813 false false 2017-02-06T10:10:38.489-05:00 20080430 79919569 true 820010534 420.75 383.09 420.75 31.56 6.10 false false
20100428 PEY420N1 1022357 OPER2 HANSEN TIMOTHY B 677.20 RG false false 1022358 499005 20100428 PEY420N1 1100590 OPER2 false 29 false 20100430 79899569 20100430 157885 20100430 79899569 77492 false false 2017-02-06T10:10:58.628-05:00 20100430 79899569 true 820012259 923.09 21.29 782.11 21.29 901.80 104.91 90.00 69.23 71.75 false false
20120510 PEY420N1 1042042 OPER2 BROWN BRIAN 814.96 RG false false 1042043 669631 20120510 PEY420N1 1116358 OPER2 false 05 true 20120515 79879484 20120515 1007044 20120515 79879484 72656 false false 2017-02-06T10:11:32.839-05:00 20120515 79879484 true 820011935 1025.00 814.96 1025.00 35.59 174.45 false false
Powered by BI Documenter