DWStaging
 dbo.FAC199_LOCATION_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.FAC199_LOCATION_A
  Properties
Property Value
Name FAC199_LOCATION_A
Schema dbo
Row Count 10
Data Size 8 KB
Index Size 24 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
ACTIVE_LOCATION_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
 
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
 
FINANCE_LOCATION
int(10, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FAC199_LOCATION_A
int(10, 0)
False
False
False
 
LOCATION_NAME
varchar(50)
True
False
False
 
LOCATION_NUM
varchar(4)
True
False
False
 
LOCATION_TYPE_CODE
varchar(8)
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
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SITE_LOCAL_NUM
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FAC199_LOCATION_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FAC199_LOCATION_A depends on)
Name Type
View
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.FAC199_LOCATION_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FAC199_LOCATION_A] Script Date: 03/09/2017 16:45:19 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FAC199_LOCATION_A](
    [ISN_FAC199_LOCATION_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,
    [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,
    [LOCATION_NAME] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOCATION_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FINANCE_LOCATION] [int] 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,
    [ACTIVE_LOCATION_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACTIVE_LOCATION_IND 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 FINANCE_LOCATION HOLD ISN_FAC199_LOCATION_A LOCATION_NAME LOCATION_NUM LOCATION_TYPE_CODE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RowUpdatedOn SITE_LOCAL_NUM
Y 20151103 FCI130N1 0853400 E000786 LOXAHATCHEE FL SOUTHERN BOULEVARD 15845 33470 40 1006321 10 LOXAHATCHEE GROVES 9 2 20161102 FCI130N1 1006320 E088197 2017-02-06T11:28:17.084-05:00 4
Y 20050609 FCI130N1 1139263 E002073 LAKE WORTH FL CONGRESS AVENUE 4200 33461 10 1538009 1 LAKE WORTH OFF-CAMP 9 2 20161028 FCI130N1 1538009 E088197 2017-02-06T11:28:17.068-05:00 1
Y 20060405 FCI130N1 1613015 E021127 20 1318062 2 PB GARDENS OFF-CAMP 9 2 20160820 FCI130N1 1318062 E000318 2017-02-06T11:28:17.084-05:00 2
Y 20071212 FCI130N1 1332187 E021127 LAKE WORTH FL CONGRESS AVENUE 4200 33461 10 1503056 7 LAKE WORTH 0000 1 20170106 FCI130N1 1503055 E088197 2017-02-06T11:28:17.084-05:00 1
Y 20150528 FCI130N1 1736590 E023242 BELLE GLADE FL COLLEGE DRIVE 1977 33430 30 739591 4 BELLE GLADE 0000 1 20170111 FCI130N1 0739590 E088197 2017-02-06T11:28:17.084-05:00 3
Y 19980326 FCI130N1 0816334 GPEDERSE 30 1055325 5 BELLE GLADE OFF-CAMP 9 2 20160329 FCI130N1 1055324 E000318 2017-02-06T11:28:17.084-05:00 3
Y 19980326 FCI130N1 0816473 GPEDERSE 50 1035105 3 BOCA RATON OFF-CAMP 9 2 20161118 FCI130N1 1035105 E088197 2017-02-06T11:28:17.084-05:00 5
Y 19980326 FCI130N1 0814550 GPEDERSE BOCA RATON FL SAINT LUCIE BLVD. 3000 33431 50 1034495 6 BOCA RATON 0000 1 20161118 FCI130N1 1034495 E088197 2017-02-06T11:28:17.084-05:00 5
Y 20151103 FCI130N1 0853144 E000786 LOXAHATCHEE FL SOUTHERN BOULEVARD 15845 33470 40 839240 9 LOXAHATCHEE GROVES 0000 1 20161025 FCI130N1 0839239 E000318 2017-02-06T11:28:17.084-05:00 4
Y 20080408 FCI130N1 0912372 E001231 PALM BEACH GARDENS FL PGA BLVD 3160 33410 20 1035419 8 PB GARDENS 0000 1 20161102 FCI130N1 1035419 E088197 2017-02-06T11:28:17.084-05:00 2
Powered by BI Documenter