DWStaging
 dbo.SPECIAL_CHECKS_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.SPECIAL_CHECKS_A
  Properties
Property Value
Name SPECIAL_CHECKS_A
Schema dbo
Row Count 74
Data Size 16 KB
Index Size 24 KB
Create Date 3/4/2015 10:09 AM
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
 
AWARD_CODE
varchar(8)
True
False
False
 
CHECK_TYPE
varchar(2)
True
False
False
 
DESCRIPTION
varchar(50)
True
False
False
 
DIRECT_DEP_OVERRIDE_IND
bit(1, 0)
True
False
False
 
FROM_HIRE_DATE
varchar(8)
True
False
False
 
GROSS_AMOUNT
numeric(7, 2)
True
False
False
 
GROSS_OR_NET_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INTERNAL_SEQ
int(10, 0)
True
False
False
 
ISN_SPECIAL_CHECKS_A
int(10, 0)
False
False
False
 
JOB_GROUP_CODE
varchar(8)
True
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
 
MAX_AMOUNT
numeric(9, 2)
True
False
False
 
MIN_AMOUNT
numeric(9, 2)
True
False
False
 
PAY_BASIS_CODE
varchar(8)
True
False
False
 
PAY_CHECK_DATE
varchar(8)
True
False
False
 
PAY_CHECK_DATE_9C
varchar(8)
True
False
False
 
PERCENT_OF_SALARY
numeric(5, 2)
True
False
False
 
PROCESSED_DATE
varchar(8)
True
False
False
 
PROCESSED_DATE_9C
int(10, 0)
True
False
False
 
REQUEST_DATE
varchar(8)
True
False
False
 
REQUEST_DATE_9C
int(10, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SENT_TO_GL_IND
bit(1, 0)
True
False
False
 
SUPPRESS_BENEFITS_IND
bit(1, 0)
True
False
False
 
SUPPRESS_DEDUCTIONS_IND
varchar(1)
True
False
False
 
TAX_CALC_OVERRIDE_IND
bit(1, 0)
True
False
False
 
TAX_PERCENT
numeric(6, 3)
True
False
False
 
TO_HIRE_DATE
varchar(8)
True
False
False
 
UNPROCESSED_IND
bit(1, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_SPECIAL_CHECKS_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.SPECIAL_CHECKS_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.SPECIAL_CHECKS_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[SPECIAL_CHECKS_A] Script Date: 03/09/2017 16:45:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[SPECIAL_CHECKS_A](
    [ISN_SPECIAL_CHECKS_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,
    [CHECK_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUEST_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INTERNAL_SEQ] [int] NULL,
    [PAY_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_CHECK_DATE_9C] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNPROCESSED_IND] [bit] NULL,
    [JOB_GROUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GROSS_AMOUNT] [numeric](7, 2) NULL,
    [PERCENT_OF_SALARY] [numeric](5, 2) NULL,
    [DIRECT_DEP_OVERRIDE_IND] [bit] NULL,
    [TAX_CALC_OVERRIDE_IND] [bit] NULL,
    [SUPPRESS_BENEFITS_IND] [bit] NULL,
    [SUPPRESS_DEDUCTIONS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FROM_HIRE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TO_HIRE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAX_AMOUNT] [numeric](9, 2) NULL,
    [MIN_AMOUNT] [numeric](9, 2) NULL,
    [GROSS_OR_NET_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWARD_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUEST_DATE_9C] [int] NULL,
    [SENT_TO_GL_IND] [bit] NULL,
    [TAX_PERCENT] [numeric](6, 3) NULL,
    [PROCESSED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROCESSED_DATE_9C] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AWARD_CODE CHECK_TYPE DESCRIPTION DIRECT_DEP_OVERRIDE_IND FROM_HIRE_DATE GROSS_AMOUNT GROSS_OR_NET_IND HOLD INTERNAL_SEQ ISN_SPECIAL_CHECKS_A JOB_GROUP_CODE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAY_BASIS_CODE PAY_CHECK_DATE PAY_CHECK_DATE_9C PERCENT_OF_SALARY PROCESSED_DATE PROCESSED_DATE_9C REQUEST_DATE REQUEST_DATE_9C RowUpdatedOn SENT_TO_GL_IND SUPPRESS_BENEFITS_IND SUPPRESS_DEDUCTIONS_IND TAX_CALC_OVERRIDE_IND TAX_PERCENT TO_HIRE_DATE UNPROCESSED_IND
20060227 PEY429N1 0829332 E001501 BO STIPEND false 250.00 G 1320196 4 22 12MO35 20060228 PEY429N1 1320196 OPER2 SALARY 20060314 79939685 20060227 79939772 20060227 79939772 2017-02-06T11:25:02.27-05:00 false true A true 25.000 20050630 false
20090331 PEY429N1 0728300 E001501 SP ONE-TIME NON-RECURRING PAYMENT false G 945122 2 34 12MO35 20090401 PEY429N1 0945122 OPER2 SALARY 20090403 79909596 2.00 20090331 79909668 20090331 79909668 2017-02-06T11:25:02.27-05:00 false true A true 25.000 20080701 false
20111205 PEY429N1 0744563 E001501 SP ONE-TIME NON-RECURRING PAYMENT DECEMBER 2011 false G 1445523 6 60 ADMIN 20111205 PEY429N1 1445523 OPER2 SALARY 20111215 79888784 1.00 20111205 79888794 20111205 79888794 2017-02-06T11:25:02.27-05:00 false true A true 25.000 20110701 false
20091203 PEY429N1 0819089 E001501 SP ONE-TIME NON-RECURRING PAYMENT DECEMBER 09 false 1000.00 G 1229224 7 47 SRMGMT 20091203 PEY429N1 1229224 OPER2 SALARY 20091215 79908784 20091203 79908796 20091203 79908796 2017-02-06T11:25:02.27-05:00 false true A true 25.000 20090701 false
20000511 PEY429N1 1439312 CWHITE BO SUPPLEMENTAL PAY true 135.00 G 1556388 15 15 248FAC 20000522 PEY429N1 1556388 CWHITE SALARY 20000525 79999474 00000000 99999999 20000522 79999477 2017-02-06T11:25:02.27-05:00 false true A true 0.280 true
20060227 PEY429N1 0830075 E001501 BO STIPEND false 250.00 G 1320196 7 25 248FAC 20060228 PEY429N1 1320196 OPER2 SALARY 20060314 79939685 20060227 79939772 20060227 79939772 2017-02-06T11:25:02.27-05:00 false true A true 25.000 20050630 false
20060227 PEY429N1 0829568 E001501 BO STIPEND false 250.00 G 1320196 6 24 248FAC35 20060228 PEY429N1 1320196 OPER2 SALARY 20060314 79939685 20060227 79939772 20060227 79939772 2017-02-06T11:25:02.27-05:00 false true A true 25.000 20050630 false
20060227 PEY429N1 0830584 E001501 BO STIPEND false 250.00 G 1320196 12 29 210/35HR 20060228 PEY429N1 1320196 OPER2 SALARY 20060314 79939685 20060227 79939772 20060227 79939772 2017-02-06T11:25:02.27-05:00 false true A true 25.000 20050630 false
20091203 PEY429N1 0819203 E001501 SP ONE-TIME NON-RECURRING PAYMENT DECEMBER 09 false 1000.00 G 1229224 8 48 PRES 20091203 PEY429N1 1229224 OPER2 SALARY 20091215 79908784 20091203 79908796 20091203 79908796 2017-02-06T11:25:02.27-05:00 false true A true 25.000 20090701 false
20060227 PEY429N1 0831174 E001501 BO STIPEND false 250.00 G 1320196 14 31 228FAC35 20060228 PEY429N1 1320196 OPER2 SALARY 20060314 79939685 20060227 79939772 20060227 79939772 2017-02-06T11:25:02.27-05:00 false true A true 25.000 20050630 false
Powered by BI Documenter