Table - dbo.DimAssignment

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
ActualSalary	numeric(11, 2)	False	False	False			The caluclated actual salary for an assignment for an employee when adjusted because the assignment started late or ended early.
AssignmentAK	varchar(20)	False	False	False			Business key for the assignment, this will contain the Person ID, the Position Code and a Sequence Number.
AssignmentEndDateRange	varchar(30)	False	False	False			A range of time, for which the assignment has been inactive, based on the current date. The ranges include 1 to 3 Months, 4 to
AssignmentFulltimeParttime	varchar(10)	False	False	False			An indication of the assignment is intended to be a full time or a part time assignment.
AssignmentSequenceNumber	smallint(5, 0)	False	False	False			A number assigned to each consecutive relationship between an employee and a position at the institution.
AssignmentSK	int(10, 0)	False	False	False	(1 / 1)		Surrogate primary key
AssignmentStatus	varchar(10)	False	False	False			An indication of the current status of the Assignment, the valid values are Active and Ended.
AssignmentType	varchar(60)	False	False	False			Descriptive name for the type of assignment. This will include Management, Instructional, Other Proffesional and Technical.
AssignmentTypeCode	varchar(3)	False	False	False			Code to indicate the type of assignment based on the primary salary account number assigned to the assignment.
BaseSalary	numeric(11, 2)	False	False	False			Defines the base annual salary for an assignment for an employee.
DailyRate	numeric(9, 2)	False	False	False			A calculated rate using the base salary divided by the number of paid contract days.
EndBasis	varchar(60)	False	False	False			Descriptive name of the reason the assignment was determined to be inactive.
EndBasisCode	varchar(8)	False	False	False			A code to indicate why the assignment was determined to be inactive.
EndDate	datetime(23, 3)	False	False	False			The date the Assignment is no longer active for the employee. Only active assignments are available for payment.
ExemptStatus	varchar(3)	False	False	False			An indication of the exempt status of the assignment. An exempt assignment will not be eligible for overtime payments.
FunctionCode	varchar(3)	False	False	False			Code to indicate the function of assignment based on the primary salary account number assigned to the assignment.
FunctionDesc	varchar(60)	False	False	False			Descriptive name for the function of assignment. This will include Management, Instructional, Other Proffesional and Technical.
HourlyRate	numeric(9, 4)	False	False	False			Degines the rate that will be calculated on the assignment for the emplloyee.
InstitutionalAssignmentType	varchar(30)	False	False	False			Descriptive name for the type of assignment as designated by the instiution.
InstitutionalAssignmentTypeCode	varchar(8)	False	False	False			A code indicating a type of assignment assigned by the institution.
JobClassCode	varchar(8)	False	False	False			A code to indicate the classification of the assignment.
JobGroup	varchar(60)	False	False	False			Descriptive name of the group categorization of the assignment.
JobGroupCode	varchar(8)	False	False	False			A code to indicate the group categorization of the assignment.
JobTitle	varchar(30)	False	False	False			The job title for the assignment, this will be the job title for an employee that holds this assignment.
LastPaymentDateRange	varchar(30)	False	False	False			A range of time, for which the assignment was processed by a regular pay, based on the current date. The ranges include 1 to 3
OvertimeRate	numeric(9, 4)	False	False	False			The overtime rate is the same as the hourly rate except that only designated overtime time types will be calculated at this rate
PayBasis	varchar(8)	False	False	False			An indication of how the rate of pay will be calculated for the assignment, the values will be Hourly or Salary.
PersonId	int(10, 0)	False	False	False			Unique identifier assigned to each employee by the source system.
PositionCode	varchar(8)	False	False	False			Unique identifier assigned to each position by the source system.
PrimaryAssignment	varchar(3)	False	False	False			Indication if the assignment should be used as the employees primary assignment as long as the assignment is active.
PrimarySalaryAccountNumber	varchar(28)	False	False	False			The current primary salary expense account for the assignment.
RegularTemporary	varchar(10)	False	False	False			An indication if the assignment 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?
StartDate	datetime(23, 3)	False	False	False			The date the Assignment is active for the employee. Only active assignments are available for payment.
TotalSalary	numeric(11, 2)	False	False	False			The caluclated total salary for an assignment for an employee which includes the base salary plus any supplements.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_dbo.DimAssignment	True	AssignmentSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name	Type
dbo.FactCheckComponent	Table
dbo.FactHoursReportedByDay	Table
dbo.FactHoursWorkedByWeek	Table
dbo.FactPositionExpense	Table

Name	Type
dbo.FactCheckComponent	TABLE
dbo.FactHoursReportedByDay	TABLE
dbo.FactHoursWorkedByWeek	TABLE
dbo.FactPositionExpense	TABLE

Object	Property	Value
DimAssignment	Display Name	Assignment
DimAssignment	Table Description	The dimension will contain one row per Assignment at the institution and will include descriptive, status and categorization inf
DimAssignment	Table Type	Dimension
ActualSalary	MS_Description	The caluclated actual salary for an assignment for an employee when adjusted because the assignment started late or ended early.
AssignmentAK	MS_Description	Business key for the assignment, this will contain the Person ID, the Position Code and a Sequence Number.
AssignmentEndDateRange	MS_Description	A range of time, for which the assignment has been inactive, based on the current date. The ranges include 1 to 3 Months, 4 to
AssignmentFulltimeParttime	MS_Description	An indication of the assignment is intended to be a full time or a part time assignment.
AssignmentSequenceNumber	MS_Description	A number assigned to each consecutive relationship between an employee and a position at the institution.
AssignmentSK	MS_Description	Surrogate primary key
AssignmentStatus	MS_Description	An indication of the current status of the Assignment, the valid values are Active and Ended.
AssignmentType	MS_Description	Descriptive name for the type of assignment. This will include Management, Instructional, Other Proffesional and Technical.
AssignmentTypeCode	MS_Description	Code to indicate the type of assignment based on the primary salary account number assigned to the assignment.
BaseSalary	MS_Description	Defines the base annual salary for an assignment for an employee.
DailyRate	MS_Description	A calculated rate using the base salary divided by the number of paid contract days.
EndBasis	MS_Description	Descriptive name of the reason the assignment was determined to be inactive.
EndBasisCode	MS_Description	A code to indicate why the assignment was determined to be inactive.
EndDate	MS_Description	The date the Assignment is no longer active for the employee. Only active assignments are available for payment.
ExemptStatus	MS_Description	An indication of the exempt status of the assignment. An exempt assignment will not be eligible for overtime payments.
FunctionCode	MS_Description	Code to indicate the function of assignment based on the primary salary account number assigned to the assignment.
FunctionDesc	MS_Description	Descriptive name for the function of assignment. This will include Management, Instructional, Other Proffesional and Technical.
HourlyRate	MS_Description	Degines the rate that will be calculated on the assignment for the emplloyee.
InstitutionalAssignmentType	MS_Description	Descriptive name for the type of assignment as designated by the instiution.
InstitutionalAssignmentTypeCode	MS_Description	A code indicating a type of assignment assigned by the institution.
JobClassCode	MS_Description	A code to indicate the classification of the assignment.
JobGroup	MS_Description	Descriptive name of the group categorization of the assignment.
JobGroupCode	MS_Description	A code to indicate the group categorization of the assignment.
JobTitle	MS_Description	The job title for the assignment, this will be the job title for an employee that holds this assignment.
LastPaymentDateRange	MS_Description	A range of time, for which the assignment was processed by a regular pay, based on the current date. The ranges include 1 to 3
OvertimeRate	MS_Description	The overtime rate is the same as the hourly rate except that only designated overtime time types will be calculated at this rate
PayBasis	MS_Description	An indication of how the rate of pay will be calculated for the assignment, the values will be Hourly or Salary.
PersonId	MS_Description	Unique identifier assigned to each employee by the source system.
PositionCode	MS_Description	Unique identifier assigned to each position by the source system.
PrimaryAssignment	MS_Description	Indication if the assignment should be used as the employees primary assignment as long as the assignment is active.
PrimarySalaryAccountNumber	MS_Description	The current primary salary expense account for the assignment.
RegularTemporary	MS_Description	An indication if the assignment 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?
StartDate	MS_Description	The date the Assignment is active for the employee. Only active assignments are available for payment.
TotalSalary	MS_Description	The caluclated total salary for an assignment for an employee which includes the base salary plus any supplements.

Object

Property

Value

/****** Object: Table [dbo].[DimAssignment] Script Date: 03/09/2017 17:14:53 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimAssignment](
    [AssignmentSK] [int] IDENTITY(1,1) NOT NULL,
    [AssignmentAK] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PersonId] [int] NOT NULL,
    [PositionCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AssignmentSequenceNumber] [smallint] NOT NULL,
    [JobTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AssignmentStatus] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AssignmentTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AssignmentType] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionDesc] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimarySalaryAccountNumber] [varchar](28) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StartDate] [datetime] NOT NULL,
    [EndDate] [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,
    [InstitutionalAssignmentTypeCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [InstitutionalAssignmentType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimaryAssignment] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RegularTemporary] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ExemptStatus] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AssignmentFulltimeParttime] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AssignmentEndDateRange] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LastPaymentDateRange] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EndBasisCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EndBasis] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BaseSalary] [numeric](11, 2) NOT NULL,
    [ActualSalary] [numeric](11, 2) NOT NULL,
    [DailyRate] [numeric](9, 2) NOT NULL,
    [HourlyRate] [numeric](9, 4) NOT NULL,
    [OvertimeRate] [numeric](9, 4) NOT NULL,
    [TotalSalary] [numeric](11, 2) 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.DimAssignment] PRIMARY KEY CLUSTERED
(
    [AssignmentSK] 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].[DimAssignment] ADD  DEFAULT ('12/31/9999') FOR [RowEndDate]

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

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The caluclated actual salary for an assignment for an employee when adjusted because the assignment started late or ended early.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'ActualSalary'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key for the assignment, this will contain the Person ID, the Position Code and a Sequence Number.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'AssignmentAK'

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A number assigned to each consecutive relationship between an employee and a position at the institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'AssignmentSequenceNumber'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of the current status of the Assignment, the valid values are Active and Ended.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'AssignmentStatus'

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Defines the base annual salary for an assignment for an employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'BaseSalary'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A calculated rate using the base salary divided by the number of paid contract days.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'DailyRate'

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date the Assignment is no longer active for the employee. Only active assignments are available for payment.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'EndDate'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Degines the rate that will be calculated on the assignment for the emplloyee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'HourlyRate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of assignment as designated by the instiution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'InstitutionalAssignmentType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A code indicating a type of assignment assigned by the institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'InstitutionalAssignmentTypeCode'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the group categorization of the assignment.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @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 assignment. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'JobGroupCode'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A range of time, for which the assignment was processed by a regular pay, based on the current date. The ranges include 1 to 3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'LastPaymentDateRange'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The overtime rate is the same as the hourly rate except that only designated overtime time types will be calculated at this rate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'OvertimeRate'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique identifier assigned to each employee by the source system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'PersonId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique identifier assigned to each position by the source system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'PositionCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the assignment should be used as the employees primary assignment as long as the assignment is active.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'PrimaryAssignment'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication if the assignment is intended to be on-going (regular) or temporary.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @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'DimAssignment', @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'DimAssignment', @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'DimAssignment', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date the Assignment is active for the employee. Only active assignments are available for payment.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'StartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The caluclated total salary for an assignment for an employee which includes the base salary plus any supplements.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimAssignment', @level2type=N'COLUMN',@level2name=N'TotalSalary'

ActualSalary

AssignmentAK

AssignmentEndDateRange

AssignmentFulltimeParttime

AssignmentSequenceNumber

AssignmentSK

AssignmentStatus

AssignmentType

AssignmentTypeCode

BaseSalary

DailyRate

EndBasis

EndBasisCode

EndDate

ExemptStatus

FunctionCode

FunctionDesc

HourlyRate

InstitutionalAssignmentType

InstitutionalAssignmentTypeCode

JobClassCode

JobGroup

JobGroupCode

JobTitle

LastPaymentDateRange

OvertimeRate

PayBasis

PersonId

PositionCode

PrimaryAssignment

PrimarySalaryAccountNumber

RegularTemporary

RowEndDate

RowIsCurrent

RowStartDate

StartDate

TotalSalary

528.30

000077843BIO5ADJS003

7 Months to 1 Year

Part Time

211937

Ended

Ops-Instructional, Other Professioanl

528.30

0.00

Contract Ended By Calendar

CONENDED

2016-05-06T00:00:00-04:00

Yes

Direct Instruction

35.2200

Adjunct Instructor

ADJUNCT

ADJFAC

Adjunct Instructors Paid By Salary

ADJUNCT

Adjunct Instructor

7 Months to 1 Year

0.0000

Salary

77843

BIO5ADJS

11110400-110400-50-56000

Temporary

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2016-04-01T00:00:00-04:00

528.30

1095.15

000002186CPO5ETOS029

More than 2 Years

Part Time

46081

Ended

Ops-Instructional, Other Professioanl

1095.15

0.00

Contract Ended By Calendar

CONENDED

2014-12-18T00:00:00-05:00

Yes

Direct Instruction

31.2900

Adjunct Instructor

ADJUNCT

ADJFAC

Adjunct Instructors Paid By Salary

ADJUNCTR

Adjunct Instructor

More than 2 Years

0.0000

Salary

2186

CPO5ETOS

11131500-131501-50-56008

Temporary

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2014-08-22T00:00:00-04:00

1095.15

0.00

000000157CJTCADJU162

More than 2 Years

Part Time

162

1462

Ended

Ops-Instructional, Other Professioanl

0.00

Contract Ended By Calendar

CONENDED

2009-09-17T00:00:00-04:00

Yes

Direct Instruction

29.2200

New Semester - Adjuncts

NEWSEM

ADJFAC

Adjunct Instructors Paid By The Hour

ADJUNCT

Adjunct Instructor

More than 2 Years

29.2200

Hourly

157

CJTCADJU

11270200-270200-93-56000

Temporary

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2009-09-02T00:00:00-04:00

0.00

2168.07

000001302MAT5OVLS036

7 Months to 1 Year

Part Time

31851

Ended

Personnel Cost-Instructional

2168.07

0.00

Contract Ended By Calendar

CONENDED

2016-08-09T00:00:00-04:00

Yes

Direct Instruction

40.8300

Overload Assignment

OVERLOAD

OVLD

Overload For Faculty_Based Upon Salary

OVERLDSY

Faculty Overload

7 Months to 1 Year

0.0000

Salary

1302

MAT5OVLS

11161700-161700-50-52100

Temporary

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2016-06-28T00:00:00-04:00

2168.07

0.00

000001828EMS1ADJU007

More than 2 Years

Part Time

45812

Ended

Ops-Instructional, Other Professioanl

0.00

Contract Ended By Calendar

CONENDED

2001-11-09T00:00:00-05:00

Yes

Direct Instruction

26.2300

New Semester - Adjuncts

NEWSEM

ADJFAC

Adjunct Instructors Paid By The Hour

ADJUNCT

Adjunct Instructor

N/A

26.2300

Hourly

1828

EMS1ADJU

11230100-230103-10-56000

Temporary

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2001-07-02T00:00:00-04:00

0.00

31783.20

0000052466183 007

More than 2 Years

Full Time

81098

Ended

Personnel Cost-Technical

31783.26

122.24

Assignment Change

CHANGE

2011-06-30T00:00:00-04:00

Academic Support

15.2800

Fulltime Employee

FULLTIME

ADASSTII

12 Month Employees Working 40 Hours Per Week

12MO40

Administrative Asst Ii

More than 2 Years

15.2800

Salary

5246

6183

Yes

14603000-460301-20-54000

Regular

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2010-07-01T00:00:00-04:00

31783.26

1679.43

000003628PIL1ADJS003

More than 2 Years

Part Time

72830

Ended

Ops-Instructional, Other Professioanl

1679.43

0.00

Contract Ended By Calendar

CONENDED

2005-05-06T00:00:00-04:00

Yes

Direct Instruction

32.9300

New Semester - Adjuncts

NEWSEM

ADJFAC

Adjunct Instructors Paid By Salary

ADJUNCT

Adjunct Instructor

More than 2 Years

0.0000

Salary

3628

PIL1ADJS

Yes

11260100-260104-10-56000

Temporary

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2005-02-01T00:00:00-05:00

1679.43

3457.17

000013289HLT1OVLS003

More than 2 Years

Part Time

109003

Ended

Personnel Cost-Instructional

3457.17

0.00

Temporary Assignment

TEMPJOB

2004-06-21T00:00:00-04:00

Yes

Direct Instruction

38.4900

Overload Assignment

OVERLOAD

OVLD

Overload For Faculty_Based Upon Salary

OVERLDSY

Faculty Overload

More than 2 Years

0.0000

Salary

13289

HLT1OVLS

11140800-140802-10-52100

Temporary

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2004-05-16T00:00:00-04:00

3457.17

1995.12

000088321BBM6ADJS020

7 Months to 1 Year

Part Time

214150

Ended

Ops-Instructional, Other Professioanl

1995.12

0.00

Contract Ended By Calendar

CONENDED

2016-05-06T00:00:00-04:00

Yes

Direct Instruction

39.1200

Adjunct Instructor

ADJUNCT

ADJFAC

Adjunct Instructors Paid By Salary

ADJUNCT

Adjunct Instructor

7 Months to 1 Year

0.0000

Salary

88321

BBM6ADJS

11150591-115050-93-56000

Temporary

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2016-01-06T00:00:00-05:00

1995.12

0.00

000029766CJTCADJU083

More than 2 Years

Part Time

156459

Ended

Ops-Instructional, Other Professioanl

0.00

Contract Ended By Calendar

CONENDED

2008-07-30T00:00:00-04:00

Yes

Direct Instruction

29.2200

New Semester - Adjuncts

NEWSEM

ADJFAC

Adjunct Instructors Paid By The Hour

ADJUNCT

Adjunct Instructor

More than 2 Years

29.2200

Hourly

29766

CJTCADJU

11270200-270200-93-56000

Temporary

9999-12-31T23:59:00-05:00

2017-03-09T12:14:00-05:00

2008-07-30T00:00:00-04:00

0.00

Property	Value
Name	DimAssignment
Schema	dbo
Row Count	239594
Data Size	107736 KB
Index Size	416 KB
Create Date	3/9/2017 10:43 AM
Description