DWStaging
 dbo.ST_STDNT_TEST_DEMO_A (Table)
  Properties
Property Value
Name ST_STDNT_TEST_DEMO_A
Schema dbo
Row Count 2847292
Data Size 281424 KB
Index Size 42480 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
ACTIVE_1_IND
varchar(1)
True
False
False
 
ACTIVE_2_IND
varchar(1)
True
False
False
 
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
 
EFF_TRM
varchar(6)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INIT_STATUS_IND
varchar(1)
True
False
False
 
ISN_ST_STDNT_TEST_DEMO_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
 
PGM_ID
varchar(5)
True
False
False
 
PLACEMENT_AREA
varchar(3)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STATUS_IND
varchar(1)
True
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
TABE_EXMPTN_IND
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_STDNT_TEST_DEMO_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_STDNT_TEST_DEMO_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_STDNT_TEST_DEMO_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_TEST_DEMO_A] Script Date: 03/09/2017 16:46:29 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_TEST_DEMO_A](
    [ISN_ST_STDNT_TEST_DEMO_A] [int] NOT 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,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PLACEMENT_AREA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVE_1_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVE_2_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TABE_EXMPTN_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INIT_STATUS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACTIVE_1_IND ACTIVE_2_IND ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID EFF_TRM HOLD INIT_STATUS_IND ISN_ST_STDNT_TEST_DEMO_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PGM_ID PLACEMENT_AREA RowUpdatedOn STATUS_IND STDNT_ID TABE_EXMPTN_IND
A I 19990306 STS272N0 1807507 OPERTNS 258250 U 1076538 20040401 STS272N0 0258250 OPER2 ENG 2017-02-06T09:30:06.979-05:00 U R10419166
I I 20160414 STS272N0 1721360 SAG 1959505 T 2179387 20160804 STS272N0 1959505 OPER1 REA 2017-02-06T09:31:18.505-05:00 T N13264817
I F 20090120 STS272N0 1741279 FACTS1 255320 C 2115550 20140507 STS272N0 0255320 OPER2 ENG 2017-02-06T09:31:14.2-05:00 C C13119623
A I 19990306 STS272N0 1626260 OPERTNS 1626260 U 1001622 MAT 2017-02-06T09:30:02.33-05:00 U T10113652
I I 20151222 STS272N0 1115455 OPER1 832193 T 2723984 20160630 STS272N0 0832193 OPER1 MAT 2017-02-06T09:31:54.401-05:00 T K14977110
A I 20140909 STS272N0 0336084 WEB8 225365 U 2652156 20160107 STS272N0 0225365 WEB5 ENG 2017-02-06T09:31:49.893-05:00 U D14864011
A I 19990306 STS272N0 0617206 OPERTNS 617206 U 511405 REA 2017-02-06T09:29:31.536-05:00 U W08166662
A I 19990306 STS272N0 0202246 OPERTNS 257032 T 262893 20020718 STS272N0 0257032 OPER2 ENG 2017-02-06T09:29:16.013-05:00 T S07135528
A I 20000502 STS272N0 1652424 IVOWELL 2315324 U 1386953 20000811 STS272N0 2315324 OPER2 ENG 2017-02-06T09:30:27.025-05:00 U L09884974
A I 19990306 STS272N0 1204585 OPERTNS 1907448 U 805751 20000609 STS272N0 1907448 OPER2 ENG 2017-02-06T09:29:49.741-05:00 U K09329905
Powered by BI Documenter