DWStaging
 dbo.ST_EXTRNL_COST_ATTEND_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.ST_EXTRNL_COST_ATTEND_A
  Properties
Property Value
Name ST_EXTRNL_COST_ATTEND_A
Schema dbo
Row Count 57
Data Size 8 KB
Index Size 24 KB
Create Date 8/15/2012 1:36 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
 
EXTRNL_BOOKS_AND_SUPPLIES
numeric(17, 2)
True
False
False
 
EXTRNL_PERSONAL_EXP
numeric(17, 2)
True
False
False
 
EXTRNL_ROOM_AND_BOARD
numeric(17, 2)
True
False
False
 
EXTRNL_TRANSPORT
numeric(17, 2)
True
False
False
 
EXTRNL_TUITION_FEES
numeric(17, 2)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INST_ID
varchar(8)
True
False
False
 
INST_TY
varchar(1)
True
False
False
 
ISN_ST_EXTRNL_COST_ATTEND_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
 
RECEIVED_DATE
varchar(8)
True
False
False
 
RECEIVED_TIME
varchar(7)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
TRANSIENT_TRM
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_EXTRNL_COST_ATTEND_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_EXTRNL_COST_ATTEND_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_EXTRNL_COST_ATTEND_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_EXTRNL_COST_ATTEND_A] Script Date: 03/09/2017 16:46:05 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_EXTRNL_COST_ATTEND_A](
    [ISN_ST_EXTRNL_COST_ATTEND_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,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANSIENT_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVED_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXTRNL_TUITION_FEES] [numeric](17, 2) NULL,
    [EXTRNL_ROOM_AND_BOARD] [numeric](17, 2) NULL,
    [EXTRNL_BOOKS_AND_SUPPLIES] [numeric](17, 2) NULL,
    [EXTRNL_TRANSPORT] [numeric](17, 2) NULL,
    [EXTRNL_PERSONAL_EXP] [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 EXTRNL_BOOKS_AND_SUPPLIES EXTRNL_PERSONAL_EXP EXTRNL_ROOM_AND_BOARD EXTRNL_TRANSPORT EXTRNL_TUITION_FEES HOLD INST_ID INST_TY ISN_ST_EXTRNL_COST_ATTEND_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RECEIVED_DATE RECEIVED_TIME RowUpdatedOn STDNT_ID TRANSIENT_TRM
20150113 STR320N0 1037062 OPER2 617.00 1161.00 7500.00 1416.00 1271.00 1037063 001500 P 26 20150113 STR320N0 1037063 OPER2 20150113 1037063 2017-02-06T11:32:13.784-05:00 O14195002 20152
20150113 STR320N0 1037056 OPER2 617.00 1161.00 7500.00 1416.00 1271.00 1037056 001500 P 24 20150113 STR320N0 1037056 OPER2 20150113 1037056 2017-02-06T11:32:13.784-05:00 J13465869 20152
20160826 STR320N0 0846206 OPER1 400.00 900.00 3000.00 1000.00 98.83 846207 001533 P 50 20160826 STR320N0 0846207 OPER1 20160826 0846207 2017-02-06T11:32:13.784-05:00 C14305957 20171
20141008 STR320N0 0845555 OPER2 573.00 1386.00 4879.00 928.00 2965.00 845557 003954 P 22 20141008 STR320N0 0845557 OPER2 20141008 0845557 2017-02-06T11:32:13.784-05:00 A14302962 20151
20170111 STR320N0 0817451 OPER1 617.00 1161.00 7500.00 1416.00 1271.00 817451 001500 P 57 20170111 STR320N0 0817451 OPER1 20170111 0817451 2017-02-06T11:32:13.784-05:00 C14715726 20171
20140127 STR320N0 2002320 OPER1 610.00 1063.50 677.00 1583.50 2694.00 2002320 001481 P 12 20140127 2002320 2017-02-06T11:32:13.784-05:00 R13802962 20142
20130617 STR320N0 2002587 OPER1 1500.00 2898.00 4383.00 4316.00 2693.28 2002587 001506 P 4 20130617 2002587 2017-02-06T11:32:13.784-05:00 A14227052 20133
20130826 STR320N0 2001165 OPER1 600.00 1381.50 855.00 1057.50 1224.00 2001165 001470 P 5 20130826 2001165 2017-02-06T11:32:13.784-05:00 C14544522 20141
20140520 STR320N0 2004306 OPER1 617.00 1161.00 7500.00 1416.00 1271.00 2004306 001500 P 15 20140520 2004306 2017-02-06T11:32:13.784-05:00 K14295380 20143
20140909 STR320N0 2000090 OPER1 316.50 118.50 2341.50 713.50 618.36 2000090 006750 P 19 20140909 2000090 2017-02-06T11:32:13.784-05:00 A12746483 20151
Powered by BI Documenter