DWStaging
 dbo.FAC200_FACILITY_CALENDAR_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.FAC200_FACILITY_CALENDAR_A
  Properties
Property Value
Name FAC200_FACILITY_CALENDAR_A
Schema dbo
Row Count 9862
Data Size 896 KB
Index Size 192 KB
Create Date 11/5/2012 2:46 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
 
CAL_ACADEMIC_YEAR
varchar(7)
True
False
False
 
CAL_DATE
varchar(8)
True
False
False
 
CAL_DAY_DESC
varchar(8)
True
False
False
 
CAL_DAY_TYPE_CODE
varchar(8)
True
False
False
 
CAL_DAY_TYPE_SUB_CODE
varchar(8)
True
False
False
 
CAL_INVERT_DATE
varchar(8)
True
False
False
 
CAL_REASON_CODE
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FAC200_FACILITY_CALENDAR_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
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FAC200_FACILITY_CALENDAR_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FAC200_FACILITY_CALENDAR_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FAC200_FACILITY_CALENDAR_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FAC200_FACILITY_CALENDAR_A] Script Date: 03/09/2017 16:45:20 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FAC200_FACILITY_CALENDAR_A](
    [ISN_FAC200_FACILITY_CALENDAR_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,
    [CAL_ACADEMIC_YEAR] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAL_INVERT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAL_DAY_DESC] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAL_DAY_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAL_DAY_TYPE_SUB_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAL_REASON_CODE] [varchar](8) 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 CAL_ACADEMIC_YEAR CAL_DATE CAL_DAY_DESC CAL_DAY_TYPE_CODE CAL_DAY_TYPE_SUB_CODE CAL_INVERT_DATE CAL_REASON_CODE HOLD ISN_FAC200_FACILITY_CALENDAR_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RowUpdatedOn
20110504 FCC120N1 1213098 E001772 2015-16 20150726 79849273 1213098 8548 2017-02-06T11:18:14.421-05:00
19970611 FCC120N1 0906223 ZTJDM 1974-75 19750208 80249791 906223 1477 2017-02-06T11:18:14-05:00
20000927 FCC120N1 1330271 JFERGSN 2003-04 20030225 79969774 1330271 3690 2017-02-06T11:18:14.125-05:00
20110504 FCC120N1 1213161 E001772 2016-17 20160601 79839398 1213161 8839 2017-02-06T11:18:14.437-05:00
20000927 FCC120N1 1330227 JFERGSN 2002-03 20021210 79978789 1330227 3619 2017-02-06T11:18:14.125-05:00
20090903 FCC120N1 1436147 E001772 2011-12 20110331 79889668 1436147 6657 2017-02-06T11:18:14.312-05:00
20000927 FCC120N1 1330346 JFERGSN 2004-05 20040706 79959293 1330346 4170 2017-02-06T11:18:14.156-05:00
19970611 FCC120N1 0906243 ZTJDM 1975-76 19750802 80249197 906243 1652 2017-02-06T11:18:14.015-05:00
20061116 FCC120N1 1114535 E002073 2010-11 20100721 79899278 1239406 6241 20090903 FCC120N1 1239406 E001772 2017-02-06T11:18:14.281-05:00
20000131 FCC120N1 1010302 GPEDRSN 2000-01 20010121 79989878 1010302 2945 2017-02-06T11:18:14.078-05:00
Powered by BI Documenter