Central Reporting Job Scheduling
CR2xxxJ CR5xxxJ CR6xxxJ CR7xxxJ PG8xxx PG9xxx Other

CR6039J
Salary Forecasting - Apply Base Cost Increases

Calculates and applies salary and employer benefit cost increases/decreases against the salary reporting extract file based on user entered cost parameters.
Report:
CR6039A    Apply Base Cost Increases - Input Parameters
CR6039B    Apply Base Cost Increases - Update Report
Special Instructions None
Frequency On-request
Scheduling Restrictions None
Execution Time Anytime (O, B, P or I)
Job Completion Status None
Job Groups None
Job Dependency CR6040J must be run prior to this job.
Operator Instructions None
Estimated Run Time None
Recovery/Restart This job is restartable.


Parameters

CR6039-REP A code to indicate to either suppress or print detail employee update information on CR6039B.
1 = Report employee detail and totals.
2 = Report job function, district/grand totals only.
CR6039-SORT Enter the sort sequence for the update report:
1 = DST-CD, JOB-FUNC, EMP-NAME, JOB-NUM, ACCT-NUM
2 = JOB-FUNC, EMP-NAME, JOB-NUM, ACCT-NUM
HEALTH-1 Enter the new health insurance dollar amount to be effective. If none, leave
blank. Enter as follows: AAAAA,BB
AAAAA = The new health insurance monthly premium amount entered as dollars and cents, (i.e., $255.50 = 25550).
BB = Effective Month. Enter the effective month of the health insurance amount. The amount will be applied that month onward to the end of the fiscal year. Any combination of the 6 above cost factors may be entered for a given job run. If any error is detected in the parameters entered, (i.e., % or amount = 0, effective month not between 01 and 12, job function or retirement plan not valid, etc.), the Input Parameter Report will be printed, but no cost calculations will be done.
INDUST-1 Enter the Industrial Insurance Increase/ Decrease factor. If none, leave blank. Enter as follows: AAAA,BB
AAAA = The Industrial Insurance Percentage Increase/Decrease with decimal implied in first position, (i.e., 2.90% = 0290).
BB = Effective Month. Enter the effective month of the Industrial Insurance Percent. The calculation will be made for that month onward to the end of the fiscal
year. , = Separator
MEDAID-1 Enter the Medical Aid Increase/Decrease factor. If none, leave blank. Enter as follows: AAAA,BB
AAAA = The Medical Aid Percentage Increase/Decrease with decimal implied in first position (i.e., 3.45% = 0345).
BB = Effective Month. Enter the effective month of the medical aid percent. The calculation will be made for that month onward to the end of the fiscal year. , = Separator
OASI-1 Enter the REUGULAR and MEDICARE portion of the OASI Increase/Decrease factor. If only one is changing, enter its new value and enter the current value inwhich the Salary Forecasting data base was calulated in the other. (If college has both Regular and Medicare portion of Oasi - values must be entered for BOTH. If college has only Medicare portion, enter that value only.) IF NO OASI FACTOR APPLICABLE - LEAVE BLANK. Enter as follows: AAAA,BBBBBB,CCCC,DDDDDD,EE
AAAA = The "Regular" Oasi Increase/Decrease with decimal implied in first position. (ie 6.28 enter as 0628) BBBBBB = The "Regular" Oasi Maximum Gross. Enter the maximum gross that the percentage should be applied upto. Enter as whole dollars, ie 053400.
CCCC = The "Medicare" Oasi Increase/Decrease with decimal implied in first position. (ie 1.55 enter as 0155) DDDDDD = The "Medicare" Oasi Maximum Gross. Enter the maximum gross that the percentage should be applied upto. Enter as whole dollars, ie 125000.
EE = Effective month. Enter the effective month for BOTH the Regular and MEDICARE percents. The calculation will be made for that month onward to the end of the fiscal year. , = Seperator
RETIRE-1
RETIRE-2
RETIRE-3
From 1 to 3 Retirement Cost Increase/Decrease variable lines may be entered. Each line contains variables for up to four retirement plans, therefore a maximum of 12 retirement plan variables may be entered. If the retirement factor should apply to all retirement plans, enter the factor with a retirement plan of "**" on just the first occurance of line
1. If no retirement calculation is to be done, leave these 3 lines blank. Enter as follows: AA,BBBB,CC/X/Y/Z
AA = Retirement Plan. Enter the retirement plan the increase is to be applied against. If all retirement plans, enter "**".
BBBB = Percentage Increase/Decrease, with decimal implied in 1st position, (i.e.,
2.65%, enter as 0265).
CC = Effective Month. Enter the effective month of the Retirement Percent. The increase/decrease will be calculated for that month onward to the end of the fiscal
year.
X = 2nd variable information for a retirement plan.
Y = 3rd variable information for a retirement plan.
Z = 4th variable information for a retirement plan. ,/ = Variable/Retirement Plan separators.
SAL-1
SAL-2
SAL-3
SAL-4
SAL-5
From 1 to 5 Salary COST INCREASE/DECREASE variable lines may be entered. Each line contains variables for up to 3 job functions, therefore a maximum of 15 job function salary variables may be entered. If the salary increase factor should apply to all salaries or job functions, enter the factor with a job function of "**" on just the first occurance of line
1. If no salary factors are to be applied, leave those 5 lines blank. Enter as follows: AA,BBBB,C,D,EEE,FF/X/Y Where:
AA = Job Function. Enter the job function that the job increase is to be applied against. If all job functions, enter "**". See attached list of job functions.
BBBB = Percentage or Amount. If percent, decimal implied in 1st position (i.e.,
3.5% enter as 0350). If whole dollar amount, enter as dollars with no decimals (i.e., $75 = 0075).
C = Percentage or Amount Indicator. Enter "P" if amount entered for BBBB is a percent, "A" if amount entered is a dollar amount.
D = Plus or Minus Indicator. Enter "+" if amount entered for BBBB is an increase, "-" if amount entered is a decrease.
EEE = Salary miniumum. Enter the minimum whole dollar increase to be calculated. This is normally associate with C = Percentage. If none, enter zeros.
FF = Effective Increase Month. Enter the effective month of the salary increase. The increase will be calculated for that month onward to the end of the fiscal year, (i.e., 9 month increase beginning in Sept., enter 09).
X = 2nd variable information for a job function for the line - leave blank if
none.
Y = 3rd variable information for a job function for the line - leave blank if
none. ,/ = Variable/Job Function separators
SF-ADJ Enter the 6 digit identification of the reporting extract file ouput from this job which contains only the cost factor adjustment amounts for only those employees affected. It is suggested that this be identified in the same manner as the SF-OUTPUT reporting extract file for this job, but suffixed with the number "1" in each instance, (i.e., 8889B1, 8889C1, etc.). The SF-ADJ output file identified in this job may, if desired, be identified as the SF-INPUT file to any of the reporting
jobs.
SF-INPUT Enter the 6 digit file identification of the reporting extract file to be input to this job. This file identification will be either the SF-OUTPUT file identification from the reporting extract file generation run (CR6040J) or the SF-OUTPUT file identification created by a prior or previous run of this job. The file used here will be the file from which the cost increases are calculated
from.
SF-OUTPUT Enter the 6 digit file identification of the reporting extract file to be created with the cost calculation factors applied where applicable. It is suggested that the fiscal year being calculated/reported followed by a letter be used. (i.e., 8889B, 8889C,
etc.) where "B" is the SF-OUTPUT with "A" as SF-INPUT, "C" is the SF-OUTPUT with "B" as SF-INPUT, etc. NOTE: This process may be run multiple times where the SF-OUTPUT file from one run would be the SF-INPUT file to another. The SF-OUTPUT file created from any given run will probably want to be reported and would be identified as the SF-INPUT file to those jobs.

Distribution: PPMS
Created: WED, JAN 04, 2012, 06:54 AM