|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | FactEnrollmentActivity_Staging |
| Schema | dbo |
| Row Count | 9827106 |
| Data Size | 476496 KB |
| Index Size | 32 KB |
| Create Date | 5/29/2013 12:13 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ActivityDate |
datetime(23, 3) |
False |
False |
False |
|||
|
|
AddAction |
int(10, 0) |
False |
False |
False |
|||
|
|
DropAction |
int(10, 0) |
False |
False |
False |
|||
|
|
EFF_TRM |
varchar(6) |
False |
False |
False |
|||
|
|
REF_NUM |
int(10, 0) |
False |
False |
False |
|||
|
|
STDNT_ID |
varchar(9) |
False |
False |
False |
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.FactEnrollmentActivity_Staging depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.FactEnrollmentActivity_Staging)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[FactEnrollmentActivity_Staging] Script Date: 03/09/2017 17:21:32 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FactEnrollmentActivity_Staging]( [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [REF_NUM] [int] NOT NULL, [ActivityDate] [datetime] NOT NULL, [DropAction] [int] NOT NULL, [AddAction] [int] NOT NULL ) ON [PRIMARY] |
Sample Data
| ActivityDate | AddAction | DropAction | EFF_TRM | REF_NUM | STDNT_ID |
| 2005-12-13T00:00:00-05:00 | 0 | 1 | 20062 | 79201 | R12078077 |
| 2013-07-23T00:00:00-04:00 | 1 | 0 | 20141 | 174608 | D13431770 |
| 2010-05-03T00:00:00-04:00 | 1 | 0 | 20103 | 145987 | K11872850 |
| 2006-11-10T00:00:00-05:00 | 0 | 1 | 20072 | 90654 | K12256368 |
| 2014-08-07T00:00:00-04:00 | 1 | 0 | 20151 | 189522 | J14390371 |
| 2000-07-31T00:00:00-04:00 | 1 | 0 | 20011 | 20723 | J11114543 |
| 2007-08-23T00:00:00-04:00 | 0 | 1 | 20081 | 98326 | K12376646 |
| 2007-08-09T00:00:00-04:00 | 1 | 0 | 20081 | 100411 | A12657680 |
| 2009-11-05T00:00:00-05:00 | 0 | 1 | 20102 | 130894 | E12333753 |
| 2001-08-07T00:00:00-04:00 | 1 | 0 | 20021 | 29999 | D08125171 |
| Powered by BI Documenter |
