DWStaging
 dbo.AR_FINANCIAL_AID_AWARD_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_FINANCIAL_AID_AWARD_A
  Properties
Property Value
Name AR_FINANCIAL_AID_AWARD_A
Schema dbo
Row Count 850377
Data Size 108168 KB
Index Size 12744 KB
Create Date 11/7/2012 11:53 AM
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
 
AWARD_AMOUNT
numeric(17, 2)
True
False
False
 
AWARD_CHANGE_AMOUNT
numeric(17, 2)
True
False
False
 
AWARD_CHANGE_IND
varchar(1)
True
False
False
 
AWARD_OVERRIDE_AMOUNT
numeric(17, 2)
True
False
False
 
AWARD_OVERRIDE_IND
varchar(1)
True
False
False
 
DISBURSEMENT_AMOUNT
numeric(17, 2)
True
False
False
 
DISBURSEMENT_CHANGE_AMOUNT
numeric(17, 2)
True
False
False
 
DISBURSEMENT_CHANGE_IND
varchar(1)
True
False
False
 
DISBURSEMENT_OVERRIDE_AMOUNT
numeric(17, 2)
True
False
False
 
DISBURSEMENT_OVERRIDE_IND
varchar(1)
True
False
False
 
FINANCIAL_AID_KEY
varchar(20)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_AR_FINANCIAL_AID_AWARD_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
 
PROCESS_PROBLEM_CODE
varchar(4)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
TERM
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_FINANCIAL_AID_AWARD_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_FINANCIAL_AID_AWARD_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AR_FINANCIAL_AID_AWARD_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_FINANCIAL_AID_AWARD_A] Script Date: 03/09/2017 16:45:00 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_FINANCIAL_AID_AWARD_A](
    [ISN_AR_FINANCIAL_AID_AWARD_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,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FINANCIAL_AID_KEY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWARD_AMOUNT] [numeric](17, 2) NULL,
    [AWARD_CHANGE_AMOUNT] [numeric](17, 2) NULL,
    [AWARD_CHANGE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWARD_OVERRIDE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWARD_OVERRIDE_AMOUNT] [numeric](17, 2) NULL,
    [DISBURSEMENT_AMOUNT] [numeric](17, 2) NULL,
    [DISBURSEMENT_CHANGE_AMOUNT] [numeric](17, 2) NULL,
    [DISBURSEMENT_CHANGE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISBURSEMENT_OVERRIDE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISBURSEMENT_OVERRIDE_AMOUNT] [numeric](17, 2) NULL,
    [PROCESS_PROBLEM_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AWARD_AMOUNT AWARD_CHANGE_IND AWARD_OVERRIDE_IND DISBURSEMENT_AMOUNT DISBURSEMENT_CHANGE_IND DISBURSEMENT_OVERRIDE_IND FINANCIAL_AID_KEY HOLD ISN_AR_FINANCIAL_AID_AWARD_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PROCESS_PROBLEM_CODE RowUpdatedOn STUDENT_ID TERM
20010705 ITW101N1 1415018 MBLOETH 650.00 N 650.00 N 2002PBFLFSAG 144593 47967 20010914 FIC402N3 0144593 OPER2 2017-02-06T10:24:57.009-05:00 M06128524 20021
20020617 ITW101N1 1648196 MBLOETH 425.00 N 425.00 N 2003PBFEDPELL 319407 74281 20021030 FIC401B2 0102526 OPER2 2017-02-06T10:24:59.318-05:00 L11353414 20031
20111011 ITW101N1 0801539 E028108 1494.00 N 1494.00 N 2012PBFEDDLSUB 543087 479310 20111021 FIC227N2 0059137 OPER2 2017-02-06T10:25:33.669-05:00 J13870308 20121
19991029 FIC401N1 2014556 OPER2 250.00 250.00 2000PBIFSPBCC 1900450 18068 20000420 FIC401N1 1900450 OPER2 2017-02-06T10:24:54.513-05:00 A06990121 20001
20111104 ITW101N1 0605111 OPER2 2775.00 N 2775.00 N 2012PBFEDPELL 448166 481289 20120330 FIC227N2 0038041 OPER2 2017-02-06T10:25:33.841-05:00 C13693742 20122
20130620 ITW101N1 0206317 OPER1 N N 2014PBFEDPELL 139564 599299 20140121 FIC401B1 0139564 OPER2 2017-02-06T10:25:43.622-05:00 M14378236 20142
20120719 ITW101N1 0433495 OPER1 1500.00 N 1500.00 N 2013PBFEDPELL 453102 549094 20121005 FIC227N2 0048463 OPER2 2017-02-06T10:25:39.488-05:00 M13414982 20131
20140702 ITW101N1 0241019 OPER1 N N 2015PBFLFSAG 251563 662000 20150122 FIC401B1 0251563 OPER2 2017-02-06T10:25:49.082-05:00 K14728943 20152
20130807 ITW101N1 1442018 E028108 2474.00 N 2474.00 N 2014PBFEDDLSUB 406441 619258 20130913 FIC227N2 0144094 OPER2 2017-02-06T10:25:45.369-05:00 J14073134 20141
20121127 ITW101N1 0859026 E028108 594.00 N 594.00 N 2013PBFEDDLSUB 513392 554391 20130124 FIC401B2 0149168 OPER2 2017-02-06T10:25:39.909-05:00 D06158182 20132
Powered by BI Documenter