| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|
| cProcessCode | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event.
|
| mnAddressNumber | AN8 | MATH_NUMERIC | OPT | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
| mnSequenceNumber | SEQ | MATH_NUMERIC | OPT | INPUT |
A number that specifies the sequence of information. |
| cMethodCode | BDM | char | OPT | INPUT |
An employee can in a variety of ways split up net pay. This code specifies the method(s) in which a segment is to be computed:
$ A
specific amount is to be deposited.
% A percentage of net pay is to be deposited.
C A specific amount is to be generated as a payroll
check.
P A specific amount is to be generated as cash.
R The remainder of the net pay, after % and/or specific amount segments are
processed, is to be deposited in the bank.
Q The remainder of the net pay, after % and/or specific amount segments are processed, is to be
generated as cash.
D The remainder of the net pay, after % and/or specific amount segments are processed, is to be generated as a
payroll check.
NOTE: A remainder record is required and only one method can be specified (R, Q, or D). |
| szAccountNumber | FOA# | char | OPT | INPUT |
The employee's unique account number at the financial institution. The number is obtained from the MICR line of a voided check or a
deposit slip from the employee's account. You must include dash cue symbols in the field.
However, they are recorded in a translated mode as a
hyphen (-). Account numbers can also be obtained from other sources, such as passbooks or debit cards. When transcribing information, left
justify and enter only numbers (0 through 9), alphabetic (A through Z), and hyphens (-). If less than 17 characters are required, leave the
unused spaces blank. Spaces left within the depositor's account number will be ignored when the paperless entry is prepared. For example,
0123 4 56789 will appear as 0123456789 in the entry record, and 0123-4 56789 will appear as 0123-456789.
If you change this number, the system
automatically prenotes the employee's auto deposit record again.
NOTE: The Financial Organization Account Number (FOA#) is used as
the company's unique bank account number rather than the employee's unique bank account number in the following files:
F06560 - Bank
Reconciliation - Issue Table
F06561 - Bank Reconciliation - Paid Table |
| szSocialSecurityNumber | SSN | char | OPT | INPUT |
A number that indicates the tax ID. In the United States, the tax ID is the social security number. In Canada, it is the social insurance number.
If you add employee information for a non-US or non-Canadian company, you can leave this field blank. However, if the international code is
set to Y and the default company is non-Canadian and non-United States, you can enter a 16-character number for the tax ID.
The system
does not permit duplicate tax ID numbers. Also, the number cannot include dashes. For example, if a social security number of nn-nn-nnnn is
used, the number should be entered as follows: 123456789.
|
| szNameAlpha | ALPH | char | OPT | INPUT |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name. |
| szCompanyHome | HMCO | char | OPT | INPUT |
The company number where the employee records generally reside. |
| szTaxID | TAX | char | OPT | INPUT |
The identification code required by various tax authorities. This can be a social security number, federal or state corporate tax ID, sales tax
number, and so on. The system verifies the number and prints the separators in their correct format, according to the value of TAXC
(Person/Corporation Code). If no value exists for TAXC, the system uses the Corporate Entity.
Attention Accounts Payable users: The Supplier Master
record supplies the default value for the tax ID for 1099 processing. |
| szStandardEntryClass | SEC | char | OPT | INPUT |
This code permits various kinds of paperless entries to be distinguished. The following entry classes have been defined:
SIA Single
item authorization; and
PPD Pre-arranged payments and deposits.
At the time of this writing only "PPD" is recommended for the entry class. |
| szServiceClassCode | SCC | char | OPT | INPUT |
This code identifies the general classification of dollar entries to be exchanged. This standard is used to facilitate transmission of data
between organizations. Automated Clearing House (ACH) entries required for payroll deposits use the following service class codes:
200 -
ACH entries mixed debit and credits;
220 - ACH credits only (batch format); or
225 - ACH debits only (batch format).
At the time of this writing
only the use of class 200 is recommended. |
| jdDatePayStarts | PSDT | JDEDATE | OPT | INPUT |
The date that an employee may begin participating in the company's benefit plans or may be included in payroll processing.
You can also
use this field to provide a beginning date for seasonal employees or for employees who work only part of the year (such as a teacher who
works only nine months of the year). |
| jdDatePayStops | PTDT | JDEDATE | OPT | INPUT |
The date when an employee should no longer be included in a payroll cycle or the date when an employee stops participating in the
company's benefit plans.
You can use this date for terminated employees, seasonal employees, or employees who work only part of the year
(such as a teacher who works only nine months of the year). See also data item PSDT.
This date may also be the date that a deduction, benefit,
or accrual instruction stops. |
| cFullPartialCode | FPCD | char | OPT | INPUT |
This code only applies to method code $ (see BDM). If there is not enough net pay remaining to process the amount specified in the
amount/percentage field, a value of P in this field specifies that a partial amount can be generated for the bank and account specified for the
segment. A value of F specifies that if the full amount cannot be generated, the segment is ignored.
If you leave this field blank, the system uses F
as the default value. |
| szPreNotificationCode | PREN | char | OPT | INPUT |
A code used to distinguish various types of debit and credit nondollar prenotification transactions that must precede the first actual
automated paperless transaction with dollars for an employee.
Demand Account Credits
23 Prenotification of Credit Authorization
24
Prenotification of Credit/Mailed Authorization Savings Account Credits
33 Prenotification of Credit Authorization
34 Prenotification of Credit/Mailed
Authorization Debits are not currently handled by this Payroll system.
Automatic prenoting is only done one time. Therefore, if your bank requires
multiple prenote cycles, you can manually set the transaction code (TCOD) for this record to a prenote code and leave it that way for as
long as necessary. |
| cDeductionPeriod001 | DEP1 | char | OPT | INPUT |
A code designating the pay period in which the system calculates the DBA/auto deposit. Valid codes are:
Y
Take the DBA/auto deposit
during the current period.
N
Do not take the DBA/auto deposit during the current period.
*
Take the DBA/auto deposit only during the first pay
period for each month the employee works based on the ending date of this month's pay period.
blank
Continue to look for a code at the lower
level. The system searches for DBA/auto deposit rules first at the employee level, then at the group level, and finally at the DBA master level. If
the field is blank at all levels, the system does not calculate the DBA/auto deposit in that period.
M
Applies only to benefits based on gross
hours or dollars. An M in the fifth field only tells the system to calculate the benefit during the special timecard post. An M implies a Yes for a
weekly withholding frequency.
|
| cDeductionPeriod002 | DEP2 | char | OPT | INPUT |
A code designating the pay period in which the system calculates the DBA/auto deposit. Codes are:
Y
Take the DBA/auto deposit during
the current period.
N
Do not take the DBA/auto deposit during the current period.
*
Take the DBA/auto deposit ONLY during the first pay
period for each month the employee works based on the pay-period-end-date month.
Blank
SPECIAL MEANING: Continue to look for a code
at the lower level. The system searches for DBA/auto deposit rules first at the employee level, then at the group level, and finally at the DBA
master level. If the field is blank at all levels, the system does not calculate the DBA/auto deposit in that period.
M
SPECIAL MEANING:
Applies only to benefits based on gross hours or dollars. An M in the fifth field only tells the system to calculate the benefit during the daily
timecard post. An M implies a yes for a weekly withholding frequency.
|
| cDeductionPeriod003 | DEP3 | char | OPT | INPUT |
A code designating the pay period in which the system calculates the DBA/auto deposit. Codes are:
Y
Take the DBA/auto deposit during
the current period.
N
Do not take the DBA/auto deposit during the current period.
*
Take the DBA/auto deposit ONLY during the first pay
period for each month the employee works based on the pay-period-end-date month.
Blank
SPECIAL MEANING: Continue to look for a code
at the lower level. The system searches for DBA/auto deposit rules first at the employee level, then at the group level, and finally at the DBA
master level. If the field is blank at all levels, the system does not calculate the DBA/auto deposit in that period.
M
SPECIAL MEANING:
Applies only to benefits based on gross hours or dollars. An M in the fifth field only tells the system to calculate the benefit during the daily
timecard post. An M implies a yes for a weekly withholding frequency.
|
| cDeductionPeriod004 | DEP4 | char | OPT | INPUT |
A code designating the pay period in which the system calculates the DBA/auto deposit. Codes are:
Y
Take the DBA/auto deposit during
the current period.
N
Do not take the DBA/auto deposit during the current period.
*
Take the DBA/auto deposit ONLY during the first pay
period for each month the employee works based on the pay-period-end-date month.
Blank
SPECIAL MEANING: Continue to look for a code
at the lower level. The system searches for DBA/auto deposit rules first at the employee level, then at the group level, and finally at the DBA
master level. If the field is blank at all levels, the system does not calculate the DBA/auto deposit in that period.
M
SPECIAL MEANING:
Applies only to benefits based on gross hours or dollars. An M in the fifth field only tells the system to calculate the benefit during the daily
timecard post. An M implies a yes for a weekly withholding frequency.
|
| cDeductionPeriod005 | DEP5 | char | OPT | INPUT |
A code designating the pay period in which the system calculates the DBA/auto deposit. Codes are:
Y
Take the DBA/auto deposit during
the current period.
N
Do not take the DBA/auto deposit during the current period.
*
Take the DBA/auto deposit ONLY during the first pay
period for each month the employee works based on the pay-period-end-date month.
Blank
SPECIAL MEANING: Continue to look for a code
at the lower level. The system searches for DBA/auto deposit rules first at the employee level, then at the group level, and finally at the DBA
master level. If the field is blank at all levels, the system does not calculate the DBA/auto deposit in that period.
M
SPECIAL MEANING:
Applies only to benefits based on gross hours or dollars. An M in the fifth field only tells the system to calculate the benefit during the daily
timecard post. An M implies a yes for a weekly withholding frequency.
|
| cDeductionPeriod006 | DEP6 | char | OPT | INPUT |
A code designating the pay period in which the system calculates the DBA or auto deposit. Valid codes are:
Y
Calculate the DBA or auto
deposit during the current period.
N
Do not calculate the DBA or auto deposit during the current period.
*
Calculate the DBA or auto deposit
only during the first pay period for each month that the employee works based on the ending date of this month's pay period.
Blank
Continue
to look for a code at the lower level. The system searches for DBA or auto deposit rules first at the employee level, then at the group level,
and finally at the DBA master level. If the field is blank at all levels, the system does not calculate the DBA or auto deposit in that period.
M
Use this value only in the fifth period field to calculate the benefit or accrual during the special, or manual timecard post. M applies only to
benefits or accruals based on gross hours or dollars. An M implies a Yes for a weekly withholding frequency. You should not use this value for
any DBA with B in the Method of Calculation field.
|
| szOriginalBank | OFO# | char | OPT | INPUT |
This is the transit routing number used to identify the financial organization to which the deposit tape is being sent for processing. Obtain
this code from the bank at which your company's payroll account is maintained.
This bank will serve as a clearing house for your employees'
automatic deposits'. Using the Individuals Financial Organization No (IFO#) and Financial Organization Account Number (FOA#), this bank will
route--through electronic funds transfers (EFT)--each employee's deposit to his own account at his own financial institution. |
| szEmployeeBank | IFO# | char | OPT | INPUT |
The bank transit number for the employee's financial institution. Banks might refer to this number as the ABA or payment routing number.
This number can be obtained from the employee's check or deposit slip. It is located between the MICR colons (:) at the bottom of the check.
For
U.S. banks, this number contains 9 digits. If this number does not contain nine digits, you must contact the employee's financial institution to
obtain the correct number.
For Canadian banks, this number contains 8 digits. Therefore, Canadian clients must enter the bank transit number
with a leading zero.
If you change this number for an employee, the system creates a prenote for the employee's next auto deposit. |
| szTransactionCode | TCOD | char | OPT | INPUT |
A code used to distinguish various types of bank accounts, for example,checking, savings, or credit union. Currently the following codes
have been assigned:
Demand Account Credits
20 - Reserved
21 - Credit entry to return automated deposit
22 - Automated Deposit
Savings Account Credits
30 - Reserved
31 - Credit entry to return automated deposit
32 - Automated Deposit
Demand Account
Debits
25 - Reserved
26 - Debit entry to return automated payment
27 - Automated Payment
Savings Account Debits
35 -
Reserved
36 - Debit entry to return automated payment
37 - Automated Payment
NOTE: If you leave this field blank, the system uses the
default value of 22. |
| mnAmountPercent | GPAY | MATH_NUMERIC | OPT | INPUT |
The actual gross pay amount for an employee. This amount is different from the distributed gross pay amount used for labour
distribution.
On Work Order Time Entry, use this field to record miscellaneous pay for an employee, such as piece rate bonus.
|
| szUserID | USER | char | OPT | INPUT |
The code that identifies a user profile.
|
| szProgramID | PID | char | OPT | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565.
The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where:
T
The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program.
SS
The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system.
XXX
The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.
|
| jdDateUpdated | UPMJ | JDEDATE | OPT | INPUT |
The date that specifies the last update to the file record. |
| cReturnCode | EV02 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event.
|