DWStaging
 dbo.ST_ED_PLAN_LOG_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_LOG_A
  Properties
Property Value
Name ST_ED_PLAN_LOG_A
Schema dbo
Row Count 513330
Data Size 32640 KB
Index Size 7696 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
ISN_ST_ED_PLAN_LOG_A
int(10, 0)
False
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
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_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_ED_PLAN_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_ED_PLAN_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_ED_PLAN_LOG_A] Script Date: 03/09/2017 16:46:04 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_ED_PLAN_LOG_A](
    [ISN_ST_ED_PLAN_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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
ISN_ST_ED_PLAN_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER REMINDER REVIEW_STATUS RowUpdatedOn STDNT_ID TERM
167282 M 20130823 <notty> 1458392 STUDENT N N 2017-02-06T10:33:43.231-05:00 S14442362 20141
432998 A 20160425 <notty> 1337462 STUDENT Y N 2017-02-06T10:33:56.195-05:00 M14873079 20171
16025 M 20110726 <notty> 1245528 E001605 N C 2017-02-06T10:33:35.853-05:00 J13797196 20122
36443 A 20111020 <notty> 1124505 STUDENT N N 2017-02-06T10:33:36.835-05:00 L13783394 20122
148082 P 20130626 <notty> 1638488 ROOT Y N 2017-02-06T10:33:42.327-05:00 D14506786 20133
269235 A 20141008 <notty> 2019213 STUDENT N N 2017-02-06T10:33:48.411-05:00 K14585772 20152
165077 M 20130819 <notty> 1047069 STUDENT N N 2017-02-06T10:33:43.138-05:00 A14379010 20141
266265 M 20141005 <notty> 2337078 STUDENT N 2017-02-06T10:33:48.239-05:00 T14677728 20161
70260 A 20120527 <notty> 1310192 STUDENT N 2017-02-06T10:33:38.505-05:00 M11089323 20132
504198 A 20161201 <notty> 1052147 STUDENT Y N 2017-02-06T10:33:59.768-05:00 D15379753 20171
Powered by BI Documenter