DWOperations
 dbo.Verify_dbo_DimStudentObjective (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.Verify_dbo_DimStudentObjective
  Properties
Property Value
Name Verify_dbo_DimStudentObjective
Schema dbo
Row Count 1632030
Data Size 357968 KB
Index Size 1352 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
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
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
 
In Primary Key
VerifyStudentObjectiveSK
int(10, 0)
False
False
False
(1 / 1)
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyStudentObjectiveSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimStudentObjective depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimStudentObjective)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimStudentObjective] Script Date: 03/09/2017 17:21:48 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimStudentObjective](
    [VerifyStudentObjectiveSK] [int] IDENTITY(1,1) NOT NULL,
    [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,
    [RowIsDuplicate] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsSelected] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_Verify_dbo_DimStudentObjective] PRIMARY KEY CLUSTERED 
(
    [VerifyStudentObjectiveSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  Sample Data
ActualGraduationTerm ActualGraduationTermTitle AdmissionStatus AwardType AwardTypeCode EffectiveTerm EffectiveTermTitle ExpectedGraduationTerm ExpectedGraduationTermTitle GraduationAge GraduationAgeRange GraduationHonorsCode GraduationStatusCode PrimaryObjective Program ProgramCode ProgramStatusCode ReportedTerm ReportedTermTitle RowIsDuplicate RowIsSelected SequenceNumber StudentId StudentObjectiveAK TransferInstitution TransferInstitutionId TransferMajor TransferMajorCode VerifyStudentObjectiveSK
N/A N/A Y ASSOCIATE IN SCIENCE DEGREE AS 20142 SPRING TERM 2014 N/A N/A 0 Other N/A A No INTERNET SERVICES TECHNOLOGY 2122 IN N/A N/A N Y 1 F14250658 F14250658212220142001 N/A N/A N/A N/A 493842
N/A N/A Y NON-CREDIT NC 20153 SUMMER TERM 2015 N/A N/A 0 Other N/A A Yes NC-PERSONAL ENRICHMENT 8384 AC N/A N/A N Y 1 E15105000 E15105000838420153001 N/A N/A N/A N/A 1294415
N/A N/A Y ASSOCIATE IN ARTS DEGREE AA 20171 FALL TERM 2016 N/A N/A 0 Other N/A A Yes ASSOCIATE IN ARTS 1000 AC N/A N/A N Y 1 C14265193 C14265193100020171001 FLORIDA ATLANTIC UNIVERSITY 001481 Nursing 513801 1621948
N/A N/A N NON-CREDIT NC 20123 SUMMER TERM 2012 N/A N/A 0 Other N/A A No NC-PERSONAL ENRICHMENT 8384 IN N/A N/A N Y 1 T14217228 T14217228838420123001 N/A N/A N/A N/A 502776
N/A N/A N ASSOCIATE IN ARTS DEGREE AA 20071 FALL TERM 2006 N/A N/A 0 Other N/A A No GENERAL/TRANSFER AA 1000 IN N/A N/A N Y 1 B12102398 B12102398100020071001 N/A N/A N/A N/A 1180762
N/A N/A Y NON-CREDIT NC 20091 FALL TERM 2008 N/A N/A 0 Other N/A A Yes NC-PERSONAL ENRICHMENT 8384 AC N/A N/A N Y 1 C13041918 C13041918838420091001 N/A N/A N/A N/A 227489
N/A N/A N VOCATIONAL CERTIFICATE VC 20033 SUMMER TERM 2003 N/A N/A 0 Other N/A A No PRACTICAL NURSING 5234 IN N/A N/A N Y 1 K11696036 K11696036523420033001 N/A N/A N/A N/A 263602
N/A N/A N BACHELOR OF APPLIED SCIENCE BAS 20152 SPRING TERM 2015 N/A N/A 0 Other N/A A No SUPERVISION & MANAGEMENT T705 IN N/A N/A N Y 1 J14896278 J14896278T70520152001 N/A N/A N/A N/A 519856
20061 FALL TERM 2005 Y APPLIED TECHNOLOGY DIPLOMA ATD 20061 FALL TERM 2005 20061 FALL TERM 2005 19 19 - 21 N/A G No EMER MEDICAL TECHNICIAN-BASIC B217 GR 20061 FALL TERM 2005 N Y 1 D11730520 D11730520B21720061001 N/A N/A N/A N/A 964830
N/A N/A Y NON-CREDIT NC 20123 SUMMER TERM 2012 N/A N/A 0 Other N/A A Yes NC-PERSONAL ENRICHMENT 8384 AC N/A N/A N Y 1 P14158869 P14158869838420123001 N/A N/A N/A N/A 455344
Powered by BI Documenter