DWStaging
 dbo.ST_INSTR_PAY_SCHEDULE_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.ST_INSTR_PAY_SCHEDULE_A
  Properties
Property Value
Name ST_INSTR_PAY_SCHEDULE_A
Schema dbo
Row Count 627
Data Size 72 KB
Index Size 48 KB
Create Date 2/12/2013 12:59 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_TERMINAL_ID
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
DEGREE_CODE
varchar(8)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOURLY_RATE
numeric(19, 2)
True
False
False
 
INSTR_HOURS
numeric(17, 2)
True
False
False
 
ISN_ST_INSTR_PAY_SCHEDULE_A
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TERMINAL_ID
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
PAY_METHOD
varchar(2)
True
False
False
 
RATE_DOLLAR_AMOUNT
numeric(17, 4)
True
False
False
 
RATE_PROGRAM
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
START_DATE
varchar(8)
True
False
False
 
START_DATE_9C
int(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_INSTR_PAY_SCHEDULE_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_INSTR_PAY_SCHEDULE_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_INSTR_PAY_SCHEDULE_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_INSTR_PAY_SCHEDULE_A] Script Date: 03/09/2017 16:46:10 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_INSTR_PAY_SCHEDULE_A](
    [ISN_ST_INSTR_PAY_SCHEDULE_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_TERMINAL_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_TERMINAL_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,
    [DEGREE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_METHOD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INSTR_HOURS] [numeric](17, 2) NULL,
    [RATE_DOLLAR_AMOUNT] [numeric](17, 4) NULL,
    [RATE_PROGRAM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE_9C] [int] NULL,
    [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOURLY_RATE] [numeric](19, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TERMINAL_ID ADD_TIME ADD_USER_ID DEGREE_CODE END_DATE HOLD INSTR_HOURS ISN_ST_INSTR_PAY_SCHEDULE_A MAINT_DATE MAINT_PGM MAINT_TERMINAL_ID MAINT_TIME MAINT_USER_ID PAY_METHOD RATE_DOLLAR_AMOUNT RATE_PROGRAM RowUpdatedOn START_DATE START_DATE_9C
20160421 ITS375N1 1342287 E000117 1 20160815 1442008 1.00 611 20160810 ITS375N1 1442008 E000117 PL 31.2900 STC914N4 2017-02-06T11:34:48.257-05:00 20160408 79839591
20151119 ITS375N1 1258165 E000117 6 20160815 851260 1.00 406 20160721 ITS375N1 0851260 E000117 IS 35.1800 XTC913N1 2017-02-06T11:34:48.225-05:00 20160101 79839898
20130716 ITS375N1 1251168 E020563 3 20151231 1443192 1.00 123 20151117 ITS375N1 1443192 E000117 DL 38.3500 STC914N4 2017-02-06T11:34:48.21-05:00 20130816 79869183
20120822 ITS375N1 0806085 E020563 LLASSOCP 20160731 1353384 1.00 118 20161129 ITS375N1 1353384 E006065 OC 38.4900 XTC915N1 2017-02-06T11:34:48.21-05:00 20050101 79949898
20050322 ITS375N1 1631558 E020563 1 1631558 1.00 39 PI 1.0000 STC914N3 2017-02-06T11:34:48.194-05:00 20050101 79949898
20130716 ITS375N1 1314489 E020563 9 20151231 1008031 1.00 163 20151118 ITS375N1 1008031 E000117 HA 27.2000 STC914N4 2017-02-06T11:34:48.21-05:00 20130816 79869183
20110706 ITS375N1 1404090 E020563 3 20130815 1405179 1.00 88 20130716 ITS375N1 1405179 E020563 IN 33.2400 XTC913N1 2017-02-06T11:34:48.21-05:00 20110816 79889183
20160421 ITS375N1 1349220 E000117 8 20160815 1427062 1.00 425 20160810 ITS375N1 1427062 E000117 PL 29.5100 STC914N4 2017-02-06T11:34:48.225-05:00 20160408 79839591
20110706 ITS375N1 1513542 E020563 9 20130815 1303410 1.00 315 20130716 ITS375N1 1303410 E020563 HL 37.3700 STC914N4 2017-02-06T11:34:48.225-05:00 20110816 79889183
20050126 ITS375N1 1011222 E000920 OVLD 1011222 1.00 15 OC 38.4900 XTC912N1 2017-02-06T11:34:48.194-05:00 20050101 79949898
Powered by BI Documenter