AddF08401WFRecord

Build Applicant/Employee Affirmative Action Work File

Minor Business Rule

Object Name: N0800113

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose

This NER will add records to the Applicant Work File (F08401WF).

Setup Notes and Prerequisites
In order to test if an applicant was offered a job or rejected a job, the Offers From/Through
Statuses and the Rejection From/Through Statuses must be entered.

Special Logic

Determine if Applicant was hired
If Applicant was hired,
Get HR History
Set Status Flag to 'H' for hired
If Applicant was not hired,
If Applicant was offered a job,
Set Status Flag to 'O' for offered
If Applicant was rejected,
Set Status Flag to 'R' for rejected
If not running an exception report,
Check that the EEO Job Code (EEOJ), the Gender (SEX),
the EEO Minority Group (EEOM), and the Home Business
Unit (HMCU)have valid values.
If all values are valid,
Insert record in F08401WF
If running an exception report,
Check that the EEO Job Code (EEOJ), the Gender (SEX),
the EEO Minority Group (EEOM), and the Home Business
Unit (HMCU)have valid values.
If any values are invalid,
Insert record in F08401WF

Technical Specification

mnAddressNumber - Required input field.
mnJobNumber - Required input field.
cExceptionReportFlag - Required input field.
szOffersFromStatus - Optional input field.
szOffersThruStatus - Optional input field.
szRejectionsFromStatus - Optional input field.
szRejectionsThruStatus - Optional input field.
jdDateBeginEffective - Required input field.
jdDateEndEffective - Required input field.
szAlphaName - Required input field.
szApplicantStatus - Required input field.
szSocialSecurityNumber - Required input field.
szCostCenter - Required input field.
szPositionID - Required input field.
szJobType - Required input field.
szJobStep - Required input field.
szJobCateogryEEO - Required input field.
szMinorityEEO - Required input field.
cSexMaleFemale - Required input field.
cI9Status - Required input field.
cVeteran - Required input field.
cDisabledVeteran - Required input field.
cHandicapped - Required input field.
cTravel(Y/N) - Required input field.
cRelocate - Required input field.
cRegTemp - Required input field.
cApplicantCode008 - Required input field.
cApplicantCode009 - Required input field.
cApplicantCode010 - Required input field.
szSourceOfReference - Required input field.
szApplicationMethod - Required input field.
szInterviewer - Required input field.
szBranchLocation - Required input field.
szApplicantCode005 - Required input field.
szApplicantCode006 - Required input field.
szApplicantCode007 - Required input field.
szApplicantCode008 - Required input field.
szApplicantCode009 - Required input field.
szApplicantCode010 - Required input field.
jdDateBirth - Required input field.
jdDateApplication - Required input field.
jdDateRecruitingEnd - Required input field.
jdDateFirstInterview - Required input field.
jdDateAvailToWork - Required input field.
szUserID - Required input field.
szProgramID - Required input field.
jdDateUpdated - Required input field.
szWorkStationID - Required input field.
szCostCenterHome - Required input field.

cErrorCode - Output field.

The 'Error Code' values are as follows:
0 = No errors. Record added.
1 = Applicant not found in Applicant file (F08401).
2 = EEO Job Code invalid.
3 = Gender invalid.
4 = EEO Minority Group invalid.
5 = Home Business Unit invalid.

^

Data Structure

D0800113B - Add F08401WF Record

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnApplicantID	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
cExceptionReportFlag	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.
szOffersFromStatus	APS	char	OPT	INPUT
A code that defines a step in the hiring process that the applicant has completed, such as initial contact, first interview, and so on. This is a user defined code (08/AS). When you enter or change the status of an applicant with the Applicant Entry program (P08401), the system adds a record to the supplemental data type for applicant status. To review the history of an applicant's status, you can view the information that has been added to this supplemental data type.
szOffersThruStatus	APS	char	OPT	INPUT
A code that defines a step in the hiring process that the applicant has completed, such as initial contact, first interview, and so on. This is a user defined code (08/AS). When you enter or change the status of an applicant with the Applicant Entry program (P08401), the system adds a record to the supplemental data type for applicant status. To review the history of an applicant's status, you can view the information that has been added to this supplemental data type.
szRejectionsFromStatus	APS	char	OPT	INPUT
A code that defines a step in the hiring process that the applicant has completed, such as initial contact, first interview, and so on. This is a user defined code (08/AS). When you enter or change the status of an applicant with the Applicant Entry program (P08401), the system adds a record to the supplemental data type for applicant status. To review the history of an applicant's status, you can view the information that has been added to this supplemental data type.
szRejectionsThruStatus	APS	char	OPT	INPUT
A code that defines a step in the hiring process that the applicant has completed, such as initial contact, first interview, and so on. This is a user defined code (08/AS). When you enter or change the status of an applicant with the Applicant Entry program (P08401), the system adds a record to the supplemental data type for applicant status. To review the history of an applicant's status, you can view the information that has been added to this supplemental data type.
cErrorCode	ERRC	char	OPT	OUTPUT
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
jdDateBeginningEffective	EFTB	JDEDATE	REQ	INPUT
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	REQ	INPUT
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.
szNameAlpha	ALPH	char	REQ	INPUT
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.
szApplicantStatus	APS	char	REQ	INPUT
A code that defines a step in the hiring process that the applicant has completed, such as initial contact, first interview, and so on. This is a user defined code (08/AS). When you enter or change the status of an applicant with the Applicant Entry program (P08401), the system adds a record to the supplemental data type for applicant status. To review the history of an applicant's status, you can view the information that has been added to this supplemental data type.
szSocialSecurityNumber	SSN	char	REQ	INPUT
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. If you add employee information for a non-US or non-Canadian company, you can leave this field blank. However, if the international code is set to Y and the default company is non-Canadian and non-United States, you can enter a 16-character number for the tax ID. The system does not permit duplicate tax ID numbers. Also, the number cannot include dashes. For example, if a social security number of nn-nn-nnnn is used, the number should be entered as follows: 123456789.
szCostCenter	MCU	char	REQ	INPUT
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.
szPositionID	POS	char	REQ	INPUT
A code that you use for budgetary (position) control purposes. The position ID consists of: o Position (position code and its description) o Fiscal year o Home business unit For example, you can identify position A0-1 as Accounting Manager for fiscal year 2005-2006, for home business unit 41. You might choose to set up positions so that the position IDs are the same as the corresponding job IDs. Within a home business unit, positions appear in the alphanumeric sequence of their position IDs. For example, position A0-1 appears before position A0-2.
szJobCategory	JBCD	char	REQ	INPUT
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and apply that information to the employees who are linked to that job type.
szJobStep	JBST	char	REQ	INPUT
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.
szJobCategoryEeo	EEOJ	char	REQ	INPUT
A user defined code (07/J) that specifies classifications established by the U.S. Equal Employment Opportunity Commission (EEOC) or the Canadian Employment Equity Occupational Group (EEOG) for use in reporting levels of minority employment. Do not change any of the codes provided by J.D. Edwards. You can add codes if needed.
szMinorityEeo	EEOM	char	REQ	INPUT
A user defined code (07/M) that designates minority classifications according to U.S. Equal Employment Opportunity Commission (EEOC) and Canadian Employment Equity Occupational Group (EEOG) standards. The predefined codes that J.D. Edwards provides are hardcoded. The system uses these codes to generate EEO reports and to compile Canadian Employment Equity information. Do not change these predefined codes. You can add codes, if necessary.
cSexMaleFemale	SEX	char	REQ	INPUT
Valid codes are: M Male F Female
cI9Status	HM01	char	REQ	INPUT
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 Passport used for verification L Driver's license and Social Security card V Visa (worker's permit) B Birth certificate N Waiting for verification
cVeteran	HM02	char	REQ	INPUT
A code that indicates the veteran status of the employee for EEO reporting purposes. Valid values are: N This employee is not a veteran. Y This employee is a veteran. V This employee is a Vietnam veteran. O This employee is a veteran, classified as Other as defined by the U.S. Department of Labor.
cDisabledVeteran	HM03	char	REQ	INPUT
A code indicating whether this employee is a disabled veteran. Valid codes are: Y Yes, this employee is a disabled veteran. N No, this employee is not a disabled veteran. This field is used to generate the Veterans Employee (VETS-100) report.
cHandicapped	HM04	char	REQ	INPUT
A code indicating whether this employee has a mental or physical disability. Valid codes are: Y Yes, this employee has a mental or physical disability. N No, this employee does not have a mental or physical disability. U Unknown
cTravelYN	HM05	char	REQ	INPUT
A yes/no (Y/N) code you can use to meet your needs. Currently this code has been defined to indicate whether an applicant is willing to travel. Valid codes are: Y Yes, this applicant will travel N No, this applicant is not willing to travel
cRelocate	HM06	char	REQ	INPUT
A yes/no (Y/N) code you can use to meet your needs. Currently it has been defined to indicate whether an applicant is willing to relocate. Valid codes are: Y Yes, the applicant will relocate N No, the applicant is not willing to relocate
cRegTemp	HM07	char	REQ	INPUT
A code used to indicate whether the applicant is to be a regular or a temporary employee. Valid codes are: R The applicant is to be a regular employee T The applicant is to be a temporary employee
cCategoryCodeAplcnt008	HM08	char	REQ	INPUT
A code you can define to meet your needs for applicant information not addressed by other category codes.
cCategoryCodeAplcnt009	HM09	char	REQ	INPUT
A code you can define to meet your needs for applicant information not addressed by other category codes.
cCategoryCodeAplcnt010	HM10	char	REQ	INPUT
A code you can define to meet your needs for applicant information not addressed by other category codes.
szSourceOfReference	HN01	char	REQ	INPUT
A code explaining how an applicant was referred to the position or to the company. You can define these codes using user defined code table 08/N1. This code reflects a more specific source of reference than that in the Application Method (data item HN02) field.
szApplicationMethod	HN02	char	REQ	INPUT
A code used to define how an applicant applied for the job. You can define these codes using user defined code table 08/MA. This code reflects a less specific source of information than that in the Source of Information (data item HN01) field.
szInterviewer	HN03	char	REQ	INPUT
A code used to identify the person who interviewed the applicant. You can define interviewers using user defined code table 08/N3. You can enter more specific interview information using the data types linked to the detailed applicant resume process.
szBranchLocation	HN04	char	REQ	INPUT
A code used to define the branch or geographic location for which the applicant is being considered. You can define this code using user defined code table 01/01. This code is helpful for reporting purposes.
szCategoryCodeApplcnt005	HN05	char	REQ	INPUT
A user defined code available for you to use as necessary to define applicant information.
szCategoryCodeApplcnt006	HN06	char	REQ	INPUT
A user defined code available for you to use as necessary to define applicant information.
szCategoryCodeApplcnt007	HN07	char	REQ	INPUT
A user defined code available for you to use as necessary to define applicant information.
szCategoryCodeApplcnt008	HN08	char	REQ	INPUT
A user defined code available for you to use as necessary to define applicant information.
szCategoryCodeApplcnt009	HN09	char	REQ	INPUT
A user defined code available for you to use as necessary to define applicant information.
szCategoryCodeApplcnt010	HN10	char	REQ	INPUT
A user defined code available for you to use as necessary to define applicant information.
jdDateBirth	DOB	JDEDATE	REQ	INPUT
The employee's date of birth.
jdDateApplication	RECB	JDEDATE	REQ	INPUT
The date the applicant applied for the position.
jdDateRecruitingEnd	RECE	JDEDATE	REQ	INPUT
The date when recruitment of an applicant has ended.
jdDateFirstInterview	DFIN	JDEDATE	REQ	INPUT
The date the applicant first interviewed for the job.
jdDateAvailableToBegin	DTAV	JDEDATE	REQ	INPUT
The date an applicant is available to begin work.
mnRtSalaryAsking	SALA	MATH_NUMERIC	REQ	INPUT
The amount an applicant has requested for salary.
mnHoursAvailToWork	HRA	MATH_NUMERIC	REQ	INPUT
The number of hours an applicant is available to work, if hired.
szUserId	USER	char	REQ	INPUT
The code that identifies a user profile.
szProgramId	PID	char	REQ	INPUT
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.
jdDateUpdated	UPMJ	JDEDATE	REQ	INPUT
The date that specifies the last update to the file record.
szWorkStationId	JOBN	char	REQ	INPUT
The code that identifies the work station ID that executed a particular job.
szCostCenterHome	HMCU	char	REQ	INPUT
The number of the business unit in which the employee generally resides.
mnJobnumberA	JOBS	MATH_NUMERIC	REQ	INPUT
The job number (work station ID) which executed the particular job.

Related Functions

None

Related Tables

None

DeleteF08401WFRecord

Build Applicant/Employee Affirmative Action Work File

Minor Business Rule

Object Name: N0800113

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
This function will either delete from the F08401WF one record at a time, or all records for the Job.
Setup Notes and Prerequisites

Special Logic

Technical Specification

If this is a delete of one record, then delete it.

If this is a delete of the entire work file, then select all the records for the job, and cycle
through, deleting them as you go.

^

Data Structure

D0800113A - Delete F08401WF Record

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
cErrorCode	ERRC	char	OPT	OUTPUT
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
mnJobnumberA	JOBS	MATH_NUMERIC	REQ	INPUT
The job number (work station ID) which executed the particular job.

Related Functions

None

Related Tables

None