DWStaging
 dbo.WW_NOTIFICATION (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.WW_NOTIFICATION
  Properties
Property Value
Name WW_NOTIFICATION
Schema dbo
Row Count 431
Data Size 120 KB
Index Size 32 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_WW_NOTIFICATION
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
WF_AN_AW
varchar(1)
True
False
False
 
WF_AN_BEFORE_AW
varchar(1)
True
False
False
 
WF_AN_BEFORE_FM
varchar(1)
True
False
False
 
WF_AN_BEFORE_ND
varchar(1)
True
False
False
 
WF_AN_CLOSE
varchar(1)
True
False
False
 
WF_AN_FM
varchar(1)
True
False
False
 
WF_AN_ND
varchar(1)
True
False
False
 
WF_AN_OPEN
varchar(1)
True
False
False
 
WF_AR_BEFORE_ST
varchar(1)
True
False
False
 
WF_AR_BEFORE_TR
varchar(1)
True
False
False
 
WF_AR_CLOSE
varchar(1)
True
False
False
 
WF_AR_OPEN
varchar(1)
True
False
False
 
WF_AR_ST
varchar(1)
True
False
False
 
WF_AR_TR
varchar(1)
True
False
False
 
WF_DN_BEFORE_ND
varchar(1)
True
False
False
 
WF_DN_CLOSE
varchar(1)
True
False
False
 
WF_DN_ND
varchar(1)
True
False
False
 
WF_DN_OPEN
varchar(1)
True
False
False
 
WF_DR_BEFORE_ST
varchar(1)
True
False
False
 
WF_DR_BEFORE_TR
varchar(1)
True
False
False
 
WF_DR_CLOSE
varchar(1)
True
False
False
 
WF_DR_OPEN
varchar(1)
True
False
False
 
WF_DR_ST
varchar(1)
True
False
False
 
WF_DR_TR
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_NO_TEXT01
varchar(60)
True
False
False
 
WW_NO_TEXT02
varchar(60)
True
False
False
 
WW_NO_TEXT03
varchar(60)
True
False
False
 
WW_NO_TEXT04
varchar(60)
True
False
False
 
WW_NO_TEXT05
varchar(60)
True
False
False
 
WW_NO_TEXT06
varchar(60)
True
False
False
 
WW_NO_TEXT07
varchar(60)
True
False
False
 
WW_NO_TEXT08
varchar(60)
True
False
False
 
WW_NO_TEXT09
varchar(60)
True
False
False
 
WW_NO_TEXT10
varchar(60)
True
False
False
 
WW_NOTIFICATION_FORM
varchar(1)
True
False
False
 
WW_NOTIFICATION_PKK
varchar(11)
True
False
False
 
WW_NOTIFICATION_TYPE
varchar(2)
True
False
False
 
WW_RECORD_TYPE
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_WW_NOTIFICATION
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WW_NOTIFICATION depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WW_NOTIFICATION)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WW_NOTIFICATION] Script Date: 03/09/2017 16:47:06 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WW_NOTIFICATION](
    [ISN_WW_NOTIFICATION] [int] NOT NULL,
    [WW_RECORD_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NOTIFICATION_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NOTIFICATION_FORM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NOTIFICATION_PKK] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_AR_OPEN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AR_BEFORE_ST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AR_ST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AR_BEFORE_TR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AR_TR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AR_CLOSE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DR_OPEN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DR_BEFORE_ST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DR_ST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DR_BEFORE_TR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DR_TR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DR_CLOSE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AN_OPEN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AN_BEFORE_ND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AN_ND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AN_BEFORE_AW] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AN_AW] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AN_BEFORE_FM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AN_FM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AN_CLOSE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DN_OPEN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DN_BEFORE_ND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DN_ND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_DN_CLOSE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT01] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT02] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT03] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT04] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT05] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT06] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT07] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT08] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT09] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_NO_TEXT10] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WW_NOTIFICATION RowUpdatedOn WF_AN_AW WF_AN_BEFORE_AW WF_AN_BEFORE_FM WF_AN_BEFORE_ND WF_AN_CLOSE WF_AN_FM WF_AN_ND WF_AN_OPEN WF_AR_BEFORE_ST WF_AR_BEFORE_TR WF_AR_CLOSE WF_AR_OPEN WF_AR_ST WF_AR_TR WF_DN_BEFORE_ND WF_DN_CLOSE WF_DN_ND WF_DN_OPEN WF_DR_BEFORE_ST WF_DR_BEFORE_TR WF_DR_CLOSE WF_DR_OPEN WF_DR_ST WF_DR_TR WF_FAO WW_CDATE WW_HOLD WW_MDATE WW_NO_TEXT01 WW_NO_TEXT02 WW_NO_TEXT03 WW_NO_TEXT04 WW_NO_TEXT05 WW_NO_TEXT06 WW_NO_TEXT07 WW_NO_TEXT08 WW_NO_TEXT09 WW_NO_TEXT10 WW_NOTIFICATION_FORM WW_NOTIFICATION_PKK WW_NOTIFICATION_TYPE WW_RECORD_TYPE
335 2017-02-06T11:27:10.612-05:00 PB 2012-05-09T00:00:00-04:00 819580 * Copy of parent(s) W2 C DPA-W2 R AR T
324 2017-02-06T11:27:10.612-05:00 PB 2011-04-25T00:00:00-04:00 1309515 2016-05-06T00:00:00-04:00 If you have registered for SUMMER classes, YOUR SUMMER 2016 AID WILL BE CANCELLED. You must pay your SUMMER tuition and fees by the due date. You may enroll in a tuition payment plan by visiting. www.mycollegepaymentplan.com/palmbeach If you are unable to pay your tuition and fees by the due date, you may want to go online and drop your courses. DO NOT rely on your classes being cancelled for nonpayment. S S DR T
406 2017-02-06T11:27:10.628-05:00 PB 2015-03-30T00:00:00-04:00 1207215 2016-05-06T00:00:00-04:00 * Your FAFSA indicates that you did not use IRS Data Retrival Tool to import YOUR PARENT"S FEDERAL TAX information.Therefore, you must submit an IRS transcript of your (step/remarried) parent's tax information to your campus financial aid office. A tax transcript can only be obtained from the IRS via their website at www.irs.gov or by calling 1-800-908-9946. PLEASE NOTE: We CAN NOT accept a copy of the tax return to satisfy this requirement. Q DPTAX2 R AR T
151 2017-02-06T11:27:10.596-05:00 PB 2002-03-27T00:00:00-05:00 823016 2012-05-09T00:00:00-04:00 * NSLDS reports that you owe a repayment of federal aid from a previous college attendance. We can't process your application until you resolve this with U.S. Department of Education, 1-800-621-3115. C DPERKOP R AR T
20 2017-02-06T11:27:10.596-05:00 PB 1999-01-15T00:00:00-05:00 1019034 2014-05-07T00:00:00-04:00 * Your FAFSA indicates you may have a Bachelor's Degree, which renders you ineligible for federal and state grants. However, you may be eligible for other aid, such as work and loans. If you do not have a Bachelor's Degree, complete the Bacherlor Degree Corection Form on our web site and take it to your campus financial aid office. M DDEGREE R AR T
21 2017-02-06T11:27:10.596-05:00 PB 1999-02-19T00:00:00-05:00 1029308 2012-02-10T00:00:00-05:00 We have received your Free Application for Federal Financial Aid (FAFSA). Before we can advise you of your financial aid eligibility, please submit the following information or documents to your campus Financial Aid Office. N O AR T
254 2017-02-06T11:27:10.612-05:00 PB 2013-03-20T00:00:00-04:00 1423382 * Copy of parent(s) W2 I DPA-W2 R AR T
286 2017-02-06T11:27:10.612-05:00 PB 2006-03-28T00:00:00-05:00 748125 * A copy of the Death Certificate. Q DDCERT R AR T
206 2017-02-06T11:27:10.612-05:00 PB 2003-09-10T00:00:00-04:00 1350322 2008-04-04T00:00:00-04:00 * We were unable to verify your Citizenship Eligibility Status for Financial Aid. Therefore, we have forwarded Citizenship Documnet(s) to INS for authentication. There is no action required on your part at this time. I DINSVER R AR T
396 2017-02-06T11:27:10.612-05:00 PB 2014-07-21T00:00:00-04:00 1333118 * Independent Verification Form 1 completed and signed. This form is available on the PBSC financial aid web site under FORMS. N DVFI-1 R AR T
Powered by BI Documenter