DWStaging
 dbo.CHECK_COMPONENT_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_COMPONENT_A
  Properties
Property Value
Name CHECK_COMPONENT_A
Schema dbo
Row Count 15172081
Data Size 1796680 KB
Index Size 226176 KB
Create Date 11/2/2012 2:42 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCT_INTERNAL_ID
int(10, 0)
True
False
False
 
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
 
C_PAY_CHECK_DATE_9C
varchar(8)
True
False
False
 
CALENDAR_YTD_AMOUNT
numeric(17, 2)
True
False
False
 
CHECK_TYPE
varchar(2)
True
False
False
 
COMPONENT_AMOUNT
numeric(17, 2)
True
False
False
 
COVERAGE_AMOUNT
numeric(17, 2)
True
False
False
 
EMPLOYEE_DEDUCTION_ACCOUNT_ID
varchar(16)
True
False
False
 
EMPLOYEE_DEDUCTION_CASE_NBR
varchar(16)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOURLY_RATE
numeric(17, 4)
True
False
False
 
HOURS_USED
numeric(17, 2)
True
False
False
 
INTERNAL_SEQ
int(10, 0)
True
False
False
 
ISN_CHECK_COMPONENT_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
 
PAY_CHECK_COMPONENT_TYPE_CODE
varchar(21)
True
False
False
 
PAY_CHECK_DATE
varchar(8)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
PRIORITY_SEQ_NBR
int(10, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
VENDOR_CODE
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_CHECK_COMPONENT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.CHECK_COMPONENT_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.CHECK_COMPONENT_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[CHECK_COMPONENT_A] Script Date: 03/09/2017 16:45:08 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[CHECK_COMPONENT_A](
    [ISN_CHECK_COMPONENT_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_COMPONENT_TYPE_CODE] [varchar](21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIORITY_SEQ_NBR] [int] NULL,
    [COVERAGE_AMOUNT] [numeric](17, 2) NULL,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INTERNAL_SEQ] [int] NULL,
    [COMPONENT_AMOUNT] [numeric](17, 2) NULL,
    [CALENDAR_YTD_AMOUNT] [numeric](17, 2) NULL,
    [HOURLY_RATE] [numeric](17, 4) NULL,
    [HOURS_USED] [numeric](17, 2) NULL,
    [C_PAY_CHECK_DATE_9C] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMPLOYEE_DEDUCTION_ACCOUNT_ID] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMPLOYEE_DEDUCTION_CASE_NBR] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCT_INTERNAL_ID] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCT_INTERNAL_ID ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID C_PAY_CHECK_DATE_9C CALENDAR_YTD_AMOUNT CHECK_TYPE COMPONENT_AMOUNT EMPLOYEE_DEDUCTION_ACCOUNT_ID EMPLOYEE_DEDUCTION_CASE_NBR HOLD HOURLY_RATE INTERNAL_SEQ ISN_CHECK_COMPONENT_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAY_CHECK_COMPONENT_TYPE_CODE PAY_CHECK_DATE PERSON_ID POSITION_CODE RowUpdatedOn VENDOR_CODE
45706583 20111109 PEY418N1 1341483 OPER2 79888884 1776.73 RG 88.69 1341483 9883622 10SOCSEC 001 20111115 1280 2017-02-06T08:34:05.719-05:00 590155625
20110613 PEY418N1 1439248 OPER2 79889384 14162.28 RG 1287.48 1439248 9526209 01TAXABLE SOCSEC 001 20110615 32742 2017-02-06T08:33:31.165-05:00
20120912 PEY418N1 1103160 OPER2 79879085 RG 32.00 1103160 10708093 20PP 001 20120914 37615 2017-02-06T08:35:24.64-05:00
41702963 20110211 PEY418N1 1059297 OPER2 79889784 520.58 RG 260.29 1059297 40.8300 16 9196358 01ASSIGNRG001 001 20110215 47560 CTR1ADJS 2017-02-06T08:33:00.011-05:00
20070510 PEY418N1 1210018 OPER2 79929484 RG 1210018 5887690 19LIVE CHECK 001 20070515 31644 2017-02-06T08:27:44.874-05:00
20090327 PEY418N1 1052093 OPER2 79909668 RG 1052093 7437840 19LIVE CHECK 001 20090331 351 2017-02-06T08:30:12.186-05:00
20050727 PEY418N1 1135574 OPER2 79949270 13274.90 RG 980.53 1135574 4425988 01TASSIGNR 001 20050729 3003 2017-02-06T08:25:26.251-05:00
20050913 PEY418N1 1327363 OPER2 79949084 RG 967.33 1327363 4532095 12SUBTOTAL 001 20050915 14434 2017-02-06T08:25:36.267-05:00
4083466 20030625 PEY418N1 1431541 OPER2 79969369 574.12 RG 74.25 1431541 2870296 10WITHHOLD 001 20030630 10532 2017-02-06T08:22:59.392-05:00 590155625
20170111 PEY418N1 1625449 OPER2 79829886 RG 262.05 1625449 15145328 12SUBTOTAL 001 20170113 91472 2017-02-06T08:42:30.211-05:00
Powered by BI Documenter