DWStaging
 dbo.WF_BUDGET (Table)
Home  Diagrams  Documents  Images  DWStaging  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:  DWStaging   Tables   dbo.WF_BUDGET
  Properties
Property Value
Name WF_BUDGET
Schema dbo
Row Count 1561488
Data Size 146232 KB
Index Size 23328 KB
Create Date 2/13/2013 11:34 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ISN_WF_BUDGET
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
WF_AID_YEAR
varchar(4)
True
False
False
 
WF_BU_M1_BUDGET
decimal(5, 0)
True
False
False
 
WF_BU_M1_C1
decimal(5, 0)
True
False
False
 
WF_BU_M1_C2
decimal(5, 0)
True
False
False
 
WF_BU_M1_C3
decimal(5, 0)
True
False
False
 
WF_BU_M1_C4
decimal(5, 0)
True
False
False
 
WF_BU_M1_C5
decimal(5, 0)
True
False
False
 
WF_BU_M1_C6
decimal(5, 0)
True
False
False
 
WF_BU_M1_C7
decimal(5, 0)
True
False
False
 
WF_BU_M1_C8
decimal(5, 0)
True
False
False
 
WF_BU_M2_BUDGET
decimal(5, 0)
True
False
False
 
WF_BU_M2_C1
decimal(5, 0)
True
False
False
 
WF_BU_M2_C2
decimal(5, 0)
True
False
False
 
WF_BU_M2_C3
decimal(5, 0)
True
False
False
 
WF_BU_M2_C4
decimal(5, 0)
True
False
False
 
WF_BU_M2_C5
decimal(5, 0)
True
False
False
 
WF_BU_M2_C6
decimal(5, 0)
True
False
False
 
WF_BU_M2_C7
decimal(5, 0)
True
False
False
 
WF_BU_M2_C8
decimal(5, 0)
True
False
False
 
WF_BU_M3_BUDGET
decimal(5, 0)
True
False
False
 
WF_BU_M3_C1
decimal(5, 0)
True
False
False
 
WF_BU_M3_C2
decimal(5, 0)
True
False
False
 
WF_BU_M3_C3
decimal(5, 0)
True
False
False
 
WF_BU_M3_C4
decimal(5, 0)
True
False
False
 
WF_BU_M3_C5
decimal(5, 0)
True
False
False
 
WF_BU_M3_C6
decimal(5, 0)
True
False
False
 
WF_BU_M3_C7
decimal(5, 0)
True
False
False
 
WF_BU_M3_C8
decimal(5, 0)
True
False
False
 
WF_BU_S_CLS
varchar(3)
True
False
False
 
WF_BU_S_COL
varchar(3)
True
False
False
 
WF_BU_S_DEG
varchar(3)
True
False
False
 
WF_BU_S_ENR
decimal(7, 2)
True
False
False
 
WF_BU_S_IOS
varchar(1)
True
False
False
 
WF_BU_S_MAJ
varchar(3)
True
False
False
 
WF_BU_S_SS1
varchar(5)
True
False
False
 
WF_BU_S_SS2
varchar(5)
True
False
False
 
WF_BU_S_SS3
varchar(5)
True
False
False
 
WF_BU_S_TIM
varchar(1)
True
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WW_CDATE
date(10, 0)
True
False
False
 
WW_HOLD
int(10, 0)
True
False
False
 
WW_MDATE
date(10, 0)
True
False
False
 
WW_REGISTRATION_TERM
varchar(1)
True
False
False
 
WW_STUDENT_ID
char(18)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_WF_BUDGET
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_BUDGET depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_BUDGET)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_BUDGET] Script Date: 03/09/2017 16:46:40 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_BUDGET](
    [ISN_WF_BUDGET] [int] NOT NULL,
    [WW_STUDENT_ID] [char](18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_REGISTRATION_TERM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_BU_M1_BUDGET] [decimal](5, 0) NULL,
    [WF_BU_M1_C1] [decimal](5, 0) NULL,
    [WF_BU_M1_C2] [decimal](5, 0) NULL,
    [WF_BU_M1_C3] [decimal](5, 0) NULL,
    [WF_BU_M1_C4] [decimal](5, 0) NULL,
    [WF_BU_M1_C5] [decimal](5, 0) NULL,
    [WF_BU_M1_C6] [decimal](5, 0) NULL,
    [WF_BU_M1_C7] [decimal](5, 0) NULL,
    [WF_BU_M1_C8] [decimal](5, 0) NULL,
    [WF_BU_M2_BUDGET] [decimal](5, 0) NULL,
    [WF_BU_M2_C1] [decimal](5, 0) NULL,
    [WF_BU_M2_C2] [decimal](5, 0) NULL,
    [WF_BU_M2_C3] [decimal](5, 0) NULL,
    [WF_BU_M2_C4] [decimal](5, 0) NULL,
    [WF_BU_M2_C5] [decimal](5, 0) NULL,
    [WF_BU_M2_C6] [decimal](5, 0) NULL,
    [WF_BU_M2_C7] [decimal](5, 0) NULL,
    [WF_BU_M2_C8] [decimal](5, 0) NULL,
    [WF_BU_M3_BUDGET] [decimal](5, 0) NULL,
    [WF_BU_M3_C1] [decimal](5, 0) NULL,
    [WF_BU_M3_C2] [decimal](5, 0) NULL,
    [WF_BU_M3_C3] [decimal](5, 0) NULL,
    [WF_BU_M3_C4] [decimal](5, 0) NULL,
    [WF_BU_M3_C5] [decimal](5, 0) NULL,
    [WF_BU_M3_C6] [decimal](5, 0) NULL,
    [WF_BU_M3_C7] [decimal](5, 0) NULL,
    [WF_BU_M3_C8] [decimal](5, 0) NULL,
    [WF_BU_S_COL] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_BU_S_MAJ] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_BU_S_DEG] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_BU_S_CLS] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_BU_S_TIM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_BU_S_ENR] [decimal](7, 2) NULL,
    [WF_BU_S_IOS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_BU_S_SS1] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_BU_S_SS2] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_BU_S_SS3] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_BUDGET RowUpdatedOn WF_AID_YEAR WF_BU_M1_C1 WF_BU_M1_C2 WF_BU_M1_C3 WF_BU_M1_C4 WF_BU_M1_C5 WF_BU_M2_C1 WF_BU_M2_C2 WF_BU_M2_C3 WF_BU_M2_C4 WF_BU_M2_C5 WF_BU_S_CLS WF_BU_S_COL WF_BU_S_DEG WF_BU_S_ENR WF_BU_S_IOS WF_BU_S_MAJ WF_BU_S_SS1 WF_BU_S_SS2 WF_BU_S_SS3 WF_BU_S_TIM WF_FAO WW_CDATE WW_HOLD WW_MDATE WW_REGISTRATION_TERM WW_STUDENT_ID
58721 2017-02-06T09:56:12.714-05:00 2001 PB 2000-08-23T00:00:00-04:00 559053 2001-08-09T00:00:00-04:00 M 57570631013309949C
1184483 2017-02-06T09:58:48.918-05:00 2014 5370 4275 450 1800 750 FR 1 AS O 435 N PB 2014-01-22T00:00:00-05:00 201446 2014-08-01T00:00:00-04:00 S 57570635575114492C
129630 2017-02-06T09:56:22.464-05:00 2003 765 2272 200 464 300 765 2272 200 464 300 PB 2002-06-03T00:00:00-04:00 432251 2003-08-25T00:00:00-04:00 F 57570631775474968C
26432 2017-02-06T09:56:08.081-05:00 2000 683 2600 400 464 300 342 464 150 PB 1999-12-14T00:00:00-05:00 1149375 2000-06-30T00:00:00-04:00 F 57570631122983109C
1488062 2017-02-06T09:59:32.115-05:00 2017 PB 2016-05-18T00:00:00-04:00 732167 2016-12-10T00:00:00-05:00 M 57570636307156602C
1013244 2017-02-06T09:58:24.301-05:00 2013 1474 3150 450 1800 750 786 3150 450 900 375 PB 2012-05-15T00:00:00-04:00 2243330 2013-08-01T00:00:00-04:00 F 57570633828415132C
1357609 2017-02-06T09:59:13.566-05:00 2015 1474 4275 450 1800 750 PB 2015-05-07T00:00:00-04:00 1057426 F 57570635972779591C
212142 2017-02-06T09:56:34.18-05:00 2004 925 2775 375 576 500 705 2775 375 576 500 FR 1 AAS 10.00 I 309 T PB 2003-07-23T00:00:00-04:00 352181 2004-08-09T00:00:00-04:00 F 57570631855844414C
1400875 2017-02-06T09:59:19.806-05:00 2016 1474 4275 585 1800 750 1474 4275 585 1800 750 PB 2015-07-23T00:00:00-04:00 1753063 2015-07-28T00:00:00-04:00 F 57570634303525774C
1207596 2017-02-06T09:58:52.022-05:00 2015 1474 3150 450 1800 750 FR 5 I N PB 2015-04-06T00:00:00-04:00 244499 2015-08-08T00:00:00-04:00 S 57570635954436628C
Powered by BI Documenter