STRL - ROLLOVER

This common code is required by the STUTZZ utility when option 02 (Common Code Launch) is used.
Since SubTracker is part of the Human Resources subsystem, employee data can be set aside for testing purposes and not be updated by the conversion process. This is done by placing the word "TEST" in the Selection Code 2 field of the Employee Master Record. To make this employee updateable, just take the word "TEST" out of that field.
Code Category: STRL
Code Value: ROLLOVER
Short Description: "DEBUG ON" or "DEBUG OFF"
Medium Description: INSERT ONLY or UPDATE ONLY or blank for both. Insert Only means that if the record is found, the process will not update. Update Only means that if the record is not found, the process will not insert. Blank means both options are available and will both update existing records and insert new records if no record exists.
Long Description: Reserved for future use.
Associated Numeric Values
1-5: Reserved for future use.
Associated Codes
1: Name of table. This is where you put the table name of the table that you are inserting / updating data in.
2: Reserved for future use.
3: TAB or COMMA or PIPE. This is the delimiter type for the data file.
4: DT or DU or DV or DW or DX or DY or D6 or D8. This is the date format. They are as follows:
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 Description
1: Name of file. The data file MUST be in the /admin/data directory on the app server. It can be no longer than 8 characters long, all letters in caps and have no extensions. For example, EMPLOYEE or RETIREE or BENEINFO.
2-4: Reserved for future use.
5: ORACLE, INFORMIX or SQL (default). This flag will inform the program which system you are working with so that any special handling dealing with datetime fields or reserved words can be done.