DWStaging
 dbo.WF_TRANSCRIPT (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_TRANSCRIPT
  Properties
Property Value
Name WF_TRANSCRIPT
Schema dbo
Row Count 193478
Data Size 25248 KB
Index Size 3304 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_TRANSCRIPT
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
WF_AID_PROGRAM
varchar(5)
True
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WF_TR_D01_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D01_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D01_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D01_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D01_SOURCE
varchar(1)
True
False
False
 
WF_TR_D02_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D02_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D02_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D02_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D02_SOURCE
varchar(1)
True
False
False
 
WF_TR_D03_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D03_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D03_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D03_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D03_SOURCE
varchar(1)
True
False
False
 
WF_TR_D04_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D04_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D04_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D04_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D04_SOURCE
varchar(1)
True
False
False
 
WF_TR_D05_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D05_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D05_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D05_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D05_SOURCE
varchar(1)
True
False
False
 
WF_TR_D06_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D06_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D06_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D06_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D06_SOURCE
varchar(1)
True
False
False
 
WF_TR_D07_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D07_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D07_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D07_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D07_SOURCE
varchar(1)
True
False
False
 
WF_TR_D08_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D08_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D08_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D08_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D08_SOURCE
varchar(1)
True
False
False
 
WF_TR_D09_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D09_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D09_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D09_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D09_SOURCE
varchar(1)
True
False
False
 
WF_TR_D10_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D10_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D10_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D10_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D10_SOURCE
varchar(1)
True
False
False
 
WF_TR_D11_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D11_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D11_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D11_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D11_SOURCE
varchar(1)
True
False
False
 
WF_TR_D12_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D12_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D12_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D12_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D12_SOURCE
varchar(1)
True
False
False
 
WF_TR_D13_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D13_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D13_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D13_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D13_SOURCE
varchar(1)
True
False
False
 
WF_TR_D14_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D14_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D14_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D14_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D14_SOURCE
varchar(1)
True
False
False
 
WF_TR_D15_AID_YEAR
varchar(4)
True
False
False
 
WF_TR_D15_PAID
decimal(7, 2)
True
False
False
 
WF_TR_D15_PEND
decimal(7, 2)
True
False
False
 
WF_TR_D15_SCHOOL_ID
varchar(9)
True
False
False
 
WF_TR_D15_SOURCE
varchar(1)
True
False
False
 
WF_TR_P_DEFLT
varchar(1)
True
False
False
 
WF_TR_P_PAID
decimal(9, 2)
True
False
False
 
WF_TR_P_PEND
decimal(9, 2)
True
False
False
 
WF_TR_P_REPAY
varchar(1)
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_TRANSCRIPT
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_TRANSCRIPT depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_TRANSCRIPT)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_TRANSCRIPT] Script Date: 03/09/2017 16:47:03 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_TRANSCRIPT](
    [ISN_WF_TRANSCRIPT] [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_PROGRAM] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_TR_P_DEFLT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_P_REPAY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_P_PAID] [decimal](9, 2) NULL,
    [WF_TR_P_PEND] [decimal](9, 2) NULL,
    [WF_TR_D01_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D01_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D01_PAID] [decimal](7, 2) NULL,
    [WF_TR_D01_PEND] [decimal](7, 2) NULL,
    [WF_TR_D01_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D02_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D02_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D02_PAID] [decimal](7, 2) NULL,
    [WF_TR_D02_PEND] [decimal](7, 2) NULL,
    [WF_TR_D02_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D03_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D03_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D03_PAID] [decimal](7, 2) NULL,
    [WF_TR_D03_PEND] [decimal](7, 2) NULL,
    [WF_TR_D03_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D04_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D04_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D04_PAID] [decimal](7, 2) NULL,
    [WF_TR_D04_PEND] [decimal](7, 2) NULL,
    [WF_TR_D04_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D05_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D05_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D05_PAID] [decimal](7, 2) NULL,
    [WF_TR_D05_PEND] [decimal](7, 2) NULL,
    [WF_TR_D05_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D06_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D06_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D06_PAID] [decimal](7, 2) NULL,
    [WF_TR_D06_PEND] [decimal](7, 2) NULL,
    [WF_TR_D06_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D07_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D07_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D07_PAID] [decimal](7, 2) NULL,
    [WF_TR_D07_PEND] [decimal](7, 2) NULL,
    [WF_TR_D07_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D08_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D08_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D08_PAID] [decimal](7, 2) NULL,
    [WF_TR_D08_PEND] [decimal](7, 2) NULL,
    [WF_TR_D08_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D09_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D09_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D09_PAID] [decimal](7, 2) NULL,
    [WF_TR_D09_PEND] [decimal](7, 2) NULL,
    [WF_TR_D09_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D10_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D10_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D10_PAID] [decimal](7, 2) NULL,
    [WF_TR_D10_PEND] [decimal](7, 2) NULL,
    [WF_TR_D10_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D11_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D11_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D11_PAID] [decimal](7, 2) NULL,
    [WF_TR_D11_PEND] [decimal](7, 2) NULL,
    [WF_TR_D11_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D12_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D12_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D12_PAID] [decimal](7, 2) NULL,
    [WF_TR_D12_PEND] [decimal](7, 2) NULL,
    [WF_TR_D12_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D13_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D13_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D13_PAID] [decimal](7, 2) NULL,
    [WF_TR_D13_PEND] [decimal](7, 2) NULL,
    [WF_TR_D13_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D14_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D14_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D14_PAID] [decimal](7, 2) NULL,
    [WF_TR_D14_PEND] [decimal](7, 2) NULL,
    [WF_TR_D14_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D15_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D15_SCHOOL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TR_D15_PAID] [decimal](7, 2) NULL,
    [WF_TR_D15_PEND] [decimal](7, 2) NULL,
    [WF_TR_D15_SOURCE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_TRANSCRIPT RowUpdatedOn WF_AID_PROGRAM WF_FAO WF_TR_D01_AID_YEAR WF_TR_D01_PEND WF_TR_D01_PAID WF_TR_D01_SCHOOL_ID WF_TR_D01_SOURCE WF_TR_D02_AID_YEAR WF_TR_D02_PAID WF_TR_D02_SCHOOL_ID WF_TR_D02_SOURCE WF_TR_D03_AID_YEAR WF_TR_D03_PAID WF_TR_D03_SCHOOL_ID WF_TR_D03_SOURCE WF_TR_D04_AID_YEAR WF_TR_D04_SCHOOL_ID WF_TR_D04_SOURCE WF_TR_D05_AID_YEAR WF_TR_D05_SCHOOL_ID WF_TR_D05_SOURCE WF_TR_D06_AID_YEAR WF_TR_D06_SCHOOL_ID WF_TR_D06_SOURCE WF_TR_D07_AID_YEAR WF_TR_D07_SCHOOL_ID WF_TR_D07_SOURCE WF_TR_D08_AID_YEAR WF_TR_D08_SCHOOL_ID WF_TR_D08_SOURCE WF_TR_D09_AID_YEAR WF_TR_D09_SCHOOL_ID WF_TR_D09_SOURCE WF_TR_D10_AID_YEAR WF_TR_D10_SCHOOL_ID WF_TR_D10_SOURCE WF_TR_D11_AID_YEAR WF_TR_D11_SCHOOL_ID WF_TR_D11_SOURCE WF_TR_D12_AID_YEAR WF_TR_D12_SCHOOL_ID WF_TR_D12_SOURCE WF_TR_D13_AID_YEAR WF_TR_D13_SCHOOL_ID WF_TR_D13_SOURCE WF_TR_D14_AID_YEAR WF_TR_D14_SCHOOL_ID WF_TR_D14_SOURCE WF_TR_D15_AID_YEAR WF_TR_D15_SCHOOL_ID WF_TR_D15_SOURCE WF_TR_P_DEFLT WF_TR_P_PEND WF_TR_P_PAID WF_TR_P_REPAY WW_CDATE WW_HOLD WW_MDATE WW_STUDENT_ID
76544 2017-02-06T10:47:04.858-05:00 DLSUB PB 2011 3375.00 001895 N N 3375.00 N 2011-02-01T00:00:00-05:00 1107243 2011-06-27T00:00:00-04:00 57570634382073306C
132978 2017-02-06T10:47:16.309-05:00 DLSUB PB 2012 001512 A 2013 4500.00 038323 N N 4500.00 N 2011-07-27T00:00:00-04:00 2133114 2016-11-09T00:00:00-05:00 57570634135066098C
186159 2017-02-06T10:47:26.589-05:00 PELL PB 2017 2907.00 001512 A 2907.00 2016-09-01T00:00:00-04:00 2146351 2016-11-09T00:00:00-05:00 57570636397634353C
60024 2017-02-06T10:47:01.395-05:00 STAFU PB 2009 3500.00 001512 A 3500.00 2008-08-14T00:00:00-04:00 2126235 2016-11-09T00:00:00-05:00 57570633826471273C
145979 2017-02-06T10:47:18.789-05:00 DLUNS PB 2013 1200.00 001512 A 2014 3900.00 001512 A 5100.00 2012-11-08T00:00:00-05:00 2139235 2016-11-09T00:00:00-05:00 57570635133622680C
39052 2017-02-06T10:46:56.918-05:00 PELL PB 2005 4050.00 001512 A 2006 4050.00 001512 A 8100.00 2005-01-04T00:00:00-05:00 2121180 2016-11-09T00:00:00-05:00 57570632606506656C
171237 2017-02-06T10:47:23.734-05:00 DLUNS PB 2015 5500.00 006750 N N 5500.00 N 2015-03-05T00:00:00-05:00 1523589 2015-06-15T00:00:00-04:00 57570635694646484C
135725 2017-02-06T10:47:16.823-05:00 DLSUB PB 2013 1750.00 020988 N 2014 1750.00 041485 N N 3500.00 N 2012-11-05T00:00:00-05:00 940568 2014-06-30T00:00:00-04:00 57570635109646256C
89390 2017-02-06T10:47:07.276-05:00 PELL PB 2009 981.00 001512 A 2010 2700.00 001512 A 2011 555.00 001512 A 4236.00 2008-06-18T00:00:00-04:00 2130045 2016-11-09T00:00:00-05:00 57570633741969535C
2287 2017-02-06T10:46:49.632-05:00 PELL PB 2000 3125.00 001512 A 3125.00 1999-08-16T00:00:00-04:00 2114323 2016-11-09T00:00:00-05:00 57570631002029565C
Powered by BI Documenter