DWStaging
 dbo.BUDGET_PREP_LOG_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_LOG_FILE
  Properties
Property Value
Name BUDGET_PREP_LOG_FILE
Schema dbo
Row Count 14802
Data Size 1744 KB
Index Size 264 KB
Create Date 2/12/2013 1:45 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
AMOUNT
numeric(9, 0)
True
False
False
 
BATCH_JOB_NAME
varchar(8)
True
False
False
 
BUDGET_HEADER_TOTAL_DEFAULT
varchar(1)
True
False
False
 
BUDGET_IND
varchar(1)
True
False
False
 
BUILD_FROM_FISCAL_YEAR
varchar(4)
True
False
False
 
BUILD_NEXT_ITER_FROM
int(10, 0)
True
False
False
 
CHANGE_REASON
varchar(50)
True
False
False
 
CONTROL_IND
varchar(1)
True
False
False
 
CONTROL_TOTAL_IND
varchar(1)
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_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
 
ISN_BUDGET_PREP_LOG_FILE
int(10, 0)
False
False
False
 
ITERATION_NO
int(10, 0)
True
False
False
 
LAST_ITER_MOD_DATE
varchar(8)
True
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
varchar(8)
True
False
False
 
NEXT_ITER_NO
int(10, 0)
True
False
False
 
ORIG_AMOUNT
numeric(9, 0)
True
False
False
 
PERCENT
numeric(17, 2)
True
False
False
 
POST_CALENDAR_PERIOD
varchar(6)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
RUN_IND
varchar(1)
True
False
False
 
TO_GL_CODE
varchar(9)
True
False
False
 
TO_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_LOG_FILE
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.BUDGET_PREP_LOG_FILE depends on)
Name Type
  Child Dependencies (objects that depend on dbo.BUDGET_PREP_LOG_FILE)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[BUDGET_PREP_LOG_FILE] Script Date: 03/09/2017 16:45:08 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[BUDGET_PREP_LOG_FILE](
    [ISN_BUDGET_PREP_LOG_FILE] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ITERATION_NO] [int] 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,
    [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,
    [PERCENT] [numeric](17, 2) NULL,
    [BUDGET_IND] [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,
    [AMOUNT] [numeric](9, 0) NULL,
    [ORIG_AMOUNT] [numeric](9, 0) NULL,
    [CHANGE_REASON] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FRINGE_IND] [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,
    [CONTROL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTROL_TOTAL_IND] [varchar](1) 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,
    [RUN_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BATCH_JOB_NAME] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
AMOUNT BATCH_JOB_NAME BUDGET_HEADER_TOTAL_DEFAULT BUDGET_IND BUILD_FROM_FISCAL_YEAR CHANGE_REASON CONTROL_IND CONTROL_TOTAL_IND FISCAL_YEAR FRINGE_IND FROM_GL_CODE FROM_ORG_UNIT GL_ACCT_NO GL_CODE_DESCRIPTION GL_CODE_FOR_FRINGE GL_CODE_FOR_FRINGE_DESC GL_PARM_CODE ISN_BUDGET_PREP_LOG_FILE ITERATION_NO LAST_ITER_MOD_DATE LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER ORIG_AMOUNT POST_CALENDAR_PERIOD RowUpdatedOn RUN_IND TO_GL_CODE TO_ORG_UNIT USER_UPDATE_CODE
5900 B 2014 153020005302003065701 DATA SOFTWARE-ED. NON-CAPITAL 3236 1 A 20130625 <notty> 1049096 E026994 5900 2017-02-06T11:24:14.908-05:00
289800 B 2016 150000002000000054500 TECH CLER TRADE & SERV-REG PT 10654 1 A 20150626 <notty> 1107241 E026994 289800 2017-02-06T11:24:15.657-05:00
9100 B 2016 111210001210005065501 EDUCATIONAL MATERIALS & SUPPLY 8661 1 P 20150626 <notty> 1101402 E026994 9100 2017-02-06T11:24:15.438-05:00
500 B 2017 161110006111009165502 OFFICE MATERIALS AND SUPPLIES 13523 1 A 20160623 <notty> 1713037 E026994 500 2017-02-06T11:24:15.969-05:00
9000 B 2016 163308006330005061000 FREIGHT AND POSTAGE 11067 1 A 20150626 <notty> 1107284 E026994 9000 2017-02-06T11:24:15.704-05:00
200 B 2013 112402002402003065501 EDUCATIONAL MATERIALS & SUPPLY 496 1 A 20120628 <notty> 1524427 E026994 200 2017-02-06T11:24:14.674-05:00
100 B 2013 161140006114009262002 PRINTING - COLLEGE 1522 1 A 20120628 <notty> 1524499 E026994 100 2017-02-06T11:24:14.768-05:00
400 B 2017 115000006000011060502 TRAVEL-OUT-OF-DISTRICT 12888 1 A 20160623 <notty> 1712550 E026994 400 2017-02-06T11:24:15.875-05:00
10754 B 2016 112601002601121065501 EDUCATIONAL MATERIALS & SUPPLY 9098 1 P 20150626 <notty> 1101405 E026994 10754 2017-02-06T11:24:15.485-05:00
2000 B 2016 148010004801019265502 OFFICE MATERIALS AND SUPPLIES 9676 1 P 20150626 <notty> 1101409 E026994 2000 2017-02-06T11:24:15.548-05:00
Powered by BI Documenter