This report will produce a report listing the employee's address and various information from the employee master information. An optional CSV export file is provided if you would like to load employee information into another computerized software product.
The export file (SRB$OPSWRK:??????.CSV) is a fixed length 316 record byte ASCII file, fields delimited by commas and character fields enclosed in quotation marks. The export file format is:
|
FIELD# |
DATA DESCRIPTION |
MAX SIZE |
TYPE |
|---|---|---|---|
|
1 |
Employee Number |
10 |
Numeric |
|
2 |
Employee Name |
50 |
Character |
|
3 |
Address 1 |
30 |
Character |
|
4 |
Address 2 |
30 |
Character |
|
5 |
City and Prov |
28 |
Character |
|
6 |
Postal Code |
10 |
Character |
|
7 |
Location Code |
4 |
Numeric |
|
8 |
Location Description |
30 |
Character |
|
9 |
User Defined |
10 |
Character |
|
10 |
Email Address |
100 |
Character |
Print Employee No
-
Enter 'Y' to print the employee number.
-
Enter 'N' if the employee number is not to be printed.
Print Address
-
Enter 'Y' to print the employee's address.
-
Enter 'N' if the employee's address is not to be printed.
Print SIN
-
Enter 'Y' to print the employee's Social Insurance Number.
-
Enter 'N' if the employee's Social Insurance Number is not to be printed.
Print Birthdate
-
Enter 'Y' to print the employee's birth date.
-
Enter 'N' if the employee's birth date is not to be printed.
Print Location
-
Enter 'Y' to print the location.
-
Enter 'N' if the location is not to be printed.
Print Occupation
-
Enter 'Y' to print the occupation code.
-
Enter 'N' if the occupation code is not to be printed.
Print Salary Grid
-
Enter 'Y' to print the employee's salary grid.
-
Enter 'N' if the salary grid is not to be printed.
Print Email Adress
-
Enter 'Y' to print the employee's Email Address.
-
Enter 'N' if the Email Address is not to be printed.
Sort by:
-
A NAME
-
B EMP #
-
C SIN
-
D BIRTHDATE
-
E NAME WITHIN LOCATION
-
F EMP # WITHIN LOCATION
-
G BIRTHDATE WITHIN LOCATION
Input Sort Code
-
Enter a valid sort code to sort by employee name. The report/export file will sort in the order chosen.
Report Employees Terminated / On Leave / On Leave with Benefits
Occupation Codes to Include
-
Enter the occupation codes one at a time to report or accept the default to include all occupation codes.
Include Generation of CSV Export File
-
Enter 'Y' to include the generation of the comma separated export file, ######.CSV.
-
Enter 'N' to omit the generation of the comma separated export file.
The report lists:
-
The employee number, name
-
Employee's SIN, Birthdate
-
Employee's address, city, province, postal code and country
-
Employee's phone numbers
-
Employee's Location code and description
-
Employee's Occupation code and description, from master function line
-
Employee's Salary grid and description, from master function line
-
Employee's email address