DWOperations
 dbo.FactStudentGrades_Staging (Table)
Home  Diagrams  Documents  Images  DWOperations  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:  DWOperations   Tables   dbo.FactStudentGrades_Staging
  Properties
Property Value
Name FactStudentGrades_Staging
Schema dbo
Row Count 3446585
Data Size 424200 KB
Index Size 16 KB
Create Date 8/28/2013 9:56 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Attempt1
int(10, 0)
False
False
False
 
Attempt2
int(10, 0)
False
False
False
 
Attempt2OrMore
int(10, 0)
False
False
False
 
Attempt3OrMore
int(10, 0)
False
False
False
 
GradeA
int(10, 0)
False
False
False
 
GradeB
int(10, 0)
False
False
False
 
GradeByLetterOther
int(10, 0)
False
False
False
 
GradeC
int(10, 0)
False
False
False
 
GradeD
int(10, 0)
False
False
False
 
GradeF
int(10, 0)
False
False
False
 
GradeFail
int(10, 0)
False
False
False
 
GradeI
int(10, 0)
False
False
False
 
GradeMarginal
int(10, 0)
False
False
False
 
GradeN
int(10, 0)
False
False
False
 
GradeOther
int(10, 0)
False
False
False
 
GradeP
int(10, 0)
False
False
False
 
GradeS
int(10, 0)
False
False
False
 
GradeSuccess
int(10, 0)
False
False
False
 
GradeU
int(10, 0)
False
False
False
 
GradeW
int(10, 0)
False
False
False
 
GradeWithdrawal
int(10, 0)
False
False
False
 
GradeX
int(10, 0)
False
False
False
 
RefNum
int(10, 0)
False
False
False
 
StudentId
varchar(9)
False
False
False
 
Term
varchar(6)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactStudentGrades_Staging depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FactStudentGrades_Staging)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactStudentGrades_Staging] Script Date: 03/09/2017 17:21:33 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactStudentGrades_Staging](
    [StudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Term] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RefNum] [int] NOT NULL,
    [GradeSuccess] [int] NOT NULL,
    [GradeMarginal] [int] NOT NULL,
    [GradeFail] [int] NOT NULL,
    [GradeWithdrawal] [int] NOT NULL,
    [GradeOther] [int] NOT NULL,
    [GradeA] [int] NOT NULL,
    [GradeB] [int] NOT NULL,
    [GradeC] [int] NOT NULL,
    [GradeD] [int] NOT NULL,
    [GradeF] [int] NOT NULL,
    [GradeW] [int] NOT NULL,
    [GradeS] [int] NOT NULL,
    [GradeP] [int] NOT NULL,
    [GradeU] [int] NOT NULL,
    [GradeN] [int] NOT NULL,
    [GradeX] [int] NOT NULL,
    [GradeI] [int] NOT NULL,
    [GradeByLetterOther] [int] NOT NULL,
    [Attempt1] [int] NOT NULL,
    [Attempt2] [int] NOT NULL,
    [Attempt2OrMore] [int] NOT NULL,
    [Attempt3OrMore] [int] NOT NULL
) ON [PRIMARY]
  Sample Data
Attempt1 Attempt2 Attempt2OrMore Attempt3OrMore GradeA GradeB GradeByLetterOther GradeC GradeD GradeF GradeFail GradeI GradeMarginal GradeN GradeOther GradeP GradeS GradeSuccess GradeU GradeW GradeWithdrawal GradeX RefNum StudentId Term
1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 30409 J10599041 20021
0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 168262 M14171870 20132
1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 55475 T11075835 20041
0 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 91818 L12086708 20072
0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 160983 D13624499 20131
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 19914 J11190907 20011
1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 217311 V12968558 20171
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 12195 R08397051 19993
1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 186077 J13381322 20142
1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 161179 A13005079 20131
Powered by BI Documenter