USPIMPORT - Import File Specifications
- General Record Format
- Attendance/Absence Import Specification
The USPIMPORT/ ATTEND option allows data obtained from third party software to be imported into USPS. The information is imported into ATDSCN and may be used to automatically load information into UPDCAL_CUR or UPDCAL_FUT.
The import file used with the ATTEND option will be supplied by a third party software vendor. It must be a comma delimited or comma separated values (CSV) file.
The record layout for this file is described in the next section of this chapter.
Any records in the CSV file which are unable to be posted to ATDSCN will be written to a "rejected" CSV file. If desired, the ITC may edit the file to correct the errors then reload the corrected "rejected" file using USPIMPORT.
Attendance/Absence Import Specification
General Record Format
The input records are standard comma separated values (CSV). The records must conform to the following rules:
- Each field is separated by a comma (,).
- Text fields that contain spaces or lowercase characters should be surrounded by double quotes (").
- Numeric fields must contain numeric digits, an explicit decimal point (.), and a leading or trailing sign (+/-). If a sign character is not included in the field, it is assumed positive. The decimal point is optional if the number is a whole number.
- Numeric values must be in the range specified in the record layout.
- Each field is identified by its ordinal position within the record.
- For fields that are optional, if the field is at the end of the record, you may omit the field and all fields after it. For fields in the middle of the record, you must specify a null (string) field consisting of two double quotes ("").
Each record should be terminated by a LF/CR sequence (or just LF or just CR as is appropriate for the source operating system). An LF/CR sequence is preferred.
Example of Absence Transactions
This is an absence transaction record for ID 123456789 on 09-21-1998 for one day of sick leave. Notice that no data was supplied after the appointment type. These fields are all optional.
This is an absence record for ID 123456789 on 09-21-1998 for 5.75 hours of sick leave. In this transaction, the location code is used to determine the job rather than the job number.
Example of Attendance Transactions
This is an attendance record for ID 123456789. The attendance was for half a day and it is not to be posted to UPDCAL. The job to post to will be determined by the location code and the unit amount (if necessary).
This is an attendance record for ID 123456789 on 10-31-1998. The attendance was for 5 hours and may be posted to UPDCAL using the XREF code for charging the pay account.
This transaction will have the same affect as the previous transaction except it will be using the budget account supplied for pay account charging.
This transaction will post an attendance record for one day. The sub for ID was supplied, so the user will have the option of charging this attendance off to the absentee's regular pay account. At run-time, the user will be asked if they wish to charge the default pay accounts or the regular employee's pay accounts.
Example of Attendance/UPDCAL Transactions
This transaction will post an attendance record for ID 123456789 on 05/14/2012. The attendance is for 5 hours. The pay information will be posted to UPDCAL with the pay type of MIS if the "Post to UPDCAL Current, Future, None:" flag is set to Y. The sub for ID was not supplied therefore, the listed pay account on the csv file will be charged. The board projection flag is set to Y therefore the benefits will be charged to the correct benefit account accordingly.
This transaction will post an absence dock ATDSCN record of 4 hours for ID 987654321 on 01/21/2012. The information will be posted in UPDCAL as a DCK pay type if the user selected Y in the Post to UPDCAL option in the USPIMPORT setup screen.