The Modified SNS Proposed Function Line Report displays the changes that have been made to proposed functions line when they are accepted in the Staffing Notification Processing Screen.
The report lets you select records based on payroll, the name of the user who accepted the notification, notification number, audit date, notification effective date and notification completion date. You can also run the report for specified employees as well as report on only certain types of changes.
The report will show the name and number of the employee whose proposed functions were changed, as well as the payroll ID, notification number, effective date, completion date, username, and timestamp of the change. Additionally, the original proposed function line(s) will be displayed. If sufficient information is contained in the audit records, then the post-modification function lines will also be displayed. The post-modification function lines are reconstructed based on the original function lines and the audit details. The audit details (which comprises of each field that was modified along with the before and after values) can also be displayed.
This report was written a couple of years after SNS was first released. For that reason, the data that originally stored during the audit process didn't fully anticipate the requirements of this report. In conjunction with this report, the auditing procedures were enhanced so as to make available more information on this report. This will result in a few differences when the report displays data that was stored after this report was developed as opposed to before.
Some of the differences include:
The original records did not store the function line number that was being modified. So, if there was more than one function line you can't necessarily tell what function line was being affected. The report will not attempt to display the post-modification function line if it cannot find the function line number on the audit detail. Instead, you will see the following message:
Could not reconstruct modified function lines, problem with field: ???????
and will show the first field that was missing the function line number.
The original audit records did not store enough information to find the exact status history record (with the corresponding original proposed function lines) that went along with the audit details. When the report encounters this, it will search through all of the status history records for that notification and assume a match based on both timestamps being within 10 seconds of each other. This works just fine in the vast majority of instances. In the event that a status history record cannot be found, those changes will be omitted from the report and you will see the following message on the screen (or in the log file if you run in batch):
COULDN'T FIND ANY HRSH01 FOR NO: 0000030467 *****
THE_TIMESTAMP: 20031117110842
HRSH01_LIST: /20031117110856 /
The first timestamp displayed is from the audit details, while the HRSH01_LIST of timestamps is from all status history records attached to that notification. In the above example, you can see that the audit records were created at 11:08.42 am while the status history record was created at 11:08.56 a difference of 14 seconds. There must have been a dramatic system slow down at that time to cause such a delay in when each of the audit records was created.
Additionally, the original auditing process did not write out a record if you closed a notification without accepting non-blank proposed function lines. As a result, this item cannot be reported on entries that were created before this report was developed.
One of the shortcomings of this report is that if function lines are re-ordered, the system reports that all different fields were changed. This can somewhat skew the results depending on how frequently this happens. This project has so drastically exceeded its original scope (and cost) that no attempt has been made to rectify this shortcoming at this time.
Fields To Report On
-
Enter 'A' to report function lines that have been changed in any way. In other words display the function lines regardless of what field changed.
-
Enter 'S' to specify what changes you are interested in seeing on the report.
Fields
-
Enter a list of characters (each character represents a field) that will determine what changes are displayed on the report.
-
Refer to the below table to see what each letter means:
|
Character |
Field |
|---|---|
|
G |
Salary Grid |
|
C |
Pay Cycle |
|
T |
Pay Type |
|
% |
Percentage Employed |
|
R |
Pay Rate |
|
H |
Base Hours |
|
O |
Occupation Code |
|
E |
Employee Type |
|
S |
Shift Code |
|
1 |
Start Period |
|
2 |
End Period |
|
L |
Any GL or Costing Change |
|
3 |
Closed with accepting non-blank proposed function lines |
Payrolls
-
Enter up to 10 payrolls to report on. If you do not enter any payrolls, you will report on all payrolls. Search for a list of all payrolls. Leave this field blank and Enter to continue to the next prompt.
Users
-
Enter up to 10 users to report on. If you do not enter any users, you will report on all users. Search for a list of users. Leave this field blank and Enter to continue to the next prompt.
Notification Number
-
Enter a notification number here if you want to view a specific notification.
Audit Change Date Range
-
Enter a range of dates (each must be entered as (YY)YYMMDD) to select records based on the date that the audit records were created. This is the date the function lines were accepted.
Notification Effective Date Range
-
Enter a range of dates (each must be entered as (YY)YYMMDD) to select records based on the notification effective date.
Notification Completion Date Range
-
Enter a range of dates (each must be entered as (YY)YYMMDD) to select records based on the date that the notifications were completed.
Employee Sort
-
Enter 'A' to sort the employees alphabetically.
-
Enter 'N' to sort the employees by number.
Report Sort
-
Enter '1' to sort the report by payroll, employee and effective date.
-
Enter '2' to sort the report by payroll, user and employee.
Report Format
-
Enter '1' to include both function lines and the audit details.
-
Enter '2' to include the function lines only – without the audit details. Note: the audit details will always display if unable to reconstruct the modified function lines.
-
Enter '3' to include the audit details only.
Employee Selection
-
Enter 'A' to select all employees that match the above criteria.
-
Enter 'S' to select individual employees by number.
Employees
-
Enter the number(s) of the employee(s) to include on the report. Search to do an employee lookup by name. Or alternatively, you can enter a portion of the employee's last name directly into the employee number prompt and it will do the lookup by name for you.