DWStaging
 dbo.FAC193_ROOM_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.FAC193_ROOM_A
  Properties
Property Value
Name FAC193_ROOM_A
Schema dbo
Row Count 7399
Data Size 960 KB
Index Size 152 KB
Create Date 2/17/2014 1:29 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
 
COMMENTS
varchar(60)
True
False
False
 
EVENT_END_DATE
varchar(8)
True
False
False
 
EVENT_START_DATE
varchar(8)
True
False
False
 
EVENT_TYPE_CODE
varchar(8)
True
False
False
 
FACILITY_LOCAL_NUM
varchar(4)
True
False
False
 
FACILITY_NUM
int(10, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INVENTORY_KEY
varchar(12)
True
False
False
 
ISN_FAC193_ROOM_A
int(10, 0)
False
False
False
 
LOCATION_NUM
varchar(4)
True
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
 
REC_TYPE
varchar(1)
True
False
False
 
ROOM_CONDITION_CODE
varchar(8)
True
False
False
 
ROOM_ENROLLMENT_CAPACITY
int(10, 0)
True
False
False
 
ROOM_ICS_CODE
varchar(8)
True
False
False
 
ROOM_JOINT_USE_CODE
varchar(8)
True
False
False
 
ROOM_MAX_CAPACITY
int(10, 0)
True
False
False
 
ROOM_NAME
varchar(20)
True
False
False
 
ROOM_NET_SQUARE_FEET
int(10, 0)
True
False
False
 
ROOM_NUM
varchar(6)
True
False
False
 
ROOM_ONLINE_CODE
varchar(8)
True
False
False
 
ROOM_PURGE_DATE
varchar(8)
True
False
False
 
ROOM_STATIONS_TYPE
varchar(8)
True
False
False
 
ROOM_STUDENT_STATIONS
int(10, 0)
True
False
False
 
ROOM_STYLE_SETUP_CODE
varchar(8)
True
False
False
 
ROOM_USE_CODE
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SITE_LOCAL_NUM
varchar(1)
True
False
False
 
SITE_NUM
int(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FAC193_ROOM_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FAC193_ROOM_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FAC193_ROOM_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FAC193_ROOM_A] Script Date: 03/09/2017 16:45:17 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FAC193_ROOM_A](
    [ISN_FAC193_ROOM_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,
    [REC_TYPE] [varchar](1) 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,
    [SITE_NUM] [int] NULL,
    [FACILITY_NUM] [int] NULL,
    [ROOM_NUM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INVENTORY_KEY] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_USE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_NET_SQUARE_FEET] [int] NULL,
    [ROOM_ICS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_JOINT_USE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_CONDITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_PURGE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_ENROLLMENT_CAPACITY] [int] NULL,
    [ROOM_STUDENT_STATIONS] [int] NULL,
    [ROOM_STATIONS_TYPE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_ONLINE_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,
    [ROOM_MAX_CAPACITY] [int] NULL,
    [COMMENTS] [varchar](60) 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_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID COMMENTS EVENT_END_DATE EVENT_START_DATE EVENT_TYPE_CODE FACILITY_LOCAL_NUM FACILITY_NUM HOLD INVENTORY_KEY ISN_FAC193_ROOM_A LOCATION_NUM MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID REC_TYPE ROOM_CONDITION_CODE ROOM_ENROLLMENT_CAPACITY ROOM_ICS_CODE ROOM_JOINT_USE_CODE ROOM_MAX_CAPACITY ROOM_NAME ROOM_NET_SQUARE_FEET ROOM_NUM ROOM_ONLINE_CODE ROOM_PURGE_DATE ROOM_STATIONS_TYPE ROOM_STYLE_SETUP_CODE ROOM_USE_CODE RowUpdatedOn SITE_LOCAL_NUM SITE_NUM
20120323 FCI120N1 1145253 E000786 108 1145253 010108003005 6509 I 1 90000000 0 ELEVATOR LOBBY 103 003005 020 2017-02-06T11:21:04.134-05:00 1
20030211 FCI125N1 1021135 KMITEFF ETA 128 1552510 01012800224 4570 0000 20030211 FCI125N1 1552510 KMITEFF S 1 1 00224 ONLINE NONE MISSING 2017-02-06T11:21:03.978-05:00 1 1
20070801 FCI125N1 1440262 E000786 HT 107 1320095 09010700415 5306 0000 20090603 FCI125N1 1320095 E000786 S 1 1 00415 ONLINE NONE MISSING 2017-02-06T11:21:04.025-05:00 5 9
19971120 CP008PC 1550392 107 040107001141 1587 I 1 10000000 0 CLOSET 17 001141 115 2017-02-06T11:21:03.698-05:00 4
19971120 CP008PC 1550068 AH 208 1449500 01020800217 1035 0000 20130104 FCI120N1 1449500 E000786 I 1 73000000 0 CUSTODIAL 52 00217 010 2017-02-06T11:21:03.635-05:00 1 1
19971120 CP008PC 1551062 101 1501206 09010100121 2056 19990820 FCI120N1 1501205 KMITEFF I 1 10000000 0 OFFICE 115 00121 310 2017-02-06T11:21:03.744-05:00 9
19971120 CP008PC 1551139 102 09010200305 2175 I 1 90000000 0 CORRIDOR 49 00305 020 2017-02-06T11:21:03.744-05:00 9
20031002 FCI120N1 1016524 E000786 104 939369 09010400111 4735 20151218 FCI120N1 0939369 E000786 I 1 10000000 0 OFFICE 144 00111 310 2017-02-06T11:21:03.978-05:00 9
20101014 FCI120N1 0938458 E000786 128 912204 010128001324 6139 20151124 FCI120N1 0912204 E000786 I 1 10000000 0 OFFICE 128 001324 310 2017-02-06T11:21:04.103-05:00 1
19971120 CP008PC 1550402 107 1009091 04010700128 1605 20030903 FCI120N1 1009091 E000786 I 1 90000000 0 RESTROOM (W) 233 00128 030 2017-02-06T11:21:03.698-05:00 4
Powered by BI Documenter