DWStaging
 dbo.ST_SPCL_FEE_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_SPCL_FEE_LOG_A
  Properties
Property Value
Name ST_SPCL_FEE_LOG_A
Schema dbo
Row Count 3191
Data Size 432 KB
Index Size 80 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
 
CRS_FEE_IND
varchar(1)
True
False
False
 
EFF_TRM_9S_COMP
varchar(6)
True
False
False
 
END_TRM
varchar(6)
True
False
False
 
FEE_AMT
numeric(17, 2)
True
False
False
 
FEE_ASSESS
varchar(1)
True
False
False
 
FEE_CRED_TY
varchar(1)
True
False
False
 
FEE_GRP
varchar(2)
True
False
False
 
FEE_TY
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_SPCL_FEE_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
 
OVRD_FLG
varchar(1)
True
False
False
 
RFND_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
TRM_YR
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_SPCL_FEE_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_SPCL_FEE_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_SPCL_FEE_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_SPCL_FEE_LOG_A] Script Date: 03/09/2017 16:46:21 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_SPCL_FEE_LOG_A](
    [ISN_ST_SPCL_FEE_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,
    [CRS_FEE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_TRM] [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_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_GRP] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_TY] [varchar](4) 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_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_9S_COMP] [varchar](6) 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 CRS_FEE_IND EFF_TRM_9S_COMP END_TRM FEE_AMT FEE_ASSESS FEE_CRED_TY FEE_GRP FEE_TY HOLD ISN_ST_SPCL_FEE_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OVRD_FLG RFND_IND RowUpdatedOn TRM_YR
20140225 STF200N0 1256503 E002073 C 798579 20163 149.76 E N LM S466 1256503 2420 A 20140225 pts/376 1256503 E002073 N Y 2017-02-06T11:26:44.903-05:00 20142
20110622 STF200N0 1205009 E002073 C 798789 20163 5300.00 E B CF S417 909503 2251 M 20130107 pts/62 909503 E002073 20130107 STF200N0 0909503 E002073 N Y 2017-02-06T11:26:44.887-05:00 20121
20070813 STF200N0 1538318 E002073 C 799269 20103 63.84 E B LM S273 1012597 927 M 20080107 pts/215 1012597 E002073 20080107 STF200N0 1012597 E002073 N Y 2017-02-06T11:26:44.778-05:00 20073
20130107 STF200N0 0951583 E002073 C 798589 20163 103.00 E B SF SF45 951583 2310 A 20130107 pts/62 951583 E002073 N Y 2017-02-06T11:26:44.887-05:00 20141
20090701 STF200N0 1221541 E005840 C 798989 20183 28.97 E N SB SB01 1106384 3016 M 20150706 pts/271 1106383 E002073 20150706 STF200N0 1106384 E002073 N Y 2017-02-06T11:26:44.981-05:00 20101
20100616 STF200N0 1502309 E002073 C 798889 20133 6.83 A B IS INAC 1502309 1576 A 20100616 pts/243 1502309 E002073 N Y 2017-02-06T11:26:44.841-05:00 20111
20040108 STF200N0 1347493 E002073 C 799579 20103 49.60 E B LM S141 1000081 794 M 20080107 pts/215 1000081 E002073 20080107 STF200N0 1000081 E002073 N Y 2017-02-06T11:26:44.778-05:00 20042
20030528 STF200N0 2127231 E002073 C 799669 20103 178.00 E B SF S126 958330 779 M 20080107 pts/215 958330 E002073 20080107 STF200N0 0958330 E002073 N Y 2017-02-06T11:26:44.778-05:00 20033
20150526 STF200N0 1610226 E002073 C 798479 20183 522.00 E B LM S508 1106047 3012 M 20150706 pts/271 1106047 E002073 20150706 STF200N0 1106047 E002073 N Y 2017-02-06T11:26:44.981-05:00 20152
20110323 STF200N0 1552181 E002073 C 798889 20183 206.64 E N LM S405 1052002 2910 M 20150706 pts/271 1052002 E002073 20150706 STF200N0 1052002 E002073 N Y 2017-02-06T11:26:44.934-05:00 20111
Powered by BI Documenter