Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnCheckControlNumber | CKCN | MATH_NUMERIC | OPT | NONE |
A number used to group all payroll transactions for each payment or individual interim payment. This number is carried into the accounting
journal entries and facilitates the update of the actual check number after payment printing is complete. This number is also used for
automatically voiding payments. The payment work table contains both the actual check number and the check control number. All associated
payment transactions are automatically reversed using the check control number.
This is not the actual check number. |
mnPDBANumber | PDBA | MATH_NUMERIC | OPT | NONE |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
numbered from 1000 to 9999. |
szTimecardCacheName | PID | char | OPT | NONE |
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.
|
mnHourlyRate | SHRT | MATH_NUMERIC | OPT | NONE |
This is the employee's hourly rate. If applicable, Pay Type Multiplier and Shift Differential values will be added.
If you change the value of
the data display decimals for this field, you must also change the Hourly Rate (PHRT) and Base Rate (BHRT) fields in Time Entry to have
exactly the same data display decimals. |
mnTransactionNumber | PRTR | MATH_NUMERIC | OPT | NONE |
A unique number that the system assigns to each timecard. You can use this field in the Time Entry By Job program to retrieve a specific
timecard for display. This field is also used to tie a timecard to each Actual Burden audit record created for the timecard during the Actual
Burden Journaling process. |
jdDateWorked | DWK | JDEDATE | OPT | NONE |
The date used as the actual work date or pay-period ending date. |
cInterimCheckFlag | ICC | char | OPT | NONE |
For OneWorld:
A code that indicates one of the following conditions:
Blank The payment was processed in a regular payroll cycle.
I
The payment was processed as an interim. Interim payments can include replacements for both regular voided payments and manually
voided payments.
X The payment is an original payment that has been voided.
For World:
An internal code that indicates one of the following
conditions:
o The time and pay record is for an interim payment.
o The record in the Payment table (F07350) is an interim payment.
o An
employee has an interim payment in the Payment table for the current pay period.
Valid codes are:
X The payment has been voided.
V
The payment is a void of a previously-entered payment.
I The payment was processed as an interim check.
Blank The payment was
processed in a regular payroll cycle. |
mnWorkState | WST | MATH_NUMERIC | OPT | NONE |
Vertex state code identifying the state where the employee works. REQUIRED. |
mnWorkCounty | WCNT | MATH_NUMERIC | OPT | NONE |
Vertex county code identifying where the employee works. Zero fill if you do not need to calculate county taxes. |
mnWorkCity | WCTY | MATH_NUMERIC | OPT | NONE |
Vertex city code identifying the city where the employee works. Zero fill if you do not need to calculate city taxes. |
mnGrossPay | GPAY | MATH_NUMERIC | OPT | NONE |
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.
|
mnHoursWorked | PHRW | MATH_NUMERIC | OPT | NONE |
The number of hours associated with each transaction. |
mnPieces | PCUN | MATH_NUMERIC | OPT | NONE |
The number of pieces for piecework or any other unit of measure you want to track for this employee. Examples are: recording miles driven
for drivers of company vehicles, cubic yards of concrete, feet drilled, or miles flown and so forth. |
szUnionCode | UN | char | OPT | NONE |
A user defined code (06/UN) that represents the union or plan in which the employee or group of employees work or participate. |
szJobCode | JBCD | char | OPT | NONE |
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and
apply that information to the employees who are linked to that job type. |
szJobStep | JBST | char | OPT | NONE |
A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job
type to determine pay rates by job in the Pay Rates table. |
cProcessedCode | YST | char | OPT | NONE |
A code used to indicate whether a payroll transaction has been processed through the payroll cycle. This value is held within various files
within the payroll system. Valid values are:
Blank
Unprocessed.
1
Processed.
P
Processed and checks have been printed (F07350
Only).
************************************************************
The F07351 contains values as they relate to the printed payment. For the F07351, valid
values are:
Blank
Not Printed.
I
Interim Printed.
1
Non-Interim Printed.
|
szBusinessUnit | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
szHomeCompany | HMCO | char | OPT | NONE |
The company number where the employee records generally reside. |
cWorkersCompFloatCode | WET | char | OPT | NONE |
A code that specifies any special circumstances associated with the workers compensation insurance (WCI) code, resulting in multiple
rates for the same WCI code due to location or risk, for example. The subclass should remain blank if multiple rates do not exist. Default codes
are:
Blank
There are no special circumstances associated with this code.
F
There are special circumstances associated with this code. |
szWorkersCompCode | WCMP | char | OPT | NONE |
A user defined code (00/W) that represents a workers' compensation insurance (WCI) code. This code should correspond to the
classifications on your periodic workers' compensation insurance reports. |
mnBaseHourlyRate | BHRT | MATH_NUMERIC | OPT | NONE |
This is the employee's base hourly rate as retrieved from either the Employee Master or the Union Rates Table. This number would not be
modified by multipliers, differentials, etc. It is saved in the time entry file (F0611) for the express purpose of being able to account for
premium pay separate from base pay. (See also: HRT, PWRT, BRT)
***Important Note*** If you change the number of DATA DISPLAY DECIMAL
digits for the field "PHRT", "SHRT" you MUST also change this field's data display decimals to be the same number. |
mnYTDGross | YTD | MATH_NUMERIC | OPT | NONE |
The sum of all net postings from the first day of the current fiscal year to the last day of the current month or period.
The system uses the
period totals from the Account Balances table (F0902) to calculate the YTD period end total. |
mnYTDHours | YTD | MATH_NUMERIC | OPT | NONE |
The sum of all net postings from the first day of the current fiscal year to the last day of the current month or period.
The system uses the
period totals from the Account Balances table (F0902) to calculate the YTD period end total. |
mnYTDPieces | YTD | MATH_NUMERIC | OPT | NONE |
The sum of all net postings from the first day of the current fiscal year to the last day of the current month or period.
The system uses the
period totals from the Account Balances table (F0902) to calculate the YTD period end total. |
cPrintMethod | PCK | char | OPT | NONE |
A code that identifies whether the PDBA is to be printed on the paystub or whether it is to be printed on a payment that is separate from
other PDBAs.
Valid values for pay types and payroll taxes include:
Y Print on paystub (default)
S Print separate payment (one item per
payment)
C Print separate payment (C types combined)
N Do not print on paystub Valid values for DBAs include:
Y Print as total deductions
(default)
S Print separate payment (one item per payment)
C Print separate payment (include detail)
N Do not print on paystub
I Print
individual DBA codes
T Print by DBA print group
The separate payment feature is not available for any payroll taxes being withheld from the
employee's payment. |
cEffectOnGross | PAYG | char | OPT | NONE |
A code that indicates whether the pay type is added to, subtracted from, or does not affect the employee's gross pay. Valid values
are:
+
Pay type will be added to the employee's gross pay.
-
Pay type will be subtracted from the employee's gross pay.
Blank
Pay type will not have
an effect on the employee's gross pay.
A pay type should not have a negative effect on gross pay. If you set up a pay type to have a negative
effect on gross or net pay, gross-to-net errors appear on the Payroll Register. PeopleSoft recommends that you set up a deduction instead
of a pay type that would have a negative effect on gross pay.
When you set up a pay type with no effect on gross pay and a positive effect
on net pay, do not create a separate check. Creating a separate check will cause a gross-to-net error.
|
cEffectOnNet | PAYN | char | OPT | NONE |
A code that indicates whether the pay type is added to, subtracted from, or does not affect the employee's net pay.
Valid values are:
+
Pay type will be added to the employee's net pay
- Pay type will be subtracted from the employee's net pay
blank Pay type will not
have an effect on the employee's net pay
A pay type should not have a negative effect on net pay. If you set up a pay type to have a negative
effect on gross or net pay, gross-to-net errors appear on the Payroll Register. J.D.Edwards recommends that you set up a deduction instead
of a pay type that would have a negative effect on gross pay.
When you set up a pay type with no effect on gross pay and a positive effect
on net pay, do not create a separate check. Creating a separate check will cause a gross-to-net error. |
cSickVacationType | SVH | char | OPT | NONE |
A user defined code (system 06, type SV) that specifies whether the benefit or accrual type is sick, vacation, holiday, leave, or other. |
szTaxExemptTypes01 | TT01 | char | OPT | NONE |
You can specify up to 15 tax types for which the respective payroll tax is not to be computed for a pay, deduction, or benefit code.
If you
enter * in the first element of this list, no taxes are computed. |
szTaxExemptTypes02 | TT02 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes03 | TT03 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes04 | TT04 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes05 | TT05 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes06 | TT06 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes07 | TT07 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes08 | TT08 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes09 | TT09 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes10 | TT10 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes11 | TT11 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes12 | TT12 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes13 | TT13 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes14 | TT14 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
szTaxExemptTypes15 | TT15 | char | OPT | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
enter an asterisk (*) in the first element of this list, it signifies that no taxes are to be computed. |
cReadWriteMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cReturnCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cLevelCalculated | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cAutoPayMethod | IIAP | char | OPT | NONE |
A code that determines how the system treats this pay type when computing automatically generated pay (typically for salaried
employees). It also identifies supplemental pay. Valid codes are:
Y The dollars with this pay type are part of the employee's base pay, for example,
regular, holiday, sick, and vacation pay.
N The dollars with this pay type are in addition to the employee's base pay, for example, overtime
pay and time off without pay.
S The hours with this pay type are subtracted from the employee's base pay at standard rate and added back
at the entered pay rate.
B The dollars with this pay type are in addition to the employee's base pay and are treated as supplemental pay
for taxation purposes, for example, bonuses, commissions, and payoffs. Canadian bonuses, irregular comissions, and lump sums use auto
pay method B.
C The hours or dollars entered using this pay type override all autopay instructions.
For World:
If multiple jobs are used, a Y in
this field might cause the pay type to be paid in addition to the regular pay. For example, if the job code, job step,home business unit, or
position have been overridden in time entry, and if multiple active jobs exist for the employee, and if the overridden information does not match
an existing active job record, this system processes pay types with the Auto Pay Method set to Y as additional pay. J.D. Edwards
recommends that you always use a pay type with N in this field when paying someone for work in addition to their regular pay. This ensures that the
system processes the pay type the same in multiple-job or single-job situations.
If your company docks employees' pay when they take leave in
excess of what has been earned, you should have pay type 997 set up as the pay type to dock pay. Enter N as the autopay method for this
pay type.
If your company attaches contract calendars to employees to accumulate wages,you should have pay type 996 set up as the pay
type to accumulate wages. Enter C as the autopay method for this pay type. |
mnAssignmentNumber_TSKID | TSKID | MATH_NUMERIC | OPT | NONE |
A number that identifies a task that is used for resource scheduling. The task number is generated by the system. |
cRechargeCode | RCCD | char | OPT | NONE |
A code that identifies whether the employee is to be handled through the Recharge processing option for the Payroll Journal Entry
program. Valid codes are:
1 Payroll Processing Only
2 Payroll and Recharge Processing
3 Recharge Processing Only
After a timecard has
been added, you cannot change its record type. |