DWStaging
 dbo.FAC194_EVENT_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.FAC194_EVENT_A
  Properties
Property Value
Name FAC194_EVENT_A
Schema dbo
Row Count 49176
Data Size 9624 KB
Index Size 776 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
 
ADDR_APT_SUITE_NUM
varchar(15)
True
False
False
 
ADDR_CITY_CODE
varchar(20)
True
False
False
 
ADDR_STATE_CODE
varchar(2)
True
False
False
 
ADDR_STREET_DIRECTION
varchar(2)
True
False
False
 
ADDR_STREET_NAME
varchar(30)
True
False
False
 
ADDR_STREET_NUM
varchar(6)
True
False
False
 
ADDR_TYPE_CODE
varchar(30)
True
False
False
 
ADDR_ZIP_CODE
varchar(9)
True
False
False
 
CUSTOMER_ID
varchar(9)
True
False
False
 
EVENT_CONTACT_AREA_CODE
varchar(3)
True
False
False
 
EVENT_CONTACT_DEPARTMENT
varchar(40)
True
False
False
 
EVENT_CONTACT_EXCHANGE
varchar(3)
True
False
False
 
EVENT_CONTACT_EXTENSION
varchar(5)
True
False
False
 
EVENT_CONTACT_LOCATION
varchar(40)
True
False
False
 
EVENT_CONTACT_NAME
varchar(40)
True
False
False
 
EVENT_CONTACT_NUMBER
varchar(4)
True
False
False
 
EVENT_CONTACT_TYPE_CODE
varchar(8)
True
False
False
 
EVENT_END_DATE
varchar(8)
True
False
False
 
EVENT_HEAD_COUNT
int(10, 0)
True
False
False
 
EVENT_KEY
varchar(9)
True
False
False
 
EVENT_REQUESTOR_NAME
varchar(40)
True
False
False
 
EVENT_REQUESTOR_ORG
varchar(40)
True
False
False
 
EVENT_START_DATE
varchar(8)
True
False
False
 
EVENT_STATUS_IND
varchar(1)
True
False
False
 
EVENT_TITLE
varchar(50)
True
False
False
 
EVENT_TYPE_CODE
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FAC194_EVENT_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_FAC194_EVENT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FAC194_EVENT_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FAC194_EVENT_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FAC194_EVENT_A] Script Date: 03/09/2017 16:45:18 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FAC194_EVENT_A](
    [ISN_FAC194_EVENT_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,
    [EVENT_KEY] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_TITLE] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_HEAD_COUNT] [int] NULL,
    [EVENT_STATUS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_REQUESTOR_ORG] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_REQUESTOR_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_TYPE_CODE] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_STREET_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_STREET_NUM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_STREET_DIRECTION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_APT_SUITE_NUM] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_CITY_CODE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_STATE_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_ZIP_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_CONTACT_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_CONTACT_DEPARTMENT] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_CONTACT_LOCATION] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_CONTACT_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_CONTACT_AREA_CODE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_CONTACT_EXCHANGE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_CONTACT_NUMBER] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVENT_CONTACT_EXTENSION] [varchar](5) 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 ADDR_APT_SUITE_NUM ADDR_CITY_CODE ADDR_STATE_CODE ADDR_STREET_DIRECTION ADDR_STREET_NAME ADDR_STREET_NUM ADDR_TYPE_CODE ADDR_ZIP_CODE CUSTOMER_ID EVENT_CONTACT_AREA_CODE EVENT_CONTACT_DEPARTMENT EVENT_CONTACT_EXCHANGE EVENT_CONTACT_EXTENSION EVENT_CONTACT_LOCATION EVENT_CONTACT_NAME EVENT_CONTACT_NUMBER EVENT_CONTACT_TYPE_CODE EVENT_END_DATE EVENT_HEAD_COUNT EVENT_KEY EVENT_REQUESTOR_NAME EVENT_REQUESTOR_ORG EVENT_START_DATE EVENT_STATUS_IND EVENT_TITLE EVENT_TYPE_CODE HOLD ISN_FAC194_EVENT_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RowUpdatedOn
20130409 FCS110N1 1503054 E005408 14109 SANDRA LIVINGSTON 20130501 30 D0231 DR. JIHAN MAHMOUD 20130501 B DEFENSE OF THE CAPSTONE PROJECT LECTURE 1503117 36743 20130409 FCS110N1 1503116 E005408 2017-02-06T11:17:13.612-05:00
20061011 FCS110N1 1002418 E001146 25401 SUE LEVINE 20061106 20 E4062 FRANK ATKINS 20061106 B FACILITIES WORK ORDERS MEETING 949378 17263 20061017 FCS110N1 0949378 E001146 2017-02-06T11:17:11.553-05:00
20140107 FCS110N1 1540536 E000469 561 SBDC 862 AD304 JACKIE RULE 4781 20140227 5 S02746 20140227 B SBDC EDUCATIONAL MEETING MEETING 1540554 39387 20140107 FCS110N1 1540554 E000469 2017-02-06T11:17:13.924-05:00
20050124 FCS110N1 1741371 E010885 13230 O ROCHA 20050407 400 C6859 K HARTWIG 20050207 B HVAC SEMINAR SEMINAR 1454353 12654 20050406 FCS110N1 1454352 E010885 2017-02-06T11:17:11.038-05:00
20001211 FCS110N1 2103056 BLOOMFIY 1382 YERIMYE BLOOMFIELD 20010103 20 C1128 MAGDALA RAY 20010103 B DIVISION MTG/COMMUNICATION & MATH MEETING 2103091 3334 20001211 FCS110N1 2103090 BLOOMFIY 2017-02-06T11:17:10.071-05:00
20141027 FCS110N1 1526327 E072917 25401 SANDRA LEMBO 20141120 30 E101736 JENNIFER EVANS 20141120 B WELLNESS CENTER-SMOKING CESSATION LECTURE MEETING 1526349 42362 20141027 FCS110N1 1526349 E072917 2017-02-06T11:17:14.205-05:00
20001206 FCS110N1 0846159 SLEVINE 561 625 SUE LEVINE 2545 20010222 20 E0598 JUDITH BOUTIETTE 20010222 B VTEL HONORS ORIENTATION MEETING 851398 3308 20001206 FCS110N1 0851396 SLEVINE 2017-02-06T11:17:10.071-05:00
20020321 FCS110N1 1536545 SLEVINE 561 207 SUE LEVINE 5401 20020326 10 E1106 VIRGINIA BROOKS 20020326 B PLANNING COMMITTEE MEETING 1536580 5990 20020321 FCS110N1 1536580 SLEVINE 2017-02-06T11:17:10.32-05:00
20030926 FCS110N1 1020528 E000719 561 INFO TECH 868 IT208 - CENTRAL JUDY FERGUSON 3242 20031006 12 C94492 20031006 B SR. SYSTEMS ANALYST INTERVIEW MEETING 1020554 9295 20030926 FCS110N1 1020554 E000719 2017-02-06T11:17:10.679-05:00
20121218 FCS110N1 1518209 E005408 14109 SANDRA LIVINGSTON 20130508 144 D0131 CHERIE HANNA 20130508 B BACHELOR'S GRADUATION RECEPTION RECEPT 1223267 35873 20130311 FCS110N1 1223267 E005408 2017-02-06T11:17:13.518-05:00
Powered by BI Documenter