DWStaging
 dbo.ST_EXTRNL_COST_ATTEND_LOG_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_LOG_A
  Properties
Property Value
Name ST_EXTRNL_COST_ATTEND_LOG_A
Schema dbo
Row Count 103
Data Size 16 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_LOG_A
int(10, 0)
False
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
varchar(8)
True
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_LOG_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_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_EXTRNL_COST_ATTEND_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_EXTRNL_COST_ATTEND_LOG_A] Script Date: 03/09/2017 16:46:05 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_EXTRNL_COST_ATTEND_LOG_A](
    [ISN_ST_EXTRNL_COST_ATTEND_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RECEIVED_DATE RECEIVED_TIME RowUpdatedOn STDNT_ID TRANSIENT_TRM
20150520 STR320N0 0854076 OPER2 617.00 1161.00 7500.00 1416.00 1271.00 854076 001500 P 50 M 20150520 <notty> 854076 OPER2 20150520 STR320N0 0854076 OPER2 20150520 0854076 2017-02-06T11:31:51.476-05:00 L14147623 20153
20140519 STR320N0 0839009 OPER2 158.25 1146.75 356.75 297.18 839010 006750 P 18 M 20140519 <notty> 839010 OPER2 20140519 STR320N0 0839010 OPER2 20140519 0839010 2017-02-06T11:31:51.476-05:00 A13989033 20143
20160205 STR320N0 0955362 OPER1 617.00 1161.00 7500.00 1416.00 1271.00 820514 001500 P 80 M 20160226 <notty> 820514 OPER1 20160226 STR320N0 0820514 OPER1 20160226 0820514 2017-02-06T11:31:51.476-05:00 N14339089 20162
20160427 STR320N0 0858178 OPER1 617.00 1161.00 7500.00 1416.00 1271.00 858178 001500 P 81 A 20160427 <notty> 858178 OPER1 20160427 0858178 2017-02-06T11:31:51.476-05:00 J14570261 20162
20150520 STR320N0 0854080 OPER2 617.00 1161.00 7500.00 1416.00 1271.00 854081 001500 P 53 M 20150520 <notty> 854081 OPER2 20150520 STR320N0 0854081 OPER2 20150520 0854081 2017-02-06T11:31:51.476-05:00 J14165716 20153
20150826 STR320N0 0826408 OPER2 660.00 1350.00 5079.00 850.00 1336.00 816509 001477 P 71 M 20151002 <notty> 816509 OPER2 20151002 STR320N0 0816509 OPER2 20151002 0816509 2017-02-06T11:31:51.476-05:00 A14360598 20161
20160518 STR320N0 0829347 OPER1 252.00 711.00 462.00 927.00 1281.00 829347 001519 P 84 M 20160518 <notty> 829347 OPER1 20160518 STR320N0 0829347 OPER1 20160518 0829347 2017-02-06T11:31:51.476-05:00 D13615661 20163
20160518 STR320N0 0829347 OPER1 252.00 711.00 462.00 927.00 1281.00 840479 001519 P 85 M 20160519 <notty> 840479 OPER1 20160519 STR320N0 0840479 OPER1 20160519 0840479 2017-02-06T11:31:51.476-05:00 D13615661 20163
20130516 STR320N0 2001530 OPER1 481.20 851.20 541.60 1282.80 1904.40 2001530 001481 P 3 A 20130516 <notty> 2001530 OPER1 20130516 2001530 2017-02-06T11:31:51.476-05:00 E13821616 20133
20150825 STR320N0 0821453 OPER2 800.00 1105.00 4700.00 1294.00 1377.00 821453 001528 P 60 A 20150825 <notty> 821453 OPER2 20150825 0821453 2017-02-06T11:31:51.476-05:00 A14140974 20161
Powered by BI Documenter