Table - dbo.FORM_1095_LOG_A_LINE

Properties

Property	Value
Name	FORM_1095_LOG_A_LINE_14
Schema	dbo
Row Count	60073
Data Size	1584 KB
Index Size	1056 KB
Create Date	2/26/2016 9:04 AM
Description

Columns

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
cnxarraycolumn	smallint(5, 0)	False	False	False
ISN_FORM_1095_LOG_A	int(10, 0)	False	False	False
LINE_14	varchar(3)	True	False	False
LINE_14_COUNT	smallint(5, 0)	False	False	False
RowUpdatedOn	datetime2(27, 7)	False	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name	Clustered	Columns
U2UJVQ20QOL3G5	False	ISN_FORM_1095_LOG_A, cnxarraycolumn

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name

Text

Checked

Parent Dependencies (objects that dbo.FORM_1095_LOG_A_LINE_14 depends on)

Name

Type

Child Dependencies (objects that depend on dbo.FORM_1095_LOG_A_LINE_14)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[FORM_1095_LOG_A_LINE_14] Script Date: 03/09/2017 16:45:35 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FORM_1095_LOG_A_LINE_14](
    [ISN_FORM_1095_LOG_A] [int] NOT NULL,
    [LINE_14_COUNT] [smallint] NOT NULL,
    [LINE_14] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]

Sample Data

cnxarraycolumn	ISN_FORM_1095_LOG_A	LINE_14	LINE_14_COUNT	RowUpdatedOn
11	2110	1H	13	2017-02-06T11:23:14.458-05:00
2	558	1A	13	2017-02-06T11:23:13.74-05:00
3	913		13	2017-02-06T11:23:13.943-05:00
11	3389		13	2017-02-06T11:23:15.144-05:00
6	2094		13	2017-02-06T11:23:14.458-05:00
9	1527		13	2017-02-06T11:23:14.192-05:00
5	317		13	2017-02-06T11:23:13.631-05:00
0	4556	1H	13	2017-02-06T11:23:15.706-05:00
3	3843		13	2017-02-06T11:23:15.362-05:00
10	3668		13	2017-02-06T11:23:15.284-05:00