User Guide : Map Connectors : Source and Target Map Connectors : PayChex (DJF) Import
 
Share this page             
PayChex (DJF) Import
The integration platform can write, but not read, PayChex (DJF) Import files using an underlying ASCII (Fixed) connector. These files can be read by PayChex software.
This connector sets field width in bytes. What actually varies is the number of characters that fit into a given field. For example, if a field width is 10 bytes and the encoding is Shift-JIS, the field can hold a minimum of 5 characters and a maximum of 10. This means that if you try to write 8 Japanese characters, data is truncated (the Kanji characters all take 2 bytes).
Connector-Specific Notes
No known limitations.
Property Options
You can set the following target (T) properties.
Property
S/T
Description
DatatypeSet
T
This allows you to switch between standard ASCII data types and COBOL display data types.
FieldSeparator
T
Allows you to choose a field separator character for your target file. The default is None. The other choices are comma (,), tab, space, carriage return-line feed (CR-LF), line feed (LF), carriage return (CR), line feed-carriage return (LF-CR), control-R, and pipe ( | ).
If the record separator is not one of the choices in the list and is a printable character, highlight None and then type the correct character. For example, if the separator is an asterisk ( * ), type an asterisk from the keyboard.
If the record separator is not a printable character, replace CR-LF with a backslash, an X, and the hexadecimal value for the separator. For example, if the separator is a check mark, then enter \XFB. For a list of the 256 standard and extended ASCII characters, search for "hex values" in the documentation.
FillFields
T
Writes an ASCII data file where every field is variable length. If this property is set to false, all trailing spaces are removed from each field when the data is written. The default is true. The true setting pads all fields with spaces to the end of the field length to maintain the fixed length of the records.
Ragged Right
T
Writes an ASCII data file where the last field in each record is variable length when set to true. The default is false. The false setting pads the last field with spaces to the end of the record length to maintain the fixed length of the records.
Note:  You must set FillFields to false for the RaggedRight property to work properly. The Ragged Right property has no effect if you set FillFields to true. If you set FillFields to false, then the RaggedRight property determines whether blank fields and fields with only spaces as their data still appears at the end of the record.
RecordSeparator
T
A PayChex (DJF) Import Properties file is presumed to have a carriage return-line feed (CR-LF) between records. To use other characters for a record separator, click the RecordSeparator cell and click once. Then click the arrow to the right of the box and click the desired record separator in the list box. The list box choices are carriage return-line feed (default), line feed, carriage return, line feed-carriage return, form feed, empty line and no record separator. To use a separator other than one from the list, you can type it here.
If the record separator is not one of the choices in the list and is a printable character, highlight the CR-LF and then type the correct character. For example, if the separator is a pipe ( | ), type a pipe from the keyboard.
If the record separator is not a printable character, replace CR-LF with a backslash, an X, and the hexadecimal value for the separator. For example, if the separator is a check mark, then enter \XFB. For a list of the 256 standard and extended ASCII characters, search for "hex values" in the documentation.
Tab Size
T
This sets the number or spaces represented by a tab character. The default is 0.
CodePage
T
This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US.
ANSI
OEM
0037 US (EBCDIC)
0273 Germany (EBCDIC)
0277 Norway (EBCDIC)
0278 Sweden (EBCDIC)
0280 Italy (EBCDIC)
0284 Spain (EBCDIC)
0285 UK (EBCDIC)
0297 France (EBCDIC)
0437 MSDOS United States
0500 Belgium (EBCDIC)
0850 MSDOS Multilingual (Latin 1)
0860 MSDOS Portuguese
0861 MSDOS Icelandic
0863 MSDOS Canadian French
0865 MSDOS Nordic
1051 Roman-8
PayChex Structure
PayChex (DJF) Import files have a predefined structure. One hundred forty-seven fields are defined. The main fields are all 16 characters long with a 1-character separator field in between each one. The data types available vary according to the property options you select. However, all the predefined fields are considered Text.
This is a list of the predefined fields minus the separator fields:
Soc Sec No
Emp Number
First Name
Last Name
Hrly Rate
Level 1-3
Per. Start
Per. End
Department
Rate 1-3
Regular
Ovt Hrs
OT Factor
NonExSick
Exc Sick
Vacation
Holiday
Misc
Expense
Bonus/W
Bonus/P
Bonus/F
1099 Pmt
Chk Num.
Oth Earn1
Oth Earn2
Salary
Adj01 - Adj30
Hour48 - Hour60
Data Types
The following data types are available when the DatatypeSet property is at the default ASCII setting:
Boolean
Name
Number
Text
These data types are available when the DatatypeSet property is set to COBOL:
Display
Display justified
Display sign leading
Display sign leading separate
Display sign trailing
Display sign trailing separate
Text
Zoned decimal
Zoned leading sign
Zoned trailing sign