|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | FactApplicationStatus_Staging |
| Schema | dbo |
| Row Count | 530985 |
| Data Size | 64400 KB |
| Index Size | 16 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 |
datetime(23, 3) |
False |
False |
False |
|||
|
|
ApplicationSource |
varchar(10) |
False |
False |
False |
|||
|
|
ApplicationTerm |
varchar(6) |
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 |
|||
|
|
RowIsDuplicate |
char(1) |
False |
False |
False |
|||
|
|
RowIsSelected |
char(1) |
False |
False |
False |
|||
|
|
StudentId |
varchar(9) |
False |
False |
False |
|||
|
|
StudentObjectiveAK |
varchar(23) |
False |
False |
False |
|||
|
|
VerifyApplicationSK |
int(10, 0) |
False |
False |
False |
(1 / 1) |
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.FactApplicationStatus_Staging depends on)
| Name | Type |
StoredProcedure |
Child Dependencies (objects that depend on dbo.FactApplicationStatus_Staging)
| Name | Type |
STOREDPROCEDURE |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[FactApplicationStatus_Staging] Script Date: 03/09/2017 17:21:32 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FactApplicationStatus_Staging]( [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, [ApplicationSource] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [StudentObjectiveAK] [varchar](23) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ApplicationDate] [datetime] 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, [RowIsDuplicate] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [RowIsSelected] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY] |
Sample Data
| ApplicationAK | ApplicationDate | ApplicationSource | ApplicationTerm | EnrolledAfterApplicationTerm | EnrolledInApplicationTerm | NeedAdvising | NeedEducationalPlan | NeedOrientation | NeedTesting | NeedTranscripts | NoAdmissionBarriers | NotEnrolled | OtherRegistrationHold | ResidencyHold | RowIsDuplicate | RowIsSelected | StudentId | StudentObjectiveAK | VerifyApplicationSK |
| M12928297CC200911000 | 2008-06-03T00:00:00-04:00 | 10FTICDR | 20091 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | N | Y | M12928297 | M12928297100020091001 | 196404 |
| S11324803CR201222358 | 2015-05-31T00:00:00-04:00 | 50READMT | 20122 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | N | Y | S11324803 | S11324803235820122001 | 401977 |
| C13898648CR201723409 | 2016-12-16T00:00:00-05:00 | 50READMT | 20172 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | Y | N | C13898648 | C13898648340920172001 | 322696 |
| A15252141CC201632301 | 2016-02-28T00:00:00-05:00 | 10FTICDR | 20163 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | Y | Y | A15252141 | A15252141230120163001 | 512306 |
| S14665145CC201512151 | 2014-02-13T00:00:00-05:00 | 40TRNSFR | 20151 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | N | Y | S14665145 | S14665145215120151002 | 265350 |
| B13649892CR201233409 | 2015-05-31T00:00:00-04:00 | 50READMT | 20123 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | N | Y | B13649892 | B13649892340920123001 | 313470 |
| S11471984CC200233409 | 2002-04-05T00:00:00-05:00 | 40TRNSFR | 20023 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | N | Y | S11471984 | S11471984340920023001 | 251804 |
| D13781448CC201131000 | 2011-02-23T00:00:00-05:00 | 40TRNSFR | 20113 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | N | Y | D13781448 | D13781448100020113001 | 76141 |
| M15084767CC201611000 | 2015-06-14T00:00:00-04:00 | 10FTICDR | 20161 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | N | Y | M15084767 | M15084767100020161001 | 208886 |
| J12416640CC20071A087 | 2006-08-15T00:00:00-04:00 | 40TRNSFR | 20071 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | N | Y | J12416640 | J12416640A08720071001 | 127349 |
| Powered by BI Documenter |
