DWStaging
 dbo.ST_TST_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_TST_A
  Properties
Property Value
Name ST_TST_A
Schema dbo
Row Count 856558
Data Size 100768 KB
Index Size 12808 KB
Create Date 8/15/2012 2:11 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
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
 
CAMP_CNTR
varchar(5)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INIT_TST_DT
varchar(8)
True
False
False
 
ISN_ST_TST_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
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
TRANSMISSION_MODE
varchar(2)
True
False
False
 
TST_ADMIN_SSN
varchar(9)
True
False
False
 
TST_DT
varchar(8)
True
False
False
 
TST_FRM
varchar(4)
True
False
False
 
TST_LANG
varchar(2)
True
False
False
 
TST_TY
varchar(4)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_TST_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_TST_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_TST_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_TST_A] Script Date: 03/09/2017 16:46:31 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_TST_A](
    [ISN_ST_TST_A] [int] NOT NULL,
    [STUDENT_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,
    [CAMP_CNTR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TST_LANG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TST_ADMIN_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANSMISSION_MODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INIT_TST_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CAMP_CNTR HOLD INIT_TST_DT ISN_ST_TST_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RowUpdatedOn STUDENT_ID TRANSMISSION_MODE TST_ADMIN_SSN TST_DT TST_FRM TST_LANG TST_TY
20070709 STA050N1 1203306 E025006 19 1203411 20061001 449488 20070709 STA050N1 1203411 E025006 2017-02-06T10:05:32.009-05:00 J12633806 LI E025006 20070101 A EN SAT
19990308 STA050N1 0429594 OPERTNS 5 926335 19931001 134710 19990308 STA050N1 0926335 OPERTNS 2017-02-06T10:05:09.919-05:00 A07177207 EL 19931001 A EN SAT
19990308 STA050N1 0425503 OPERTNS 1 1158255 19941006 30548 19990515 STA050N1 1158255 OPERTNS 2017-02-06T10:05:02.665-05:00 M07025208 LI 19941006 A EN CPT
20130422 STA050N1 1240276 E072906 29 1240418 20110507 730980 20130422 STA050N1 1240418 E072906 2017-02-06T10:05:51.462-05:00 A14388664 LI E072906 20110507 A EN SAT
20020507 STA050N1 1656040 WALTMANW 1 1656173 20020507 220390 20020507 STA050N1 1656173 WALTMANW 2017-02-06T10:05:16.019-05:00 C11496999 LI WALTMANW 20020507 A EN CPT
20000127 STA050N1 1538231 CPANTON 1 1538435 19980901 161410 20000127 STA050N1 1538435 CPANTON 2017-02-06T10:05:11.838-05:00 E11144607 LI CPANTON 19981001 A EN ACT
20080409 STA050N1 1040242 E000246 5 1041288 20080409 479469 20080409 STA050N1 1041288 E000246 2017-02-06T10:05:34.099-05:00 J12824199 LI E000246 20080409 A EN CPT
20010716 STA050N1 1209145 DCESTARO 1 1209511 20010716 197369 20010716 STA050N1 1209511 DCESTARO 2017-02-06T10:05:14.474-05:00 L10176535 LI DCESTARO 20010716 A EN CPT
19990308 STA050N1 0540077 OPERTNS 1 540077 19901001 114979 2017-02-06T10:05:08.468-05:00 R09474982 19910201 A EN CLST
20050629 STA050N1 1508293 E000998 3 1508474 20000522 373684 20050629 STA050N1 1508474 E000998 2017-02-06T10:05:26.377-05:00 S11176088 LI E000998 20050629 A EN CPT
Powered by BI Documenter