DWStaging
 dbo.ST_CLASS_INSTR_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_CLASS_INSTR_A
  Properties
Property Value
Name ST_CLASS_INSTR_A
Schema dbo
Row Count 242718
Data Size 34104 KB
Index Size 3632 KB
Create Date 8/15/2012 12:45 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
 
CLASS_KEY
varchar(25)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INLOAD_ASSGN_SEQ
int(10, 0)
True
False
False
 
INLOAD_LOAD_FAC
numeric(17, 2)
True
False
False
 
INLOAD_POS_CD
varchar(8)
True
False
False
 
INSTR_ID
varchar(9)
True
False
False
 
INSTR_PRIM
varchar(1)
True
False
False
 
ISN_ST_CLASS_INSTR_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
 
MAX_LOAD_CD
varchar(8)
True
False
False
 
OVERLD_ASSGN_SEQ
int(10, 0)
True
False
False
 
OVERLD_LOAD_FAC
numeric(17, 2)
True
False
False
 
OVERLD_POS_CD
varchar(8)
True
False
False
 
OVERLD_SEQ_NO
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_CLASS_INSTR_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_CLASS_INSTR_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_CLASS_INSTR_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_CLASS_INSTR_A] Script Date: 03/09/2017 16:45:58 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_CLASS_INSTR_A](
    [ISN_ST_CLASS_INSTR_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,
    [HOLD] [int] 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,
    [CLASS_KEY] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INSTR_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INSTR_PRIM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAX_LOAD_CD] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INLOAD_POS_CD] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INLOAD_LOAD_FAC] [numeric](17, 2) NULL,
    [INLOAD_ASSGN_SEQ] [int] NULL,
    [OVERLD_POS_CD] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OVERLD_LOAD_FAC] [numeric](17, 2) NULL,
    [OVERLD_SEQ_NO] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OVERLD_ASSGN_SEQ] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CLASS_KEY HOLD INLOAD_ASSGN_SEQ INLOAD_LOAD_FAC INLOAD_POS_CD INSTR_ID INSTR_PRIM ISN_ST_CLASS_INSTR_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAX_LOAD_CD OVERLD_POS_CD OVERLD_SEQ_NO RowUpdatedOn
20021022 STC670N0 1458294 DKLEIN NEMO0190 20031 19 058 1552091 0.70 PSC1ADJU 000004137 Y 23656 20021022 STC670N0 1552090 DKLEIN PARTTIME 2017-02-06T10:42:35.85-05:00
20040831 STC670N0 0824393 E002073 CENC0010 20052 2 005 820322 9.00 CPI2ADJS 000010823 Y 63044 20050302 STC670N0 0820322 E011832 PARTTIME 2017-02-06T10:42:39.142-05:00
20050831 STC670N0 0358277 OPER2 CMAT0012 20071 1 015 916597 8 9.00 MAP1ADJS 000002832 Y 83416 20060817 STC670N0 0916597 E002304 PARTTIME 2017-02-06T10:42:40.904-05:00
20120604 STC670N0 2212330 E002073 CPHY1001 20132 2 002 1155085 75 9.00 PHY2ADJS 000029452 Y 172417 20130111 STC670N0 1155084 E000968 PARTTIME 2017-02-06T10:42:48.361-05:00
20160914 STC670N0 1406172 E000230 CMVW2325 R 20172 1 001 1406259 MUS1ADJS 000006824 Y 222731 PARTTIME 2017-02-06T10:42:52.308-05:00
20160106 STC670N0 0944339 E062717 NFFP0010 20162 1 001 1451324 93 FIR1ADJU 000001404 N 214185 20160106 STC670N0 1451323 E062717 PARTTIME 2017-02-06T10:42:51.684-05:00
20081103 STC670N0 2037499 E002073 CBSC1050 20101 2 001 1104399 13 9.00 3150 000002019 Y 127459 20090820 STC670N0 1104398 E000968 FULLTIME 2017-02-06T10:42:44.602-05:00
20140903 STC670N0 1248175 E005901 NCJK0205 20151 1 001 1248297 JAI1ADJU 000013435 N 197607 20140903 STC670N0 1248296 E005901 PARTTIME 2017-02-06T10:42:50.389-05:00
20110225 STC670N0 0843449 E000565 NCJK0062 20111 1 002 843501 21 CJTCADJU 000047872 N 152054 20110225 STC670N0 0843500 E000565 PARTTIME 2017-02-06T10:42:46.661-05:00
20111118 STC670N0 1117151 E002073 CSPN1120 20131 5 002 1123382 4 12.00 3194 000072621 Y 159634 20120806 STC670N0 1123382 E047564 FULLTIME 2017-02-06T10:42:47.285-05:00
Powered by BI Documenter