DWOperations
 dbo.Staged_dbo_DimStudentObjective__New (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.Staged_dbo_DimStudentObjective__New
  Properties
Property Value
Name Staged_dbo_DimStudentObjective__New
Schema dbo
Row Count 1631584
Data Size 376856 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
ActualGraduationTerm
varchar(6)
False
False
False
 
ActualGraduationTermTitle
varchar(30)
False
False
False
 
AdmissionStatus
varchar(3)
False
False
False
 
AwardType
varchar(30)
False
False
False
 
AwardTypeCode
varchar(3)
False
False
False
 
EffectiveTerm
varchar(6)
False
False
False
 
EffectiveTermTitle
varchar(30)
False
False
False
 
ExpectedGraduationTerm
varchar(6)
False
False
False
 
ExpectedGraduationTermTitle
varchar(30)
False
False
False
 
GraduationAge
smallint(5, 0)
False
False
False
 
GraduationAgeRange
varchar(10)
False
False
False
 
GraduationHonorsCode
varchar(3)
False
False
False
 
GraduationStatusCode
varchar(3)
False
False
False
 
PrimaryObjective
varchar(3)
False
False
False
 
Program
varchar(30)
False
False
False
 
ProgramCode
varchar(5)
False
False
False
 
ProgramStatusCode
varchar(3)
False
False
False
 
ReportedTerm
varchar(6)
False
False
False
 
ReportedTermTitle
varchar(30)
False
False
False
 
RowEndDate
datetime(23, 3)
True
False
False
 
RowIsCurrent
char(1)
False
False
False
 
RowStartDate
datetime(23, 3)
False
False
False
 
SequenceNumber
int(10, 0)
False
False
False
 
StudentId
varchar(9)
False
False
False
 
StudentObjectiveAK
varchar(23)
False
False
False
 
TransferInstitution
varchar(50)
False
False
False
 
TransferInstitutionId
varchar(8)
False
False
False
 
TransferMajor
varchar(30)
False
False
False
 
TransferMajorCode
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.Staged_dbo_DimStudentObjective__New depends on)
Name Type
  Child Dependencies (objects that depend on dbo.Staged_dbo_DimStudentObjective__New)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Staged_dbo_DimStudentObjective__New] Script Date: 03/09/2017 17:21:43 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Staged_dbo_DimStudentObjective__New](
    [StudentObjectiveAK] [varchar](23) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ProgramCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Program] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EffectiveTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EffectiveTermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SequenceNumber] [int] NOT NULL,
    [AdmissionStatus] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AwardTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AwardType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimaryObjective] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ProgramStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GraduationStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ExpectedGraduationTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ExpectedGraduationTermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ActualGraduationTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ActualGraduationTermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GraduationAge] [smallint] NOT NULL,
    [GraduationAgeRange] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GraduationHonorsCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TransferMajorCode] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TransferMajor] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TransferInstitutionId] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TransferInstitution] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReportedTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReportedTermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL
) ON [PRIMARY]
  Sample Data
ActualGraduationTerm ActualGraduationTermTitle AdmissionStatus AwardType AwardTypeCode EffectiveTerm EffectiveTermTitle ExpectedGraduationTerm ExpectedGraduationTermTitle GraduationAge GraduationAgeRange GraduationHonorsCode GraduationStatusCode PrimaryObjective Program ProgramCode ProgramStatusCode ReportedTerm ReportedTermTitle RowIsCurrent RowStartDate SequenceNumber StudentId StudentObjectiveAK TransferInstitution TransferInstitutionId TransferMajor TransferMajorCode
20072 Spring Term 2007 Y Associate In Science Degree AS 20061 Fall Term 2005 20072 Spring Term 2007 29 22 - 29 N/A G No Dental Hygiene 2151 GR 20072 Spring Term 2007 Y 2017-03-09T11:38:00-05:00 1 A06155063 A06155063215120061001 N/A N/A N/A N/A
N/A N/A Y Non-Credit NC 19992 Winter Term 1999 N/A N/A 0 Other N/A A Yes Nc-Lifelong Learning 8384 AC N/A N/A Y 2017-03-09T11:38:00-05:00 1 R11035698 R11035698838419992001 N/A N/A N/A N/A
N/A N/A Y Non-Degree Seeking ND 20163 Summer Term 2016 N/A N/A 0 Other N/A A Yes Special Permission 3410 AC N/A N/A Y 2017-03-09T11:38:00-05:00 1 M15263643 M15263643341020163001 N/A N/A N/A N/A
N/A N/A N Non-Degree Seeking ND 19971 Fall Term 1996 N/A N/A 0 Other N/A A No Transient 3001 IN N/A N/A Y 2017-03-09T11:38:00-05:00 1 A06572028 A06572028300119971001 N/A N/A N/A N/A
N/A N/A N Non-Degree Seeking ND 20011 Fall Term 2000 N/A N/A 0 Other N/A A No Personal Improvement 3408 IN N/A N/A Y 2017-03-09T11:38:00-05:00 1 S09651704 S09651704340820011001 N/A N/A N/A N/A
N/A N/A Y Non-Degree Seeking ND 20121 Fall Term 2011 N/A N/A 0 Other N/A A No Hs Early Admission 3803 AC N/A N/A Y 2017-03-09T11:38:00-05:00 1 B13533690 B13533690380320121001 N/A N/A N/A N/A
N/A N/A Y Non-Degree Seeking ND 19611 Fall Term 1960 N/A N/A 0 Other N/A A Yes Personal Improvement 3408 AC N/A N/A Y 2017-03-09T11:38:00-05:00 1 T10667020 T10667020340819611001 N/A N/A N/A N/A
N/A N/A Y Non-Degree Seeking ND 20042 Spring Term 2004 N/A N/A 0 Other N/A A No Transient Student 3409 IN N/A N/A Y 2017-03-09T11:38:00-05:00 1 H06942452 H06942452340920042001 N/A N/A N/A N/A
N/A N/A Y Associate In Arts Degree AA 20153 Summer Term 2015 N/A N/A 0 Other N/A A Yes Associate In Arts 1000 AC N/A N/A Y 2017-03-09T11:38:00-05:00 1 C15001514 C15001514100020153001 University Of Central Florida 003954 Finance, General (Bs) 520801
N/A N/A Y Non-Degree Seeking ND 19762 Winter Term 1976 N/A N/A 0 Other N/A A Yes Personal Improvement 3408 AC N/A N/A Y 2017-03-09T11:38:00-05:00 1 J10381986 J10381986340819762001 N/A N/A N/A N/A
Powered by BI Documenter