DWStaging
 dbo.WF_LOANDSB (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_LOANDSB
  Properties
Property Value
Name WF_LOANDSB
Schema dbo
Row Count 138067
Data Size 14048 KB
Index Size 2496 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_LOANDSB
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
WF_AID_YEAR
varchar(4)
True
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WF_LD_ACC1
decimal(7, 2)
True
False
False
 
WF_LD_ACC2
decimal(7, 2)
True
False
False
 
WF_LD_ACC3
decimal(7, 2)
True
False
False
 
WF_LD_ACK
varchar(1)
True
False
False
 
WF_LD_ACK_DATE
date(10, 0)
True
False
False
 
WF_LD_ACT
varchar(1)
True
False
False
 
WF_LD_ACT_DATE
date(10, 0)
True
False
False
 
WF_LD_ACT_RSN
varchar(2)
True
False
False
 
WF_LD_AMT1
decimal(7, 2)
True
False
False
 
WF_LD_AMT2
decimal(7, 2)
True
False
False
 
WF_LD_AMT3
decimal(7, 2)
True
False
False
 
WF_LD_CHECK
varchar(15)
True
False
False
 
WF_LD_DATE
date(10, 0)
True
False
False
 
WF_LD_DIST
varchar(1)
True
False
False
 
WF_LD_DP
varchar(1)
True
False
False
 
WF_LD_DSB1
decimal(7, 2)
True
False
False
 
WF_LD_DSB2
decimal(7, 2)
True
False
False
 
WF_LD_DSB3
decimal(7, 2)
True
False
False
 
WF_LD_ENR
varchar(1)
True
False
False
 
WF_LD_FEE1
decimal(7, 2)
True
False
False
 
WF_LD_FEE2
decimal(7, 2)
True
False
False
 
WF_LD_FEE3
decimal(7, 2)
True
False
False
 
WF_LD_NET1
decimal(7, 2)
True
False
False
 
WF_LD_NET2
decimal(7, 2)
True
False
False
 
WF_LD_NET3
decimal(7, 2)
True
False
False
 
WF_LD_REB1
decimal(7, 2)
True
False
False
 
WF_LD_REB2
decimal(7, 2)
True
False
False
 
WF_LD_REB3
decimal(7, 2)
True
False
False
 
WF_LD_SEQ
int(10, 0)
True
False
False
 
WF_LD_SNT_BATCH
varchar(3)
True
False
False
 
WF_LD_SNT_DATE
date(10, 0)
True
False
False
 
WF_LD_SNT1
decimal(7, 2)
True
False
False
 
WF_LD_SNT2
decimal(7, 2)
True
False
False
 
WF_LD_SNT3
decimal(7, 2)
True
False
False
 
WF_LOAN_ID
int(10, 0)
True
False
False
 
WF_LOANDSB_ID
int(10, 0)
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_STUDENT_ID
char(18)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_WF_LOANDSB
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_LOANDSB depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_LOANDSB)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_LOANDSB] Script Date: 03/09/2017 16:46:56 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_LOANDSB](
    [ISN_WF_LOANDSB] [int] NOT NULL,
    [WW_STUDENT_ID] [char](18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_LOAN_ID] [int] NULL,
    [WF_LOANDSB_ID] [int] 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_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_LD_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_LD_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_LD_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_LD_ACT_DATE] [date] NULL,
    [WF_LD_AMT1] [decimal](7, 2) NULL,
    [WF_LD_FEE1] [decimal](7, 2) NULL,
    [WF_LD_REB1] [decimal](7, 2) NULL,
    [WF_LD_NET1] [decimal](7, 2) NULL,
    [WF_LD_SNT1] [decimal](7, 2) NULL,
    [WF_LD_ACC1] [decimal](7, 2) NULL,
    [WF_LD_DSB1] [decimal](7, 2) NULL,
    [WF_LD_AMT2] [decimal](7, 2) NULL,
    [WF_LD_FEE2] [decimal](7, 2) NULL,
    [WF_LD_REB2] [decimal](7, 2) NULL,
    [WF_LD_NET2] [decimal](7, 2) NULL,
    [WF_LD_SNT2] [decimal](7, 2) NULL,
    [WF_LD_ACC2] [decimal](7, 2) NULL,
    [WF_LD_DSB2] [decimal](7, 2) NULL,
    [WF_LD_AMT3] [decimal](7, 2) NULL,
    [WF_LD_FEE3] [decimal](7, 2) NULL,
    [WF_LD_REB3] [decimal](7, 2) NULL,
    [WF_LD_NET3] [decimal](7, 2) NULL,
    [WF_LD_SNT3] [decimal](7, 2) NULL,
    [WF_LD_ACC3] [decimal](7, 2) NULL,
    [WF_LD_DSB3] [decimal](7, 2) NULL,
    [WF_LD_DATE] [date] NULL,
    [WF_LD_DIST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_LD_CHECK] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_LD_SEQ] [int] NULL,
    [WF_LD_SNT_BATCH] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_LD_SNT_DATE] [date] NULL,
    [WF_LD_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_LD_ACK_DATE] [date] NULL,
    [WF_LD_ENR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_LOANDSB RowUpdatedOn WF_AID_YEAR WF_FAO WF_LD_ACC2 WF_LD_ACC1 WF_LD_ACK WF_LD_ACK_DATE WF_LD_ACT WF_LD_ACT_RSN WF_LD_AMT2 WF_LD_AMT1 WF_LD_CHECK WF_LD_DATE WF_LD_DIST WF_LD_DP WF_LD_DSB1 WF_LD_ENR WF_LD_FEE2 WF_LD_NET2 WF_LD_REB2 WF_LD_FEE1 WF_LD_NET1 WF_LD_REB1 WF_LD_SEQ WF_LD_SNT_BATCH WF_LD_SNT1 WF_LD_SNT_DATE WF_LOAN_ID WF_LOANDSB_ID WW_CDATE WW_HOLD WW_MDATE WW_STUDENT_ID
126109 2017-02-06T10:48:51.516-05:00 2016 PB S 2015-10-02T00:00:00-04:00 2016-02-10T00:00:00-05:00 X 1 ANT 2015-10-02T00:00:00-04:00 1 2 2015-09-21T00:00:00-04:00 1456333 2015-10-02T00:00:00-04:00 57570635810986215C
62320 2017-02-06T10:48:43.466-05:00 2011 PB 2250.00 A 2011-02-08T00:00:00-05:00 2250.00 2011-02-08T00:00:00-05:00 2 22.00 2239.00 11.00 1 REL 2011-02-08T00:00:00-05:00 1 2 2011-01-25T00:00:00-05:00 951296 2011-02-09T00:00:00-05:00 57570633543877321C
135506 2017-02-06T10:48:52.764-05:00 2017 PB 1750.00 S 2016-10-17T00:00:00-04:00 1750.00 2017-01-25T00:00:00-05:00 2 18.00 1732.00 1 ANT 2016-10-17T00:00:00-04:00 1 2 2016-10-14T00:00:00-04:00 1602267 2016-10-17T00:00:00-04:00 57570633946509704C
87908 2017-02-06T10:48:46.571-05:00 2013 PB 783.00 A 2013-04-03T00:00:00-04:00 783.00 2013-01-23T00:00:00-05:00 2 7.00 776.00 2 REL 2013-04-03T00:00:00-04:00 4 1 2013-01-03T00:00:00-05:00 838332 2013-04-04T00:00:00-04:00 57570633350406821C
127395 2017-02-06T10:48:51.656-05:00 2016 PB S 2015-12-22T00:00:00-05:00 2015-12-18T00:00:00-05:00 X 1 ANT 2015-12-22T00:00:00-05:00 2 2 2015-11-04T00:00:00-05:00 1653274 2015-12-22T00:00:00-05:00 57570634940183998C
69857 2017-02-06T10:48:44.356-05:00 2011 PB 687.00 A 2011-06-27T00:00:00-04:00 687.00 2011-06-27T00:00:00-04:00 F 6.00 684.00 3.00 1 REL 2011-06-27T00:00:00-04:00 2 2 2011-05-04T00:00:00-04:00 1100175 2011-06-28T00:00:00-04:00 57570634093604477C
122509 2017-02-06T10:48:51.11-05:00 2016 PB 1125.00 A 2015-09-24T00:00:00-04:00 1125.00 2015-09-23T00:00:00-04:00 1 F 12.00 1113.00 1 REL 2015-09-24T00:00:00-04:00 3 1 2015-07-23T00:00:00-04:00 1943163 2015-09-24T00:00:00-04:00 57570635472327329C
109009 2017-02-06T10:48:49.441-05:00 2014 PB S 2014-05-08T00:00:00-04:00 2014-06-03T00:00:00-04:00 X 1 ANT 2014-05-08T00:00:00-04:00 4 1 2014-04-30T00:00:00-04:00 839433 2014-05-09T00:00:00-04:00 57570635325581141C
58541 2017-02-06T10:48:42.936-05:00 2010 PB 1750.00 2010-03-17T00:00:00-04:00 E 2 1741.25 8.75 1741.25 1750.00 1 2 2010-02-11T00:00:00-05:00 1142440 2010-03-17T00:00:00-04:00 57570634297301710C
117184 2017-02-06T10:48:50.502-05:00 2015 PB R 2015-04-10T00:00:00-04:00 2015-03-11T00:00:00-04:00 X 2015-04-10T00:00:00-04:00 1 2 2015-01-05T00:00:00-05:00 949412 2015-05-12T00:00:00-04:00 57570634484752484C
Powered by BI Documenter