Functional Description
The purpose of this function is to detect changes made to data items in the Employee Master File (F060116) and direct
those changes to another Business Function to be written to the History File (F08042) and Turnover File (F08045).
Due to OneWorlds limitation on the number of data items that can be in a Data Structure, we are dividing the Employee
Master File Data Items in half. This function process the last half of the EE Master File Data Items.
Technical Specifications
Parameters
Data Item Data Structure DescriptionI/ORequiredNotes
ICCInterimCheckCodeIYPass in from F060116 Database Trigger
NMAXAmountMaximumNetPayI YPass in from F060116 Database Trigger
SOCCStOccupClassCodeIYPass in from F060116 Database Trigger
IUSRInterimCheckUserIdIYPass in from F060116 Database Trigger
ITRMTerminalIdInterimCkIYPass in from F060116 Database Trigger
INBTInterimProcessingBatchIYPass in from F060116 Database Trigger
REGNRegnIYPass in from F060116 Database Trigger
PSTPPayStepIYPass in from F060116 Database Trigger
IHWorkHoursPerYearIYPass in from F060116 Database Trigger
CCPRCountryForPayrollIYPass in from F060116 Database Trigger
ADPNAutoDepositPreNoteIYPass in from F060116 Database Trigger
TCNFThirdCtryNationalFlagIYPass in from F060116 Database Trigger
RAFResidentAlienFlagIYPass in from F060116 Database Trigger
TIPETippedEmployeeIYPass in from F060116 Database Trigger
RCCDRechargeCodeIYPass in from F060116 Database Trigger
BDRTRateBillingBurdenIYPass in from F060116 Database Trigger
BORNNewRechargeBurdenRateIYPass in from F060116 Database Trigger
NBDRDteNewBurdRateEffectIYPass in from F060116 Database Trigger
WETFloatCodeIYPass in from F060116 Database Trigger
AFLGAddressFlagIYPass in from F060116 Database Trigger
RMSTMaritalStatusResStateIYPass in from F060116 Database Trigger
LMSTLocalAreaMaritalIYPass in from F060116 Database Trigger
SMKRFlagSmokerIYPass in from F060116 Database Trigger
CBACCashBasisAccumulatorIYPass in from F060116 Database Trigger
CBAFCashBasisFlagIYPass in from F060116 Database Trigger
PCCDPayCycleCodeIYPass in from F060116 Database Trigger
RCDTDateRecallIYPass in from F060116 Database Trigger
LSDTDateLoaStartsIYPass in from F060116 Database Trigger
PADTDateParticipationIYPass in from F060116 Database Trigger
PYMHPaymentMethodIYPass in from F060116 Database Trigger
UYSTUpdateStatusFlagIYPass in from F060116 Database Trigger
DTSPDateTimeStampIYPass in from F060116 Database Trigger
ANN8AddressNumberPayeeIYPass in from F060116 Database Trigger
PPNBPayPeriodNumberIYPass in from F060116 Database Trigger
PYDTPayCycleProcessDateIYPass in from F060116 Database Trigger
CBENCashBenefitIYPass in from F060116 Database Trigger
DOBMBirthdateMonthIYPass in from F060116 Database Trigger
DSTMStartdateMonthIYPass in from F060116 Database Trigger
PSALRatePreviousSalaryIYPass in from F060116 Database Trigger
HIPNHipNumberIYPass in from F060116 Database Trigger
CMCreditMessageIYPass in from F060116 Database Trigger
LSALAnnualSalaryLifeIYPass in from F060116 Database Trigger
DIVCBenefitGroupCodeIYPass in from F060116 Database Trigger
VSHFVotingSharesFlagIYPass in from F060116 Database Trigger
PYRVPriorYearsVestingIYPass in from F060116 Database Trigger
ANPASupervisorIYPass in from F060116 Database Trigger
PGRDPayGradeIYPass in from F060116 Database Trigger
PGRSPayGradeStepIYPass in from F060116 Database Trigger
SLOCSalaryDataLocalityIYPass in from F060116 Database Trigger
NRVWDteNextReviewIYPass in from F060116 Database Trigger
TINCTypeIncreaseNextRevwIYPass in from F060116 Database Trigger
HM01I9StatusIYPass in from F060116 Database Trigger
HM02VeteranIYPass in from F060116 Database Trigger
HM03DisabledVeteranIYPass in from F060116 Database Trigger
HM04HandicappedIYPass in from F060116 Database Trigger
POSPositionIDIYPass in from F060116 Database Trigger
ED01UserDefinedDate001IYPass in from F060116 Database Trigger
ED02UserDefinedDate002IYPass in from F060116 Database Trigger
ED03UserDefinedDate003IYPass in from F060116 Database Trigger
ED04UserDefinedDate004IYPass in from F060116 Database Trigger
ED05UserDefinedDate005IYPass in from F060116 Database Trigger
ED06UserDefinedDate006IYPass in from F060116 Database Trigger
ED07UserDefinedDate007IYPass in from F060116 Database Trigger
ED08UserDefinedDate008IYPass in from F060116 Database Trigger
ED09UserDefinedDate009IYPass in from F060116 Database Trigger
ED10UserDefinedDate010IYPass in from F060116 Database Trigger
ED11UserDefinedDate011IYPass in from F060116 Database Trigger
ED12UserDefinedDate012IYPass in from F060116 Database Trigger
ED13UserDefinedDate013IYPass in from F060116 Database Trigger
ED14UserDefinedDate014IYPass in from F060116 Database Trigger
ED15UserDefinedDate015IYPass in from F060116 Database Trigger
ED16UserDefinedDate016IYPass in from F060116 Database Trigger
ED17UserDefinedDate017IYPass in from F060116 Database Trigger
ED18UserDefinedDate018IYPass in from F060116 Database Trigger
ED19UserDefinedDate019IYPass in from F060116 Database Trigger
ED20UserDefinedDate020IYPass in from F060116 Database Trigger
DEPTDepartmentCodeIYPass in from F060116 Database Trigger
FAGEAgeFixedIYPass in from F060116 Database Trigger
FSALSalaryFixedIYPass in from F060116 Database Trigger
ADSDDateAdjustedServiceIYPass in from F060116 Database Trigger
CMPACompaRatioIYPass in from F060116 Database Trigger
EPNTJobEvaluationPointsIYPass in from F060116 Database Trigger
JOBNWorkStationIdIYPass in from F060116 Database Trigger
USERUserIdIYPass in from F060116 Database Trigger
PIDProgramIdIYPass in from F060116 Database Trigger
UPMJDateUpdatedIYPass in from F060116 Database Trigger
K001401kNonDiscrimination001IYPass in from F060116 Database Trigger
K002401kNonDiscrimination002IYPass in from F060116 Database Trigger
K003401kNonDiscrimination003IYPass in from F060116 Database Trigger
K004401kNonDiscrimination004IYPass in from F060116 Database Trigger
K005401kNonDiscrimination005IYPass in from F060116 Database Trigger
K006401kNonDiscrimination006IYPass in from F060116 Database Trigger
K007401kNonDiscrimination007IYPass in from F060116 Database Trigger
K008401kNonDiscrimination008IYPass in from F060116 Database Trigger
K009401kNonDiscrimination009IYPass in from F060116 Database Trigger
K010401kNonDiscrimination010IYPass in from F060116 Database Trigger
ATPYDefaultAutoPayTypeIYPass in from F060116 Database Trigger
PENSPensionIYPass in from F060116 Database Trigger
ORGOregonInsuranceIYPass in from F060116 Database Trigger
BENSEmployeeBenefitStatusIYPass in from F060116 Database Trigger
FTEFullTimeEquivalentsIYPass in from F060116 Database Trigger
AAFVacationFactorsIYPass in from F060116 Database Trigger
SUISourceofSUIReportingIYPass in from F060116 Database Trigger
DTSFSalaryForcastChangeDateIYPass in from F060116 Database Trigger
SMOYMonthsStandardPerYearIYPass in from F060116 Database Trigger
PIDTRSProgramId IYPass in from F060116 Database Trigger
USERTRSUser IYPass in from F060116 Database Trigger
JOBNTRSWorkStationId IYPass in from F060116 Database Trigger
TRSTRSChangeReason IYPass in from F060116 Database Trigger
EFTOTRSDateEffectiveOn IYPass in from F060116 Database Trigger
ACTNAction IYPass in from F060116 Database Trigger
Related Tables
Table Table Description
F08040HR Constants Information
Processing
Check the Flags in F08040 to see if History and/or Turnover is being tracked.
If History is Tracked
If Data Item has Changed
Send History Information to an External Routine to be Written to
History.
Endif
Next Data Item
If Turnover is Tracked
D0800019 - HR History - Write Record to JDECache - Segment 2
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cInterimCheckCode | ICC | char | NONE | NONE |
For OneWorld:
A code that indicates one of the following conditions:
Blank The payment was processed in a regular payroll cycle.
I
| ||||
mnAmountMaximumNetPay | NMAX | MATH_NUMERIC | NONE | 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
| ||||
szStOccupClassCode | SOCC | char | NONE | NONE |
A series of codes that identify occupational titles and their definitions.
These codes are used in one or more states in the preparation of
| ||||
szInterimCheckUserId | IUSR | char | NONE | NONE |
This is the user id by which the interim check was entered. This is needed to control the tax, deduction and benefit calculations for the
| ||||
szTerminalIdInterimCk | ITRM | char | NONE | NONE |
This is the terminal from which the interim check was entered. This is needed to control the tax, deduction and benefit calculations for the
| ||||
cInterimProcessingBatch | INBT | char | NONE | NONE |
This data item for future use. | ||||
szRegn | REGN | char | NONE | NONE |
A region within a state. This field is intended for use in preparation of unemployment reports for some states. | ||||
szPayStep | PSTP | char | NONE | NONE |
A quantity that identifies the number of optional pay increments, if any, available within each pay grade. | ||||
mnWorkHoursPerYear | IH | MATH_NUMERIC | NONE | NONE |
The number of work hours in the year. When you do not set your payroll company constants to use the Pay Grade Step table as the
| ||||
szCountryForPayroll | CCPR | char | NONE | NONE |
A user defined code list 00/CN that indicates the country in which the employee resides. | ||||
cAutoDepositPreNote | ADPN | char | NONE | NONE |
A code that lets you test the deposit instructions for one pay period before actually processing a deposit. Adding an employee to this form
| ||||
cThirdCtryNationalFlag | TCNF | char | NONE | NONE |
A code which specifies whether the employee is defined as a Third Country Nationalist. | ||||
cResidentAlienFlag | RAF | char | NONE | NONE |
A code which specifies whether the employee is designation as a Craft or Staff employee.
This field is reserved for future usage for
| ||||
cTippedEmployee | TIPE | char | NONE | NONE |
A code that specifies whether this employee receives or claims tips and should be included in any necessary Tip Processing programs.
| ||||
cRechargeCode | RCCD | char | NONE | NONE |
A code that identifies whether the employee is to be handled through the Recharge processing option for the Payroll Journal Entry
| ||||
mnRateBillingBurden | BDRT | MATH_NUMERIC | NONE | NONE |
An hourly rate to be used when charging 'burden' associated with the actual billing (recharge) amounts. | ||||
mnNewRechargeBurdenRate | BORN | MATH_NUMERIC | NONE | NONE |
The employee's new burden billing rate for all payroll entries input or automatically generated FOR THE PAYROLL PERIOD AFTER the
| ||||
cFloatCode | WET | char | NONE | NONE |
A code that specifies any special circumstances associated with the workers compensation insurance (WCI) code, resulting in multiple
| ||||
cAddressFlag | AFLG | char | NONE | NONE |
A flag used to designate whether to print address on the pay check. | ||||
cMaritalStatusResState | RMST | char | NONE | NONE |
A user defined code (system 06, type MS) that specifies the marital status code for the state of residence. It is used for tax computations.
| ||||
cLocalAreaMarital | LMST | char | NONE | NONE |
The employee's Local marital status code as retrieved from the locality's W-4.
This code is used in the computation of all local (city, county)
| ||||
szFlagSmoker | SMKR | char | NONE | NONE |
A flag to identify the language preference of the employee. Codes are: E English F French | ||||
mnCashBasisAccumulator | CBAC | MATH_NUMERIC | NONE | NONE |
The amount of Net Pay which was rounded in or out in order to pay the employee a whole dollar versus dollars and cents. Any amount
| ||||
cCashBasisFlag | CBAF | char | NONE | NONE |
A flag to indicate whether the employee wishes to accumulate cents within the Cash Basis Accumulator field(0) or adjust the Federal Tax up
| ||||
szPayCycleCode | PCCD | char | NONE | NONE |
A code that identifies the values for a master payroll cycle. | ||||
jdDateRecall | RCDT | JDEDATE | NONE | NONE |
The date on which the employee can be recalled for employment, if known. | ||||
jdDateLoaStarts | LSDT | JDEDATE | NONE | 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
| ||||
jdDateParticipation | PADT | JDEDATE | NONE | NONE |
The date the employee began participating in the company deferred income or stock option plan. This date must be later than the Date
| ||||
cPaymentMethod | PYMH | char | NONE | NONE |
A flag used to indicate how the employee is to be paid. This field may be used to override all Net Pay Instructions for the employee or
| ||||
cUpdateStatusFlag | UYST | char | NONE | NONE |
This code is used in the final update process to determine if an employee's records have been upated completely, or if the employee must
| ||||
mnDateTimeStamp | DTSP | MATH_NUMERIC | NONE | NONE |
The date and time which the transaction is being, or was processed, through Final Update. | ||||
mnAddressNumberPayee | ANN8 | MATH_NUMERIC | NONE | NONE |
The address book number for the supplier who receives the final payment.
In Benefits administration, this is the address book number of the
| ||||
szPayPeriodNumber | PPNB | char | NONE | NONE |
The number of the pay period from the beginning of the year. For instance, a monthly payroll cycle beginning in January has a total of 12
| ||||
jdPayCycleProcessDate | PYDT | JDEDATE | NONE | NONE |
This data item contains the date the pay cycle was processed. | ||||
cCashBenefit | CBEN | char | NONE | NONE |
A code (flag) specifying whether a BENEFIT will print on a check, auto deposit or payslip. The valid codes are:
Y Yes, print the benefit on
| ||||
mnBirthdateMonth | DOBM | MATH_NUMERIC | NONE | NONE |
The month in which the employee was born. | ||||
mnStartdateMonth | DSTM | MATH_NUMERIC | NONE | NONE |
The month in which the employee started working. | ||||
mnRatePreviousSalary | PSAL | MATH_NUMERIC | NONE | NONE |
The salary that was previously attached to an employee. This field is updated by the HR History Monitor whenever a change is made to
| ||||
szHipNumber | HIPN | char | NONE | NONE |
A unique identifier for secondary employee numbers, such as an employee's health insurance plan ID number. | ||||
szCreditMessage | CM | char | NONE | NONE |
A value in the user defined code table 00/CM that indicates the credit status of a customer or supplier. Examples are:
1
Over credit
| ||||
mnAnnualSalaryLife | LSAL | MATH_NUMERIC | NONE | NONE |
You can use this field to calculate deductions, benefits, and accruals (DBAs) for an employee's life insurance premium. Any table method
| ||||
szBenefitGroupCode | DIVC | char | NONE | NONE |
The benefit group to which the employee is assigned. Benefit groups facilitate employee enrollment by categorizing benefit plans and
| ||||
cVotingSharesFlag | VSHF | char | NONE | NONE |
A flag to identify whether the employee ownes stock in the company and therefore is allowed to vote. | ||||
mnPriorYearsVesting | PYRV | MATH_NUMERIC | NONE | NONE |
The number of prior years which have been accumulating from pension vesting purposes. | ||||
mnSupervisor | ANPA | MATH_NUMERIC | NONE | NONE |
The address book number of the supervisor. | ||||
szPayGrade | PGRD | char | NONE | NONE |
A code that designates a category for grouping employees according to pay ranges. For each pay grade, you enter a pay range that
| ||||
szPayGradeStep | PGRS | char | NONE | NONE |
A code that identifies a pay grade and pay step. You can use this code to determine an employee's pay rate.
If you have set up your
| ||||
szSalaryDataLocality | SLOC | char | NONE | NONE |
A user defined code (07/SL) that defines the different salary localities within an organization. For example, you can compare salaries for
| ||||
jdDteNextReview | NRVW | JDEDATE | NONE | NONE |
The date on which the employee is scheduled for the next performance or salary review. This field is for information only. It is not used by
| ||||
cTypeIncreaseNextRevw | TINC | char | NONE | NONE |
A user defined code (06/RV) that specifies the type of performance review to be completed for the next review period. | ||||
cI9Status | HM01 | char | NONE | NONE |
A code indicating the method used to verify that this employee is eligible to work in the United States. Valid codes are:
Y I9 form on file
P
| ||||
cVeteran | HM02 | char | NONE | NONE |
A code that indicates the veteran status of the employee for EEO reporting purposes. Valid values are:
N
This employee is not a
| ||||
cDisabledVeteran | HM03 | char | NONE | NONE |
A code indicating whether this employee is a disabled veteran. Valid codes are:
Y
Yes, this employee is a disabled veteran.
N
No, this
| ||||
cHandicapped | HM04 | char | NONE | NONE |
A code indicating whether this employee has a mental or physical disability. Valid codes are:
Y
Yes, this employee has a mental or
| ||||
szPositionID | POS | char | NONE | NONE |
A code that you use for budgetary (position) control purposes. The position ID consists of:
o Position (position code and its description)
| ||||
jdUserDefinedDate001 | ED01 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate002 | ED02 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate003 | ED03 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate004 | ED04 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate005 | ED05 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate006 | ED06 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate007 | ED07 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate008 | ED08 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate009 | ED09 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate010 | ED10 | JDEDATE | NONE | NONE |
A user defined date. Because this field is not linked to any specific function or application within the system, you can use this date for any
| ||||
jdUserDefinedDate011 | ED11 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date which is not already defined in the Payroll system. For example, if your organization
| ||||
jdUserDefinedDate012 | ED12 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date that is not already defined in the Payroll system. For example, if your organization needs
| ||||
jdUserDefinedDate013 | ED13 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date which is not already defined in the Payroll system. For example, if your organization
| ||||
jdUserDefinedDate014 | ED14 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date which is not already defined in the Payroll system. For example, if your organization
| ||||
jdUserDefinedDate015 | ED15 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date which is not already defined in the Payroll system. For example, if your organization
| ||||
jdUserDefinedDate016 | ED16 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date that is not already defined in the Payroll system. For example, if your organization needs
| ||||
jdUserDefinedDate017 | ED17 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date that is not already defined in the Payroll system. For example, if your organization needs
| ||||
jdUserDefinedDate018 | ED18 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date that is not already defined in the Payroll system. For example, if your organization needs
| ||||
jdUserDefinedDate019 | ED19 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date that is not already defined in the Payroll system. For example, if your organization needs
| ||||
jdUserDefinedDate020 | ED20 | JDEDATE | NONE | NONE |
A user-defined date in a field that can hold a date that is not already defined in the Payroll system. For example, if your organization needs
| ||||
szDepartmentCode | DEPT | char | NONE | NONE |
The number of the department in which the employee resides. | ||||
mnAgeFixed | FAGE | MATH_NUMERIC | NONE | 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
| ||||
mnSalaryFixed | FSAL | MATH_NUMERIC | NONE | NONE |
You can use this field to calculate deductions, benefits, and accruals (DBAs) for a spouse's life insurance premium. Any table method that
| ||||
jdDateAdjustedService | ADSD | JDEDATE | NONE | NONE |
The date the employee was rehired by the company. If the employee terminated and subsequently returned, this date represents the date
| ||||
mnCompaRatio | CMPA | MATH_NUMERIC | NONE | NONE |
A calculation used to compare an employee's salary/wage against a midpoint amount set up within a pay grade or salary range. | ||||
mnJobEvaluationPoints | EPNT | MATH_NUMERIC | NONE | NONE |
The number of points calculated for a specific job using any job evaluation method. A job is defined as the combination of job type and job
| ||||
szWorkStationId | JOBN | char | NONE | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
szUserId | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
szProgramId | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdDateUpdated | UPMJ | JDEDATE | NONE | NONE |
The date that specifies the last update to the file record. | ||||
c401kNonDiscrimination001 | K001 | char | NONE | NONE |
The non-discrimination testing code that you use to identify owners and officers of the company. | ||||
c401kNonDiscrimination002 | K002 | char | NONE | NONE |
The non-discrimination testing code that identifies the top 20% most highly compensated employees for the previous year. | ||||
c401kNonDiscrimination003 | K003 | char | NONE | NONE |
The non-discrimination testing code that identifies the employees who were highly-compensated in the previous year. | ||||
c401kNonDiscrimination004 | K004 | char | NONE | NONE |
The non-discrimination testing code that identifies the top 20% most highly compensated employees for the determination year. | ||||
c401kNonDiscrimination005 | K005 | char | NONE | NONE |
The non-discrimination testing code that identifies the 100 employees who were paid the most during the determination year. | ||||
c401kNonDiscrimination006 | K006 | char | NONE | NONE |
The non-discrimination testing code that identifies the 10 employees who were paid the most during the determination year. | ||||
c401kNonDiscrimination007 | K007 | char | NONE | NONE |
The non-discrimination testing code that identifies the employees who were highly-compensated in the determination year. | ||||
c401kNonDiscrimination008 | K008 | char | NONE | NONE |
A code that indicates an employee has worked the minimum number of hours required for participating in your organization's 401(k) plan.
| ||||
c401kNonDiscrimination009 | K009 | char | NONE | NONE |
This non-discrimination test field is currently not being used. | ||||
c401kNonDiscrimination010 | K010 | char | NONE | NONE |
This non-discrimination test field is currently not being used. | ||||
mnDefaultAutoPayType | ATPY | MATH_NUMERIC | NONE | NONE |
This code is used specifically to designate the default pay type to be used in the generation of autopay in those instances where the
| ||||
cPension | PENS | char | NONE | NONE |
A code that specifies whether the employee is eligible to participate in the company's retirement plan. When you process W-2 information
| ||||
cOregonInsurance | ORG | char | NONE | NONE |
A code to specify whether an employee is participating in the Oregon Industrial Insurance program. The Oregon SUI continuation report
| ||||
cEmployeeBenefitStatus | BENS | char | NONE | NONE |
A user defined code (06/EA) that specifies an employee status, such as new hire or rehire. The system uses this value as it searches and
| ||||
mnFullTimeEquivalents | FTE | MATH_NUMERIC | NONE | NONE |
The full-time equivalent (FTE) amount. This figure is the portion of a full-time worker that an employee represents within the business unit.
| ||||
cVacationFactors | AAF | char | NONE | NONE |
A value in this field represents the number of pay periods that this check is to cover. This is used by the Payroll system to direct the Vertex
| ||||
cSourceofSUIReporting | SUI | char | NONE | NONE |
Use this field to specify the work tax area that is used for SUI reporting.
You can specify that the system use either the resident state or the
| ||||
mnSalaryForcastChangeDate | DTSF | JDEDATE | NONE | NONE |
A date in the future when it is expected the employee will be given a salary change. This date is used by the position budget module to
| ||||
mnMonthsStandardPerYear | SMOY | MATH_NUMERIC | NONE | NONE |
The number of periods in the year during which the employee will be paid the salary amount. The system uses this number to calculate the
| ||||
szTRSProgramId | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szTRSUser | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
szTRSWorkStationId | JOBN | char | NONE | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
szTRSChangeReason | TRS | char | NONE | NONE |
A code that indicates the reason for one of the following:
o Changing an active employee's record
o Terminating an employee
o
| ||||
jdTRSDateEffectiveOn | EFTO | JDEDATE | NONE | NONE |
A future date when all changes will take effect or the date when the changes went into effect. If you do not enter a date in this field, the system
| ||||
jdDteNewBurdRateEffect | NBDR | JDEDATE | NONE | NONE |
The date on which the new burden billing rate for an employee takes effect.
The new rates actually go into effect AFTER THE PAYROLL
| ||||
cAction | ACTN | char | NONE | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
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
|
N0800180 Sync Compensation Review Work Tables with Employee Changes |
F08040 HR History Constants |