DWOperations
 dbo.Verify_dbo_DimGlCode (Table)
Home  Diagrams  Documents  Images  DWOperations  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:  DWOperations   Tables   dbo.Verify_dbo_DimGlCode
  Properties
Property Value
Name Verify_dbo_DimGlCode
Schema dbo
Row Count 1610
Data Size 352 KB
Index Size 24 KB
Create Date 8/28/2013 9:56 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
AccountSign
smallint(5, 0)
False
False
False
 
Glc
varchar(5)
False
False
False
 
GlCategory
varchar(30)
False
False
False
 
GlCategoryCode
varchar(3)
False
False
False
 
GlcDescription
varchar(30)
False
False
False
 
GlClass
varchar(30)
False
False
False
 
GlClassCode
varchar(3)
False
False
False
 
GlCodeAK
varchar(9)
False
False
False
 
GlCodeName
varchar(50)
False
False
False
 
GlCodeSubTotal
varchar(30)
False
False
False
 
GlCodeSubTotalCode
varchar(5)
False
False
False
 
GlGroup
varchar(10)
False
False
False
 
GlSubCategory
varchar(30)
False
False
False
 
GlSubCategoryCode
varchar(3)
False
False
False
 
HrClassification
varchar(10)
False
False
False
 
HrTimeStatus
varchar(30)
False
False
False
 
Qual2
varchar(4)
False
False
False
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
False
False
False
 
In Primary Key
VerifyGlCodeSK
int(10, 0)
False
False
False
(1 / 1)
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyGlCodeSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimGlCode depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimGlCode)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimGlCode] Script Date: 03/09/2017 17:21:47 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimGlCode](
    [VerifyGlCodeSK] [int] IDENTITY(1,1) NOT NULL,
    [GlCodeAK] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Glc] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Qual2] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlClassCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlClass] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlGroup] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCategoryCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCategory] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlSubCategoryCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlSubCategory] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlcDescription] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCodeName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCodeSubTotalCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCodeSubTotal] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HrClassification] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HrTimeStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AccountSign] [smallint] NOT NULL,
    [RowIsDuplicate] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsSelected] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_DimGlCode] PRIMARY KEY CLUSTERED 
(
    [VerifyGlCodeSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  Sample Data
AccountSign Glc GlCategory GlCategoryCode GlcDescription GlClass GlClassCode GlCodeAK GlCodeName GlCodeSubTotal GlCodeSubTotalCode GlGroup GlSubCategory GlSubCategoryCode HrClassification HrTimeStatus Qual2 RowIsDuplicate RowIsSelected VerifyGlCodeSK
-1 23200 Other Liabilities 23 FEDERAL EXCISE TAX PAYABLE LIABILITIES 2 23200 FEDERAL EXCISE TAX PAYABLE FEDERAL EXCISE TAX PAYABLE 23200 LIABILITIE FEDERAL EXCISE TAX PAYABLE 232 N/A N/A N Y 724
-1 27163 Due to Other Agencies 27 DEFER INC - OTHER FEES(40900) LIABILITIES 2 27163 DEFER INC - OTHER FEES(40900) DEFER INC - OTHER FEES(40900) 27163 LIABILITIE DEFERRED REVENUE 271 N/A N/A N Y 725
-1 40800 Tuition & Fees Revenue 40 FINANCIAL AID FUND FEES REVENUE 4 408000401 FINANCIAL AID FEES-FL 2004 Financial Aid Fees 40844 REVENUE FINANCIAL AID FUND FEES 408 N/A N/A 0401 N Y 939
-1 22326 Current Liabilities 22 SECURITY FIRST TSA PAYABLE LIABILITIES 2 22326 SECURITY FIRST TSA PAYABLE SECURITY FIRST TSA PAYABLE 22326 LIABILITIE RETIREMENT CONTRIB. PAYABLE 223 N/A N/A N Y 14
-1 41909 Support from Local Government 41 REFUNDED TO GRANTOR-DELETED REVENUE 4 41909 REFUNDED TO GRANTOR-LOCAL GOVT TO BE DELETED Support from Local Government 41510 REVENUE INDIRECT COSTS REC.-CITY/CNTY 419 N/A N/A N Y 622
-1 40860 Tuition & Fees Revenue 40 STUDENT CAPITAL IMP FEE A & P REVENUE 4 40860SUMM STUDENT CAPITAL IMP FEE A & P STUDENT CAPITAL IMPR FEE 40869 REVENUE FINANCIAL AID FUND FEES 408 N/A N/A SUMM N Y 1390
1 64005 Utilities, Workforce 64 FUEL-VEHICULAR CURRENT EXPENSES 6 64005 FUEL-VEHICULAR FUEL-VEHICULAR 64005 Expenses UTILITIES 640 N/A N/A N Y 271
-1 22700 Current Liabilities 22 TO BE DELETED 6/30 LIABILITIES 2 22700 ACCRUED COMPENSATED LEAVE PAY.-TO BE DELETED TO BE DELETED 6/30 22700 LIABILITIE COMPENSATED LEAVE PAYABLE 227 N/A N/A N Y 158
-1 40120 Tuition & Fees Revenue 40 TUITION-PSV REVENUE 4 401200203 TUITION-PSV SP 2002 Tuition 40100 REVENUE STUDENT FEES CONTROL (INT USE) 401 N/A N/A 0203 N Y 1238
-1 31140 Fund Balance 31 FUND BALANCE-COLLEGE-OTHER ST FUND BALANCE 3 31140 FUND BALANCE-COLLEGE-OTHER ST FUND BALANCE-COLLEGE-OTHER ST 31140 FUND BALAN FUND BALANCE - COLLEGE 311 N/A N/A N Y 23
Powered by BI Documenter