DWStaging
 dbo.ST_STDNT_TEST_SCORES_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.ST_STDNT_TEST_SCORES_A
  Properties
Property Value
Name ST_STDNT_TEST_SCORES_A
Schema dbo
Row Count 20
Data Size 8 KB
Index Size 24 KB
Create Date 8/15/2012 2:10 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ADMIN_SSN
varchar(9)
True
False
False
 
APPEND
varchar(4)
True
False
False
 
CAMP_CNTR
varchar(5)
True
False
False
 
CITY
varchar(20)
True
False
False
 
CNTRY
varchar(3)
True
False
False
 
DOB
varchar(8)
True
False
False
 
EXMPT_CD
varchar(2)
True
False
False
 
EXMPT_DT
varchar(8)
True
False
False
 
FIRST
varchar(20)
True
False
False
 
INIT_TST_DT
varchar(8)
True
False
False
 
ISN_ST_STDNT_TEST_SCORES_A
int(10, 0)
False
False
False
 
LAST
varchar(35)
True
False
False
 
MIDDLE
varchar(20)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SEL_SUBTEST
varchar(1)
True
False
False
 
SEX
varchar(1)
True
False
False
 
STATE
varchar(2)
True
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
STREET_1
varchar(32)
True
False
False
 
STREET_2
varchar(32)
True
False
False
 
SUBTEST
varchar(2)
True
False
False
 
TRANS_MODE
varchar(2)
True
False
False
 
TST_DT
varchar(8)
True
False
False
 
TST_FRM
varchar(4)
True
False
False
 
TST_GRD
varchar(2)
True
False
False
 
TST_LANG
varchar(2)
True
False
False
 
TST_SCR
varchar(6)
True
False
False
 
TST_TY
varchar(4)
True
False
False
 
ZIP
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_STDNT_TEST_SCORES_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_STDNT_TEST_SCORES_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_STDNT_TEST_SCORES_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_TEST_SCORES_A] Script Date: 03/09/2017 16:46:30 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_TEST_SCORES_A](
    [ISN_ST_STDNT_TEST_SCORES_A] [int] NOT NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TST_TY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TST_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TST_FRM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIRST] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIDDLE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPEND] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ZIP] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DOB] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEX] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMP_CNTR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TST_LANG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADMIN_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANS_MODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INIT_TST_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUBTEST] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TST_SCR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TST_GRD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEL_SUBTEST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXMPT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXMPT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADMIN_SSN APPEND CAMP_CNTR CITY CNTRY DOB EXMPT_CD EXMPT_DT FIRST INIT_TST_DT ISN_ST_STDNT_TEST_SCORES_A LAST MIDDLE RowUpdatedOn SEL_SUBTEST SEX STATE STDNT_ID STREET_1 STREET_2 SUBTEST TRANS_MODE TST_DT TST_FRM TST_GRD TST_LANG TST_SCR TST_TY ZIP
3 DATEBITH FIRST NAME ATETET 2 LAST NAME M.I. 2017-02-06T11:34:54.309-05:00 STUDENT I RC EL ATETET A EN 00RD00 CPT
3 19851004 KETHIUS 20070924 15 ANDERSON T 2017-02-06T11:34:54.309-05:00 k12724001 EA EL 20070924 A EN 002100 CPT
3 19851004 KETHIUS 20070924 16 ANDERSON T 2017-02-06T11:34:54.309-05:00 k12724001 RC EL 20070924 A EN 002700 CPT
3 19790321 SHAMEARA 20070924 12 PORTER L 2017-02-06T11:34:54.309-05:00 s06019285 EA EL 20070924 A EN 002200 CPT
3 19800708 KAMESHIA 20070924 19 MOORE A 2017-02-06T11:34:54.309-05:00 K06176663 RC EL 20070924 A EN 004100 CPT
3 19881114 ANQUENETTE 20070924 11 SMITH J 2017-02-06T11:34:54.309-05:00 A12446308 SS EL 20070924 A EN 004000 CPT
3 19800708 KAMESHIA 20070924 18 MOORE A 2017-02-06T11:34:54.309-05:00 K06176663 EA EL 20070924 A EN 003700 CPT
3 19790321 SHAMEARA 20070924 14 PORTER L 2017-02-06T11:34:54.309-05:00 s06019285 SS EL 20070924 A EN 007400 CPT
3 DATEBITH FIRST NAME ATETET 4 LAST NAME M.I. 2017-02-06T11:34:54.309-05:00 STUDENT I CM EL ATETET A EN 00CL00 CPT
3 19890630 AMANDA 20070924 7 JEAN L 2017-02-06T11:34:54.309-05:00 A12499869 RC EL 20070924 A EN 002800 CPT
Powered by BI Documenter