DWStaging
 dbo.NRA_STUDENTS (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.NRA_STUDENTS
  Properties
Property Value
Name NRA_STUDENTS
Schema dbo
Row Count 4523
Data Size 416 KB
Index Size 112 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
 
DOCUMENT_SENT_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_NRA_STUDENTS
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
 
NRA_STATUS
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
TAX_PERCENT
numeric(17, 2)
True
False
False
 
TRM_YR
varchar(6)
True
False
False
 
WITHHOLD_ALLOWANCE
numeric(17, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_NRA_STUDENTS
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.NRA_STUDENTS depends on)
Name Type
  Child Dependencies (objects that depend on dbo.NRA_STUDENTS)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[NRA_STUDENTS] Script Date: 03/09/2017 16:45:46 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[NRA_STUDENTS](
    [ISN_NRA_STUDENTS] [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,
    [TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NRA_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DOCUMENT_SENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TAX_PERCENT] [numeric](17, 2) NULL,
    [WITHHOLD_ALLOWANCE] [numeric](17, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID DOCUMENT_SENT_IND HOLD ISN_NRA_STUDENTS MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NRA_STATUS RowUpdatedOn STUDENT_ID TRM_YR
20100811 FIC970N1 0258359 OPER2 Y 901263 2801 20100910 FIC970N1 0901263 E037629 T 2017-02-06T11:27:21.626-05:00 L11603909 20111
20110928 FIC970N1 0306242 OPER2 306242 3510 T 2017-02-06T11:27:21.688-05:00 G13055512 20121
20100811 FIC970N1 0258289 OPER2 258289 2773 T 2017-02-06T11:27:21.626-05:00 E09167891 20111
20070110 FIC970N1 0226308 OPER2 Y 1135034 715 20070207 FIC970N1 1135034 E002364 C 2017-02-06T11:27:21.47-05:00 P09369539 20072
20130208 FIC970N1 0922238 E002364 922238 3928 C 2017-02-06T11:27:21.704-05:00 140832144 20132A
20090826 FIC970N1 0309122 OPER2 Y 1343351 2267 20091001 FIC970N1 1343351 E002364 C 2017-02-06T11:27:21.594-05:00 S12771291 20101
20060809 FIC970N1 0326053 OPER2 1546083 428 20060816 FIC970N1 1546083 E002364 C 2017-02-06T11:27:21.407-05:00 J11914892 20071
20070509 FIC970N1 0212173 OPER2 212173 798 T 2017-02-06T11:27:21.47-05:00 K12474144 20073
20080514 FIC970N1 0216012 OPER2 1619092 1334 20080520 FIC970N1 1619092 E002364 C 2017-02-06T11:27:21.516-05:00 P12745451 20083
20070228 FIC970N1 0203521 OPER2 Y 1427570 766 20070328 FIC970N1 1427570 E002364 C 2017-02-06T11:27:21.47-05:00 J12209821 20072
Powered by BI Documenter