EnterpriseDW
 dbo.DimApplication (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.DimApplication
  Properties
Property Value
Name DimApplication
Schema dbo
Row Count 486199
Data Size 148352 KB
Index Size 568 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
ApplicationAK
varchar(23)
False
False
False
 
ApplicationDate
date(10, 0)
False
False
False
 
ApplicationEntry
varchar(15)
False
False
False
 
In Primary Key
ApplicationSK
int(10, 0)
False
False
False
(1 / 1)
ApplicationTerm
varchar(6)
False
False
False
 
ApplicationTermTitle
varchar(30)
False
False
False
 
ApplicationType
varchar(60)
False
False
False
 
ApplicationTypeCode
varchar(3)
False
False
False
 
AwardType
varchar(30)
False
False
False
 
AwardTypeCode
varchar(3)
False
False
False
 
BachelorApplicant
varchar(3)
False
False
False
 
BasisOfAdmission
varchar(30)
False
False
False
 
BasisOfAdmissionCode
varchar(3)
False
False
False
 
CreditVocationalBachelorApplication
varchar(15)
False
False
False
 
EnrollmentStatus
varchar(30)
False
False
False
 
EnrollmentStatusCode
varchar(3)
False
False
False
 
FirstTermEnrolled
varchar(6)
False
False
False
 
FirstTermEnrolledTitle
varchar(30)
False
False
False
 
FirstTimeInCollege
varchar(3)
False
False
False
 
HomeCampus
varchar(50)
False
False
False
 
HomeCampusCode
varchar(3)
False
False
False
 
InitialOrReadmitApplication
varchar(15)
False
False
False
 
Program
varchar(30)
False
False
False
 
ProgramCode
varchar(5)
False
False
False
 
RowEndDate
datetime(23, 3)
True
False
False
 
RowIsCurrent
char(1)
False
False
False
 
RowStartDate
datetime(23, 3)
False
False
False
 
StudentId
varchar(9)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
ApplicationSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimApplication depends on)
Name Type
Table
  Child Dependencies (objects that depend on dbo.DimApplication)
Name Type
TABLE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimApplication] Script Date: 03/09/2017 17:14:53 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimApplication](
    [ApplicationSK] [int] IDENTITY(1,1) NOT NULL,
    [ApplicationAK] [varchar](23) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ApplicationTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ApplicationTermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ApplicationEntry] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ApplicationTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ApplicationType] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CreditVocationalBachelorApplication] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [InitialOrReadmitApplication] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BasisOfAdmissionCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BasisOfAdmission] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EnrollmentStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EnrollmentStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FirstTimeInCollege] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BachelorApplicant] [varchar](3) 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,
    [AwardTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AwardType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ApplicationDate] [date] NOT NULL,
    [FirstTermEnrolled] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FirstTermEnrolledTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HomeCampusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HomeCampus] [varchar](50) 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,
 CONSTRAINT [PK_DimApplication] PRIMARY KEY CLUSTERED 
(
    [ApplicationSK] 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
ApplicationAK ApplicationDate ApplicationEntry ApplicationSK ApplicationTerm ApplicationTermTitle ApplicationType ApplicationTypeCode AwardType AwardTypeCode BachelorApplicant BasisOfAdmission BasisOfAdmissionCode CreditVocationalBachelorApplication EnrollmentStatus EnrollmentStatusCode FirstTermEnrolled FirstTermEnrolledTitle FirstTimeInCollege HomeCampus HomeCampusCode InitialOrReadmitApplication Program ProgramCode RowIsCurrent RowStartDate StudentId
J12218582CR200813409 2015-05-31T00:00:00-04:00 Application 206839 20081 Fall Term 2007 College Credit Readmit Application CR Non-Degree Seeking ND No College Transfer T Credit Readmitted Student R 20081 Fall Term 2007 No Palm Beach Gardens Campus 2 Readmit Transient Student 3409 Y 2017-03-09T11:41:00-05:00 J12218582
B13965769CC201211000 2011-08-26T00:00:00-04:00 Application 60565 20121 Fall Term 2011 College Credit Application CC Associate In Arts Degree AA No Hs Graduate H Credit New Student N N/A N/A Yes Palm Beach Gardens Campus 2 Initial Associate In Arts 1000 Y 2017-03-09T11:41:00-05:00 B13965769
B14482913VC201335236 2013-06-03T00:00:00-04:00 Application 62373 20133 Summer Term 2013 Vocational Application VC Vocational Certificate VC No College Transfer T Vocational New Student N N/A N/A No Lake Worth Campus 1 Initial Medical Assisting 5236 Y 2017-03-09T11:41:00-05:00 B14482913
E14229520CC201231000 2012-07-20T00:00:00-04:00 Application 152090 20123 Summer Term 2012 College Credit Application CC Associate In Arts Degree AA No College Transfer T Credit New Student N N/A N/A No Boca Raton Campus 5 Initial Associate In Arts 1000 Y 2017-03-09T11:41:00-05:00 E14229520
W12907044CC201032301 2010-04-14T00:00:00-04:00 Application 477753 20103 Summer Term 2010 College Credit Application CC Associate In Science Degree AS No College Transfer T Credit New Student N 20103 Summer Term 2010 No Belle Glade Campus 3 Initial Nursing 2301 Y 2017-03-09T11:41:00-05:00 W12907044
E15311988CC201631000 2016-04-30T00:00:00-04:00 Application 150393 20163 Summer Term 2016 College Credit Application CC Associate In Arts Degree AA No College Transfer T Credit New Student N N/A N/A No Palm Beach Gardens Campus 2 Initial Associate In Arts 1000 Y 2017-03-09T11:41:00-05:00 E15311988
M15414980VC201725267 2016-08-17T00:00:00-04:00 Application 351516 20172 Spring Term 2017 Vocational Application VC Vocational Certificate VC No Hs Graduate H Vocational New Student N N/A N/A Yes Palm Beach Gardens Campus 2 Initial Heating/Vent/Ac/Refrigeration 5267 Y 2017-03-09T11:41:00-05:00 M15414980
K13318506CC20152T701A 2014-09-11T00:00:00-04:00 Objective 259542 20152 Spring Term 2015 College Credit Application CC Bachelor Of Applied Science BAS Yes Hs Graduate H Bachelor Readmitted Student R N/A N/A Yes Boca Raton Campus 5 Initial Supervision & Management T701A Y 2017-03-09T11:41:00-05:00 K13318506
D13250139CC201313408 2009-06-03T00:00:00-04:00 Application 122188 20131 Fall Term 2012 College Credit Application CC Non-Degree Seeking ND No Hs Graduate H Credit New Student N N/A N/A Yes Lake Worth Campus 1 Initial Personal Improvement 3408 Y 2017-03-09T11:41:00-05:00 D13250139
W11791704CC200422198 2003-09-08T00:00:00-04:00 Application 481233 20042 Spring Term 2004 College Credit Application CC Associate In Science Degree AS No College Transfer T Credit New Student N N/A N/A No Belle Glade Campus 3 Initial Building Construction Technolo 2198 Y 2017-03-09T11:41:00-05:00 W11791704
Powered by BI Documenter