Module:GS pay

Module documentation[view] [edit] [history] [purge]

{{Module rating }}

Implements Template:GS pay

Update using data from OPM

Usage

{{#invoke:GS pay|get|GS Grade}}
{{#invoke:GS pay|get|GS Grade|Step Number}}

The above documentation is transcluded from Module:GS pay/doc. (edit | history)
Editors can experiment in this module's sandbox (create | mirror) and testcases (edit | run) pages.
Subpages of this module.

--
-- This module implements {{GS pay}}
-- There are 150 cells in the GS Pay table. This LUA reduces the amount of
--   manual input needed to 46
--

local p = {}
local stepOnePay = {}
local GSOnePay = {}
local GSTwoPay = {}
local WIGIncrease = {}

-- UPDATE THESE. Last Update: 2020
-- https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/salary-tables/pdf/2020/GS.pdf
	--For GS [Grade] Step 1 pay
	stepOnePay[3] = 23976
	stepOnePay[4] = 26915
	stepOnePay[5] = 30113
	stepOnePay[6] = 33567
	stepOnePay[7] = 37301
	stepOnePay[8] = 41310
	stepOnePay[9] = 45627
	stepOnePay[10] = 50246
	stepOnePay[11] = 55204
	stepOnePay[12] = 66167
	stepOnePay[13] = 78681
	stepOnePay[14] = 92977
	stepOnePay[15] = 109366
	-- Within Grade increase for GS [Grade]
	WIGIncrease[3] = 799
	WIGIncrease[4] = 897
	WIGIncrease[5] = 1004
	WIGIncrease[6] = 1119
	WIGIncrease[7] = 1243
	WIGIncrease[8] = 1377
	WIGIncrease[9] = 1521
	WIGIncrease[10] = 1675
	WIGIncrease[11] = 1840
	WIGIncrease[12] = 2206
	WIGIncrease[13] = 2623
	WIGIncrease[14] = 3099
	WIGIncrease[15] = 3646
	-- GS1 Pay Table (because it has inconsistent WIG)
	GSOnePay[1] = 19543
	GSOnePay[2] = 20198
	GSOnePay[3] = 20848
	GSOnePay[4] = 21494
	GSOnePay[5] = 22144
	GSOnePay[6] = 22524
	GSOnePay[7] = 23166
	GSOnePay[8] = 23814
	GSOnePay[9] = 23840
	GSOnePay[10] = 24448
	-- GS2 Pay Table (because it has inconsistent WIG}
	GSTwoPay[1] = 21974
	GSTwoPay[2] = 22497
	GSTwoPay[3] = 23225
	GSTwoPay[4] = 23840
	GSTwoPay[5] = 24108
	GSTwoPay[6] = 24817
	GSTwoPay[7] = 22526
	GSTwoPay[8] = 26235
	GSTwoPay[9] = 26944
	GSTwoPay[10] = 27653

function p.basePay(grade, step)
	if step == nil then
		if grade > 2 then
			return stepOnePay[grade]
		elseif grade == 1 then
			return GSOnePay[1]
		else
			return GSTwoPay[2]
		end
	else
		local pay = stepOnePay[grade] + (WIGIncrease[grade] * (step - 1))
		return pay
	end
end
	
function p.get(frame)
	return p.basePay(tonumber(frame.args[1]), tonumber(frame.args[2]))
end
	
return p