DWStaging
 dbo.FAC196_ACTIVITY_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.FAC196_ACTIVITY_A
  Properties
Property Value
Name FAC196_ACTIVITY_A
Schema dbo
Row Count 3362043
Data Size 429944 KB
Index Size 50136 KB
Create Date 8/15/2012 11:34 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACTIVITY_DATE
varchar(8)
True
False
False
 
ACTIVITY_END_TIME
varchar(4)
True
False
False
 
ACTIVITY_HEAD_COUNT
int(10, 0)
True
False
False
 
ACTIVITY_ROLLOVER_IND
varchar(1)
True
False
False
 
ACTIVITY_SEQ_NO
int(10, 0)
True
False
False
 
ACTIVITY_START_TIME
varchar(4)
True
False
False
 
ACTIVITY_STATUS_IND
varchar(1)
True
False
False
 
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
 
GROUP_FUNCTION_KEY
varchar(26)
True
False
False
 
GROUP_LOCATION_KEY
varchar(9)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INVENTORY_KEY
varchar(12)
True
False
False
 
ISN_FAC196_ACTIVITY_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
 
REQUEST_COMPLETED_DATE
varchar(8)
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
 
TIME_SEQ_NO
int(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FAC196_ACTIVITY_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FAC196_ACTIVITY_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FAC196_ACTIVITY_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FAC196_ACTIVITY_A] Script Date: 03/09/2017 16:45:19 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FAC196_ACTIVITY_A](
    [ISN_FAC196_ACTIVITY_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,
    [GROUP_FUNCTION_KEY] [varchar](26) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INVENTORY_KEY] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_SEQ_NO] [int] NULL,
    [GROUP_LOCATION_KEY] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_CUR_USE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_STYLE_SETUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_START_TIME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_END_TIME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_ROLLOVER_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUEST_COMPLETED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIME_SEQ_NO] [int] NULL,
    [ACTIVITY_STATUS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_HEAD_COUNT] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACTIVITY_DATE ACTIVITY_END_TIME ACTIVITY_HEAD_COUNT ACTIVITY_ROLLOVER_IND ACTIVITY_SEQ_NO ACTIVITY_START_TIME ACTIVITY_STATUS_IND ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID GROUP_FUNCTION_KEY GROUP_LOCATION_KEY HOLD INVENTORY_KEY ISN_FAC196_ACTIVITY_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID REQUEST_COMPLETED_DATE ROOM_CUR_USE_CODE ROOM_STYLE_SETUP_CODE RowUpdatedOn TIME_SEQ_NO
20000411 1145 30 293394 1030 B 19990810 FCS120N1 1138022 MSPENCER CLASS 14883 1 10000SCA 1138022 01020100101 163075 2017-02-06T10:28:45.675-05:00 103199
20070625 2145 36 2555850 1800 B 20060528 FCS120N1 1452190 E002073 CLASS 95830 1 20000BB 1452190 04011100303 1254855 2017-02-06T10:30:08.73-05:00 910674
20140515 1545 24 5049918 1200 B 20130405 FCS120N1 1403115 E002073 CLASS 182487 1 20000SC 1403115 04011600231 2565787 2017-02-06T10:31:52.674-05:00 1705819
20110214 1345 28 3824340 1230 B 20091214 FCS120N1 1959056 E002073 CLASS 139424 1 10000TL 1959056 01011600108 1904382 2017-02-06T10:31:02.316-05:00 1327963
20160824 1345 30 6178720 1230 B 20151130 FCS120N1 2235280 E002073 CLASS 216467 1 10000BA 2235280 01011200304 3011114 2017-02-06T10:32:23.609-05:00 2050087
20060405 1215 26 2039468 1100 B 20050209 FCS120N1 1157404 E001415 CLASS 78801 1 20000AA 1157404 04010200228 988923 2017-02-06T10:29:48.466-05:00 727268
20061120 2200 25 2532069 1800 B 20060328 FCS120N1 1538153 E006527 CLASS 88941 1 10000CRB 1538153 01041000109 1248379 2017-02-06T10:30:08.2-05:00 816522
20000307 1145 35 274936 1030 B 19990730 FCS120N1 1328134 ECASSIDY CLASS 13633 1 10000SS 1328134 01013200205 146571 2017-02-06T10:28:44.411-05:00 97321
20040630 2145 24 1620806 1800 B 20031202 FCS120N1 0212194 OPER2 CLASS 64017 1 20000LC 212194 04010700205 782623 2017-02-06T10:29:32.179-05:00 556539
20050621 1300 20 2000021 0900 B 20050126 FCS120N1 1521246 E005901 CLASS 76187 2 10000ETA 1521246 01012800223 961006 2017-02-06T10:29:46.328-05:00 710564
Powered by BI Documenter