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 Codes P 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.