DWStaging
 dbo.IT_R2T4_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.IT_R2T4_A
  Properties
Property Value
Name IT_R2T4_A
Schema dbo
Row Count 24072
Data Size 4048 KB
Index Size 400 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
ACG_DOE_DEBT_PAID_TO_COLL
decimal(7, 2)
True
False
False
 
ACG_ORIG_DISB
decimal(7, 2)
True
False
False
 
ACG_ORIG_DOE_DEBT
decimal(7, 2)
True
False
False
 
ACG_OWED_COLLEGE
decimal(7, 2)
True
False
False
 
ACG_REVISED_AWARD
decimal(7, 2)
True
False
False
 
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
 
BOOK_STORE_CHARGE_IND
varchar(1)
True
False
False
 
BOOK_STORE_CHARGES
decimal(7, 2)
True
False
False
 
COST_OF_ATTENDANCE
decimal(7, 2)
True
False
False
 
FAO
varchar(2)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_IT_R2T4_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
 
NSLDS_DATE
varchar(8)
True
False
False
 
PELL_DOE_DEBT_PAID_TO_COLL
decimal(7, 2)
True
False
False
 
PELL_ORIG_DISB
decimal(7, 2)
True
False
False
 
PELL_ORIG_DOE_DEBT
decimal(7, 2)
True
False
False
 
PELL_OWED_COLLEGE
decimal(7, 2)
True
False
False
 
PELL_REVISED_AWARD
decimal(7, 2)
True
False
False
 
PERC_EARNED
decimal(5, 2)
True
False
False
 
REC_TYPE
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SEOG_DOE_DEBT_PAID_TO_COLL
decimal(7, 2)
True
False
False
 
SEOG_ORIG_DISB
decimal(7, 2)
True
False
False
 
SEOG_ORIG_DOE_DEBT
decimal(7, 2)
True
False
False
 
SEOG_OWED_COLLEGE
decimal(7, 2)
True
False
False
 
SEOG_REVISED_AWARD
decimal(7, 2)
True
False
False
 
SMART_DOE_DEBT_PAID_TO_COLL
decimal(7, 2)
True
False
False
 
SMART_ORIG_DISB
decimal(7, 2)
True
False
False
 
SMART_ORIG_DOE_DEBT
decimal(7, 2)
True
False
False
 
SMART_OWED_COLLEGE
decimal(7, 2)
True
False
False
 
SMART_REVISED_AWARD
decimal(7, 2)
True
False
False
 
STATUS
varchar(2)
True
False
False
 
STATUS_DATE
varchar(8)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
STUDENT_SSN
varchar(9)
True
False
False
 
TERM
varchar(6)
True
False
False
 
TERM_60_PERC_DATE
varchar(8)
True
False
False
 
TOTAL_TUITION
decimal(11, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_IT_R2T4_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.IT_R2T4_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.IT_R2T4_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[IT_R2T4_A] Script Date: 03/09/2017 16:45:40 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[IT_R2T4_A](
    [ISN_IT_R2T4_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,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REC_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NSLDS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [TOTAL_TUITION] [decimal](11, 2) NULL,
    [BOOK_STORE_CHARGES] [decimal](7, 2) NULL,
    [BOOK_STORE_CHARGE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERC_EARNED] [decimal](5, 2) NULL,
    [COST_OF_ATTENDANCE] [decimal](7, 2) NULL,
    [TERM_60_PERC_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PELL_ORIG_DISB] [decimal](7, 2) NULL,
    [PELL_OWED_COLLEGE] [decimal](7, 2) NULL,
    [PELL_REVISED_AWARD] [decimal](7, 2) NULL,
    [PELL_ORIG_DOE_DEBT] [decimal](7, 2) NULL,
    [PELL_DOE_DEBT_PAID_TO_COLL] [decimal](7, 2) NULL,
    [SEOG_ORIG_DISB] [decimal](7, 2) NULL,
    [SEOG_OWED_COLLEGE] [decimal](7, 2) NULL,
    [SEOG_REVISED_AWARD] [decimal](7, 2) NULL,
    [SEOG_ORIG_DOE_DEBT] [decimal](7, 2) NULL,
    [SEOG_DOE_DEBT_PAID_TO_COLL] [decimal](7, 2) NULL,
    [ACG_ORIG_DISB] [decimal](7, 2) NULL,
    [ACG_OWED_COLLEGE] [decimal](7, 2) NULL,
    [ACG_REVISED_AWARD] [decimal](7, 2) NULL,
    [ACG_ORIG_DOE_DEBT] [decimal](7, 2) NULL,
    [ACG_DOE_DEBT_PAID_TO_COLL] [decimal](7, 2) NULL,
    [SMART_ORIG_DISB] [decimal](7, 2) NULL,
    [SMART_OWED_COLLEGE] [decimal](7, 2) NULL,
    [SMART_REVISED_AWARD] [decimal](7, 2) NULL,
    [SMART_ORIG_DOE_DEBT] [decimal](7, 2) NULL,
    [SMART_DOE_DEBT_PAID_TO_COLL] [decimal](7, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BOOK_STORE_CHARGE_IND BOOK_STORE_CHARGES COST_OF_ATTENDANCE FAO HOLD ISN_IT_R2T4_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NSLDS_DATE PELL_ORIG_DISB PELL_OWED_COLLEGE PELL_REVISED_AWARD REC_TYPE RowUpdatedOn STATUS STATUS_DATE STUDENT_ID STUDENT_SSN TERM TERM_60_PERC_DATE TOTAL_TUITION
20150511 FIW425N1 1114564 OPER1 N 16403.00 PB 815514 19967 20150706 FIW425N1 0815514 E003320 20150706 1432.00 295.00 1137.00 N 2017-02-06T11:19:29.91-05:00 08 20150706 N14494645 900828368 20152 20150323 589.50
20131014 FIW425N1 0920369 OPER1 N 15248.00 PB 1556011 14720 20131014 FIW425N1 1556011 E062735 O 2017-02-06T11:19:29.239-05:00 98 20131014 D13868179 900746611 20141 20131031
20160328 FIW425N1 1126315 OPER1 N 7428.00 PB 1126315 21689 722.00 722.00 O 2017-02-06T11:19:30.144-05:00 01 20160328 N13614680 900721394 20162 20160322 303.00
20160104 FIW425N1 1927500 OPER1 N 14475.00 PB 1625393 20998 20160314 FIW425N1 1625393 E003320 20160313 341.00 171.00 170.00 N 2017-02-06T11:19:30.05-05:00 08 20160314 N14920607 900858864 20161 20151031 642.00
20150511 FIW425N1 1112472 OPER1 N 12669.00 PB 813406 19194 20150723 FIW425N1 0813406 E003320 20150722 2149.00 2149.00 N 2017-02-06T11:19:29.816-05:00 08 20150723 J14273569 900795939 20152 20150323 1097.13
20140317 FIW425N1 0943413 OPER1 N 1191.00 PB 947151 16040 20140328 FIW425N1 0947151 E062735 20140503 706.00 199.00 507.00 O 2017-02-06T11:19:29.411-05:00 09 20140328 E06833214 900075814 20142 20140402 319.75
20170103 FIW425N1 0940419 OPER2 N 13436.00 PB 940419 23929 1454.00 1454.00 N 2017-02-06T11:19:30.425-05:00 00 20170103 G15417462 900909389 20171 20161101 945.00
20120723 FIW425N1 1003404 OPER2 N 1030.00 PB 1423439 12018 20120806 FIW425N1 1423439 E047464 694.00 694.00 O 2017-02-06T11:19:28.911-05:00 00 20120723 P14094288 900778390 20123 20120716 288.00
20150105 FIW425N1 1123587 OPER1 N 15248.00 PB 1115291 18351 20150316 FIW425N1 1115291 E003320 20150308 2865.00 718.00 2147.00 N 2017-02-06T11:19:29.707-05:00 06 20150316 M13766381 900736810 20151 20141101 1435.50
20110912 FIW425N1 0800525 OPER2 259.70 13536.00 PB 921117 9358 20120105 FIW425N1 0921117 E077724 O 2017-02-06T11:19:28.521-05:00 98 20120105 J13711692 900772482 20121 20111028 601.00
Powered by BI Documenter