Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
cPayTypeHSP | SALY | char | OPT | NONE |
A code that specifies how an employee is paid. Valid codes are:
H
Hourly
S
Salaried
P
Piecework
|
mnPayCycleBypassCount | PYCB | MATH_NUMERIC | OPT | NONE |
The number of pay cycles (that is, paychecks) bypassed. This is normally specified during the interim check process and would be used
for short-term absences such as vacations and jury duty. A normal paycheck will only be printed for an employee if this number is zero.
For
Flexible Spending Accounts Auto Deposit Instructions Only: This field is used to provide a count for the number of Pay cycles you want to
bypass the auto deposit feature so that you can write a manual check. Reasons for bypassing pay periods might be the employee's involvement
in jury duty, vacation, or leave of absence.
|
mnBenefitCycleBypassCt | BCB | MATH_NUMERIC | OPT | NONE |
The number of pay cycles (paychecks) that you want the system to bypass the benefit calculations.
Typically, you specify this information
during the interim check process. If you leave this value blank when you enter an interim check, the system bypasses the same number of
cycles that you enter in the Replace Next N Checks field. This number must be equal to or greater than the number of pay bypasses. If you
specify less than this number, the system bypasses the same number of pay cycles that you entered in the Replace Next N Checks field.
When
you enter a value in this field, the system updates the employee's master record. If you change or delete the other information on the interim
check,the system does not remove or adjust the bypass count. You must use the Change action on Additional Parameters to change the value
in the Employee Master table. However, if you delete the interim check the system also deletes the value from the Employee Master table. |
szCompanyHome | HMCO | char | OPT | NONE |
The company number where the employee records generally reside. |
szTaxAreaWork | TARA | char | OPT | NONE |
A code that identifies a geographical location and the tax authorities for an employee work site, including employee and employer statutory
requirements. In the Vertex payroll tax calculation software, the tax area code is synonymous with GeoCode. To determine the valid codes
for your location, refer to the documentation for the tax calculation software that you are using.
|
jdDateBeginningEffective | EFTB | JDEDATE | OPT | NONE |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:
o When a change of address becomes effective.
o When a lease becomes
effective.
o When a price becomes effective.
o When the currency exchange rate becomes effective.
o When a tax rate becomes effective.
|
jdDateEndingEffective | EFTE | JDEDATE | OPT | NONE |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.
|
cAdvanceOnPay | ADV | char | OPT | NONE |
A value of "1" indicates that the transaction has an advance payment on the employee's special process amount. |
jdDatePayPeriodEnding | PPED | JDEDATE | OPT | NONE |
The last day of a processing period (pay period, month, quarter or year). |
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. |
cInterimCheckStatus | ICS | char | OPT | NONE |
A code that indicates the type of payment that the system generated.
For OneWorld, valid codes are:
A Automatic deposit
C
Computer-generated payment
V Voided regular payment
M Manually-generated payment
Z Voided manual payment For World, valid codes are:
A
Automatic deposit
C Computer-generated payment
P Payslip (cash)
M Manually-generated payment
X Voided payment
If the code is M,
the Automatic Accounting Instruction (AAI) for the payroll manual check bank are used to generate the cash entry. If the code is C or blank,
the AAI for the normal payroll bank is used. |
szPayrollLockoutIdentifi | USR | char | OPT | NONE |
This code is a combination of the IBM user ID and the batch number assigned to a prepayroll selection. It is used to prohibit one employee
from being processed in more than one concurrent payroll cycle. It also locks out everyone but the user who is running the payroll (or
prepayroll) from updating the employee's master file or time records until either the the cycle is complete or a reset of the payroll lockout is
executed. |
szDBAAliasCacheName | 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.
|
szGroupLimitsCacheName | 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.
|
szDBACacheName | 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.
|
szCheckControlNoCacheName | 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.
|
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.
|
szTransNoDetailCacheName | 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.
|
szDBADetailCacheName | 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.
|
szBasisCacheName | 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.
|
szUnionLevelCacheName | 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.
|
cPayFrequency | PFRQ | char | OPT | NONE |
A user defined code (07/PF) that indicates how often an employee is paid. Valid codes are:
B
Biweekly
W
Weekly
S
Semimonthly
M
Monthly
A
Annually
C
European Annualized
The system uses the value in the Description-2 field on user defined codes to calculate the amount per
pay period for a salaried employee. |
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. |
cDeductionFactors | DAAF | char | OPT | NONE |
A code which designates the number of periods that the check represents, and therefore the number of periods that the 'Flat Dollar'
deductions are to apply. This number will be multiplied by the standard deduction amount to come up with the amount to be subtracted from the
employee's check. |
cPayPeriodNumberW | PPM1 | char | OPT | NONE |
The number of the pay period, within the month, for employees who are paid weekly. This field is used in conjunction with the Pay Period to
Calculate field on the DBA Setup form to determine which deductions, benefits, and accruals the system will calculate during the current
payroll cycle. |
cPayPeriodNumber2 | PPM2 | char | OPT | NONE |
The number of the pay period, within the month, for employees who are paid biweekly. The system uses this value and the Pay Period to
Calculate, from the DBA Setup form, to determine which deductions, benefits, and accruals to calculate during the current payroll cycle. |
cPayPeriodNumber3 | PPM3 | char | OPT | NONE |
The number of the pay period, within the month, for employees paid semimonthly. The system uses this value and the Pay Period to
Calculate, from the DBA Setup form, to determine which deductions, benefits, and accruals to calculate for the current payroll processing cycle. |
cPayPeriodNumber4 | PPM4 | char | OPT | NONE |
The number of the pay period within the month, for employees who are paid monthly. This field is used in conjunction with the Pay Period to
Calculate field on the DBA Setup form to determine which deductions, benefits, and accruals are to be calculated during this payroll cycle. |
cPayPeriodNumber5 | PPM5 | char | OPT | NONE |
The number of the pay period for employees who are paid annually. This field is used in conjunction with the Pay Period to Calculate field
on the DBA Setup form to determine which deductions, benefits, and accruals are to be calculated during this payroll cycle. |
cPayPeriodNumber6 | PPM6 | char | OPT | NONE |
The number of the pay period, within the month, that is used in conjunction with the Pay Period to Calculate field on the DBA Setup form to
determine which deductions, benefits, and accruals are to be calculated during this payroll cycle. |
cPayPeriodNumbersF07210 | PPMB | char | OPT | NONE |
For WorldSoftware:
The definition of this field depends on the program from which you access the field:
o Valid Master Pay Cycles
(P069061) - A value that specifies which period bucket number in the Payroll Integrity table (F0620) will be updated.
The integrity period number
specifies one of five periods in which the system stores the history. It does not determine the calculation of DBAs. If you run a multiple
frequency payroll (such as salary with both weekly and biweekly employees), enter an unused integrity period number. For example, for the first
biweekly payroll of the month, use 2 because 1 was already used for the first weekly payroll.
o Pay Cycle Control Parameters (P06210) - A
value that specifies whether the pre-payroll programs will calculate those benefits and accruals that are based on calendar month amounts
(dollars/hours). If the value is N, the system skips these benefits and accruals.
For OneWorld:
A value that specifies whether the pre-payroll
programs will calculate benefits and accruals that are based on calendar month amounts (dollars/hours). Valid values are:
Y Yes. The
pre-payroll programs will calculate benefits and accruals that are based on calendar month amounts (dollars/hours).
N No. The pre-payroll
programs will not calculate benefits and accruals that are based on calendar month amounts (dollars/hours).
Blank Same as N. |
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. |
mnTimeLastUpdated | UPMT | MATH_NUMERIC | OPT | NONE |
The time that specifies when the program executed the last update to this record. |
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile.
|
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job.
|
jdDateBirth | DOB | JDEDATE | OPT | NONE |
The employee's date of birth. |
jdDateOriginalEmployment | DSI | JDEDATE | OPT | NONE |
The date on which the employee was originally hired by the company. If the employee was terminated and subsequently rehired, the new
start date will be represented by the data in the Date Started (DST) field. |
jdDateEmploymentStart | DST | JDEDATE | OPT | NONE |
The date on which the employee actually reported to work for the most recent period of hire. When an employee initially begins working,
the default is the original hire date. If no original hire date exists, the system uses the current date. This field can be updated multiple times if, for
example, an employee is a seasonal worker.
For the calculation tables in the Payroll system and the eligibility tables and date codes in the
Human Resources system, the system also uses this date as a start date when it calculates deductions, benefits, and accruals. |
mnAgeFixed | FAGE | MATH_NUMERIC | OPT | NONE |
For World:
The age of the employee as of a certain date (for example, January 1st) for a given year. You can manually update this field or
update it each year using the future data facility.
For One World:
The age of the employee as of a certain date (for example, January 1st) for a
given year. You can manually update this field or the system can update this field when you run the Update Employee Master Age report
(R083495). |
mnSalaryFixed | FSAL | MATH_NUMERIC | OPT | NONE |
You can use this field to calculate deductions, benefits, and accruals (DBAs) for a spouse's life insurance premium. Any table method that
begins with an F uses this field. |
mnAnnualSalaryLife | LSAL | MATH_NUMERIC | OPT | NONE |
You can use this field to calculate deductions, benefits, and accruals (DBAs) for an employee's life insurance premium. Any table method
that begins with an I (Insurance) uses this field. |
jdDateLoaStarts | LSDT | JDEDATE | OPT | NONE |
The date on which an employee's paid or unpaid leave of absence begins. Use this date to indicate the leave for the Family and Medical
Leave Act. |
jdDateParticipation | PADT | JDEDATE | OPT | NONE |
The date the employee began participating in the company deferred income or stock option plan. This date must be later than the Date
Started date. |
mnRtPiecework | PPRT | MATH_NUMERIC | OPT | NONE |
The rate paid for the type of component (piece) produced. If you enter a rate in this field, this rate overrides the rate in the Employee Master
file. |
mnRtSalary | SAL | MATH_NUMERIC | OPT | NONE |
The amount that an employee is paid in one year, assuming that the employee is paid every pay period of the year.
For WorldSoftware:
For
the employee's primary job, the system stores the annual salary in the Employee Master Information table (F060116) and the Employee
Jobs table (F060118). For secondary jobs, the system stores the annual salary only in the Employee Jobs table (F060118).
Depending on how
the value that is entered in the Display Salary (Annual/Effective) field in the HR History Constants table (F08040), this field displays one of the
following:
o Annual salary. For salaried employees who are not linked with a contract calendar, the user enters the amount or the system
retrieves the amount from the Pay Grade/Salary Range Table (F082001). For employees who are linked with a contract calendar, the system
calculates this amount using the following formula: (((current salary minus salary paid before change) divided by number of periods to pay)
multiplied by pay frequency).
o Effective salary. For employees whose jobs are linked with a contract calendar, the system recalculates the
effective salary when you enter a mid-calendar salary adjustment. After you enter a mid-calendar adjustment, the effective salary equals the
salary that is paid to the employee from the time of the adjustment through the end of the contract. The system calculates this amount using
the following formula: ((annual salary divided by pay frequency) times periods to pay).
|
cGrossoOrNetFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cReprocessEmployeeFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnAmountGrossPayTotal | 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.
|
mnAmountNetPayTotal | NPAY | MATH_NUMERIC | OPT | NONE |
The net amount of the payment.
Before the net-deduction phase of the pre-payroll process runs, this amount equals gross pay, less taxes,
less deductions that are based on gross pay.
After the net-deduction phase, this amount represents the true net pay.
For additional information
that is related to this calculation process, see data items NPY1 and DESQ.
|
mnTotalDeductionsTotal | TTDE | MATH_NUMERIC | OPT | NONE |
The total amount of deductions for all payments in this Payroll ID. |
mnTotalHoursTotal | TTHS | MATH_NUMERIC | OPT | NONE |
The total number of hours in this Payroll ID. |
szPayrollIDOW | PAYD | char | OPT | NONE |
A code that identifies a group of employees for whom you are processing payroll. Use this ID to process each step of the payroll
cycle.
This code is also used to identify the interim ID that you select when you enter interim payments. |
szNameAlphaSort | PALF | char | OPT | NONE |
This field is the first number of character's of an employee's name. |
mnAmountMaxNetPayF060116 | NMAX | MATH_NUMERIC | OPT | NONE |
The lowest amount to be generated as a check, bank advice, or payslip. The system does not allow zero amount checks if you have
specified a minimum check amount. You can leave this field blank. Generally, this field's value will specify the minimum amount that must be paid
to the employee. |
mnAmountMaxNetPayF07210 | NMAX | MATH_NUMERIC | OPT | NONE |
The lowest amount to be generated as a check, bank advice, or payslip. The system does not allow zero amount checks if you have
specified a minimum check amount. You can leave this field blank. Generally, this field's value will specify the minimum amount that must be paid
to the employee. |
mnGeneralLedgerBatch | GICU | MATH_NUMERIC | OPT | NONE |
The batch number which has been assigned to the group of Journal Entries generated in the Payroll System. This number ties the entries
together all of the way through Final Update and into the General Ledger Post program. |
cDeductionsNotTakenFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cArrearagesTakenFlag | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnOverpaymentDBA | 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. |
szChildSupportCache | 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.
|
mnEndingQuarterMonth | DTEM | MATH_NUMERIC | OPT | NONE |
A two-digit number that specifies the applicable month. If you leave this field blank, the program uses the system date.
|
mnEndingYearMonth | DTEM | MATH_NUMERIC | OPT | NONE |
A two-digit number that specifies the applicable month. If you leave this field blank, the program uses the system date.
|
mnBeginingYearMonth | DTEM | MATH_NUMERIC | OPT | NONE |
A two-digit number that specifies the applicable month. If you leave this field blank, the program uses the system date.
|
mnBeginingQuarterMonth | DTEM | MATH_NUMERIC | OPT | NONE |
A two-digit number that specifies the applicable month. If you leave this field blank, the program uses the system date.
|
cJournalsProcessingOptionFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnRtHourly | 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. |
szUnionCodeF060116 | 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. |
szCostCenterF060116 | 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.
|
szJobCategoryF060116 | 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. |
szJobStepF060116 | 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. |
jdDatePayCheck | CKDT | JDEDATE | OPT | NONE |
The date associated with the various types of net pay instructions. This date relates to a payroll check, an interim payment, a bank
automatic-deposit advice slip, a payslip (cash), or a claim reimbursement. |
szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions.
Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.
|
szCostCenterHome | HMCU | char | OPT | NONE |
The number of the business unit in which the employee generally resides. |
szReportingCodesPayro001 | P001 | char | OPT | NONE |
A category code that defines payroll system needs. You can define the use and description of this code to fit your organization. For
example, you can set up a category code for information such as Division, Supervisor, Branch office, Health insurance plan, Stock plan, and so on.
Note: When setting up category codes in the Workforce Management system, you should coordinate information with the payroll department
to insure that information is not duplicated or overwritten.
|
szReportingCodesPayro002 | P002 | char | OPT | NONE |
A category code which specifies payroll system needs. You may define the use and description of this code to fit your organization. For
example, you can set up a category code for any of the following categories:
o Division
o Supervisor
o Branch Office
o Health Insurance
Plan
o Stock Plan
Work Force Management: Coordinate the use of this category code with the payroll department. |
szReportingCodesPayro003 | P003 | char | OPT | NONE |
A category code which specifies payroll system needs. You can define the use and description of this code to fit your organization. For
example, you can set up a category code for any of the following categories:
o Division
o Supervisor
o Branch Office
o Health Insurance
Plan
o Stock Plan
Work Force Management: Coordinate the use of this category code with your payroll department. |
szReportingCodesPayro004 | P004 | char | OPT | NONE |
A category code which specifies payroll system needs. You can define the use and description of this code to fit your organization. For
example, you can set up a category code for any of the following categories:
o Division
o Supervisor
o Branch Office
o Health Insurance
Plan
o Stock Plan
Work Force Management: Coordinate the use of this category code with your payroll department. |
szRoutingCodeCheck | MAIL | char | OPT | NONE |
A user defined code (07/CR) that specifies the check routing or mail-stop code. Use this code to sequence the printing of payroll checks to
facilitate their handling and delivery. |
szProgram | 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.
|
cTaxHistoryType | THTY | char | OPT | NONE |
A user defined code (07/TH) that specifies the type of information being tracked for the employee in the US Taxation Summary History
table (F06136) or the Canadian Tax History table (F0713). The value in this field determines what type of year-end form the system generates. |
cTerminatedEEPaidFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cEmployeePayStatus | PAST | char | OPT | NONE |
The code used to indicate whether an employee's pay status is active or inactive. Codes for active pay status employees are numeric,
and codes for inactive pay status employees are alphabetic. The system omits all employees with alphabetic pay status codes from the
payroll run.
See also Employment Status (EST) and Change Reason (TRS). |
jdDateTerminated | DT | JDEDATE | OPT | NONE |
The date that the employee was terminated, if applicable. |
szCountryForPayroll | CCPR | char | OPT | NONE |
A user defined code list 00/CN that indicates the country in which the employee resides. |
szCountryCacheName | 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.
|
szDBAOverrideInstructionsCache | 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.
|
cRetrievePDBAHistorySysFlag | PHISH | char | OPT | NONE |
This option determines how the system retrieves PDBA history for an employee. This value works in conjunction with the Retrieve PDBA
History System Flag on the Additional Options tab of the Company Options form for Company 0 (zero). If that flag is set to look at each PDBA to
determine how to retrieve PDBA history, you must enter a value in this field. Valid values are:
1
Retrieve PDBA historical amounts using the
Corporate Tax ID associated with the Home Company on the employee's timecard. (Default)
2
Retrieve PDBA historical amounts across all
Corporate Tax IDs for which the employee has history for the current year. |