DWStaging
 dbo.AR_1098_A (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.AR_1098_A
  Properties
Property Value
Name AR_1098_A
Schema dbo
Row Count 1059065
Data Size 297832 KB
Index Size 15816 KB
Create Date 10/14/2016 1:30 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ADD_DATE
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
AMMENDED_DATE
varchar(8)
True
False
False
 
CALENDAR_YEAR
varchar(4)
True
False
False
 
CLAIMANT_CITY
varchar(20)
True
False
False
 
CLAIMANT_COUNTRY
varchar(3)
True
False
False
 
CLAIMANT_FIRST_NAME
varchar(20)
True
False
False
 
CLAIMANT_LAST_NAME
varchar(35)
True
False
False
 
CLAIMANT_MIDDLE_NAME
varchar(20)
True
False
False
 
CLAIMANT_STATE
varchar(2)
True
False
False
 
CLAIMANT_STREET_1
varchar(32)
True
False
False
 
CLAIMANT_STREET_2
varchar(32)
True
False
False
 
CLAIMANT_ZIP
varchar(11)
True
False
False
 
DELIVERY_METHOD
varchar(1)
True
False
False
 
FEES_PAID_BY_STUDENT
numeric(11, 2)
True
False
False
 
FUTURE_YEAR_AID
numeric(8, 2)
True
False
False
 
FUTURE_YEAR_AMENDED_AID
numeric(8, 2)
True
False
False
 
FUTURE_YEAR_AMENDED_PAYMENTS
numeric(8, 2)
True
False
False
 
FUTURE_YEAR_PAYMENTS
numeric(8, 2)
True
False
False
 
GRADUATE_FLAG
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_AR_1098_A
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
PREF_IND
varchar(1)
True
False
False
 
PRINT_DATE
varchar(8)
True
False
False
 
PRIOR_YEAR_AID
numeric(8, 2)
True
False
False
 
PRIOR_YEAR_AMENDED_AID
numeric(8, 2)
True
False
False
 
PRIOR_YEAR_AMENDED_PAYMENTS
numeric(8, 2)
True
False
False
 
PRIOR_YEAR_PAYMENTS
numeric(8, 2)
True
False
False
 
QUALIFYING_STATUS
varchar(1)
True
False
False
 
REPRINT_DATE
varchar(8)
True
False
False
 
REPRINT_FLAG
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_AMMENDED_CITY
varchar(20)
True
False
False
 
STUDENT_AMMENDED_COUNTRY
varchar(3)
True
False
False
 
STUDENT_AMMENDED_STATE
varchar(2)
True
False
False
 
STUDENT_AMMENDED_STREET_1
varchar(32)
True
False
False
 
STUDENT_AMMENDED_STREET_2
varchar(32)
True
False
False
 
STUDENT_AMMENDED_ZIP
varchar(11)
True
False
False
 
STUDENT_CITY
varchar(20)
True
False
False
 
STUDENT_COUNTRY
varchar(3)
True
False
False
 
STUDENT_FIRST_NAME
varchar(20)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
STUDENT_LAST_NAME
varchar(35)
True
False
False
 
STUDENT_MIDDLE_NAME
varchar(20)
True
False
False
 
STUDENT_SSN
varchar(9)
True
False
False
 
STUDENT_STATE
varchar(2)
True
False
False
 
STUDENT_STREET_1
varchar(32)
True
False
False
 
STUDENT_STREET_2
varchar(32)
True
False
False
 
STUDENT_VIEW_DT
varchar(8)
True
False
False
 
STUDENT_VIEW_IND
varchar(1)
True
False
False
 
STUDENT_VIEW_TM
varchar(7)
True
False
False
 
STUDENT_ZIP
varchar(11)
True
False
False
 
SUBMIT_TO_IRS_IND
varchar(1)
True
False
False
 
TIN_CERTIFICATION
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_1098_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_1098_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AR_1098_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_1098_A] Script Date: 03/09/2017 16:44:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_1098_A](
    [ISN_AR_1098_A] [int] NOT NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [CALENDAR_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_LAST_NAME] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_FIRST_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_MIDDLE_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [QUALIFYING_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_ZIP] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_COUNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLAIMANT_LAST_NAME] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLAIMANT_FIRST_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLAIMANT_MIDDLE_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLAIMANT_STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLAIMANT_STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLAIMANT_CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLAIMANT_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLAIMANT_ZIP] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLAIMANT_COUNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AMMENDED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REPRINT_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REPRINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_AMMENDED_STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_AMMENDED_STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_AMMENDED_CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_AMMENDED_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_AMMENDED_ZIP] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_AMMENDED_COUNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRADUATE_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIOR_YEAR_PAYMENTS] [numeric](8, 2) NULL,
    [PRIOR_YEAR_AID] [numeric](8, 2) NULL,
    [FUTURE_YEAR_PAYMENTS] [numeric](8, 2) NULL,
    [FUTURE_YEAR_AID] [numeric](8, 2) NULL,
    [PRIOR_YEAR_AMENDED_PAYMENTS] [numeric](8, 2) NULL,
    [PRIOR_YEAR_AMENDED_AID] [numeric](8, 2) NULL,
    [FUTURE_YEAR_AMENDED_PAYMENTS] [numeric](8, 2) NULL,
    [FUTURE_YEAR_AMENDED_AID] [numeric](8, 2) NULL,
    [STUDENT_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUBMIT_TO_IRS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEES_PAID_BY_STUDENT] [numeric](11, 2) NULL,
    [STUDENT_VIEW_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_VIEW_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_VIEW_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREF_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DELIVERY_METHOD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIN_CERTIFICATION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AMMENDED_DATE CALENDAR_YEAR CLAIMANT_CITY CLAIMANT_COUNTRY CLAIMANT_FIRST_NAME CLAIMANT_LAST_NAME CLAIMANT_MIDDLE_NAME CLAIMANT_STATE CLAIMANT_STREET_1 CLAIMANT_STREET_2 CLAIMANT_ZIP DELIVERY_METHOD FUTURE_YEAR_AID FUTURE_YEAR_PAYMENTS GRADUATE_FLAG HOLD ISN_AR_1098_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PREF_IND PRINT_DATE QUALIFYING_STATUS REPRINT_DATE REPRINT_FLAG RowUpdatedOn STUDENT_AMMENDED_CITY STUDENT_AMMENDED_COUNTRY STUDENT_AMMENDED_STATE STUDENT_AMMENDED_STREET_1 STUDENT_AMMENDED_STREET_2 STUDENT_AMMENDED_ZIP STUDENT_CITY STUDENT_COUNTRY STUDENT_FIRST_NAME STUDENT_ID STUDENT_LAST_NAME STUDENT_MIDDLE_NAME STUDENT_SSN STUDENT_STATE STUDENT_STREET_1 STUDENT_STREET_2 STUDENT_VIEW_DT STUDENT_VIEW_IND STUDENT_VIEW_TM STUDENT_ZIP SUBMIT_TO_IRS_IND TIN_CERTIFICATION
20110112 FIC098N1 0414037 OPER2 2010 414037 565852 2017-02-06T09:52:29.118-05:00 LOXAHATCHEE US DOUGLAS D11071834 STEWART ALAN FL 1340 STALLION DR 33470 Y
20090123 FIC095N0 1020052 STUDENT E 1020052 386752 Y 2017-02-06T09:52:03.783-05:00 T11613528
20150107 FIC098N1 2119279 OPER1 2014 E 2119279 875611 20150108 FIC098B3 2015298 OPER1 20150108 Y 2017-02-06T09:53:13.188-05:00 DEERFIELD BEACH US ANNA A14523336 BORZI MICHELLE 900819816 FL 425 LAKE PT S LANE 33442 Y
20090429 FIC095N0 2035438 STUDENT P 2035438 443593 Y 2017-02-06T09:52:12.067-05:00 D13211354
20130109 FIC098N1 1203319 OPER1 2012 1002.25 1002.25 1203319 725543 Y 2017-02-06T09:52:51.956-05:00 LAKE WORTH US BRIAN B07559701 DESANTIS J FL 4541 EMERALD VISTA #333 33461 Y
20130803 FIC095N0 1900136 STUDENT E 1900136 789847 Y 2017-02-06T09:53:01.02-05:00 Z14541312
20130109 FIC098N1 1206369 OPER1 2012 P 1003.50 1206369 744502 20130109 FIC098B3 1427511 OPER1 20130109 Y 2017-02-06T09:52:54.687-05:00 DELRAY BEACH US KARLA K12873451 GONZALEZ C 900654425 FL 5088 PINETREE DRIVE 20130123 Y 1836364 33484 Y
20160623 FIC095N0 2201251 STUDENT E 2201251 1004305 Y 2017-02-06T09:53:31.706-05:00 D15373533
20160107 FIC098N1 1813444 OPER1 2015 E 1813444 986046 20160108 FIC098B3 1329416 OPER1 20160108 Y 2017-02-06T09:53:29.256-05:00 POMPANO BEACH US BRIGITTE B14052336 GAUTREAUX 900774413 FL 8203 W SAMPLE RD APT 23 20160120 Y 2216090 33065 Y
20060119 FIC098N1 1618376 OPER2 2005 P 1618376 204491 20060124 FIC098B3 0923041 OPER2 20060124 2017-02-06T09:51:38.854-05:00 PALM BEACH GARDENS US REBECCA R11565801 BUENO ANN 900497815 FL 15783 N 72 DR 33418 Y
Powered by BI Documenter