DWOperations
 dbo.Verify_dbo_DimOrgUnit (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_DimOrgUnit
  Properties
Property Value
Name Verify_dbo_DimOrgUnit
Schema dbo
Row Count 7686
Data Size 2600 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
BudgetManager
varchar(40)
False
False
False
 
BudgetManagerId
varchar(9)
False
False
False
 
ControlOrgUnit
varchar(18)
False
False
False
 
ControlOrgUnitName
varchar(30)
False
False
False
 
EndDate
datetime(23, 3)
False
False
False
 
FunctionCode
varchar(3)
False
False
False
 
FunctionDescription
varchar(30)
False
False
False
 
Fund
varchar(30)
False
False
False
 
FundCode
varchar(3)
False
False
False
 
Location
varchar(30)
False
False
False
 
LocationCode
varchar(3)
False
False
False
 
OrgUnit
varchar(18)
False
False
False
 
OrgUnitAK
varchar(16)
False
False
False
 
OrgUnitGrouping
varchar(4)
False
False
False
 
OrgUnitName
varchar(30)
False
False
False
 
OrgUnitStatus
varchar(15)
False
False
False
 
OrgUnitStatusCode
varchar(3)
False
False
False
 
PrincipalAdmin
varchar(40)
False
False
False
 
PrincipalAdminId
varchar(9)
False
False
False
 
ProjectNumber
int(10, 0)
False
False
False
 
Qual1
varchar(6)
False
False
False
 
ReportDistribution
varchar(30)
False
False
False
 
ReportDistributionCode
varchar(4)
False
False
False
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
False
False
False
 
StartDate
datetime(23, 3)
False
False
False
 
StateOrgUnit
varchar(8)
False
False
False
 
SubFunction
varchar(30)
False
False
False
 
SubFunctionCode
varchar(3)
False
False
False
 
UserGroup
varchar(40)
False
False
False
 
UserGroupId
varchar(16)
False
False
False
 
In Primary Key
VerifyOrgUnitSK
int(10, 0)
False
False
False
(1 / 1)
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyOrgUnitSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimOrgUnit depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimOrgUnit)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimOrgUnit] Script Date: 03/09/2017 17:21:47 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimOrgUnit](
    [VerifyOrgUnitSK] [int] IDENTITY(1,1) NOT NULL,
    [OrgUnitAK] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnit] [varchar](18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnitName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnitStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnitStatus] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FundCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Fund] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionDescription] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SubFunctionCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SubFunction] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StateOrgUnit] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LocationCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Location] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Qual1] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ControlOrgUnit] [varchar](18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ControlOrgUnitName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BudgetManagerId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BudgetManager] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [UserGroupId] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [UserGroup] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrincipalAdminId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrincipalAdmin] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ProjectNumber] [int] NOT NULL,
    [ReportDistributionCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReportDistribution] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnitGrouping] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StartDate] [datetime] NOT NULL,
    [EndDate] [datetime] 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_dbo.DimOrgUnit] PRIMARY KEY CLUSTERED 
(
    [VerifyOrgUnitSK] 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
BudgetManager BudgetManagerId ControlOrgUnit ControlOrgUnitName EndDate FunctionCode FunctionDescription Fund FundCode Location LocationCode OrgUnit OrgUnitAK OrgUnitGrouping OrgUnitName OrgUnitStatus OrgUnitStatusCode PrincipalAdmin PrincipalAdminId ProjectNumber Qual1 ReportDistribution ReportDistributionCode RowIsDuplicate RowIsSelected StartDate StateOrgUnit SubFunction SubFunctionCode UserGroup UserGroupId VerifyOrgUnitSK
BUDGET BUDGET 58215100-151603-90 PD GFWC HOBE SOUND WOMEN'S CLU 2098-06-30T00:00:00-04:00 58 Other Scholarships Accounts SCHOLARSHIP FUNDS 5 N/A 90 58215100-151603-90 5821510015160390 N/A PD GFWC HOBE SOUND WOMEN'S CLU Active A GRANTS GRANTS 0 151603 DISTRIBUTION 07 07 N Y 2008-07-01T00:00:00-04:00 58215100 N/A 582 BUDGET FCCSC 4928
BUDGET BUDGET 25100000-100006-94 STUDENT ACTIVITY FEES CONTROL 2199-06-30T00:00:00-04:00 25 Student Support CURRENT FUNDS - RESTRICTED 2 N/A 94 25100000-200087-94 2510000020008794 BARN SA - CONTINGENCY CENTRAL Active A GRANTS GRANTS 0 200087 N/A 38 N Y 2011-07-26T00:00:00-04:00 25100000 N/A 251 BUDGET FCCSC 986
BUDGET BUDGET 77784018-701291-10 D-97/8 DIST GEN REN/REM ALL 2007-01-12T00:00:00-05:00 77 PROJECTS FINANCED FROM PECO UNEXPND PLANT & RENEW/REPLACE 7 PRESIDENT 10 77784018-701291-10 7778401870129110 BARN D-97/8 DIST GEN REN/REM ALL Active A GRANTS GRANTS 0 701291 N/A 24 N Y 1997-07-01T00:00:00-04:00 77784018 N/A 777 BUDGET FCCSC 6244
BUDGET BUDGET 10000000- -00 UNRESTR CURRENT FUND CONTROL 2006-10-12T00:00:00-04:00 11 Direct Instruction CURRENT FUNDS - UNRESTRICTED 1 VICE PRES STUDENT AFFAIRS 30 11161700-161701-30 1116170016170130 BARN SLC-MATHEMATICS-GLADES Active A GRANTS GRANTS 0 161701 N/A 43 N Y 1990-07-01T00:00:00-04:00 11161700 Advance And Professional Instr 111 BUDGET FCCSC 1288
BUDGET BUDGET 77800001- -00 98/9 SOD REN/REM, R&M, ETC 2007-01-03T00:00:00-05:00 77 PROJECTS FINANCED FROM PECO UNEXPND PLANT & RENEW/REPLACE 7 PRESIDENT 10 77800052-701051-10 7780005270105110 BARN 98/9 SOD Active A GRANTS GRANTS 0 701051 N/A 24 N Y 1999-07-01T00:00:00-04:00 77800052 N/A 778 BUDGET FCCSC 6370
BUDGET BUDGET 58215100-151747-90 PD AMIKIDS FOUNDATION INC 2098-06-30T00:00:00-04:00 58 Other Scholarships Accounts SCHOLARSHIP FUNDS 5 N/A 90 58215100-151747-90 5821510015174790 N/A PD AMIKIDS FOUNDATION INC Active A GRANTS GRANTS 0 151747 DISTRIBUTION 07 07 N Y 2011-07-01T00:00:00-04:00 58215100 N/A 582 BUDGET FCCSC 6279
BUDGET BUDGET 10000000- -00 UNRESTR CURRENT FUND CONTROL 2013-01-15T00:00:00-05:00 16 Institutional Support CURRENT FUNDS - UNRESTRICTED 1 VICE PRES STUDENT AFFAIRS 30 16330200-633000-30 1633020063300030 BARN RECEIVING-GLADES Active A GRANTS GRANTS 0 633000 N/A 43 N Y 1990-07-01T00:00:00-04:00 16330200 General Administrative & Logis 163 BUDGET FCCSC 1831
BUDGET BUDGET 58215100-151887-90 PD FL ASSOC OF STD FIN AID ADM 2098-06-30T00:00:00-04:00 58 Other Scholarships Accounts SCHOLARSHIP FUNDS 5 N/A 90 58215100-151887-90 5821510015188790 N/A PD FL ASSOC OF STD FIN AID ADM Active A GRANTS GRANTS 0 151887 DISTRIBUTION 07 07 N Y 2013-07-01T00:00:00-04:00 58215100 N/A 582 BUDGET FCCSC 6630
BUDGET BUDGET 68126000-812190-90 PD-BUSINESS&PROF WOMEN FOUND 2002-11-19T00:00:00-05:00 68 Organizational Accounts AGENCY FUNDS 6 N/A 90 68126000-812190-90 6812600081219090 N/A PD-BUSINESS&PROF WOMEN FOUND Active A GRANTS GRANTS 0 812190 DISTRIBUTION 07 07 N Y 2000-07-01T00:00:00-04:00 68126000 N/A 681 BUDGET FCCSC 7331
BUDGET BUDGET 10000000- -00 UNRESTR CURRENT FUND CONTROL 2010-06-30T00:00:00-04:00 15 Student Support CURRENT FUNDS - UNRESTRICTED 1 VICE PRES/PROVOST MAIN CAMPUS 20 15102000-510226-20 1510200051022620 BARN SOUTHERN FRIED JAZZ BAND Active A GRANTS GRANTS 0 510226 N/A 45 N Y 2001-07-01T00:00:00-04:00 15102000 Social & Cultural Development 151 BUDGET FCCSC 2667
Powered by BI Documenter