QUESTION: My plan uses hours to compute credited service. The formula is Hours worked in the calendar year divided by 2080. If participants work more than 2080 hours in a year, credited service is greater than one. My client provides hours worked on a monthly basis and would like to project hours beginning in the current year using the last fully reported year, but not over 2080 hours. How can ProAdmin do this?

ANSWER: Set up the Projections Assumptions to use last fully reported year and set up a service definition using a calendar year measurement period. In the Hours Conversion topic of the credited service definition, the operator #THIS will return all hours, both read from the database and projected using the last fully reported year. We will compute service using the formula hours/2080 and limit this service to one when using projected hours.

Our hours conversion expression will show:   

	Next_year := (#YEAR #TODAY) + 1		&	; Add 1 to today's year.
	Jan1_NextYear = 1/1/1900 #dateplus
		[(Next_year-1900) * 1y]	&	; Determine first of next year.
	#IF #DATE < Jan1_NextYear #THEN			; Use actual hours and project
		#THIS / 2080		; current year's hours for
	#ELSE			; credited service.
		(#THIS / 2080) #MIN 1		; Use projected hours but limit
	#ENDIF			; service to one year

Back to Hours Conversion