Functional Description
The purpose of this function is to store update Before Image Cache with change reason and effective date for purpose of
Employee History and Turnover. This function is called from all forms that update, insert or delete employee master file
F060116.
Technical Specifications
Parameters
Data Item Data Structure DescriptionI/ORequiredNotes
AN8AddressNumberIYPassed from a form
ALPHNameAlphaI NNot used in this function
SSNSocialSecurityNumberINNot used in this function
OEMPEmployeeNumberThirdINNot used in this function
SEXSexMaleFemaleINNot used in this function
MSTXMaritalStatusTaxINNot used in this function
MSTIMaritalStatusTaxStateINNot used in this function
WSPSResidencyStatus12INNot used in this function
EICEarnIncomeCredStatusINNot used in this function
NDEPNumberOfDependentsINNot used in this function
ESTEmploymentStatusINNot used in this function
ECNTEmployeeClassificationINNot used in this function
TARRTaxAreaResidenceINNot used in this function
TARATaxAreaWorkINNot used in this function
HMSTStateHomeINNot used in this function
WKSEStateWorkingINNot used in this function
HMLCLocationHomeINNot used in this function
LWK1LocationWorkCityINNot used in this function
LWK2LocationWorkCountyINNot used in this function
HMCOCompanyHomeINNot used in this function
MCUCostCenterINNot used in this function
HMCUCostCenterHomeINNot used in this function
SGControlGroupINNot used in this function
MAILRoutingCodeCheckINNot used in this function
PASTEmployeePayStatusINNot used in this function
PFRQPayFrequencyINNot used in this function
SALYPayTypeHSPINNot used in this function
PYCBPayCycleBypassCountINNot used in this function
BCBBenefitCycleBypassCtINNot used in this function
UNUnionCodeINNot used in this function
JBCDJobCategoryINNot used in this function
JBSTJobStepINNot used in this function
EEOJJobCategoryEeoINNot used in this function
EEOMMinorityEeoINNot used in this function
TRSChangeReasonINNot used in this function
WCMPWorkersCompInsurCodeINNot used in this function
FLSAFlsaExemptYNINNot used in this function
WSWorkScheduleCodeINNot used in this function
SHFTShiftCodeINNot used in this function
LMTHLaborLoadingMethodINNot used in this function
PBRTRtDistributionOrBillINNot used in this function
LFLaborLoadingFactorINNot used in this function
SALRtSalaryINNot used in this function
PHRTRtHourlyINNot used in this function
PPRTRtPieceworkINNot used in this function
PWRNRtPiecerateAtNxtRaisINNot used in this function
HRTNRtHrAtNextRaiseINNot used in this function
BRTNRtBillAtNextRaiseINNot used in this function
SALNRtSalaryAtNxtRaiseINNot used in this function
STDHHrsStandardPerPayperINNot used in this function
STDDHoursStandardPerDayINNot used in this function
SDYYDaysStandardperYearINNot used in this function
USRPayrollLockoutIdentifiINNot used in this function
UFLGUpdateFlagINNot used in this function
NSWorkTaxAreaSourceINNot used in this function
IFNInitialFrstNmeGovtRpINNot used in this function
IMNMiddleInitialINNot used in this function
DOBDateBirthINNot used in this function
DSIDateOriginalEmploymentINNot used in this function
DTDateTerminatedINNot used in this function
DSTDateEmploymentStartINNot used in this function
PSDTDatePayStartsINNot used in this function
PTDTDatePayStopsINNot used in this function
NRDTDteNextRaiseEffectiveINNot used in this function
NBDTDteNewBillRateEffectINNot used in this function
NPDTDteNewPiecerateEffectINNot used in this function
LCDTDateLastCheckINNot used in this function
DRDateLastRaiseINNot used in this function
CTDTDateLastContactINNot used in this function
LADTDateLoaExpirationINNot used in this function
BSDTDateBonusINNot used in this function
CPDTDateCurrentPositionINNot used in this function
FICMTaxCalcMethodINNot used in this function
P001ReportingCodesPayro001INNot used in this function
P002ReportingCodesPayro002INNot used in this function
P003ReportingCodesPayro003INNot used in this function
P004ReportingCodesPayro004INNot used in this function
P005ReportingCodesPayro005INNot used in this function
P006ReportingCodesPayro006INNot used in this function
P007ReportingCodesPayro007INNot used in this function
P008ReportingCodesPayro008INNot used in this function
P009ReportingCodesPayro009INNot used in this function
P010ReportingCodesPayro010INNot used in this function
P011ReportingCodesPayro011INNot used in this function
P012ReportingCodesPayro012INNot used in this function
P013ReportingCodesPayro013INNot used in this function
P014ReportingCodesPayro014INNot used in this function
P015ReportingCodesPayro015INNot used in this function
P016ReportingCodesPayro016INNot used in this function
P017ReportingCodesPayro017INNot used in this function
P018ReportingCodesPayro018INNot used in this function
P019ReportingCodesPayro019INNot used in this function
P020ReportingCodesPayro020INNot used in this function
E001EligibilityCode1INNot used in this function
E002EligibilityCode2INNot used in this function
E003EligibilityCode3INNot used in this function
E004EligibilityCode4INNot used in this function
E005EligibilityCode5INNot used in this function
E006EligibilityCode6INNot used in this function
E007EligibilityCode7INNot used in this function
E008EligibilityCode8INNot used in this function
E009EligibilityCode9INNot used in this function
E010EligibilityCode010INNot used in this function
PIDTRSProgramId N/ANNot passed, assigned in this function
USERTRSUser N/ANNot passed, assigned in this function
JOBNTRSWorkStationId N/ANNot passed, assigned in this function
TRSTRSChangeReason N/A YPassed from a form
EFTOTRSDateEffectiveOn N/AYPassed from a form
ACTNAction N/ANNot used in this function
SCDCSchoolDistrictCodeINNot used in this function
Related Tables
Table Table Description
P08040Constant file
Processing
Assign values in the function for audit fields such as Workstation ID and User ID.
D0800016 - HR History - Write Record to JDECache - Segment 1
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
szNameAlpha | ALPH | char | NONE | NONE |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
szSocialSecurityNumber | SSN | char | NONE | NONE |
A number that indicates the tax ID. In the United States, the tax ID is the social security number. In Canada, it is the social insurance number.
| ||||
szEmployeeNumberThird | OEMP | char | NONE | NONE |
An alternate employee number, typically the number from the employee tracking system that your organization used prior to converting to
| ||||
cSexMaleFemale | SEX | char | NONE | NONE |
Valid codes are: M Male F Female | ||||
cMaritalStatusTax | MSTX | char | NONE | NONE |
A user defined code (system 06, type MS) that specifies the employees' federal marital status code as retrieved from the W-4 form. This
| ||||
cMaritalStatusTaxState | MSTI | char | NONE | NONE |
The employee's "Work" state marital status code as retrieved from the state W-4. This code is used in the computation of all state payroll
| ||||
cResidencyStatus12 | WSPS | char | NONE | NONE |
A value that identifies out-of-state employees for whom an employer must withhold tax for the state of residence. Valid values are:
N
| ||||
cEarnIncomeCredStatus | EIC | char | NONE | NONE |
A code that specifies whether the employee qualifies for the earned income credit and elects for the employer to give him or her the
| ||||
mnNumberOfDependents | NDEP | MATH_NUMERIC | NONE | NONE |
Number of dependents for insurance purposes. See also the definitions for federal and state tax exemptions. | ||||
cEmploymentStatus | EST | char | NONE | NONE |
A user defined code (07/ES) that specifies an employee's status within the company. You can change the default codes or set up new
| ||||
cEmployeeClassification | ECNT | char | NONE | NONE |
Employee classification determines the type of employee to the system. It identifies them as an independent contractor, a regular
| ||||
szTaxAreaResidence | TARR | char | NONE | NONE |
A code that identifies both the geographical location and the tax authorities for the employee's residence. Authorities include employee
| ||||
szTaxAreaWork | TARA | char | NONE | NONE |
A code that identifies a geographical location and the tax authorities for an employee work site, including employee and employer statutory
| ||||
szStateHome | HMST | char | NONE | NONE |
The employee's home state for tax reporting purposes. This code designates the state in which the employee resides.
Note: For W-2
| ||||
szStateWorking | WKSE | char | NONE | NONE |
The employee's work state for tax reporting purposes. This code indicates the state in which the employee normally works. The system
| ||||
szLocationHome | HMLC | char | NONE | NONE |
The location or city where the employee resides. | ||||
szLocationWorkCity | LWK1 | char | NONE | NONE |
A code identifying the city in which the employee works. | ||||
szLocationWorkCounty | LWK2 | char | NONE | NONE |
A code identifiying the county in which the employee works. | ||||
szCompanyHome | HMCO | char | NONE | NONE |
The company number where the employee records generally reside. | ||||
szCostCenter | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szCostCenterHome | HMCU | char | NONE | NONE |
The number of the business unit in which the employee generally resides. | ||||
szControlGroup | SG | char | NONE | NONE |
The last business unit (job) number associated with this employee. This field is used for distribution of paychecks and in the generation of
| ||||
szRoutingCodeCheck | char | NONE | 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
| ||||
cEmployeePayStatus | PAST | char | NONE | NONE |
The code used to indicate whether an employee's pay status is active or inactive. Codes for active pay status employees are numeric,
| ||||
cPayFrequency | PFRQ | char | NONE | NONE |
A user defined code (07/PF) that indicates how often an employee is paid. Valid codes are:
B
Biweekly
W
Weekly
S
Semimonthly
| ||||
cPayTypeHSP | SALY | char | NONE | NONE |
A code that specifies how an employee is paid. Valid codes are: H Hourly S Salaried P Piecework | ||||
mnPayCycleBypassCount | PYCB | MATH_NUMERIC | NONE | NONE |
The number of pay cycles (that is, paychecks) bypassed. This is normally specified during the interim check process and would be used
| ||||
mnBenefitCycleBypassCt | BCB | MATH_NUMERIC | NONE | NONE |
The number of pay cycles (paychecks) that you want the system to bypass the benefit calculations.
Typically, you specify this information
| ||||
szUnionCode | UN | char | NONE | NONE |
A user defined code (06/UN) that represents the union or plan in which the employee or group of employees work or participate. | ||||
szJobCategory | JBCD | char | NONE | 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
| ||||
szJobStep | JBST | char | NONE | 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
| ||||
szJobCategoryEeo | EEOJ | char | NONE | NONE |
A user defined code (07/J) that specifies classifications established by the U.S. Equal Employment Opportunity Commission (EEOC) or the
| ||||
szMinorityEeo | EEOM | char | NONE | NONE |
A user defined code (07/M) that designates minority classifications according to U.S. Equal Employment Opportunity Commission (EEOC)
| ||||
szChangeReason | 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
| ||||
szWorkersCompInsurCode | WCMP | char | NONE | NONE |
A user defined code (00/W) that represents a workers' compensation insurance (WCI) code. This code should correspond to the
| ||||
cFlsaExemptYN | FLSA | char | NONE | NONE |
A code that indicates whether the employee fits the rules of the Fair Labor Standards Act (FLSA) and thus does not have to be paid for
| ||||
cWorkScheduleCode | WS | char | NONE | NONE |
A user defined code to designate intra-pay period work schedules. This code can be used for reporting and to select employees to be
| ||||
cShiftCode | SHFT | char | NONE | NONE |
A user defined code (00/SH) that identifies daily work shifts.
In payroll systems, you can use a shift code to add a percentage or amount to
| ||||
cLaborLoadingMethod | LMTH | char | NONE | NONE |
Controls whether the labor costs include a flat burden for payroll taxes and benefits. Valid values are:
0 The flat burden factor is always
| ||||
mnRtDistributionOrBill | PBRT | MATH_NUMERIC | NONE | NONE |
A number that specifies the rate that the system uses to bill for labor services. This rate is often referred to as the billing or recharge rate.
| ||||
mnLaborLoadingFactor | LF | MATH_NUMERIC | NONE | NONE |
A multiplier to load direct labor costs with burden. For example, a factor of 1.32 would load every dollar of labor cost with 32 cents worth of
| ||||
mnRtSalary | SAL | MATH_NUMERIC | NONE | 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
| ||||
mnRtHourly | PHRT | MATH_NUMERIC | NONE | 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
| ||||
mnRtPiecework | PPRT | MATH_NUMERIC | NONE | 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
| ||||
mnRtPiecerateAtNxtRais | PWRN | MATH_NUMERIC | NONE | NONE |
This will be the employee's new piecework rate of pay for all payroll entries input or automatically generated FOR THE PAYROLL PERIOD
| ||||
mnRtHrAtNextRaise | HRTN | MATH_NUMERIC | NONE | NONE |
The base hourly rate increase for an employee. The following will be added together to determine recommended hourly increase for an
| ||||
mnRtBillAtNextRaise | BRTN | MATH_NUMERIC | NONE | NONE |
This will be the employee's new hourly billing rate for all payroll entries input or automatically generated FOR THE PAYROLL PERIOD
| ||||
mnRtSalaryAtNxtRaise | SALN | MATH_NUMERIC | NONE | NONE |
The employee's new annual salary for all payroll entries manually entered or automatically generated for the payroll period after the Date
| ||||
mnHrsStandardPerPayper | STDH | MATH_NUMERIC | NONE | NONE |
The standard number of hours that you want to pay an hourly employee for in each payroll, regardless of whether the employee works
| ||||
mnHoursStandardPerDay | STDD | MATH_NUMERIC | NONE | NONE |
The number of hours that the employee normally works in one day. If you leave this field blank, the default is the standard number of hours
| ||||
mnDaysStandardperYear | SDYY | MATH_NUMERIC | NONE | NONE |
The number of workdays in a year. The number of standard days per year multiplied by the number of hours per day equals the standard
| ||||
szPayrollLockoutIdentifi | USR | char | NONE | 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
| ||||
cUpdateFlag | UFLG | char | NONE | NONE |
This indicator in the employee master is under program control. It is set to Y when anything is added, changed or deleted related to the
| ||||
cWorkTaxAreaSource | NS | char | NONE | NONE |
This code is used to determine the source for obtaining the tax area code for the employee's work location.
N Use time entry, job master,
| ||||
cInitialFrstNmeGovtRp | IFN | char | NONE | NONE |
The first letter of the employee's first (given) name. This is primarily used to facilitate certain statutory reporting requirements. | ||||
cMiddleInitial | IMN | char | NONE | NONE |
The first letter of the individual's middle name. This is primarily used to facilitate certain statutory reporting requirements. | ||||
jdDateBirth | DOB | JDEDATE | NONE | NONE |
The employee's date of birth. | ||||
jdDateOriginalEmployment | DSI | JDEDATE | NONE | NONE |
The date on which the employee was originally hired by the company. If the employee was terminated and subsequently rehired, the new
| ||||
jdDateTerminated | DT | JDEDATE | NONE | NONE |
The date that the employee was terminated, if applicable. | ||||
jdDateEmploymentStart | DST | JDEDATE | NONE | NONE |
The date on which the employee actually reported to work for the most recent period of hire. When an employee initially begins working,
| ||||
jdDatePayStarts | PSDT | JDEDATE | NONE | NONE |
The date that an employee may begin participating in the company's benefit plans or may be included in payroll processing.
You can also
| ||||
jdDatePayStops | PTDT | JDEDATE | NONE | NONE |
The date when an employee should no longer be included in a payroll cycle or the date when an employee stops participating in the
| ||||
jdDteNextRaiseEffective | NRDT | JDEDATE | NONE | NONE |
The date that the hourly or annual pay rate for the employee increases. The new rate goes into effect after a payroll cycle completes with a
| ||||
jdDteNewBillRateEffect | NBDT | JDEDATE | NONE | NONE |
The date on which the new billing rate for an employee goes into effect. The new rates actually go into effect AFTER THE PAYROLL
| ||||
jdDteNewPiecerateEffect | NPDT | JDEDATE | NONE | NONE |
The date on which the new piecework rate for an employee goes into effect. The new rates actually go into effect AFTER THE PAYROLL
| ||||
jdDateLastCheck | LCDT | JDEDATE | NONE | NONE |
The date of the last payroll check issued to the employee. The system automatically updates this field when you run a payroll. If you leave
| ||||
jdDateLastRaise | DR | JDEDATE | NONE | NONE |
The date of the employee's last raise. For the stand-alone HR system, this is the date when you update salary and wages. If you also have
| ||||
jdDateLastContact | CTDT | JDEDATE | NONE | NONE |
The date you last contacted a temporary, seasonal, or laid-off employee, or an employee on furlough or leave of absence. | ||||
jdDateLoaExpiration | LADT | JDEDATE | NONE | NONE |
The date on which an employee's paid or unpaid leave of absence expires. | ||||
jdDateBonus | BSDT | JDEDATE | NONE | NONE |
The date an employee is to receive a bonus. This date is also part of the supplemental data for a bonus review. | ||||
jdDateCurrentPosition | CPDT | JDEDATE | NONE | NONE |
The date the employee started the current position. | ||||
cTaxCalcMethod | FICM | char | NONE | NONE |
A code that specifies the tax method that the Vertex payroll-tax calculation system uses to calculate certain taxes. The codes are defined in
| ||||
szReportingCodesPayro001 | P001 | char | NONE | NONE |
A category code that defines payroll system needs. You can define the use and description of this code to fit your organization. For
| ||||
szReportingCodesPayro002 | P002 | char | NONE | NONE |
A category code which specifies payroll system needs. You may define the use and description of this code to fit your organization. For
| ||||
szReportingCodesPayro003 | P003 | char | NONE | NONE |
A category code which specifies payroll system needs. You can define the use and description of this code to fit your organization. For
| ||||
szReportingCodesPayro004 | P004 | char | NONE | NONE |
A category code which specifies payroll system needs. You can define the use and description of this code to fit your organization. For
| ||||
szReportingCodesPayro005 | P005 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro006 | P006 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro007 | P007 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro008 | P008 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro009 | P009 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro010 | P010 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro011 | P011 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro012 | P012 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro013 | P013 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro014 | P014 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro015 | P015 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro016 | P016 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro017 | P017 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro018 | P018 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro019 | P019 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
szReportingCodesPayro020 | P020 | char | NONE | NONE |
Your may define the use and description of this code to fit the needs of your organization. You can, for example, set up a category code for
| ||||
cEligibilityCode1 | E001 | char | NONE | NONE |
A code to specify an employee's eligibility for or participation in various user defined plans or programs. For example, these codes can be
| ||||
cEligibilityCode2 | E002 | char | NONE | NONE |
A code that specifies employee eligibility for or participation in various user-defined plans or programs. For example, you might use these
| ||||
cEligibilityCode3 | E003 | char | NONE | NONE |
A code that specifies employee eligibility for or participation in various user-defined plans or programs. For example, you might use these
| ||||
cEligibilityCode4 | E004 | char | NONE | NONE |
A code to specify an employee's eligibility for or participation in various user defined plans or programs. For example, these codes can be
| ||||
cEligibilityCode5 | E005 | char | NONE | NONE |
A code to specify an employee's eligibility for or participation in various user defined plans or programs. For example, these codes can be
| ||||
cEligibilityCode6 | E006 | char | NONE | NONE |
A code to specify an employee's eligibility for or participation in various user defined plans or programs. For example, these codes can be
| ||||
cEligibilityCode7 | E007 | char | NONE | NONE |
A code that specifies employee eligibility for or participation in various user-defined plans or programs. For example, these codes might
| ||||
cEligibilityCode8 | E008 | char | NONE | NONE |
A code to specify an employee's eligibility for or participation in various user defined plans or programs. For example, these codes can be
| ||||
cEligibilityCode9 | E009 | char | NONE | NONE |
A code to specify an employee's eligibility for or participation in various user defined plans or programs. For example, these codes can be
| ||||
cEligibilityCode010 | E010 | char | NONE | NONE |
A code to specify an employee's eligibility for or participation in various user defined plans or programs. For example, these codes can be
| ||||
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
| ||||
cAction | ACTN | char | NONE | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
mnSchoolDistrictCode | SCDC | MATH_NUMERIC | OPT | NONE |
A user-defined code in UDC 06/SD that determines the school district tax for taxation purposes. Vertex automatically calculates the school
|
None |
None |