DWStaging
 dbo.ST_INTERNAL_ARTICULATION_A_COURSE_INFO (Table)
  Properties
Property Value
Name ST_INTERNAL_ARTICULATION_A_COURSE_INFO
Schema dbo
Row Count 165
Data Size 8 KB
Index Size 24 KB
Create Date 8/15/2012 1:36 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
cnxarraycolumn
smallint(5, 0)
False
False
False
 
COURSE_INFO_COUNT
smallint(5, 0)
False
False
False
 
CRNT_CRS
varchar(10)
True
False
False
 
GRADE
varchar(2)
True
False
False
 
ISN_ST_INTERNAL_ARTICULATION_A
int(10, 0)
False
False
False
 
LIC_CERT_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_INTERNAL_ARTICULATION_A, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_INTERNAL_ARTICULATION_A_COURSE_INFO depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_INTERNAL_ARTICULATION_A_COURSE_INFO)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_INTERNAL_ARTICULATION_A_COURSE_INFO] Script Date: 03/09/2017 16:46:10 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_INTERNAL_ARTICULATION_A_COURSE_INFO](
    [ISN_ST_INTERNAL_ARTICULATION_A] [int] NOT NULL,
    [COURSE_INFO_COUNT] [smallint] NOT NULL,
    [CRNT_CRS] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRADE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LIC_CERT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
cnxarraycolumn COURSE_INFO_COUNT CRNT_CRS GRADE ISN_ST_INTERNAL_ARTICULATION_A LIC_CERT_IND RowUpdatedOn
0 3 CHD1220 P 36 2017-02-06T11:34:25.839-05:00
2 3 EEC2734 P 16 2017-02-06T11:34:25.839-05:00
0 1 CJK1933 S 25 2017-02-06T11:34:25.839-05:00
2 9 CJD1731C P 13 2017-02-06T11:34:25.839-05:00
1 8 CJD1742 P 7 2017-02-06T11:34:25.839-05:00
2 3 EEC2734 P 15 2017-02-06T11:34:25.839-05:00
6 8 CJD1773 P 9 2017-02-06T11:34:25.839-05:00
0 1 CJD1933 S 44 2017-02-06T11:34:25.839-05:00
6 9 CJD1762 P 2 2017-02-06T11:34:25.839-05:00
0 3 CHD1220 P 20 2017-02-06T11:34:25.839-05:00
Powered by BI Documenter