DWOperations
 dbo.Verify_dbo_DimApplication (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_DimApplication
  Properties
Property Value
Name Verify_dbo_DimApplication
Schema dbo
Row Count 486246
Data Size 140976 KB
Index Size 536 KB
Create Date 3/9/2017 10:45 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
 
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
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
False
False
False
 
StudentId
varchar(9)
False
False
False
 
In Primary Key
VerifyApplicationSK
int(10, 0)
False
False
False
(1 / 1)
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyApplicationSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimApplication depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimApplication)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimApplication] Script Date: 03/09/2017 17:21:46 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimApplication](
    [VerifyApplicationSK] [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,
    [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_DimApplication] PRIMARY KEY CLUSTERED 
(
    [VerifyApplicationSK] 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 ApplicationTerm ApplicationTermTitle ApplicationType ApplicationTypeCode AwardType AwardTypeCode BachelorApplicant BasisOfAdmission BasisOfAdmissionCode CreditVocationalBachelorApplication EnrollmentStatus EnrollmentStatusCode FirstTermEnrolled FirstTermEnrolledTitle FirstTimeInCollege HomeCampus HomeCampusCode InitialOrReadmitApplication Program ProgramCode RowIsDuplicate RowIsSelected StudentId VerifyApplicationSK
M12138012VC201125601 2010-10-22T00:00:00-04:00 Application 20112 SPRING TERM 2011 Vocational Application VC VOCATIONAL CERTIFICATE VC No HS GRADUATE H Vocational NEW STUDENT N N/A N/A Yes BELLE GLADE CAMPUS 3 Initial CRIMINAL JUSTICE ACADEMY 5601 N Y M12138012 439467
T06967335VR200015600 2015-05-31T00:00:00-04:00 Application 20001 FALL TERM 1999 Vocational Readmit Application VR VOCATIONAL CERTIFICATE VC No HS ABVE 8TH GRADE BUT NOT GRAD V Vocational ENROLLED VOC CREDIT (PSAV) PGM 6 20001 FALL TERM 1999 No LAKE WORTH CAMPUS 1 Readmit BASIC STANDARD POLICE 5600 N Y T06967335 469032
V12875456CC20091A087 2008-04-22T00:00:00-04:00 Application 20091 FALL TERM 2008 College Credit Application CC ASSOCIATE IN APPLIED SCIENCE AAS No COLLEGE TRANSFER T Credit NEW STUDENT N N/A N/A No BOCA RATON CAMPUS 5 Initial BUSINESS ADMIN & MGMT A087 N Y V12875456 273063
G12787974CC201012301 2008-01-04T00:00:00-05:00 Application 20101 FALL TERM 2009 College Credit Application CC ASSOCIATE IN SCIENCE DEGREE AS No COLLEGE TRANSFER T Credit NEW STUDENT N 20102 SPRING TERM 2010 No LAKE WORTH CAMPUS 1 Initial NURSING 2301 N Y G12787974 98019
J13233408CC200933409 2009-05-18T00:00:00-04:00 Application 20093 SUMMER TERM 2009 College Credit Application CC NON-DEGREE SEEKING ND No COLLEGE TRANSFER T Credit NEW STUDENT N 20093 SUMMER TERM 2009 No LAKE WORTH CAMPUS 1 Initial TRANSIENT STUDENT 3409 N Y J13233408 126578
J13688775CC20151T701A 2014-08-05T00:00:00-04:00 Objective 20151 FALL TERM 2014 College Credit Application CC BACHELOR OF APPLIED SCIENCE BAS Yes HS GRADUATE H Bachelor NEW STUDENT N 20151 FALL TERM 2014 Yes BOCA RATON CAMPUS 5 Initial SUPERVISION & MANAGEMENT T701A N Y J13688775 483196
R06239180VC200615262 2005-09-08T00:00:00-04:00 Application 20061 FALL TERM 2005 Vocational Application VC VOCATIONAL CERTIFICATE VC No N/A P Vocational NEW STUDENT N 20061 FALL TERM 2005 No LAKE WORTH CAMPUS 1 Initial PLUMBING APPRENTICE - 5 YEAR 5262 N Y R06239180 446716
H07933575CR200333408 2015-05-31T00:00:00-04:00 Application 20033 SUMMER TERM 2003 College Credit Readmit Application CR NON-DEGREE SEEKING ND No HS GRADUATE H Credit READMITTED STUDENT R 20033 SUMMER TERM 2003 Yes LAKE WORTH CAMPUS 1 Readmit PERSONAL IMPROVEMENT 3408 N Y H07933575 323983
K13886916CR201721000 2016-11-21T00:00:00-05:00 Application 20172 SPRING TERM 2017 College Credit Readmit Application CR ASSOCIATE IN ARTS DEGREE AA No HS GRADUATE H Credit READMITTED STUDENT R N/A N/A Yes BOCA RATON CAMPUS 5 Readmit ASSOCIATE IN ARTS 1000 N Y K13886916 345963
K11759073CC200413800 2003-07-29T00:00:00-04:00 Application 20041 FALL TERM 2003 College Credit Application CC NON-DEGREE SEEKING ND No HS DUAL ENROLLMENT D Credit NEW STUDENT N 20041 FALL TERM 2003 No BOCA RATON CAMPUS 5 Initial HS DUAL ENROLLMENT 3800 N Y K11759073 148545
Powered by BI Documenter