DWStaging
 dbo.WF_FUND_PACKAGE (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_FUND_PACKAGE
  Properties
Property Value
Name WF_FUND_PACKAGE
Schema dbo
Row Count 943
Data Size 56 KB
Index Size 40 KB
Create Date 3/4/2015 10:09 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ISN_WF_FUND_PACKAGE
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WF_FP_AW_ACTION
varchar(2)
True
False
False
 
WF_FP_DOC_EXCLUDE
varchar(1)
True
False
False
 
WF_FP_DOC_STAT_1
varchar(1)
True
False
False
 
WF_FP_DOC_STAT_2
varchar(1)
True
False
False
 
WF_FP_DOC_STAT_3
varchar(1)
True
False
False
 
WF_FP_DOC_STAT_4
varchar(1)
True
False
False
 
WF_FP_DOC_STAT_5
varchar(1)
True
False
False
 
WF_FP_DOCUMENT
varchar(6)
True
False
False
 
WF_FP_EFC_CHECK
varchar(1)
True
False
False
 
WF_FP_FUND_CATEGORY
varchar(9)
True
False
False
 
WF_FP_MAX_EFC
int(10, 0)
True
False
False
 
WF_FP_MIN_EFC
int(10, 0)
True
False
False
 
WF_FP_PACKAGE_FUND
varchar(1)
True
False
False
 
WF_FP_PELL_ELIGIBLE
varchar(1)
True
False
False
 
WF_FP_PELL_LEU_TIM
varchar(1)
True
False
False
 
WF_FP_PELL_MAX_LEU
int(10, 0)
True
False
False
 
WF_FP_PELL_MIN_LEU
int(10, 0)
True
False
False
 
WF_FP_PRIORITY
int(10, 0)
True
False
False
 
WF_FP_RECVD_DATE
date(10, 0)
True
False
False
 
WF_FUND_ID
varchar(9)
True
False
False
 
WW_CDATE
date(10, 0)
True
False
False
 
WW_FISCAL_YEAR
varchar(4)
True
False
False
 
WW_HOLD
int(10, 0)
True
False
False
 
WW_MDATE
date(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_WF_FUND_PACKAGE
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_FUND_PACKAGE depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_FUND_PACKAGE)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_FUND_PACKAGE] Script Date: 03/09/2017 16:46:48 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_FUND_PACKAGE](
    [ISN_WF_FUND_PACKAGE] [int] NOT NULL,
    [WF_FUND_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_FP_PACKAGE_FUND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_FUND_CATEGORY] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_AW_ACTION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_PELL_ELIGIBLE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_EFC_CHECK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_MIN_EFC] [int] NULL,
    [WF_FP_MAX_EFC] [int] NULL,
    [WF_FP_DOCUMENT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_DOC_STAT_1] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_DOC_STAT_2] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_DOC_STAT_3] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_DOC_STAT_4] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_DOC_STAT_5] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_DOC_EXCLUDE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_PRIORITY] [int] NULL,
    [WF_FP_PELL_MIN_LEU] [int] NULL,
    [WF_FP_PELL_MAX_LEU] [int] NULL,
    [WF_FP_PELL_LEU_TIM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FP_RECVD_DATE] [date] NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_FUND_PACKAGE RowUpdatedOn WF_FAO WF_FP_AW_ACTION WF_FP_DOC_EXCLUDE WF_FP_DOC_STAT_1 WF_FP_DOC_STAT_2 WF_FP_DOC_STAT_3 WF_FP_DOC_STAT_4 WF_FP_DOC_STAT_5 WF_FP_DOCUMENT WF_FP_EFC_CHECK WF_FP_FUND_CATEGORY WF_FP_PACKAGE_FUND WF_FP_PELL_ELIGIBLE WF_FP_PELL_LEU_TIM WF_FUND_ID WW_CDATE WW_FISCAL_YEAR WW_HOLD WW_MDATE
783 2017-02-06T11:31:49.323-05:00 PB 504443525 2017-01-30T00:00:00-05:00 2018 1601081
831 2017-02-06T11:31:49.339-05:00 PB 5044494E4 2017-01-30T00:00:00-05:00 2018 1601088
482 2017-02-06T11:31:49.308-05:00 PB 504441434 2016-04-05T00:00:00-04:00 2017 1422352
700 2017-02-06T11:31:49.323-05:00 PB 464447484 2017-01-30T00:00:00-05:00 2018 1601060
406 2017-02-06T11:31:49.292-05:00 PB 5044554E5 2015-08-26T00:00:00-04:00 2016 1105017
416 2017-02-06T11:31:49.292-05:00 PB 504443415 2015-10-02T00:00:00-04:00 2016 1442069
222 2017-02-06T11:31:49.292-05:00 PB 464444524 2015-05-11T00:00:00-04:00 2016 1326456
934 2017-02-06T11:31:49.339-05:00 PB 504457485 2017-01-30T00:00:00-05:00 2018 1601102 2013-08-05T00:00:00-04:00
792 2017-02-06T11:31:49.339-05:00 PB 504444524 2017-01-30T00:00:00-05:00 2018 1601082 2016-08-09T00:00:00-04:00
98 2017-02-06T11:31:49.292-05:00 PB 504443415 2014-06-10T00:00:00-04:00 2015 1156301 2013-07-23T00:00:00-04:00
Powered by BI Documenter