DWOperations
 dbo.Verify_dbo_DimPosition (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_DimPosition
  Properties
Property Value
Name Verify_dbo_DimPosition
Schema dbo
Row Count 7636
Data Size 2624 KB
Index Size 24 KB
Create Date 3/9/2017 10:45 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Budgeted
varchar(3)
False
False
False
 
CountOfActiveAssignments
int(10, 0)
False
False
False
 
CountOfInactiveAssignments
int(10, 0)
False
False
False
 
DateEstablished
datetime(23, 3)
False
False
False
 
DateInactivated
datetime(23, 3)
False
False
False
 
ExemptStatus
varchar(3)
False
False
False
 
FulltimeEquivalent
numeric(5, 2)
True
False
False
 
FunctionCode
varchar(3)
False
False
False
 
FunctionDescription
varchar(60)
False
False
False
 
InactiveReason
varchar(60)
False
False
False
 
InactiveReasonCode
varchar(8)
False
False
False
 
InactiveVacantDateRange
varchar(30)
False
False
False
 
JobClassCode
varchar(8)
False
False
False
 
JobGroup
varchar(60)
False
False
False
 
JobGroupCode
varchar(8)
False
False
False
 
Location
varchar(60)
False
False
False
 
LocationCode
varchar(3)
False
False
False
 
MultipleFunds
varchar(3)
False
False
False
 
PayBasis
varchar(8)
False
False
False
 
PooledIndicator
varchar(3)
False
False
False
 
PositionAK
varchar(8)
False
False
False
 
PositionCode
varchar(8)
False
False
False
 
PositionFulltimeParttime
varchar(10)
False
False
False
 
PositionStatus
varchar(10)
False
False
False
 
PositionTitle
varchar(30)
False
False
False
 
PositionType
varchar(60)
False
False
False
 
PositionTypeCode
varchar(3)
False
False
False
 
PrimarySalaryAccountNumber
varchar(28)
False
False
False
 
RegularTemporary
varchar(10)
False
False
False
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
False
False
False
 
In Primary Key
VerifyPositionSK
int(10, 0)
False
False
False
(1 / 1)
WeeklyAuthorizedHours
numeric(5, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyPositionSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimPosition depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimPosition)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimPosition] Script Date: 03/09/2017 17:21:48 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimPosition](
    [VerifyPositionSK] [int] IDENTITY(1,1) NOT NULL,
    [PositionAK] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PositionCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PositionTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PositionStatus] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PositionTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PositionType] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionDescription] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LocationCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Location] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [DateEstablished] [datetime] NOT NULL,
    [DateInactivated] [datetime] NOT NULL,
    [JobGroupCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [JobGroup] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [JobClassCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayBasis] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Budgeted] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RegularTemporary] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PooledIndicator] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ExemptStatus] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PositionFulltimeParttime] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimarySalaryAccountNumber] [varchar](28) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CountOfActiveAssignments] [int] NOT NULL,
    [CountOfInactiveAssignments] [int] NOT NULL,
    [InactiveReasonCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [InactiveReason] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [InactiveVacantDateRange] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FulltimeEquivalent] [numeric](5, 2) NULL,
    [WeeklyAuthorizedHours] [numeric](5, 2) NULL,
    [MultipleFunds] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS 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_DimPosition] PRIMARY KEY CLUSTERED 
(
    [VerifyPositionSK] 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
Budgeted CountOfActiveAssignments CountOfInactiveAssignments DateEstablished DateInactivated ExemptStatus FulltimeEquivalent FunctionCode FunctionDescription InactiveReason InactiveReasonCode InactiveVacantDateRange JobClassCode JobGroup JobGroupCode Location LocationCode MultipleFunds PayBasis PooledIndicator PositionAK PositionCode PositionFulltimeParttime PositionStatus PositionTitle PositionType PositionTypeCode PrimarySalaryAccountNumber RegularTemporary RowIsDuplicate RowIsSelected VerifyPositionSK WeeklyAuthorizedHours
No 0 10 1999-08-18T00:00:00-04:00 2010-06-01T00:00:00-04:00 Yes 0.00 11 Direct Instruction POSITION DELETED DELETED More than 2 Years ADJFAC ADJUNCT INSTRUCTORS PAID BY SALARY ADJUNCT VICE PRES STUDENT AFFAIRS 30 No SALARY Yes CPD3ADJS CPD3ADJS Part Time Inactive ADJUNCT INSTRUCTOR OPS-Instructional, Other Professioanl 56 11184900-184900-30-56000 Temporary N Y 7544 0.00
No 0 3 1999-07-16T00:00:00-04:00 2000-12-31T00:00:00-05:00 Yes 1.00 21 Direct Instruction POSITION DELETED DELETED More than 2 Years SUPPPAYE ENDOWED CHAIR SUPPLEMENTS ENDOWEDC PRESIDENT 10 No SALARY Yes IBM ENDW IBM ENDW Part Time Inactive N/A Personnel Cost-Technical 54 21110400-110400-10-54700 Temporary N Y 3870 35.00
No 0 4 1998-07-01T00:00:00-04:00 2098-12-31T00:00:00-05:00 Yes 0.00 11 Direct Instruction N/A N/A 1 to 2 Years SUB TEMPORARY SUBSTITUTES SUBTEMP VICE PRES STUDENT AFFAIRS 30 No HOURLY Yes EDU3OSUB EDU3OSUB Part Time Vacant SUBSTITUTE Personnel Cost-Instructional 52 11140800-140803-30-52200 Temporary N Y 1870 0.00
Yes 1 18 2000-07-01T00:00:00-04:00 2098-12-31T00:00:00-05:00 No 1.00 14 Academic Support N/A N/A N/A MESPECII 12 MONTH EMPLOYEES WORKING 35 HOURS PER WEEK 12MO35 PRESIDENT 10 No SALARY No AA6068 AA6068 Full Time Filled MEDIA SPECIALIST II Personnel Cost-Technical 54 14102000-410200-10-54000 Regular N Y 5615 35.00
No 0 0 2009-02-09T00:00:00-05:00 2012-11-13T00:00:00-05:00 Yes 0.00 11 Direct Instruction POSITION DELETED DELETED More than 2 Years ADJFAC ADJUNCT INSTRUCTORS PAID BY THE HOUR ADJUNCTR VICE PRES OF ADMIN & FINANCE 50 No HOURLY Yes LNI5ETOR LNI5ETOR Part Time Inactive ADJUNCT INSTRUCTOR OPS-Instructional, Other Professioanl 56 11270300-270301-50-56008 Temporary N Y 5866 0.00
No 0 158 1998-07-01T00:00:00-04:00 2098-12-31T00:00:00-05:00 Yes 0.00 11 Direct Instruction N/A N/A 01 to 3 Months SUB REGULAR EMPLOYEES THAT SUBSTITUTE SUBREG PRESIDENT 10 No HOURLY Yes MAT1SUB+ MAT1SUB+ Part Time Vacant SUBSTITUTE Personnel Cost-Instructional 52 11161700-161700-10-52200 Temporary N Y 7595 0.00
No 0 63 2004-08-23T00:00:00-04:00 2010-06-01T00:00:00-04:00 Yes 0.00 11 Direct Instruction POSITION DELETED DELETED More than 2 Years ADJFAC ADJUNCT INSTRUCTORS PAID BY SALARY ADJUNCT PRESIDENT 10 No SALARY Yes HCR1ADJS HCR1ADJS Part Time Inactive ADJUNCT INSTRUCTOR OPS-Instructional, Other Professioanl 56 11230100-230114-10-56000 Temporary N Y 4214 0.00
Yes 1 19 2000-07-01T00:00:00-04:00 2098-12-31T00:00:00-05:00 No 1.00 17 Physical Plant Operational and Maintenance N/A N/A N/A GRDKPII 12 MONTH EMPLOYEES WORKING 40 HOURS PER WEEK 12MO40 VICE PRES/PROVOST MAIN CAMPUS 20 No SALARY No AA5400 AA5400 Full Time Filled GROUNDSKEEPER II Personnel Cost-Technical 54 17020000-702001-20-54000 Regular N Y 339 40.00
No 0 59 2006-08-23T00:00:00-04:00 2098-12-31T00:00:00-05:00 Yes 0.00 11 Direct Instruction N/A N/A 01 to 3 Months ADJFAC ADJUNCT INSTRUCTORS PAID BY SALARY ADJUNCTR VICE PRES OF ADMIN & FINANCE 50 No SALARY Yes CSE5ETOS CSE5ETOS Part Time Vacant ADJUNCT INSTRUCTOR OPS-Instructional, Other Professioanl 56 11160700-160700-50-56008 Temporary N Y 6548 0.00
Yes 1 17 2002-10-01T00:00:00-04:00 2098-12-31T00:00:00-05:00 Yes 1.00 14 Academic Support N/A N/A N/A SLCMGR 12 MONTH EMPLOYEES WORKING 40 HOURS PER WEEK 12MO40 VICE PRES/PROVOST MAIN CAMPUS 20 No SALARY No 1599 1599 Full Time Filled STUDENT LEARNING CTR MANAGER Personnel Cost-Other Professional 53 14105000-410500-20-53000 Regular N Y 2089 40.00
Powered by BI Documenter