DWOperations
 dbo.Staged_dbo_DimGlCode__New (Table)
  Properties
Property Value
Name Staged_dbo_DimGlCode__New
Schema dbo
Row Count 1610
Data Size 376 KB
Index Size 16 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
 
RowEndDate
datetime(23, 3)
True
False
False
 
RowIsCurrent
char(1)
False
False
False
 
RowStartDate
datetime(23, 3)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Staged_dbo_DimGlCode__New depends on)
Name Type
  Child Dependencies (objects that depend on dbo.Staged_dbo_DimGlCode__New)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Staged_dbo_DimGlCode__New] Script Date: 03/09/2017 17:21:40 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Staged_dbo_DimGlCode__New](
    [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,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL
) ON [PRIMARY]
  Sample Data
AccountSign Glc GlCategory GlCategoryCode GlcDescription GlClass GlClassCode GlCodeAK GlCodeName GlCodeSubTotal GlCodeSubTotalCode GlGroup GlSubCategory GlSubCategoryCode HrClassification HrTimeStatus Qual2 RowIsCurrent RowStartDate
-1 40860 Tuition & Fees Revenue 40 Student Capital Imp Fee A & P Revenue 4 408600607 Capital Improvement Fees-2007 Student Capital Impr Fee 40869 Revenue Financial Aid Fund Fees 408 N/A N/A 0607 Y 2017-03-09T11:42:00-05:00
-1 28100 Due To Other Funds 28 Due To Curr Funds - Unrestrict Liabilities 2 28100 Due To Curr Funds - Unrestricted Fund 1 Due To Curr Funds - Unrestrict 28100 Liabilitie Due To Current Funds - Unres 281 N/A N/A Y 2017-03-09T11:42:00-05:00
-1 40844 Tuition & Fees Revenue 40 Fin Aid Fee-Baccalaureate Revenue 4 408441702 Fin Aid Fee-Baccalaureate Financial Aid Fees 40844 Revenue Financial Aid Fund Fees 408 N/A N/A 1702 Y 2017-03-09T11:42:00-05:00
1 69902 Other Expenses 69 Lapse-Curr Expense(Neg Budget) Current Expenses 6 69902 Lapse-Curr Expense(Neg Budget) Lapse-Curr Expense(Neg Budget) 69902 Expenses Current Expense Contingency (B 699 N/A N/A Y 2017-03-09T11:42:00-05:00
-1 40864 Tuition & Fees Revenue 40 Capital Improv Fee-Bachelor Revenue 4 408641602 Capital Improv Fee-Bachelor Student Capital Impr Fee 40869 Revenue Financial Aid Fund Fees 408 N/A N/A 1602 Y 2017-03-09T11:42:00-05:00
1 62503 Printing, Maintenance 62 Repairs And Maint. Grounds Current Expenses 6 62503 Repairs And Maint. Grounds Repairs And Maint. Grounds 62503 Expenses Repairs And Maintenance 625 N/A N/A Y 2017-03-09T11:42:00-05:00
-1 40700 Tuition & Fees Revenue 40 Transcript Fees Revenue 4 40700 Transcript Fees Misc Student Srvc Fees 40500 Revenue Transcript Fees 407 N/A N/A Y 2017-03-09T11:42:00-05:00
1 10107 Cash & Cash Equivilants 10 Eissey Theatre Cr Card Cib Assets 1 10107 Eissey Theatre Cr Card Cib Eissey Theatre Cr Card Cib 10107 Assets Cash In Depository (Ies) 101 N/A N/A Y 2017-03-09T11:42:00-05:00
-1 40520 Tuition & Fees Revenue 40 Proc Fees - As Degree Revenue 4 40520 Proc Fees - As Degree Misc Student Srvc Fees 40500 Revenue Application Fees 405 N/A N/A Y 2017-03-09T11:42:00-05:00
-1 40450 Tuition & Fees Revenue 40 Distance Learning Course Fee Revenue 4 404501603 Distance Learning Course Fee Lab Fees 40400 Revenue Lab, Spec. Course, & User Fee 404 N/A N/A 1603 Y 2017-03-09T11:42:00-05:00
Powered by BI Documenter