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 609 removed 30 lines
‘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 640 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 642 changed 19 lines
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
__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|
|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| |
At line 662 removed 13 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
This page (revision-16) was last changed on 26-Nov-2021 10:22 by rforbesTop