Ceridian Signature Export File Layout
The following charts show the format and data source for each of the Ceridian Signature export file record types supported by this interface.
Header Record Type "-DC-"
This record appears once as the first record in the export file.
| Field | Position | Size | Contents | Data Source / Description |
|---|---|---|---|---|
| 1 | 01 - 04 | 4 | -DC- | Record type -DC-. |
| 2 | 05 - 07 | 3 | Alphanumeric | Company ID corresponding to the Ceridian Configuration that you selected. |
| 3 | 08 - 10 | 3 | Alphanumeric | Sub-Company ID corresponding to the Ceridian Configuration that you selected. |
| 4 | 11 - 25 | 15 | Blank | |
| 5 | 26 - 27 | 2 | PR | Application code. |
| 6 | 28 - 29 | 2 | X4 | This tells Ceridian that the data source was a custom program (that is, Costpoint). |
| 7 | 30 - 40 | 11 | Blank | |
| 8 | 41 - 42 | 2 | Numeric | Payroll period number that you entered in the Export Timesheets to Ceridian screen. |
| 9 | 43 | 1 | Numeric | Payroll sequence number that you entered in the Manage Ceridian Configuration screen. |
| 10 | 44 - 79 | 36 | Blank | |
| 11 | 80 | 1 | C | Ceridian Billing Code C. |
Header Record Type "BA"
This record appears once as the second record in the export file.
| Field | Position | Size | Contents | Data Source / Description |
|---|---|---|---|---|
| 1 | 01 - 03 | 3 | Alphanumeric | Company ID corresponding to the Ceridian Configuration that you selected. |
| 2 | 04 - 06 | 3 | Alphanumeric | Sub-Company ID corresponding to the Ceridian Configuration that you selected. |
| 3 | 07 - 13 | 7 | Blank | |
| 4 | 14 - 15 | 2 | BA | Record type BA. |
| 5 | 16 - 17 | 2 | Numeric | Payroll Year number that you entered without century (for example, 1996 is sent as 96). |
| 6 | 18 - 19 | 2 | Numeric | Payroll Period Number that you entered. |
| 7 | 20 | 1 | Numeric | Payroll Sequence Number that you entered. |
| 8 | 21 - 80 | 60 | Blank |
Hours/Earnings Record Type "51"
Type 51 records begin with the third record in the export file and appear once for each timesheet line that is processed by the application. (For example, a timesheet with seven charge lines would have seven type 51 records.)
| Field | Position | Size | Contents | Data Source / Description |
|---|---|---|---|---|
| 1 | 01 - 03 | 3 | Alphanumeric | Company ID corresponding to the Ceridian Configuration that you selected. |
| 2 | 04 - 13 | 10 | Alphanumeric | Ceridian Employee number dynamically built at runtime based upon the format parameters that you established in the Manage Ceridian Configuration screen. |
| 3 | 14 - 15 | 2 | 51 | Record Type 51. |
| 4 | 16 - 17 | 2 | Alphanumeric | Ceridian Pay Code linked to either the timesheet line account or pay type that you established in the Ceridian Mapping subtask of the Manage Ceridian Configuration screen. |
| 5 | 18 - 22 | 5 | Numeric | Timesheet line charge hours overpunched expressed in 100ths of an hour (for example, 24.25 hours is sent as 02425). (See the "Numeric Overpunched Fields" section for more information.) |
| 6 | 23 | 1 | Alphanumeric | Ceridian Rate Code linked to either the timesheet line account or pay type that you established in the Ceridian Mapping subtask of the Manage Ceridian Configuration screen. Must be an E, P, or R. |
| 7 | 24 - 30 | 7 | Numeric | Timesheet line labor (Rate Code E) or timesheet line hourly rate (Ceridian Rate CodesP and R) is cost overpunched. Labor cost is expressed in dollars and cents (for example, $1234.56 is sent as 0123456) while hourly rate is expressed in 10,000ths of a dollar (for example, $9.625 is sent as 0096250). |
| 8 | 31 - 80 | 50 | Blank |
Numeric Overpunched Fields
Ceridian requires that all numeric fields containing negative numbers be sent in the EBCDIC numeric overpunched format. If a numeric field has a value less than zero, the digit farthest right in the field is replaced with an overpunch character according to the following translation matrix.
| Digit | Character | Digit | Character |
|---|---|---|---|
| 0 | } | 5 | N |
| 1 | J | 6 | O |
| 2 | K | 7 | P |
| 3 | L | 8 | Q |
| 4 | M | 9 | R |
For example, the number 750 is formatted for a five-digit field as 00750, while the number -1234 in the same field is 0123M, and the number -200 is 0020}.
Employee Status Change Record Type "30"
The only type 30 record currently supported by the Ceridian Timesheet Interface is for status code S (Skip forecast). The application generates one record for each salaried employee that is receiving at least one special paycheck (that is, a type 51 record with a Pay Code of V, 7, 8, or 9) but no regular or overtime paycheck. This record type is interspersed among the type 51 records but appears as the first record for a given employee in the output file.
| Field | Position | Size | Contents | Data Source / Description |
|---|---|---|---|---|
| 1 | 01 - 03 | 3 | Alphanumeric | Company ID corresponding to the Ceridian Configuration that you selected. |
| 2 | 04 - 13 | 10 | Alphanumeric | Ceridian Employee number dynamically built at runtime based upon the format parameters that you established in the Manage Ceridian Configuration screen. |
| 3 | 14 - 15 | 2 | 30 | Record Type 30. |
| 4 | 16 | 1 | S | Status code S (Skip forecast). |
| 5 | 17 - 80 | 64 | Blank |
Batch Total Record Type "95"
This record appears once as the final record in the export file.
| Field | Position | Size | Contents | Data Source / Description |
|---|---|---|---|---|
| 1 | 01 - 03 | 3 | Alphanumeric | Company ID corresponding to the Ceridian Configuration that you selected. |
| 2 | 04 - 06 | 3 | Alphanumeric | Sub-Company ID corresponding to the Ceridian Configuration that you selected. |
| 3 | 07 - 13 | 7 | Blank | |
| 4 | 14 - 15 | 2 | 95 | Record Type 95. |
| 5 | 16 - 24 | 9 | 000000000 | Not currently used. |
| 6 | 25 - 33 | 9 | Numeric | Hash total for all charge overpunched hours fields in all type 51 records. (See "Hash Totals" section for more information.) |
| 7 | 34 - 42 | 9 | Numeric | Hash total for all labor cost/overpunched hourly rate fields in all type 51 records. |
| 8 | 43 - 51 | 9 | 000000000 | Not currently used. |
| 9 | 52 - 60 | 9 | 000000000 | Not currently used. |
| 10 | 61 - 69 | 9 | 000000000 | Not currently used. |
| 11 | 70 - 79 | 10 | Blank | |
| 12 | 80 | 1 | C | Internal use by Ceridian. |
Hash Totals
The hash totals in fields 6 and 7 are the sum of all record type 51 entries in these fields without regard to decimals.
Here is an example of how the charge hours hash total is computed:
| Charge Hours | Hash Value |
|---|---|
| 20.00 | 2,000 |
| 100.00 | 10,000 |
| -40.00 | -4,000 |
| 79.25 | 7,925 |
| Hash Total: | 15,925 |
Here is an example of how the labor cost/hourly rate hash total is computed (remember, labor cost is expressed in 100ths of a dollar, and hourly rate is expressed in 10,000ths of a dollar):
| Rate Code | Labor Amount | Hash Value |
|---|---|---|
| Labor Cost | $1,000.00 | 100,000 |
| Hourly Rate | $17.5500 | 175,500 |
| Labor Cost | $266.67 | 26,667 |
| Hourly Rate | $9.3750 | 93,750 |
| Hash Total: | 342,583 |
Since hash totals can be negative, they are formatted in the EBCDIC numeric overpunch format described earlier. Thus, a hash total of 342,583 is formatted for the nine-digit hash total field as 000342583, while a hash total of -342,583 for the same field is 00034258L.