EnterpriseDW
 dbo.DimPosition (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  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:  EnterpriseDW   Tables   dbo.DimPosition
  Properties
Property Value
Name DimPosition
Schema dbo
Row Count 7637
Data Size 2744 KB
Index Size 24 KB
Create Date 3/9/2017 10:43 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Budgeted
varchar(3)
False
False
False
 
An indication if the position is currently budgeted based on values in position budget.
CountOfActiveAssignments
int(10, 0)
False
False
False
 
The current number of acitve assignments for the position.
CountOfInactiveAssignments
int(10, 0)
False
False
False
 
The current number of inactive assignments for the position.
DateEstablished
datetime(23, 3)
False
False
False
 
The date the Position was initially created and activated.
DateInactivated
datetime(23, 3)
False
False
False
 
The date of the most recent inactivation of the Position.
ExemptStatus
varchar(3)
False
False
False
 
An indication of the exempt status of the position. An exempt position will not be eligible for overtime payments.
FulltimeEquivalent
numeric(5, 2)
True
False
False
 
The full time equivalancy of the position
FunctionCode
varchar(3)
False
False
False
 
Code to indicate the function of position based on the primary salary account number assigned to the position.
FunctionDescription
varchar(60)
False
False
False
 
Descriptive name for the function of position. This will include Management, Instructional, Other Proffesional and Technical.
InactiveReason
varchar(60)
False
False
False
 
Descriptive name of the reason the position was determined to be inactive.
InactiveReasonCode
varchar(8)
False
False
False
 
A code to indicate why the position was determined to be inactive.
InactiveVacantDateRange
varchar(30)
False
False
False
 
A range of days, for which the position has been inactive, based on the current date. The ranges include 1 to 3 Months, 4 to 6
JobClassCode
varchar(8)
False
False
False
 
A code to indicate the classification of the position.
JobGroup
varchar(60)
False
False
False
 
Descriptive name of the group categorization of the position.
JobGroupCode
varchar(8)
False
False
False
 
A code to indicate the group categorization of the position.
Location
varchar(60)
False
False
False
 
LocationCode
varchar(3)
False
False
False
 
MultipleFunds
varchar(3)
False
False
False
 
PayBasis
varchar(8)
False
False
False
 
An indication of how the rate of pay will be calculated for the position, the values will be Hourly or Salary.
PooledIndicator
varchar(3)
False
False
False
 
An indication whether or not a position is pooled. A pooled position allows multiple assignments to exist for a position at the
PositionAK
varchar(8)
False
False
False
 
Business key for the position, this will contain the Position Code.
PositionCode
varchar(8)
False
False
False
 
Position identifier assigned by the source application and used by the Data Warehouse as the Business Key.
PositionFulltimeParttime
varchar(10)
False
False
False
 
An indication of the position is intended to be a full time or a part time position.
In Primary Key
PositionSK
int(10, 0)
False
False
False
(1 / 1)
Surrogate primary key
PositionStatus
varchar(10)
False
False
False
 
An indication of the current status of the Position, the valid values are Vacant, Filled or Inactive.
PositionTitle
varchar(30)
False
False
False
 
The job title for the position, this will be the job title for an employee that holds this position.
PositionType
varchar(60)
False
False
False
 
Descriptive name for the type of position. This will include Management, Instructional, Other Proffesional and Technical.
PositionTypeCode
varchar(3)
False
False
False
 
Code to indicate the type of position based on the primary salary account number assigned to the position.
PrimarySalaryAccountNumber
varchar(28)
False
False
False
 
The current primary salary expense account for the position.
RegularTemporary
varchar(10)
False
False
False
 
An indication if the position is intended to be on-going (regular) or temporary.
RowEndDate
datetime(23, 3)
False
False
False
 
('12/31/9999')
When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent
nchar(1)
False
False
False
 
Is this the current row for this member (Y/N)?
RowStartDate
datetime(23, 3)
False
False
False
 
When did this row become valid for this member?
WeeklyAuthorizedHours
numeric(5, 2)
True
False
False
 
The number of weekly hours that this position is expected to work
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
PositionSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimPosition depends on)
Name Type
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.DimPosition)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
DimPosition
Display Name
Position
DimPosition
Table Description
The dimension will contain one row per Position at the institution and will include descriptive, status and categorization infor
DimPosition
Table Type
Dimension
Budgeted
MS_Description
An indication if the position is currently budgeted based on values in position budget.
CountOfActiveAssignments
MS_Description
The current number of acitve assignments for the position.
CountOfInactiveAssignments
MS_Description
The current number of inactive assignments for the position.
DateEstablished
MS_Description
The date the Position was initially created and activated.
DateInactivated
MS_Description
The date of the most recent inactivation of the Position.
ExemptStatus
MS_Description
An indication of the exempt status of the position. An exempt position will not be eligible for overtime payments.
FulltimeEquivalent
MS_Description
The full time equivalancy of the position
FunctionCode
MS_Description
Code to indicate the function of position based on the primary salary account number assigned to the position.
FunctionDescription
MS_Description
Descriptive name for the function of position. This will include Management, Instructional, Other Proffesional and Technical.
InactiveReason
MS_Description
Descriptive name of the reason the position was determined to be inactive.
InactiveReasonCode
MS_Description
A code to indicate why the position was determined to be inactive.
InactiveVacantDateRange
MS_Description
A range of days, for which the position has been inactive, based on the current date. The ranges include 1 to 3 Months, 4 to 6
JobClassCode
MS_Description
A code to indicate the classification of the position.
JobGroup
MS_Description
Descriptive name of the group categorization of the position.
JobGroupCode
MS_Description
A code to indicate the group categorization of the position.
PayBasis
MS_Description
An indication of how the rate of pay will be calculated for the position, the values will be Hourly or Salary.
PooledIndicator
MS_Description
An indication whether or not a position is pooled. A pooled position allows multiple assignments to exist for a position at the
PositionAK
MS_Description
Business key for the position, this will contain the Position Code.
PositionCode
MS_Description
Position identifier assigned by the source application and used by the Data Warehouse as the Business Key.
PositionFulltimeParttime
MS_Description
An indication of the position is intended to be a full time or a part time position.
PositionSK
MS_Description
Surrogate primary key
PositionStatus
MS_Description
An indication of the current status of the Position, the valid values are Vacant, Filled or Inactive.
PositionTitle
MS_Description
The job title for the position, this will be the job title for an employee that holds this position.
PositionType
MS_Description
Descriptive name for the type of position. This will include Management, Instructional, Other Proffesional and Technical.
PositionTypeCode
MS_Description
Code to indicate the type of position based on the primary salary account number assigned to the position.
PrimarySalaryAccountNumber
MS_Description
The current primary salary expense account for the position.
RegularTemporary
MS_Description
An indication if the position is intended to be on-going (regular) or temporary.
RowEndDate
MS_Description
When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent
MS_Description
Is this the current row for this member (Y/N)?
RowStartDate
MS_Description
When did this row become valid for this member?
WeeklyAuthorizedHours
MS_Description
The number of weekly hours that this position is expected to work
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimPosition] Script Date: 03/09/2017 17:14:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimPosition](
    [PositionSK] [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,
    [RowIsCurrent] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.DimPosition] PRIMARY KEY CLUSTERED 
(
    [PositionSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[DimPosition] ADD  CONSTRAINT [DF__DimPositi__RowEn__0FB750B3]  DEFAULT ('12/31/9999') FOR [RowEndDate]


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Position' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The dimension will contain one row per Position at the institution and will include descriptive, status and categorization infor' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition'


EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication if the position is currently budgeted based on values in position budget.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'Budgeted'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The current number of acitve assignments for the position.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'CountOfActiveAssignments'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The current number of inactive assignments for the position.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'CountOfInactiveAssignments'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date the Position was initially created and activated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'DateEstablished'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date of the most recent inactivation of the Position.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'DateInactivated'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of the exempt status of the position. An exempt position will not be eligible for overtime payments.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'ExemptStatus'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The full time equivalancy of the position' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'FulltimeEquivalent'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code to indicate the function of position based on the primary salary account number assigned to the position. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'FunctionCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the function of position. This will include Management, Instructional, Other Proffesional and Technical.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'FunctionDescription'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the reason the position was determined to be inactive.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'InactiveReason'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A code to indicate why the position was determined to be inactive.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'InactiveReasonCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A range of days, for which the position has been inactive, based on the current date. The ranges include 1 to 3 Months, 4 to 6' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'InactiveVacantDateRange'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A code to indicate the classification of the position. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'JobClassCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the group categorization of the position.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'JobGroup'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A code to indicate the group categorization of the position. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'JobGroupCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of how the rate of pay will be calculated for the position, the values will be Hourly or Salary.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PayBasis'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication whether or not a position is pooled. A pooled position allows multiple assignments to exist for a position at the' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PooledIndicator'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key for the position, this will contain the Position Code.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PositionAK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Position identifier assigned by the source application and used by the Data Warehouse as the Business Key.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PositionCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of the position is intended to be a full time or a part time position.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PositionFulltimeParttime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PositionSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of the current status of the Position, the valid values are Vacant, Filled or Inactive.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PositionStatus'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The job title for the position, this will be the job title for an employee that holds this position.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PositionTitle'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of position. This will include Management, Instructional, Other Proffesional and Technical.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PositionType'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code to indicate the type of position based on the primary salary account number assigned to the position. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PositionTypeCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The current primary salary expense account for the position.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'PrimarySalaryAccountNumber'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication if the position is intended to be on-going (regular) or temporary.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'RegularTemporary'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become invalid? (12/31/9999 if current row)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Is this the current row for this member (Y/N)?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become valid for this member?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'RowStartDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number of weekly hours that this position is expected to work' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPosition', @level2type=N'COLUMN',@level2name=N'WeeklyAuthorizedHours'
  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 PositionSK PositionStatus PositionTitle PositionType PositionTypeCode PrimarySalaryAccountNumber RegularTemporary RowEndDate RowIsCurrent RowStartDate WeeklyAuthorizedHours
Yes 1 20 2000-07-01T00:00:00-04:00 2098-12-31T00:00:00-05:00 No 1.00 15 Student Support N/A N/A N/A RECSPEC 12 Month Employees Working 35 Hours Per Week 12MO35 President 10 No Salary No AA1524 AA1524 Full Time 1572 Filled Records Specialist Personnel Cost-Technical 54 15601000-560100-10-54000 Regular 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 35.00
No 0 1 1998-07-01T00:00:00-04:00 2000-06-30T00:00:00-04:00 No 1.00 11 Direct Instruction Title Change TITLE More than 2 Years ATHFCORD 12 Month Employees Working 40 Hours Per Week 12MO40 Vice Pres Of Admin & Finance 50 No Salary No 1126 1126 Full Time 1338 Inactive N/A Personnel Cost-Technical 54 11140800-140801-50-54000 Regular 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 40.00
No 0 80 1999-02-01T00:00:00-05:00 2012-11-12T00:00:00-05:00 Yes 0.00 11 Direct Instruction Position Deleted DELETED More than 2 Years OVLD Overload For Faculty_Based Upon Salary OVERLDSY Vice Pres Of Admin & Finance 50 No Salary Yes COM5OVLS COM5OVLS Part Time 3168 Inactive Faculty Overload Personnel Cost-Instructional 52 11180600-180600-50-52100 Temporary 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 0.00
No 0 1 2000-11-15T00:00:00-05:00 2005-12-31T00:00:00-05:00 No 1.00 15 Student Support Position Deleted DELETED More than 2 Years P/TMAINT Hourly Workers HOURLY President 10 No Hourly No THTRZE03 THTRZE03 Part Time 7437 Inactive Part Time Maintenance Personnel Cost-Technical 54 15102000-510213-10-54500 Temporary 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 30.00
No 0 4 1998-07-01T00:00:00-04:00 2098-12-31T00:00:00-05:00 Yes 0.00 15 Student Support N/A N/A 1 to 2 Years OPSPROF Temporary Hourly Workers/No Benefits HOUR/OPS Vice Pres/Provost Main Campus 20 No Hourly Yes DSA2OPRF DSA2OPRF Part Time 4198 Vacant Ops Professional Ops-Instructional, Other Professioanl 56 15800000-580000-20-56500 Temporary 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 0.00
Yes 0 25 2000-07-01T00:00:00-04:00 2098-12-31T00:00:00-05:00 No 1.00 15 Student Support N/A N/A 07 Months to 1 Year ADMSPEC 12 Month Employees Working 40 Hours Per Week 12MO40 President 10 No Salary No AA6059 AA6059 Full Time 2714 Vacant Admissions Specialist Personnel Cost-Technical 54 15601000-560100-10-54000 Regular 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 40.00
No 0 1 2016-01-04T00:00:00-05:00 2016-05-12T00:00:00-04:00 Yes 1.00 11 Direct Instruction Position Deleted DELETED 07 Months to 1 Year PROFASSC 168 Day Faculty 168FAC Unknown 93 No Salary No 3324TMP 3324TMP Full Time 743 Inactive Associate Professor Personnel Cost-Instructional 52 11150591-115050-93-52000 Temporary 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 35.00
No 1 2 2015-08-01T00:00:00-04:00 2098-12-31T00:00:00-05:00 Yes 0.50 14 Academic Support N/A N/A N/A OPSPROF Temporary Hourly Workers/No Benefits HOUR/OPS President 10 No Hourly No STLC1102 STLC1102 Part Time 5200 Filled Ops Professional Ops-Instructional, Other Professioanl 56 14105000-410500-10-56500 Temporary 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 27.50
No 0 0 2000-01-01T00:00:00-05:00 2005-12-31T00:00:00-05:00 Yes 0.00 N/A Unknown Position Deleted DELETED More than 2 Years P/TPROF Hourly Workers HOURLY Unknown N/A No Hourly Yes PE5E01 PE5E01 Part Time 6513 Inactive Part Time Professional Unknown N/A N/A Temporary 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 0.00
No 0 5 2001-08-16T00:00:00-04:00 2004-06-30T00:00:00-04:00 Yes 0.00 11 Direct Instruction Position Deleted DELETED More than 2 Years ADJFAC Adjunct Instructors Paid By The Hour ADJUNCT Vice Pres/Provost Main Campus 20 No Hourly Yes ATC2ADJU ATC2ADJU Part Time 2722 Inactive Adjunct Instructor Ops-Instructional, Other Professioanl 56 11230100-230108-20-56000 Temporary 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00 0.00
Powered by BI Documenter