EnterpriseDW
 dbo.FactApplicationStatus (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  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:  EnterpriseDW   Tables   dbo.FactApplicationStatus
  Properties
Property Value
Name FactApplicationStatus
Schema dbo
Row Count 486198
Data Size 31368 KB
Index Size 128 KB
Create Date 3/9/2017 10:43 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ApplicationDateSK
int(10, 0)
False
False
False
 
Foreign Key
ApplicationSK
int(10, 0)
False
False
False
 
Foreign Key
ApplicationSourceSK
int(10, 0)
False
False
False
 
In Primary Key
ApplicationStatusSK
int(10, 0)
False
False
False
(1 / 1)
Foreign Key
ApplicationTermSK
int(10, 0)
False
False
False
 
EnrolledAfterApplicationTerm
smallint(5, 0)
False
False
False
 
EnrolledInApplicationTerm
smallint(5, 0)
False
False
False
 
NeedAdvising
smallint(5, 0)
False
False
False
 
NeedEducationalPlan
smallint(5, 0)
False
False
False
 
NeedOrientation
smallint(5, 0)
False
False
False
 
NeedTesting
smallint(5, 0)
False
False
False
 
NeedTranscripts
smallint(5, 0)
False
False
False
 
NoAdmissionBarriers
smallint(5, 0)
False
False
False
 
NotEnrolled
smallint(5, 0)
False
False
False
 
OtherRegistrationHold
smallint(5, 0)
False
False
False
 
ResidencyHold
smallint(5, 0)
False
False
False
 
Foreign Key
StudentObjectiveSK
int(10, 0)
False
False
False
 
Foreign Key
StudentSK
int(10, 0)
False
False
False
 
Foreign Key
StudentTermSK
int(10, 0)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
ApplicationStatusSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
ApplicationSK
DimApplication
ApplicationSK
True
ApplicationSourceSK
DimApplicationSource
ApplicationSourceSK
True
StudentSK
DimStudent
StudentSK
True
StudentObjectiveSK
DimStudentObjective
StudentObjectiveSK
True
StudentTermSK
DimStudentTerm
StudentTermSK
True
ApplicationTermSK
DimTerm
TermSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactApplicationStatus depends on)
Name Type
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactApplicationStatus)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactApplicationStatus] Script Date: 03/09/2017 17:14:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactApplicationStatus](
    [ApplicationStatusSK] [int] IDENTITY(1,1) NOT NULL,
    [ApplicationSK] [int] NOT NULL,
    [ApplicationSourceSK] [int] NOT NULL,
    [StudentObjectiveSK] [int] NOT NULL,
    [ApplicationTermSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [ApplicationDateSK] [int] NOT NULL,
    [StudentTermSK] [int] NOT NULL,
    [NeedTesting] [smallint] NOT NULL,
    [NeedAdvising] [smallint] NOT NULL,
    [NeedOrientation] [smallint] NOT NULL,
    [NeedTranscripts] [smallint] NOT NULL,
    [ResidencyHold] [smallint] NOT NULL,
    [NeedEducationalPlan] [smallint] NOT NULL,
    [OtherRegistrationHold] [smallint] NOT NULL,
    [NoAdmissionBarriers] [smallint] NOT NULL,
    [NotEnrolled] [smallint] NOT NULL,
    [EnrolledAfterApplicationTerm] [smallint] NOT NULL,
    [EnrolledInApplicationTerm] [smallint] NOT NULL,
 CONSTRAINT [PK_FactApplicationStatus] PRIMARY KEY CLUSTERED 
(
    [ApplicationStatusSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[FactApplicationStatus]  WITH CHECK ADD  CONSTRAINT [FK_FactApplicationStatus_DimApplication] FOREIGN KEY([ApplicationSK])
REFERENCES [DimApplication] ([ApplicationSK])
ALTER TABLE [dbo].[FactApplicationStatus] CHECK CONSTRAINT [FK_FactApplicationStatus_DimApplication]
ALTER TABLE [dbo].[FactApplicationStatus]  WITH CHECK ADD  CONSTRAINT [FK_FactApplicationStatus_DimApplicationSource] FOREIGN KEY([ApplicationSourceSK])
REFERENCES [DimApplicationSource] ([ApplicationSourceSK])
ALTER TABLE [dbo].[FactApplicationStatus] CHECK CONSTRAINT [FK_FactApplicationStatus_DimApplicationSource]
ALTER TABLE [dbo].[FactApplicationStatus]  WITH CHECK ADD  CONSTRAINT [FK_FactApplicationStatus_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactApplicationStatus] CHECK CONSTRAINT [FK_FactApplicationStatus_DimStudent]
ALTER TABLE [dbo].[FactApplicationStatus]  WITH CHECK ADD  CONSTRAINT [FK_FactApplicationStatus_DimStudentObjective] FOREIGN KEY([StudentObjectiveSK])
REFERENCES [DimStudentObjective] ([StudentObjectiveSK])
ALTER TABLE [dbo].[FactApplicationStatus] CHECK CONSTRAINT [FK_FactApplicationStatus_DimStudentObjective]
ALTER TABLE [dbo].[FactApplicationStatus]  WITH CHECK ADD  CONSTRAINT [FK_FactApplicationStatus_DimStudentTerm] FOREIGN KEY([StudentTermSK])
REFERENCES [DimStudentTerm] ([StudentTermSK])
ALTER TABLE [dbo].[FactApplicationStatus] CHECK CONSTRAINT [FK_FactApplicationStatus_DimStudentTerm]
ALTER TABLE [dbo].[FactApplicationStatus]  WITH CHECK ADD  CONSTRAINT [FK_FactApplicationStatus_DimTerm] FOREIGN KEY([ApplicationTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactApplicationStatus] CHECK CONSTRAINT [FK_FactApplicationStatus_DimTerm]
  Sample Data
ApplicationDateSK ApplicationSK ApplicationSourceSK ApplicationStatusSK ApplicationTermSK EnrolledAfterApplicationTerm EnrolledInApplicationTerm NeedAdvising NeedEducationalPlan NeedOrientation NeedTesting NeedTranscripts NoAdmissionBarriers NotEnrolled OtherRegistrationHold ResidencyHold StudentObjectiveSK StudentSK StudentTermSK
19970401 365174 5 205650 20012 0 1 0 0 0 0 0 1 0 0 0 3869575 23383105 53504959
20010709 200429 4 109573 20021 0 1 0 0 0 0 0 1 0 0 0 3598327 23112971 51889013
20130521 302839 2 169481 20133 0 1 0 0 0 0 0 1 0 0 0 3693901 23298464 52946621
20100315 123198 4 396273 20102 1 0 0 0 0 0 0 1 0 0 0 3194803 22932793 51045736
20020903 313435 4 421476 20031 0 1 0 0 0 0 1 0 0 0 0 3732983 23320571 53035555
20050715 380042 4 216338 20061 0 0 0 0 0 0 0 1 1 0 0 3978262 23466458 53801328
20040107 347505 4 196887 20042 0 1 0 0 0 0 0 1 0 0 0 3834376 23363817 53386744
20041026 388397 2 215949 20052 0 1 0 0 0 0 0 1 0 0 0 3986944 23457022 53794030
20090601 83861 1 49150 20101 1 0 0 0 0 0 0 1 0 0 0 3045787 22819804 50692826
20150531 144229 5 304560 20111 0 1 0 0 0 0 0 1 0 0 0 3279422 22982872 51239159
Powered by BI Documenter