HRRL - ROLLOVER
Basic Information and Descriptions
The HRUTZZ utility, which imports data into HR tables from flat files, requires this code. Review the HR Data Conversion documentation for details.
Code Category: HRRL
Code Value: ROLLOVER
Short Description: Not used.
Medium Description: INSERT ONLY, UPDATE ONLY, blank for both options, or DO NOT PURGE.
- INSERT ONLY: If the record is found and in Update mode, the process does not update.
- UPDATE ONLY: If the record is not found and in Insert mode, the process does not insert.
- Blank: Both options are available and the utility processes both updates and insertions. Most clients choose this option.
DO NOT PURGE: Use this option with Insert-Only tables. All table records for an Employee ID are purged and then rebuilt during the Insert-Only table process. Select DO NOT PURGE to bypass purging of data. New data is inserted or added to the table.
Duplicate entries can occur using this option.- DO NOT CLEAR: Select this option to prevent data from being cleared during updates. By default, if a data file column is blank, an update to HR causes the same column to be cleared. Select DO NOT CLEAR to keep the data as is and ignore all blank updates. If you want to have some data elements cleared while using DO NOT CLEAR, enter _CLEAR in the data cell of the import file. The system clears that specific data item during the process.
Long Description: Not used.
Associated Numeric Values
1: Reserved for future use.
2: Length of the Employee ID. Defines the size of the Employee ID for all tables. The process calculates the length of the value you submit in the data file and adds leading zeroes to make the data the correct length. For example, the data file contains the number 102 and ID length is specified as 8. The Employee ID becomes 00000102.
3-5: Reserved for future use.
Associated Codes
1: Reserved for future use.
2: ADD x or AS IS.
- ADD x: Adds the character entered ( x ) to the first position in the Employee ID. You can only add one character and no special characters. For example, ADD E. This tells the program to add an E to the first position in the Employee ID. Employee ID 00000102 would become E0000102. The length is still a total of 8.
AS IS: The Employee ID is not formatted and accepts whatever the user enters.
It is recommended to have the ID length set to 12 when using AS IS.
3: TAB, COMMA, or PIPE: Indicates the flat file delimiter type.
4: Indicates the date format being used.
| Date Code | Format |
|---|---|
| DT | MM/DD/YY or MMDDYY |
| DU | MM/DD/YYYY or MMDDYYYY |
| DV | DD/MM/YY |
| DW | DD/MM/YYYY |
| DX | YY/MM/DD |
| DY | YYYY/MM/DD |
| D6 | YYMMDD |
| D8 | YYYYMMDD |
5: Reserved for future use.
Associated Descriptions
1: Reserved for future use.
2: ALLOW ENDDATE UPDATE: Tells the program to allow for end date updates when processing hr_beneinfo records. The default behavior is that end dates are not allowed to be updated.
3: Reserved for future use.
4: INSERT RANGE or WARN SSN.
- The INSERT RANGE option is only available for the Salary Definitions (hr_slrytble table) process and allows ranges to be inserted into the hr_rangtble if not found.
- The WARN SSN option is only available for the Employee Master (hr_empmstr table) process. It allows duplicate SSNs to be entered into the hr_empmstr table with only a warning. If this option is not listed, duplicates are blocked.
5: Reserved for future use.