DWStaging
 dbo.POSITION_BUDGET_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.POSITION_BUDGET_A
  Properties
Property Value
Name POSITION_BUDGET_A
Schema dbo
Row Count 278685
Data Size 18328 KB
Index Size 4584 KB
Create Date 11/5/2012 9:54 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCOUNT_CODE
varchar(25)
True
False
False
 
ACCOUNT_CODE_END_DATE
varchar(8)
True
False
False
 
ACCOUNT_CODE_START_DATE
varchar(8)
True
False
False
 
ACCOUNT_FISCAL_YEAR
varchar(4)
True
False
False
 
ACCOUNT_PERC
numeric(17, 4)
True
False
False
 
ACCOUNT_POSITION_CODE
varchar(8)
True
False
False
 
ACCOUNT_PRIMARY_IND
bit(1, 0)
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
 
BEN_FISCAL_YEAR
varchar(4)
True
False
False
 
BEN_ORIGINAL_BUDGET_AMT
numeric(17, 2)
True
False
False
 
BEN_POSITION_CODE
varchar(8)
True
False
False
 
BENEFIT_IND
bit(1, 0)
True
False
False
 
BENEFIT_TYPE_CODE
varchar(8)
True
False
False
 
BUDGET_ESTABLISHED_IND
bit(1, 0)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOURS_BUDGETED
numeric(17, 2)
True
False
False
 
ISN_POSITION_BUDGET_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
 
ORIGINAL_BUDGET_AMT
numeric(17, 2)
True
False
False
 
OVERTIME_IND
bit(1, 0)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
REVISED_BUDGET_AMT
numeric(17, 2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_POSITION_BUDGET_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.POSITION_BUDGET_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.POSITION_BUDGET_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[POSITION_BUDGET_A] Script Date: 03/09/2017 16:45:50 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[POSITION_BUDGET_A](
    [ISN_POSITION_BUDGET_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,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORIGINAL_BUDGET_AMT] [numeric](17, 2) NULL,
    [REVISED_BUDGET_AMT] [numeric](17, 2) NULL,
    [HOURS_BUDGETED] [numeric](17, 2) NULL,
    [BENEFIT_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BEN_POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BEN_ORIGINAL_BUDGET_AMT] [numeric](17, 2) NULL,
    [ACCOUNT_POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_CODE] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_PERC] [numeric](17, 4) NULL,
    [ACCOUNT_PRIMARY_IND] [bit] NULL,
    [OVERTIME_IND] [bit] NULL,
    [BENEFIT_IND] [bit] NULL,
    [ACCOUNT_CODE_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_CODE_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUDGET_ESTABLISHED_IND] [bit] NULL,
    [BEN_FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCOUNT_CODE ACCOUNT_CODE_END_DATE ACCOUNT_CODE_START_DATE ACCOUNT_FISCAL_YEAR ACCOUNT_PERC ACCOUNT_POSITION_CODE ACCOUNT_PRIMARY_IND ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BEN_FISCAL_YEAR BEN_POSITION_CODE BENEFIT_IND BENEFIT_TYPE_CODE BUDGET_ESTABLISHED_IND FISCAL_YEAR HOLD HOURS_BUDGETED ISN_POSITION_BUDGET_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID ORIGINAL_BUDGET_AMT OVERTIME_IND POSITION_CODE REVISED_BUDGET_AMT RowUpdatedOn
false 20051121 PEP270N1 1020415 E001501 false false 2006 1335232 124521 20051123 PEP270N1 1335231 E001676 false SAD6TR02 2017-02-06T10:38:28.261-05:00
170200007020023057000 20100630 20090701 2010 100.0000 GRN3OPSM true false false 176470 false 2017-02-06T10:38:32.27-05:00
false 20110614 PEP250B1 0848282 E001501 false false 2012 848282 214455 1.00 false ELC1ADJS 1.00 2017-02-06T10:38:35.452-05:00
147010004701009356500 20010630 20000701 2001 100.0000 SPD6OPRF true false false 31781 false 2017-02-06T10:38:20.788-05:00
false 2016 DCA_0008 false FLRETRA false 267768 false 2017-02-06T10:38:40.039-05:00
false 2008 ENG1YB01 false MEDICARE false 148170 false 2017-02-06T10:38:30.07-05:00
false 19980806 PEP270N1 1729271 ECHEEVER false false 1999 1427189 2080.00 9741 19990628 PEP270N1 1427188 OPER2 35068.90 false 6015 26166.48 2017-02-06T10:38:18.948-05:00
false 2010 APB3OSUB false MEDICARE false 193643 false 2017-02-06T10:38:33.643-05:00
111607001607001052000 20140630 20130816 2014 50.0000 3205 true false false 243442 false 2017-02-06T10:38:38.011-05:00
false 2004 DRM1OSUB false SOCSEC false 88289 false 2017-02-06T10:38:25.453-05:00
Powered by BI Documenter