DWStaging
 dbo.ST_SPCL_FEE_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_SPCL_FEE_A
  Properties
Property Value
Name ST_SPCL_FEE_A
Schema dbo
Row Count 155620
Data Size 10240 KB
Index Size 2352 KB
Create Date 8/15/2012 2:10 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
 
CLASS_KEY
varchar(25)
True
False
False
 
CRS_FEE_IND
varchar(1)
True
False
False
 
EFF_TRM_9S_COMP
varchar(6)
True
False
False
 
END_TRM
varchar(6)
True
False
False
 
END_TRM_9S_COMP
varchar(6)
True
False
False
 
FEE_AMT
numeric(17, 2)
True
False
False
 
FEE_ASSESS
varchar(1)
True
False
False
 
FEE_CRED_CD
varchar(2)
True
False
False
 
FEE_CRED_TY
varchar(1)
True
False
False
 
FEE_CRS_ID
varchar(10)
True
False
False
 
FEE_END_TRM
varchar(6)
True
False
False
 
FEE_GRP
varchar(2)
True
False
False
 
FEE_POPLT_CLS_ADD
varchar(1)
True
False
False
 
FEE_REQ
varchar(1)
True
False
False
 
FEE_TRM_YR
varchar(6)
True
False
False
 
FEE_TY
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_SPCL_FEE_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
 
OVRD_FLG
varchar(1)
True
False
False
 
RES_CD
varchar(1)
True
False
False
 
RFND_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
TRM_FEE_CHILD_IND
varchar(1)
True
False
False
 
TRM_FEE_IND
varchar(1)
True
False
False
 
TRM_YR
varchar(6)
True
False
False
 
TRM_YR_9S_COMP
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_SPCL_FEE_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_SPCL_FEE_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_SPCL_FEE_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_SPCL_FEE_A] Script Date: 03/09/2017 16:46:21 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_SPCL_FEE_A](
    [ISN_ST_SPCL_FEE_A] [int] NOT NULL,
    [CRS_FEE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLASS_KEY] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_9S_COMP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_TRM_9S_COMP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_AMT] [numeric](17, 2) NULL,
    [FEE_ASSESS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_CRED_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_CRED_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_CRS_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_GRP] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_POPLT_CLS_ADD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_REQ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_TY] [varchar](4) 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,
    [OVRD_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RFND_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_FEE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_FEE_CHILD_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_YR_9S_COMP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [FEE_TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_END_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_CD] [varchar](1) 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 CLASS_KEY CRS_FEE_IND EFF_TRM_9S_COMP END_TRM END_TRM_9S_COMP FEE_ASSESS FEE_CRED_CD FEE_CRED_TY FEE_CRS_ID FEE_END_TRM FEE_GRP FEE_POPLT_CLS_ADD FEE_REQ FEE_TRM_YR FEE_TY ISN_ST_SPCL_FEE_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OVRD_FLG RES_CD RFND_IND RowUpdatedOn TRM_FEE_CHILD_IND TRM_FEE_IND TRM_YR TRM_YR_9S_COMP
NPRN0500 20101 1 001 INSA 79575 2017-02-06T10:50:17.067-05:00
CENC0025 20133 1 005 SF08 109494 2017-02-06T10:50:19.547-05:00
CREA0017 20122 1 020 SF08 95999 2017-02-06T10:50:18.424-05:00
CCHM1046L 20151 2 001 INSA 121383 2017-02-06T10:50:20.515-05:00
PMT0290 20033 Y Y 20023 INSA 82300 2017-02-06T10:50:17.27-05:00 20102
CEMS2659 20153 19 001 INSA 130316 2017-02-06T10:50:21.217-05:00
ENC1101L 20092 20061 DIST 120174 2017-02-06T10:50:20.421-05:00 20141
NRO0131 20063 Y Y 20061 S166 42710 2017-02-06T10:50:14.041-05:00 20043
NCDO0103 20151 3 001 S455 128164 2017-02-06T10:50:21.061-05:00
CNUR1214L 20131 1 010 SF26 102735 2017-02-06T10:50:18.986-05:00
Powered by BI Documenter