DWStaging
 dbo.FAC195_SCHEDULE_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.FAC195_SCHEDULE_A
  Properties
Property Value
Name FAC195_SCHEDULE_A
Schema dbo
Row Count 83002
Data Size 7976 KB
Index Size 1656 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
EVENT_KEY
varchar(9)
True
False
False
 
FACILITY_LOCAL_NUM
varchar(4)
True
False
False
 
INVENTORY_KEY
varchar(12)
True
False
False
 
ISN_FAC195_SCHEDULE_A
int(10, 0)
False
False
False
 
LOCATION_NUM
varchar(4)
True
False
False
 
ROOM_CUR_USE_CODE
varchar(8)
True
False
False
 
ROOM_STYLE_SETUP_CODE
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SCHEDULE_BREAK_DOWN_TIME
varchar(4)
True
False
False
 
SCHEDULE_END_DATE
varchar(8)
True
False
False
 
SCHEDULE_END_TIME
varchar(4)
True
False
False
 
SCHEDULE_HEAD_COUNT
int(10, 0)
True
False
False
 
SCHEDULE_KEY
varchar(9)
True
False
False
 
SCHEDULE_SETUP_TIME
varchar(4)
True
False
False
 
SCHEDULE_START_DATE
varchar(8)
True
False
False
 
SCHEDULE_START_TIME
varchar(4)
True
False
False
 
SCHEDULE_STATUS_IND
varchar(1)
True
False
False
 
SITE_LOCAL_NUM
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FAC195_SCHEDULE_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FAC195_SCHEDULE_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FAC195_SCHEDULE_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FAC195_SCHEDULE_A] Script Date: 03/09/2017 16:45:18 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FAC195_SCHEDULE_A](
    [ISN_FAC195_SCHEDULE_A] [int] NOT NULL,
    [EVENT_KEY] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_KEY] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SITE_LOCAL_NUM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOCATION_NUM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FACILITY_LOCAL_NUM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INVENTORY_KEY] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_HEAD_COUNT] [int] NULL,
    [SCHEDULE_STATUS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_START_TIME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_END_TIME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_SETUP_TIME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_BREAK_DOWN_TIME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_STYLE_SETUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_CUR_USE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
EVENT_KEY FACILITY_LOCAL_NUM INVENTORY_KEY ISN_FAC195_SCHEDULE_A LOCATION_NUM ROOM_CUR_USE_CODE ROOM_STYLE_SETUP_CODE RowUpdatedOn SCHEDULE_BREAK_DOWN_TIME SCHEDULE_END_DATE SCHEDULE_END_TIME SCHEDULE_HEAD_COUNT SCHEDULE_KEY SCHEDULE_SETUP_TIME SCHEDULE_START_DATE SCHEDULE_START_TIME SCHEDULE_STATUS_IND SITE_LOCAL_NUM
S02857 BT 09010400118 66786 0000 110 CLASSRM 2017-02-06T11:14:18.064-05:00 20140425 1130 20 MEETING 20140425 1000 B 5
C13016 HU 01012000114 41333 0000 210 LAB 2017-02-06T11:14:16.488-05:00 20090307 2200 40 WORKSHOP6 20090307 0900 B 1
S06225 HT 09010700103 34187 0000 680 CONFRM 2017-02-06T11:14:16.036-05:00 20161026 1730 50 MEETING 2 20161026 0800 B 5
E8133 LL 04010400234 2266 0000 110 CLASSRM 2017-02-06T11:14:14.023-05:00 20120215 1500 20 WORKSHOP 20120215 1200 B 2
C12764 TE 01023000104 40327 0000 210 LAB 2017-02-06T11:14:16.426-05:00 20081118 1000 40 MEETING 20081118 0730 B 1
C0356 SCA 01020100131 1862 0000 110 CLASSRM 2017-02-06T11:14:13.992-05:00 20000505 1330 25 MEETING1 20000105 1230 B 1
C13842 NS 01050100129 44759 0000 110 CLASSRM 2017-02-06T11:14:16.707-05:00 20090923 1300 20 MEETING 20090923 1045 N 1
E4793 LC 04010700106 36440 0000 350 CONFRM 2017-02-06T11:14:16.161-05:00 20080122 1500 10 MEETING 20080122 1300 B 2
E7439 SC 04011600127 52990 0000 610 AUD 2017-02-06T11:14:17.237-05:00 20120424 2200 10 MEETING14 20120424 1200 B 2
E1192 LL 04010400222 10586 0000 210 LAB 2017-02-06T11:14:14.523-05:00 20020819 2100 18 MEETING3 20020819 1900 B 2
Powered by BI Documenter