DWStaging
 dbo.ADJUSTMENT_A_ADJ_TAX_INFO (Table)
  Properties
Property Value
Name ADJUSTMENT_A_ADJ_TAX_INFO
Schema dbo
Row Count 108535
Data Size 2464 KB
Index Size 2256 KB
Create Date 10/25/2012 3:55 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ADJ_TAX_EXEMPT
bit(1, 0)
True
False
False
 
ADJ_TAX_INFO_COUNT
smallint(5, 0)
False
False
False
 
ADJ_TAX_TYPE_CODE
varchar(8)
True
False
False
 
cnxarraycolumn
smallint(5, 0)
False
False
False
 
ISN_ADJUSTMENT_A
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ADJUSTMENT_A, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ADJUSTMENT_A_ADJ_TAX_INFO depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ADJUSTMENT_A_ADJ_TAX_INFO)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ADJUSTMENT_A_ADJ_TAX_INFO] Script Date: 03/09/2017 16:44:50 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ADJUSTMENT_A_ADJ_TAX_INFO](
    [ISN_ADJUSTMENT_A] [int] NOT NULL,
    [ADJ_TAX_INFO_COUNT] [smallint] NOT NULL,
    [ADJ_TAX_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJ_TAX_EXEMPT] [bit] NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADJ_TAX_EXEMPT ADJ_TAX_INFO_COUNT ADJ_TAX_TYPE_CODE cnxarraycolumn ISN_ADJUSTMENT_A RowUpdatedOn
false 10 MEDICARE 2 17626 2017-02-06T11:16:25.205-05:00
false 5 AEIC 3 4466 2017-02-06T11:16:22.256-05:00
false 5 4 6121 2017-02-06T11:16:22.599-05:00
false 10 6 17672 2017-02-06T11:16:25.236-05:00
false 5 AEIC 3 11322 2017-02-06T11:16:23.411-05:00
false 5 AEIC 3 6364 2017-02-06T11:16:22.646-05:00
false 5 4 1568 2017-02-06T11:16:21.726-05:00
false 5 WITHHOLD 0 10626 2017-02-06T11:16:23.301-05:00
true 5 2 615 2017-02-06T11:16:21.554-05:00
false 10 9 15549 2017-02-06T11:16:24.378-05:00
Powered by BI Documenter