DWStaging
 dbo.TRVL_TABLE_A (Table)
  Properties
Property Value
Name TRVL_TABLE_A
Schema dbo
Row Count 2
Data Size 8 KB
Index Size 24 KB
Create Date 10/24/2012 4:04 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
 
CC_COMPANY
varchar(9)
True
False
False
 
CC_COMPANY_SEQ_NBR
int(10, 0)
True
False
False
 
DEPARTURE_CITY
varchar(15)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_TRVL_TABLE_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
 
MILE_RATE
numeric(17, 3)
True
False
False
 
RECEIV_GL_CODE
varchar(5)
True
False
False
 
RECEIV_QUAL_2
varchar(4)
True
False
False
 
RENTAL_CAR_RATE
numeric(17, 2)
True
False
False
 
RETURN_CITY
varchar(15)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SITE_LOCAL_NUM
varchar(1)
True
False
False
 
START_DATE
varchar(8)
True
False
False
 
TOLERANCE
varchar(2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_TRVL_TABLE_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.TRVL_TABLE_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.TRVL_TABLE_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[TRVL_TABLE_A] Script Date: 03/09/2017 16:46:34 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[TRVL_TABLE_A](
    [ISN_TRVL_TABLE_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,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIV_GL_CODE] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIV_QUAL_2] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOLERANCE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MILE_RATE] [numeric](17, 3) NULL,
    [RENTAL_CAR_RATE] [numeric](17, 2) NULL,
    [DEPARTURE_CITY] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RETURN_CITY] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SITE_LOCAL_NUM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_COMPANY] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_COMPANY_SEQ_NBR] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CC_COMPANY CC_COMPANY_SEQ_NBR DEPARTURE_CITY END_DATE HOLD ISN_TRVL_TABLE_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MILE_RATE RECEIV_GL_CODE RECEIV_QUAL_2 RENTAL_CAR_RATE RETURN_CITY RowUpdatedOn SITE_LOCAL_NUM START_DATE TOLERANCE
19980519 FIT041N 1048072 MCOOPER LAKE WORTH 1642585 1 19980522 FIT041N 1642585 MCOOPER LAKE WORTH 2017-02-06T11:33:15.233-05:00
20150320 FIT040N1 1552304 E014684 510313900 8 20180630 1518568 2 20151214 FIT040N1 1518568 E014684 0.445 13002 40.00 2017-02-06T11:33:15.249-05:00 20140701 04
Powered by BI Documenter