Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
szDBACacheName | PID | char | REQ | 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.
|
cSuppressErrorMessage | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
runtime error message handling.
1 = suppress runtime error message handling. |
idCacheCursor | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
szErrorMessageID | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
|
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. |
mnPayDeductBenAccType | 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. |
mnWageAttachmentNumber | WANO | MATH_NUMERIC | OPT | NONE |
A control number used to group and identify all related elements associated with a Wage Attachment (Garnishment, Levy, Child Support or
Loan). This number is assigned by the system and is used to attach a specific deduction to its related Wage Attachment information. |
jdDtWorkJulian | DWK | JDEDATE | OPT | NONE |
The date used as the actual work date or pay-period ending date. |
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. |
mnPayrollTransactionNo | 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. |
cPDBAType | DISO | char | OPT | NONE |
A code used to distinguish between the following types of payroll entries:
P
Time Cards (Earnings)
D
Deductions withheld
B
Benefit (both
cash and non cash)
A
Accrual of sick, vacation, comp, and so forth
Note: These codes may only be changed by J.D. Edwards
If you enter an *
in this field the system displays all four types of PDBAs. |
cInterimCheckCode | 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 | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
distribution. See data item DPAY.
When using Work Order Time Entry, this field is used to record miscellaneous pay for an employee, (for
example, piece rate bonus). |
mnHoursWork | 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. |
mnMonthWorked | HMO | MATH_NUMERIC | OPT | NONE |
The number of the month in which the history files were updated. |
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.
|
szBusinessUnitDBAAllocatio | 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.
|
szCompanyHome | HMCO | char | OPT | NONE |
The company number where the employee records generally reside. |
cFloatCode | 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. |
szWorkersCompInsurCode | 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. |
mnHourlyRate | PHRT | MATH_NUMERIC | OPT | NONE |
The employee's hourly rate, which is retrieved during time entry. If you enter a rate in this field on any other form, that rate can override the
value in the Employee Master table.
In the Employee Master table, this number is the employee's base hourly rate.
In the Union Rates table, it
is the straight time rate.
NOTE: If you change the number of the data display decimal digits for this field, you must also change fields Rate -
Base Hourly (BHRT) and Rate - Hourly (SHRT) so that they have exactly the same number of data display decimal digits. |
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. |
cLevelCalculated | DLVL | char | OPT | NONE |
The level at which a DBA calculation was made in the pre-payroll process. |
cPrintOnPaycheckYN | 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. |
cPDBAPrintGroup | PTCT | char | OPT | NONE |
A user defined code (07/PC) that specifies the pay type categories you want to use:
o For regular pay
o To generate overtime
o For
reporting purposes on the Certified Payroll Register (U.S. only). |
szShortDescription | DLSH | char | OPT | NONE |
A short description |
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. |
szGroupLimitCode | DGRP | char | OPT | NONE |
Specify a code common to all deductions or benefits that share the same limitations (for example, pay period dollar amount or percentage,
monthly,annual, and so on). The system takes these limits from the first deduction encountered in the group, and withholds for all
deductions until the limit is reached for the aggregate.
Example:
Deduction 6400, Group A, Annual Limit = $1000, No Pay Period Limit
Deduction 6430,
Group A, No Annual or Pay Period Limit
Deduction 7700, Group A, No Annual or Pay Period Limit
Deduction 9400, Group B, No Annual or Pay
Period Limit
Deduction 7550, Group B, No Annual Limit, Pay Period Limit = $50
For this example, the system looks at the deductions
assigned to Group A, and applies a $1000 annual limit for all three deductions. The system continues to take the deductions from an employee's
paycheck until a total of $1000 has been deducted between all entities in Group A for the year.
For deductions in Group B, the system deducts
no more than $50 per pay period between for the two deductions.
|
mnMonthToDateAmount | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
distribution. See data item DPAY.
When using Work Order Time Entry, this field is used to record miscellaneous pay for an employee, (for
example, piece rate bonus). |
mnMonthToDateHours | PHRW | MATH_NUMERIC | OPT | NONE |
The number of hours associated with each transaction. |
mnMonthToDateLimit | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
distribution. See data item DPAY.
When using Work Order Time Entry, this field is used to record miscellaneous pay for an employee, (for
example, piece rate bonus). |
mnQuarterToDateAmount | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
distribution. See data item DPAY.
When using Work Order Time Entry, this field is used to record miscellaneous pay for an employee, (for
example, piece rate bonus). |
mnQuarterToDateHours | PHRW | MATH_NUMERIC | OPT | NONE |
The number of hours associated with each transaction. |
mnQuarterToDateLimit | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
distribution. See data item DPAY.
When using Work Order Time Entry, this field is used to record miscellaneous pay for an employee, (for
example, piece rate bonus). |
mnYTDGross | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
distribution. See data item DPAY.
When using Work Order Time Entry, this field is used to record miscellaneous pay for an employee, (for
example, piece rate bonus). |
mnYTDHours | PHRW | MATH_NUMERIC | OPT | NONE |
The number of hours associated with each transaction. |
mnYTDPieces | 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. |
mnYTDGrossLimit | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
distribution. See data item DPAY.
When using Work Order Time Entry, this field is used to record miscellaneous pay for an employee, (for
example, piece rate bonus). |
mnAnnualLimit | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
distribution. See data item DPAY.
When using Work Order Time Entry, this field is used to record miscellaneous pay for an employee, (for
example, piece rate bonus). |
mnAmountDueLimit | AD | MATH_NUMERIC | OPT | NONE |
The balance or amount due on an open invoice or voucher. In the Address Book Master file (F0101), this is a memo amount field used to
determine if a particular order exceeds a credit limit. See the documentation for the Order Processing system.
|
mnAmountDue | AD | MATH_NUMERIC | OPT | NONE |
The balance or amount due on an open invoice or voucher. In the Address Book Master file (F0101), this is a memo amount field used to
determine if a particular order exceeds a credit limit. See the documentation for the Order Processing system.
|
mnNumberOfPeriods | NPRD | MATH_NUMERIC | OPT | NONE |
The number of consecutive periods used to calculate eligibility. |
mnArrearageAmount | ARRA | MATH_NUMERIC | OPT | NONE |
The amount of the deduction that is being or has been reduced because the employee did not receive wages that could cover the payroll
taxes and deductions calculated within the payroll cycle. |
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. |
szPreTaxDeduction | PRTX | char | OPT | NONE |
Enter one of the predetermined user defined codes to allow Vertex to use current tax laws in the various jurisdictions to determine whether
the DBA is pretax in that tax area. Using these codes eliminates the need to set up tax-exempt status in the P06TAX window or to have multiple
deductions to accommodate pre-tax status in one state but not another.
For Canadian users, code RPP represents Canadian Registered
Pension Plans (RPP) or Registered Retirement Savings Plans (RRSP). Code UN represents Canadian union dues.
For both US and Canada
code GTL represents the Fringe Benefit for Group Term Life.
In the following example we pass 1000 Gross, and 20 GTL.
Tax Passed
Taxable Subject Adjusted
Type Gross Gross Gross Current
Fed With 1000 1000 1020 1000
FUTA 1000 1000
1000 1000
Soc Sec 1000 1020 1020 1020
Federal Withholding and FUTA will store the Gross that was passed in, while Social
Security and Medicare will have the Gross adjusted to 1020 so as not to display -20 as excess. This will cause your Taxable gross to be stored
in our system as 1020
|
szTaxType1 | 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. |
szTaxType2 | 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. |
szTaxType3 | 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. |
szTaxType4 | 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. |
szTaxType5 | 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. |
szTaxType6 | 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. |
szTaxType7 | 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. |
szTaxType8 | 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. |
szTaxType9 | 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. |
szTaxType10 | 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. |
szTaxType11 | 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. |
szTaxType12 | 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. |
szTaxType13 | 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. |
szTaxType14 | 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. |
szTaxType15 | 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. |
szCacheActionCode | CACTN | char | OPT | NONE |
A code that indicates the activity you want to perform. Valid codes:
o Get - Retrieve the cache element
o Add - Add a cache element
o
Update - Update a cache element
o Delete - Delete a cache element
o Delete All - Delete all cache elements
o Get Next - Retrieve the
next cache element
o Add/Update - Add a cache element if it does not exist; Update a cache element if it does exist
o Terminate -
Terminate Cache |
cAddOrUpdateFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|