DWStaging
 dbo.ST_DLY_ENRLMNT_STAT_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_DLY_ENRLMNT_STAT_A
  Properties
Property Value
Name ST_DLY_ENRLMNT_STAT_A
Schema dbo
Row Count 35797
Data Size 3432 KB
Index Size 576 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_DATE_9S_COMP
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TERMINAL_ID
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
CAMP
varchar(1)
True
False
False
 
DLY_PAID_CRED_HR
numeric(17, 2)
True
False
False
 
DLY_PAID_HD_CNT_CR
int(10, 0)
True
False
False
 
DLY_PAID_HD_CNT_NCR
int(10, 0)
True
False
False
 
DLY_PAID_NCR_HR_EQV
numeric(17, 3)
True
False
False
 
DLY_RGST_CRED_HR
numeric(17, 2)
True
False
False
 
DLY_RGST_HD_CNT_CR
int(10, 0)
True
False
False
 
DLY_RGST_HD_CNT_NCR
int(10, 0)
True
False
False
 
DLY_RGST_NCR_HR_EQV
numeric(17, 3)
True
False
False
 
DLY_UNDUP_HD_CNT
int(10, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_DLY_ENRLMNT_STAT_A
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TERMINAL_ID
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
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_DLY_ENRLMNT_STAT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_DLY_ENRLMNT_STAT_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_DLY_ENRLMNT_STAT_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_DLY_ENRLMNT_STAT_A] Script Date: 03/09/2017 16:46:04 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_DLY_ENRLMNT_STAT_A](
    [ISN_ST_DLY_ENRLMNT_STAT_A] [int] NOT NULL,
    [TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_DATE_9S_COMP] [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_TERMINAL_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_TERMINAL_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DLY_PAID_HD_CNT_CR] [int] NULL,
    [DLY_PAID_HD_CNT_NCR] [int] NULL,
    [DLY_RGST_HD_CNT_CR] [int] NULL,
    [DLY_RGST_HD_CNT_NCR] [int] NULL,
    [DLY_PAID_CRED_HR] [numeric](17, 2) NULL,
    [DLY_RGST_CRED_HR] [numeric](17, 2) NULL,
    [DLY_PAID_NCR_HR_EQV] [numeric](17, 3) NULL,
    [DLY_RGST_NCR_HR_EQV] [numeric](17, 3) NULL,
    [DLY_UNDUP_HD_CNT] [int] NULL,
    [HOLD] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_DATE_9S_COMP ADD_PGM ADD_TERMINAL_ID ADD_TIME ADD_USER_ID CAMP DLY_PAID_CRED_HR DLY_PAID_HD_CNT_CR DLY_PAID_HD_CNT_NCR DLY_PAID_NCR_HR_EQV DLY_RGST_CRED_HR DLY_RGST_HD_CNT_CR DLY_RGST_HD_CNT_NCR DLY_RGST_NCR_HR_EQV DLY_UNDUP_HD_CNT HOLD ISN_ST_DLY_ENRLMNT_STAT_A MAINT_DATE MAINT_PGM MAINT_TERMINAL_ID MAINT_TIME MAINT_USER_ID RowUpdatedOn TRM_YR
20021126 79978873 STR958B0 246509 OPER2 0 29372.00 3096 532 50239.000 106405.20 11686 744 73806.000 12359 246509 5637 2017-02-06T10:49:24.916-05:00 20032
20040322 79959677 STR958B0 353423 OPER2 0 161316.40 20584 6406 798448.000 162505.40 20713 6752 816725.000 26936 353424 8072 2017-02-06T10:49:25.134-05:00 20042
20031120 79968879 STR958B0 249446 OPER2 3 7970.00 1513 344 19451.000 7976.00 1515 364 20412.000 1833 249446 7525 2017-02-06T10:49:25.087-05:00 20041
20070112 79929887 STR958B0 421122 OPER2 0 152882.40 18741 3066 700343.500 156481.40 19428 3541 731068.000 22722 421122 13912 2017-02-06T10:49:25.665-05:00 20072
20071121 79928878 STR958B0 124594 OPER1 3 7387.00 1286 296 33462.000 7399.00 1287 305 36468.000 1575 124594 15830 2017-02-06T10:49:25.852-05:00 20081
20060410 79939589 STR958B0 449595 OPER2 0 158184.20 19952 6414 724128.000 158193.20 19954 6422 725012.000 25833 449596 12227 2017-02-06T10:49:25.524-05:00 20062
20110124 79889875 STR958B0 319078 OPER2 0 233405.20 27065 2241 430184.000 239725.20 28344 2770 464673.500 30773 319078 22372 2017-02-06T10:49:26.429-05:00 20112
20100412 79899587 STR958B0 337292 OPER1 0 227000.40 26965 6364 737221.000 227030.40 26973 6462 747484.000 32820 337292 20642 2017-02-06T10:49:26.273-05:00 20102
20040604 79959395 STR958B0 219321 OPER2 2 14998.00 2941 417 16656.000 17873.00 3656 465 18709.000 4099 219321 8549 2017-02-06T10:49:25.181-05:00 20043
20070418 79929581 STR958B0 207288 OPER2 5 1763.00 325 82 7615.000 10370.00 1926 109 9574.000 2030 207288 14341 2017-02-06T10:49:25.711-05:00 20073
Powered by BI Documenter