This page (revision-16) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
16 26-Nov-2021 10:22 53 KB rforbes to previous
15 26-Nov-2021 10:22 53 KB JMyers to previous | to last
14 26-Nov-2021 10:22 53 KB JMyers to previous | to last
13 26-Nov-2021 10:22 55 KB JMyers to previous | to last
12 26-Nov-2021 10:22 55 KB JMyers to previous | to last
11 26-Nov-2021 10:22 55 KB JMyers to previous | to last
10 26-Nov-2021 10:22 55 KB JMyers to previous | to last
9 26-Nov-2021 10:22 54 KB JMyers to previous | to last
8 26-Nov-2021 10:22 55 KB JMyers to previous | to last
7 26-Nov-2021 10:22 54 KB JMyers to previous | to last
6 26-Nov-2021 10:22 54 KB JMyers to previous | to last
5 26-Nov-2021 10:22 54 KB JMyers to previous | to last
4 26-Nov-2021 10:22 54 KB JMyers to previous | to last
3 26-Nov-2021 10:22 54 KB JMyers to previous | to last
2 26-Nov-2021 10:22 53 KB JMyers to previous | to last
1 26-Nov-2021 10:22 53 KB JMyers to last

Page References

Incoming links Outgoing links
FRS
FRS

Version management

Difference between version and

At line 35 changed 5 lines
|B0320|FRS Reg Earns|All earnings PC that make up Regular Earnings
|B0321|FRS Lump Earns|All earnings PC that make up Lump Sum Leave Pay Earnings
|B0323|FRS PP Earns|All earnings PC that make up Prior Period Earnings
|B0328|FRS WC Earns|All earnings PC that make up Workers’ Compensation Earnings
|B0380|FRS Lv Hrs|All earnings PC that make up Lump Sum Leave Pay Hours
|B0320|FRS Reg Earns|All earnings PC that make-up Regular Earnings
|B0321|FRS Lump Earns|All earnings PC that make-up Lump Sum Leave Pay Earnings
|B0323|FRS PP Earns|All earnings PC that make-up Prior Period Earnings
|B0328|FRS WC Earns|All earnings PC that make-up Workers’ Compensation Earnings
|B0380|FRS Lv Hrs|All earnings PC that make-up Lump Sum Leave Pay Hours
At line 78 changed one line
The Employer Contribution Rate must be entered through the [IBPN] screen (Rate step 1; Up to limit 999,999).
The Employer Contribution Rate must be entered through the ‘IBPN’ screen (Rate step 1; Up to limit 999,999).
At line 98 changed one line
*The standard or most commonly used rule(s) for each component is indicated by the asterisk (*) in the rule column. %%
*The standard or most commonly used rule(s) for each Component is indicated by the asterisk (*) in the rule column. %%
At line 100 added one line
At line 118 changed 2 lines
|02*|Use Hire Date|Uses Hire Date from Employment Information ([IEEI]) form to determine effective date of employee’s coverage.| |B0030
|03|Use Seniority Date|Uses Seniority Date from Employment Information ([IEEI]) form to determine effective date of employee’s coverage. | |B0030
|02*|Use Hire Date|Uses Hire Date from Employment Information form (IEEI) to determine effective date of employee’s coverage.| |B0030
|03|Use Seniority Date|Uses Seniority Date from Employment Information form (IEEI) to determine effective date of employee’s coverage. | |B0030
At line 121 changed 3 lines
|05|Use Leave Date|Uses Leave Date from Employment Information ([IEEI]) form to determine effective date of the employee’s coverage. This rule is normally only used with disability type plans.| |B0030
|06|Use Birth Date|Uses employee’s birth date from Identity Information ([IEEI]) form plus a qualifying period to determine effective date of employee’s coverage. Sometimes used for pension type plans that become mandatory at age 18 or 21.| |B0030
|07|Use Termination Date|Uses employee’s termination date from Employment Information ([IEEI]) form to determine effective date of employee’s coverage. Used for special coverages available to an employee only after termination, for example, on retirement.| |B0030
|05|Use Leave Date|Uses Leave Date from Employment Information form (IEEI) to determine effective date of the employee’s coverage. This rule is normally only used with disability type plans.| |B0030
|06|Use Birth Date|Uses employee’s birth date from Identity Information form (IEID) plus a qualifying period to determine effective date of employee’s coverage. Sometimes used for pension type plans that become mandatory at age 18 or 21.| |B0030
|07|Use Termination Date|Uses employee’s termination date from Employment Information form (IEEI) to determine effective date of employee’s coverage. Used for special coverages available to an employee only after termination, for example, on retirement.| |B0030
At line 159 changed 2 lines
Yes - Choose the rule to be used\\
No - Go to B0070\\
Yes Choose the rule to be used\\
No Go to B0070\\
At line 181 changed 2 lines
|02*|Use Hire Date|Uses Hire Date from Employment Information ([IEEI]) form to determine eligibility date of employee’s coverage.| |B0090
|03|Use Seniority Date|Uses Seniority Date from Employment Information ([IEEI]) form to determine eligibility date of the employee’s coverage.| |B0090
|02*|Use Hire Date|Uses Hire Date from Employment Information form (IEEI) to determine eligibility date of employee’s coverage.| |B0090
|03|Use Seniority Date|Uses Seniority Date from Employment Information form (IEEI) to determine eligibility date of the employee’s coverage.| |B0090
At line 184 changed 3 lines
|05|Use Leave Date|Uses Leave Date from Employment Information ([IEEI]) form to determine eligibility date of employee’s coverage. This rule is normally only used with disability type plans.| |B0090
|06|Use Birth Date|Uses employee’s Birth Date from Identity Information ([IEID]) form plus a qualifying period to determine eligibility date of employee’s coverage. Sometimes used for pension type plans that become mandatory at age 18 or 21.| |B0090
|07|Use Termination Date|Uses employee’s Termination Date from Employment Information ([IEEI]) form to determine eligibility date of employee’s coverage. Used for special Coverages available to an employee only after termination (retirement).| |B0090
|05|Use Leave Date|Uses Leave Date from Employment Information form (IEEI) to determine eligibility date of employee’s coverage. This rule is normally only used with disability type plans.| |B0090
|06|Use Birth Date|Uses employee’s Birth Date from Identity Information form (IEID) plus a qualifying period to determine eligibility date of employee’s coverage. Sometimes used for pension type plans that become mandatory at age 18 or 21.| |B0090
|07|Use Termination Date|Uses employee’s Termination Date from Employment Information form (IEEI) to determine eligibility date of employee’s coverage. Used for special Coverages available to an employee only after termination (retirement).| |B0090
At line 254 changed 2 lines
|02*|Use Termination Date|Uses the employee’s Termination Date from Employment Information ([IEEI]) form to determine the date the employee’s enrollment is expired, or 31st December, 3999 if there is no termination date available.| |B0160
|03|Use Leave Date|Uses the employee’s Leave Date from Employment Information ([IEEI]) form to determine the date the employee’s enrollment is expired.| |B0160
|02*|Use Termination Date|Uses the employee’s Termination Date from Employment Information form (IEEI) to determine the date the employee’s enrollment is expired, or 31st December, 3999 if there is no termination date available.| |B0160
|03|Use Leave Date|Uses the employee’s Leave Date from Employment Information form (IEEI) to determine the date the employee’s enrollment is expired.| |B0160
At line 257 changed one line
|05*|Use Birth Date|Uses the employee’s Birth Date from the Identity Information ([IEID])form plus a continuation period to determine the date an employee’s enrollment is expired.\\ \\Sometimes used for life type plans that automatically expire at a specific age.| |B0160
|05*|Use Birth Date|Uses the employee’s Birth Date from the Identity Information form (IEID) plus a continuation period to determine the date an employee’s enrollment is expired.\\ \\Sometimes used for life type plans that automatically expire at a specific age.| |B0160
At line 279 changed one line
|02*|Terminated after Specified Day|Specify the <BC Value> on the coverage component.\\ \\The value of the component is used as the user-provided day of the month after which an employee must be terminated in order to remain enrolled during the last month of employment.\\ \\Must be entered as DD (15 for the 15th of the month.)|B0160|B0180
|02*|Terminated after Specified Day|Specify the <BC Value> on the coverage component.\\ \\The value of the component is used as the user-provided day of the month after which an employee must be terminated in order to remain enrolled during the last month of employment.\\ \\Must be entered as DD (15 for the 15th of the month.) |B0160|B0180
At line 321 changed 2 lines
|02*|Use Termination Date|Uses employee’s Termination Date from Employment Information ([IEEI]) form to determine date employee’s eligibility is expired, or 31st December, 3999 if date is unavailable.| |B0220
|03|Use Leave Date|Uses employee’s Leave Date from Employment Information ([IEEI]) form to determine date employee’s eligibility is expired, or 31st December, 3999 if date is unavailable.| |B0220
|02*|Use Termination Date|Uses employee’s Termination Date from Employment Information form (IEEI) to determine date employee’s eligibility is expired, or 31st December, 3999 if date is unavailable.| |B0220
|03|Use Leave Date|Uses employee’s Leave Date from Employment Information form (IEEI) to determine date employee’s eligibility is expired, or 31st December, 3999 if date is unavailable.| |B0220
At line 324 changed one line
|05*|Use Birth Date|Uses employee’s Birth Date from Identity Information ([IEID]) form plus a continuation period to determine date employee’s eligibility is expired. Sometimes used for life type plans that automatically expire at a specific age.| |B0220
|05*|Use Birth Date|Uses employee’s Birth Date from Identity Information form (IEID) plus a continuation period to determine date employee’s eligibility is expired. Sometimes used for life type plans that automatically expire at a specific age.| |B0220
At line 409 changed one line
|00|UserCalc Only|Specify the name of the <User Calc> on the component.\\ \\ The UserCalc must be of the type `Function`, with a return value of the type `Numeric`. Use the RET operator to return the numeric value.\\ \\This value is interpreted by the component as a user provided prior period earnings.| |B0328
|00|UserCalc Only|Specify the name of the <User Calc> on the component.\\ \\ The UserCalc must be of the type `Function`, with a return value of the type `Numeric`. Use the RET operator to return the numeric value.\\ \\This value is interpreted by the component as a user-provided prior period earnings.| |B0328
At line 417 changed one line
|00|UserCalc Only|Specify the name of the <User Calc> on the component.\\ \\The UserCalc must be of the type `Function`, with a return value of the type `Numeric`. Use the RET operator to return the numeric value.\\ \\This value is interpreted by the component as a user provided special compensation amount.| |B0350
|00|UserCalc Only|Specify the name of the <User Calc> on the component.\\ \\The UserCalc must be of the type `Function`, with a return value of the type `Numeric`. Use the RET operator to return the numeric value.\\ \\This value is interpreted by the component as a user- provided special compensation amount.| |B0350
At line 464 changed one line
|00|Use Value from UserCalc|Specify the name of the <User Calc> on the component.\\ \\The UserCalc must be of the type `Function`, with a return value of the type `Numeric`. Use the RET operator to return the numeric value.\\ \\This value is interpreted by the component as a user provided contribution rate.| |B0810
|00|Use Value from UserCalc|Specify the name of the <User Calc> on the component.\\ \\The UserCalc must be of the type `Function`, with a return value of the type `Numeric`. Use the RET operator to return the numeric value.\\ \\This value is interpreted by the component as a user- provided contribution rate.| |B0810
At line 528 changed one line
|0010 – 0299|Pre-processing/Qualification
|0010 – 0299|Preprocessing/Qualification
At line 576 changed one line
This is a SYSTEM updated user field.\\
This is a SYSTEM updated user field.
At line 579 changed one line
\\ \\
At line 581 changed 2 lines
This is a SYSTEM updated user field.\\
This is a SYSTEM updated user field.
At line 592 changed one line
Function [RPFRS] produces the FRS report and optionally the associated file for transmission. \\ \\
Function [UPFRS] produces the FRS report and optionally the associated file for transmission. \\ \\
At line 605 changed 3 lines
|Employer Contribution Amount|Derived from Coverage ([IBPN])|The ER Rate on the coverage multiplied by the Pay Component containing the earnings
|Leave Hours|From PC|The hours in the Pay Component on Benefit Component B380
|Adjustment|Derived from Coverage ([IBPN])|The ER Rate on the coverage multiplied by the Pay Component containing the earnings, when there is an amount in the Pay Component attached to B383
|Employer Contribution Amount Derived from (IBPN) Coverage The ER Rate on the coverage multiplied by the Pay Component containing the earnings
Leave Hours From PC The hours in the Pay Component on Benefit Component B380
Adjustment Derived from (IBPN) Coverage The ER Rate on the coverage multiplied by the Pay Component containing the earnings, when there is an amount in the Pay Component attached to B383
At line 609 added 31 lines
Output Transmission File from the above report
‘Process FRS’ Highlights
‘Process FRS’ is not currently available through the menu bar. However, the form may be accessed through the command window with ‘UPFRS’.
‘Process FRS’ Usages and Examples
Report Parameter Form People List Mandatory, Multiple Selection, LOV available, <ALL>
A people list may be used to indicate specific employee transaction to be processed.
Person Code Mandatory, Multiple Selection, LOV available, <ALL>
The person code(s) of specific employee(s) to be processed.
Payroll Month/Year Mandatory
Users must specify the reporting month and year to be displayed on the report as MM/YYYY
AsOf Date Period Mandatory, Date, LOV available (DD-MON-YYYY)
This date is used to determine the wage rate, department, class code, etc. for the employee. This is used as there may be more than one period supplied.
For Period Mandatory
The pay period of the first pay to be included entered as YYYYPP.
To Period Mandatory
The pay period of the last pay to be included entered as YYYYPP.
Sort Method Mandatory, LOV available
Employees will be printed in this person code order unless this parameter is <Yes>
Create File Mandatory, LOV available
The report may be run without creating an interface file (normally for testing purposes).
Interface Directory Mandatory, text
Must be a directory on the server for which the current user (as signed onto the client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the ‘TEMP’ directory on the server, not the local directory for the computer terminal being used.
File Name Mandatory, text
Enter the name of the file that will be created in the interface directory specified.
Exception Level Mandatory, LOV available
A ‘trace’ report of exception messages may be produced to assist in the testing phase. If necessary, choose from 0 – 9 (highest) level of trace. Please note that this is a voluminous report and will cause very slow performance.
At line 610 changed one line
Modify the standard FRS file requirements using the [IDFDV] function for HL$FLPERS.\\ \\
Modify the standard FRS file requirements using the IDFDV function for HL$FLPERS.
At line 612 changed 28 lines
__File Format Supported__
||Field Identifier||Description||Source||Variable||Notes
|DEPARTMENT|Department|Data Base Column|[DDP.DEPARTMENT_CODE|DEPARTMENT_CODE]|
|POSITION NUMBER|Position Number|Data Base Column|[DPS.POSITION_CODE|POSITION_CODE]|
|CLASS CODE|Class Code|Not Specified| |
|PLAN|FRS Plan Code|Data Base Column|[BPN.PLAN_CODE|PLAN_CODE]|
|WORK PERIOD|Work Period Code|Not Specified| |
|ADJ CODE|Adjustment Code|Not Specified| |
|CHECK DATE|Check Date|Not Specified| |
|EMPLOYEE NAME|Employee Name (Last, First, MI)|Not Specified| |
|SOCIAL SECURITY NUMBER|Employee Social Security Number|Data Base Column|[EID.GOVERNMENT_CODE|GOVERNMENT_CODE]|
|DATE OF BIRTH|Date of Birth (DOB)|Data Base Column|[EID.BIRTH_DATE|BIRTH_DATE]|
|SEX|Employee Gender|Data Base Column|[EID.GENDER|GENDER]|
|ADDRESS LINE 1|Employee Address Line One|Data Base Column|[EPS.ADDRESS_LINE_1|ADDRESS_LINE_1]|
|ADDRESS LINE 2|Employee Address Line Two|Data Base Column|[EPS.ADDRESS_LINE_2|ADDRESS_LINE_2]|
|ADDRESS CITY|Employee City|Data Base Column|[EPS.LOCALITY|LOCALITY]|
|ADDRESS STATE|Employee State|Data Base Column|[DSP.STATE_PROVINCE_CODE|STATE_PROVINCE_CODE]|
|ADDRESS ZIP CODE|Employee Zip|Data Base Column|[EPS.ZIP_POSTAL|ZIP_POSTAL]|
|SALARY|Salary|Element|GROSS|
|EE CONTRIBUTION|Employee Contribution Amount|Pay Component|FRS EE|
|ER CONTRIBUTION|Employer Contribution Amount|Pay Component|FRS ER|
|REPORT PERIOD|Report Period|Not Specified| |
|ANNUAL LEAVE HOURS|Annual Leave Hours|Pay Component| |
|AGENCY|Agency Number|Constant| |
|REPORT FORMAT CODE|Report Format Code|Constant| |
|REPORT PERIOD CD|Report Period (MMYYYY)|Not Specified| |
|TR|Trailer Record Identifier|Constant| |
|DETAIL RECORD COUNT|Detail Record Count|Not Specified| |
File Format Supported
Field Identifier Description Source Variable Notes
DEPARTMENT Department Data Base Column DDP.DEPARTMENT_CODE
POSITION NUMBER Position Number Data Base Column DPS.POSITION_CODE
CLASS CODE Class Code Not Specified
PLAN FRS Plan Code Data Base Column BPN.PLAN_CODE
WORK PERIOD Work Period Code Not Specified
ADJ CODE Adjustment Code Not Specified
CHECK DATE Check Date Not Specified
EMPLOYEE NAME Employee Name (Last, First, MI) Not Specified
SOCIAL SECURITY NUMBER Employee Social Security Number Data Base Column EID.GOVERNMENT_CODE
DATE OF BIRTH Date of Birth (DOB) Data Base Column EID.BIRTH_DATE
SEX Employee Gender Data Base Column EID.GENDER
ADDRESS LINE 1 Employee Address Line One Data Base Column EPS.ADDRESS_LINE_1
ADDRESS LINE 2 Employee Address Line Two Data Base Column EPS.ADDRESS_LINE_2
ADDRESS CITY Employee City Data Base Column EPS.LOCALITY
ADDRESS STATE Employee State Data Base Column DSP.STATE_PROVINCE_CO DE
ADDRESS ZIP CODE Employee Zip Data Base Column EPS.ZIP_POSTAL
SALARY Salary Element GROSS
At line 663 added 15 lines
Field Identifier Description Source Variable Notes
EE CONTRIBUTION Employee Contribution Amount Pay Component FRS EE
ER CONTRIBUTION Employer Contribution Amount Pay Component FRS ER
REPORT PERIOD Report Period Not Specified
ANNUAL LEAVE HOURS Annual Leave Hours Pay Component
AGENCY Agency Number Constant
REPORT FORMAT CODE Report Format Code Constant
REPORT PERIOD CD Report Period (MMYYYY) Not Specified
TR Trailer Record Identifier Constant
DETAIL RECORD COUNT Detail Record Count Not Specified
[{If var='loginstatus' contains 'authenticated'
At line 642 changed 2 lines
![Notes|Edit:Internal.FRS]
[{InsertPage page='Internal.FRS' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.FRS]
[{InsertPage page='Internal.FRS' default='Click to create a new discussion page'}]
}]
This page (revision-16) was last changed on 26-Nov-2021 10:22 by rforbesTop