Table - dbo.DimRelativeDay

Property	Value
Name	DimRelativeDay
Schema	dbo
Row Count	220032
Data Size	42776 KB
Index Size	112 KB
Create Date	5/29/2013 12:12 AM
Description	Term Relative Day information including number of days from start of term. One row per Term for the period -365 days prior to the start date and +365 days after the start date for all terms.

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
RelativeDay	varchar(15)	False	False	False			Descriptive title for the relative day of the term.
RelativeDayDate	date(10, 0)	False	False	False			The day number as comparted to the start date of the term in date format.
RelativeDayDateSK	int(10, 0)	False	False	False			The day number as comparted to the start date of the term in integer format.
RelativeDayFullDescription	varchar(50)	False	False	False			Full Description is composed of [Term Title], [Relative Day]. For example - Fall 2015, Day -365
RelativeDayFullDescription_Sort	int(10, 0)	False	False	False			Field provides correct sort order for relative days based on Term and RelativeDay.
RelativeDayNumber	int(10, 0)	False	False	False			The day number as comparted to the start date of the term.
RelativeDaySK	int(10, 0)	False	False	False			Primary ID Key for the Relative Day Dimension, consists of the relative day number concatenated with the term year and the term.
RowEndDate	datetime(23, 3)	True	False	False			When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent	char(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?
Term	varchar(6)	False	False	False			Academic time indication, relates to the academic calendar of the institution. The Term is made up of two values, the first four characters are the academic year and the last two are the term.
TermTitle	varchar(30)	False	False	False			Descriptive name for the term.
TermTypeCode	varchar(3)	False	False	False			Term code for the term.
TermYear	varchar(4)	False	False	False			Academic Year for the term.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_DimRelativeDay	True	RelativeDaySK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.FactEnrollmentActivity	Table
dbo.FactEnrollmentSnapshot	Table

Name	Type
dbo.FactEnrollmentActivity	TABLE
dbo.FactEnrollmentSnapshot	TABLE

Object	Property	Value
DimRelativeDay	MS_Description	Term Relative Day information including number of days from start of term. One row per Term for the period -365 days prior to the start date and +365 days after the start date for all terms.
RelativeDay	MS_Description	Descriptive title for the relative day of the term.
RelativeDayDate	MS_Description	The day number as comparted to the start date of the term in date format.
RelativeDayDateSK	MS_Description	The day number as comparted to the start date of the term in integer format.
RelativeDayFullDescription	MS_Description	Full Description is composed of [Term Title], [Relative Day]. For example - Fall 2015, Day -365
RelativeDayFullDescription_Sort	MS_Description	Field provides correct sort order for relative days based on Term and RelativeDay.
RelativeDayNumber	MS_Description	The day number as comparted to the start date of the term.
RelativeDaySK	MS_Description	Primary ID Key for the Relative Day Dimension, consists of the relative day number concatenated with the term year and the term.
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?
Term	MS_Description	Academic time indication, relates to the academic calendar of the institution. The Term is made up of two values, the first four characters are the academic year and the last two are the term.
TermTitle	MS_Description	Descriptive name for the term.
TermTypeCode	MS_Description	Term code for the term.
TermYear	MS_Description	Academic Year for the term.

Object

Property

Value

/****** Object: Table [dbo].[DimRelativeDay] Script Date: 03/09/2017 17:14:56 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimRelativeDay](
    [RelativeDaySK] [int] NOT NULL,
    [Term] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TermYear] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TermTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RelativeDayNumber] [int] NOT NULL,
    [RelativeDay] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RelativeDayDate] [date] NOT NULL,
    [RelativeDayDateSK] [int] NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
    [RelativeDayFullDescription_Sort] [int] NOT NULL,
    [RelativeDayFullDescription] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [PK_DimRelativeDay] PRIMARY KEY CLUSTERED
(
    [RelativeDaySK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Term Relative Day information including number of days from start of term. One row per Term for the period -365 days prior to the start date and +365 days after the start date for all terms.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive title for the relative day of the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'RelativeDay'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The day number as comparted to the start date of the term in date format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'RelativeDayDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The day number as comparted to the start date of the term in integer format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'RelativeDayDateSK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Full Description is composed of [Term Title], [Relative Day]. For example - Fall 2015, Day -365' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'RelativeDayFullDescription'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Field provides correct sort order for relative days based on Term and RelativeDay.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'RelativeDayFullDescription_Sort'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The day number as comparted to the start date of the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'RelativeDayNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary ID Key for the Relative Day Dimension, consists of the relative day number concatenated with the term year and the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'RelativeDaySK'

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'DimRelativeDay', @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'DimRelativeDay', @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'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Academic time indication, relates to the academic calendar of the institution. The Term is made up of two values, the first four characters are the academic year and the last two are the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'Term'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'TermTitle'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Term code for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'TermTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Academic Year for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimRelativeDay', @level2type=N'COLUMN',@level2name=N'TermYear'

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

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

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

1 to 2 Years

SUB

TEMPORARY SUBSTITUTES

SUBTEMP

VICE PRES STUDENT AFFAIRS

30

No

HOURLY

Yes

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

MESPECII

12 MONTH EMPLOYEES WORKING 35 HOURS PER WEEK

12MO35

PRESIDENT

10

No

SALARY

No

AA6068

Full Time

Filled

MEDIA SPECIALIST II

Personnel Cost-Technical

54

14102000-410200-10-54000

Regular

N

Y

5615

35.00

No

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

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

01 to 3 Months

SUB

REGULAR EMPLOYEES THAT SUBSTITUTE

SUBREG

PRESIDENT

10

No

HOURLY

Yes

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

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

GRDKPII

12 MONTH EMPLOYEES WORKING 40 HOURS PER WEEK

12MO40

VICE PRES/PROVOST MAIN CAMPUS

20

No

SALARY

No

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

01 to 3 Months

ADJFAC

ADJUNCT INSTRUCTORS PAID BY SALARY

ADJUNCTR

VICE PRES OF ADMIN & FINANCE

50

No

SALARY

Yes

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

SLCMGR

12 MONTH EMPLOYEES WORKING 40 HOURS PER WEEK

12MO40

VICE PRES/PROVOST MAIN CAMPUS

20

No

SALARY

No

1599

Full Time

Filled

STUDENT LEARNING CTR MANAGER

Personnel Cost-Other Professional

53

14105000-410500-20-53000

Regular

N

Y

2089

40.00