DWStaging
 dbo.BUDGET_PREP_FILE (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.BUDGET_PREP_FILE
  Properties
Property Value
Name BUDGET_PREP_FILE
Schema dbo
Row Count 95965
Data Size 10232 KB
Index Size 1472 KB
Create Date 10/24/2012 1:57 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
 
BUDGET_HEADER_TOTAL_DEFAULT
varchar(1)
True
False
False
 
BUDGET_IND
varchar(1)
True
False
False
 
BUDGET_MANAGER
varchar(9)
True
False
False
 
BUDGET_ORG_UNIT
varchar(16)
True
False
False
 
BUILD_FROM_FISCAL_YEAR
varchar(4)
True
False
False
 
BUILD_NEXT_ITER_FROM
int(10, 0)
True
False
False
 
CONTROL_ACCT_NO
varchar(25)
True
False
False
 
CONTROL_IND
varchar(1)
True
False
False
 
CONTROL_TOTAL_IND
varchar(1)
True
False
False
 
DISTRIBUTION
varchar(4)
True
False
False
 
FISCAL_MANAGER
varchar(9)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
FRINGE_IND
varchar(1)
True
False
False
 
FROM_GL_CODE
varchar(9)
True
False
False
 
FROM_ORG_UNIT
varchar(16)
True
False
False
 
GL_ACCT_NO
varchar(25)
True
False
False
 
GL_ACCT_NO_2
varchar(25)
True
False
False
 
GL_CODE_DESCRIPTION
varchar(30)
True
False
False
 
GL_CODE_FOR_FRINGE
varchar(5)
True
False
False
 
GL_CODE_FOR_FRINGE_DESC
varchar(15)
True
False
False
 
GL_PARM_CODE
varchar(2)
True
False
False
 
GL_TYPE
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_BUDGET_PREP_FILE
int(10, 0)
False
False
False
 
ITERATION_NO
int(10, 0)
True
False
False
 
LAST_ITER_MOD_DATE
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
 
NEXT_ITER_NO
int(10, 0)
True
False
False
 
ORG_TITLE
varchar(40)
True
False
False
 
PERCENT
numeric(17, 2)
True
False
False
 
POST_CALENDAR_PERIOD
varchar(6)
True
False
False
 
PRINCIPAL_ADMIN
varchar(9)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
TO_GL_CODE
varchar(9)
True
False
False
 
TO_ORG_UNIT
varchar(16)
True
False
False
 
TOTAL_ORG_UNIT
varchar(16)
True
False
False
 
USER_ITER_NO
int(10, 0)
True
False
False
 
USER_UPDATE_CODE
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_BUDGET_PREP_FILE
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.BUDGET_PREP_FILE depends on)
Name Type
  Child Dependencies (objects that depend on dbo.BUDGET_PREP_FILE)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[BUDGET_PREP_FILE] Script Date: 03/09/2017 16:45:07 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[BUDGET_PREP_FILE](
    [ISN_BUDGET_PREP_FILE] [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,
    [FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTROL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUDGET_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FRINGE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUDGET_ORG_UNIT] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUDGET_MANAGER] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRINCIPAL_ADMIN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_TITLE] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTROL_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISTRIBUTION] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOTAL_ORG_UNIT] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_CODE_DESCRIPTION] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FROM_ORG_UNIT] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TO_ORG_UNIT] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ITERATION_NO] [int] NULL,
    [PERCENT] [numeric](17, 2) NULL,
    [FROM_GL_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TO_GL_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_PARM_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_ACCT_NO_2] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTROL_TOTAL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FISCAL_MANAGER] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUILD_NEXT_ITER_FROM] [int] NULL,
    [NEXT_ITER_NO] [int] NULL,
    [USER_ITER_NO] [int] NULL,
    [USER_UPDATE_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_ITER_MOD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUILD_FROM_FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POST_CALENDAR_PERIOD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUDGET_HEADER_TOTAL_DEFAULT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_CODE_FOR_FRINGE] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_CODE_FOR_FRINGE_DESC] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BUDGET_HEADER_TOTAL_DEFAULT BUDGET_IND BUDGET_MANAGER BUDGET_ORG_UNIT BUILD_FROM_FISCAL_YEAR CONTROL_ACCT_NO CONTROL_IND CONTROL_TOTAL_IND DISTRIBUTION FISCAL_MANAGER FISCAL_YEAR FRINGE_IND FROM_GL_CODE FROM_ORG_UNIT GL_ACCT_NO GL_ACCT_NO_2 GL_CODE_DESCRIPTION GL_CODE_FOR_FRINGE GL_CODE_FOR_FRINGE_DESC GL_PARM_CODE GL_TYPE HOLD ISN_BUDGET_PREP_FILE LAST_ITER_MOD_DATE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID ORG_TITLE POST_CALENDAR_PERIOD PRINCIPAL_ADMIN RowUpdatedOn TO_GL_CODE TO_ORG_UNIT TOTAL_ORG_UNIT USER_UPDATE_CODE
20140619 FIG516N2 0918272 E026994 2015 7 918272 53338 2017-02-06T11:18:36.464-05:00 5821510015181490
20150626 FIG516N2 1104125 E026994 2016 5 1104125 63986 2017-02-06T11:18:37.868-05:00 1510200051028930
20140619 FIG516N2 0918140 E026994 2015 6 918140 48712 2017-02-06T11:18:35.84-05:00 5812510012509890
20140619 FIG512N2 1041021 E026994 B 2015 145000004500001065702 DATA SOFTWARE-ADMIN. NON-CAP 1041021 60776 2017-02-06T11:18:37.447-05:00
20130625 FIG516N2 1032596 E026994 2014 4 1032596 27739 2017-02-06T11:18:33.188-05:00 5812510012507690
20160623 FIG516N2 1647139 E026994 2017 4 1647139 91117 2017-02-06T11:18:41.44-05:00 6812100068125120
20140619 FIG516N2 0918044 E026994 2015 4 918044 45679 2017-02-06T11:18:35.419-05:00 1460400046040310
20160426 FIG100N2 1014368 E030656 2016 5 79812 2017-02-06T11:18:39.911-05:00 5312510022504190
20160623 FIG516N2 1646595 E026994 2017 6 1646595 89572 2017-02-06T11:18:41.238-05:00 5821510015172290
20120628 FIG516N2 1205076 E026994 2013 7 1205076 17905 2017-02-06T11:18:31.862-05:00 7790206470901090
Powered by BI Documenter