DWStaging
 dbo.ST_ED_PLAN_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_ED_PLAN_A
  Properties
Property Value
Name ST_ED_PLAN_A
Schema dbo
Row Count 147423
Data Size 13872 KB
Index Size 2232 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
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
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_ED_PLAN_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
 
REMINDER
varchar(1)
True
False
False
 
REVIEW_STATUS
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
TERM
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_ED_PLAN_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_ED_PLAN_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_ED_PLAN_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_ED_PLAN_A] Script Date: 03/09/2017 16:46:04 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_ED_PLAN_A](
    [ISN_ST_ED_PLAN_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,
    [TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REMINDER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REVIEW_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID HOLD ISN_ST_ED_PLAN_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID REMINDER REVIEW_STATUS RowUpdatedOn STDNT_ID TERM
20161031 STD635N0 0551380 STUDENT 1836341 143241 20161031 STD635N0 1836341 STUDENT N N 2017-02-06T10:39:28.025-05:00 A13679626 20172
20150202 STD635N0 1445425 STUDENT 1445425 101499 C 2017-02-06T10:39:25.856-05:00 H14811434 20163
20140603 STD635N0 1408004 STUDENT 1408004 83997 N 2017-02-06T10:39:24.936-05:00 M11731254 20151
20070910 STD635N0 2014331 WEB5 2014331 1550 Y N 2017-02-06T10:39:20.584-05:00 S12419727 20082
20161207 STD635N0 1613504 STUDENT 1613504 146649 Y N 2017-02-06T10:39:28.228-05:00 G14981740 20172
20161027 STD635N0 1839212 STUDENT 1839212 143005 Y N 2017-02-06T10:39:28.025-05:00 E15262835 20171
20120221 STD635N0 2232085 STUDENT 2232085 42298 N C 2017-02-06T10:39:22.752-05:00 B14039408 20132
20160229 STD635N0 1151305 STUDENT 1151305 126362 Y N 2017-02-06T10:39:27.151-05:00 C14926943 20173
20121001 STD635N0 1635181 STUDENT 1635181 52112 Y N 2017-02-06T10:39:23.251-05:00 A12935847 20132
20130327 STD635N0 0847197 STUDENT 1007292 61295 20150210 STD635N0 1007292 E011761 N C 2017-02-06T10:39:23.735-05:00 M11981172 20152
Powered by BI Documenter