AddWorkFileTypeOneRecord

Job Competency Work File Management

Minor Business Rule

Object Name: N0800200

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this function is to add a type 1 record to the F08006WF (Job Competencies Work File).
A type 1 record is written every time a Job Competency Code is attached to a level in the
organization.

Setup Notes and Prerequisites

Special Logic

Technical Specification

The parameters passed in are written to the F08006WF with a Default/Override flag value of 1.  If the
draft flag passed in is 1, then dates are not written in the record.  If the draft flag is not 1,
then the dates are written.

Data Structure

D0800200A - Write Job Competency Work File Type One Record

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnParentKeyIDInternal	PUKID	MATH_NUMERIC	REQ	INPUT
A unique number that the system uses to identify a record in a file.
mnUniqueKeyIDInternal	UKID	MATH_NUMERIC	REQ	INPUT
This field is a unique number used to identify a record in a file.
szOrganizationType	OTPS	char	REQ	INPUT
A user-defined code (00/TS) that identifies the type of organization structure, such as financial or responsibility. Each type of organization structure can have a separate hierarchy.
szJobCompetencyCode	JCC	char	REQ	INPUT
A code that uniquely identifies each job competency. Competencies are high-level human attributes that help an employee achieve the goals and objectives of the company. These competencies are also the foundation of an employee's job and job description.
szJobGroup	JGRP	char	OPT	INPUT
A grouping of similar jobs that are linked together to form a unit. The jobs might be similar in functions within the organization, job duties, tasks, responsibilities, job evaluation methods, or pay philosophies. Typical job units are clerical or administrative; technical, engineering, scientific, and professional; factory jobs; management; and executive. Consider dividing groups into separate populations based on the differences between exempt and non-exempt employees, according to the rules and regulations of the Fair Labor Standards Act. For example, consider assigning all your managers to the Managers job group. A job category defines a specific job, and all related job categories are classified by a job group. You can define job group codes using user defined code table 08/JG.
szOrganizationalBusinessUnit	ORMCU	char	OPT	INPUT
A business unit that is included in the organizational structure for job competencies. You use organizational business units to assign job competency information to levels within your organizational structure. This business unit is independent of an employee's home business unit and security business unit.
szJobType	JBCD	char	OPT	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	OPT	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.
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.
cOptionOverridesExistFlag	OVEX1	char	OPT	INPUT
A symbol in this field indicates that the job competency options have overrides at this level.
cIncludeOverridesExistFlag	OVEX2	char	OPT	INPUT
A symbol in this field indicates that the Job Competency Include in Gap/Performance Appraisal flag has overrides at this level.
cDescription1OverridesExist	OVEX3	char	OPT	INPUT
A symbol in this field indicates that the Job Competency User Defined Description has overrides at this level.
cDescription2OverridesExist	OVEX4	char	OPT	INPUT
A symbol in this field indicates that the Job Competency User Defined Description has overrides at this level.
cDescription3OverridesExist	OVEX5	char	OPT	INPUT
A symbol in this field indicates that the Job Competency User Defined Description has overrides at this level.
cDescription4OverridesExis	OVEX6	char	OPT	INPUT
A symbol in this field indicates that the Job Competency User Defined Description has overrides at this level.
cDescription5OverridesExis	OVEX7	char	OPT	INPUT
A symbol in this field indicates that the Job Competency User Defined Description has overrides at this level.
cDescription6OverridesExis	OVEX8	char	OPT	INPUT
A symbol in this field indicates that the Job Competency User Defined Description has overrides at this level.
szJobCompetencySource	JCCS	char	REQ	INPUT
The location in the organizational structure where the competency is defined.
cAddTypeTwoRecord	EV01	char	OPT	INPUT
If this flag is set to 1 it will also add a type two record for the type one record being added. If it is not set to 1, the calling program must write the type two record. 1 = Write a type two record 0 = Do not write a type two record ^
cDraftFlag	DFLAG	char	REQ	INPUT
If the draft flag is 1, the record will be written without dates. If the draft flag is not 1, the record will be written with dates.

Related Functions

None

Related Tables

None

AddWorkFileTypeTwoRecord

Job Competency Work File Management

Minor Business Rule

Object Name: N0800200

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this function is to add a type 2 record to the F08006WF (Job Competency Work File).  A
type 2 record shows the locations in the organizational structure where the Job Competency Code has
some sort of override such as an include in gap/performance appraisal flag override, an option
override, or a description override.

Setup Notes and Prerequisites

Special Logic

Technical Specification

Make sure the Begin Date is before the End Date if this is not a draft.

Assign the Default Override Flag a value of 2.

Set the character to write which denotes that overrides exist.  Currently, this is a *, if any of the
override flags passed in have a value, set their value to a *.  This will allow the calling program
to enter any character and still keep the character written to the work file consistent.

Go through the records already existing in the F08006WF that occur during the same time period of the
overrides being written.  Update and write records so that the new override that was passed is
represented in records for the time period passed in.  If this is a draft, then simply update the * pattern
for the single record at this level, or write a new record at this level if one does not already
exist.

Data Structure

D0800200B - Write Job Competency Work File Type Two Record

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnParentKeyIDInternal	PUKID	MATH_NUMERIC	REQ	INPUT
A unique number that the system uses to identify a record in a file.
mnUniqueKeyIDInternal	UKID	MATH_NUMERIC	REQ	INPUT
This field is a unique number used to identify a record in a file.
szOrganizationType	OTPS	char	REQ	INPUT
A user-defined code (00/TS) that identifies the type of organization structure, such as financial or responsibility. Each type of organization structure can have a separate hierarchy.
szJobCompetencyCode	JCC	char	REQ	INPUT
A code that uniquely identifies each job competency. Competencies are high-level human attributes that help an employee achieve the goals and objectives of the company. These competencies are also the foundation of an employee's job and job description.
szJobGroup	JGRP	char	OPT	INPUT
A grouping of similar jobs that are linked together to form a unit. The jobs might be similar in functions within the organization, job duties, tasks, responsibilities, job evaluation methods, or pay philosophies. Typical job units are clerical or administrative; technical, engineering, scientific, and professional; factory jobs; management; and executive. Consider dividing groups into separate populations based on the differences between exempt and non-exempt employees, according to the rules and regulations of the Fair Labor Standards Act. For example, consider assigning all your managers to the Managers job group. A job category defines a specific job, and all related job categories are classified by a job group. You can define job group codes using user defined code table 08/JG.
szOrganizationalBusinessUnit	ORMCU	char	OPT	INPUT
A business unit that is included in the organizational structure for job competencies. You use organizational business units to assign job competency information to levels within your organizational structure. This business unit is independent of an employee's home business unit and security business unit.
szJobType	JBCD	char	OPT	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	OPT	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.
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.
cOptionOverridesExistFlag	OVEX1	char	OPT	INPUT
Pass a character into this parameter if the options are being overridden for this period of time.
cIncludeOverridesExistFlag	OVEX2	char	OPT	INPUT
Pass a character into this parameter if the include in gap/performance appraisal flag is being overridden for this period of time.
cDescription1OverridesExist	OVEX3	char	OPT	INPUT
Pass a character into this parameter if the user defined competency description 1 is being overridden for this period of time.
cDescription2OverridesExist	OVEX4	char	OPT	INPUT
Pass a character into this parameter if the user defined competency description 2 is being overridden for this period of time.
cDescription3OverridesExist	OVEX5	char	OPT	INPUT
Pass a character into this parameter if the user defined competency description 3 is being overridden for this period of time.
cDescription4OverridesExis	OVEX6	char	OPT	INPUT
Pass a character into this parameter if the user defined competency description 4 is being overridden for this period of time.
cDescription5OverridesExis	OVEX7	char	OPT	INPUT
Pass a character into this parameter if the user defined competency description 5 is being overridden for this period of time.
cDescription6OverridesExis	OVEX8	char	OPT	INPUT
Pass a character into this parameter if the user defined competency description 6 is being overridden for this period of time.
szJobCompetencySource	JCCS	char	REQ	INPUT
This data item is no longer used.
cDraftFlag	DFLAG	char	REQ	INPUT
A code that indicates whether an organizational structure is in draft mode and has not yet been activated. Valid values are: 1 Yes 0 No

Related Functions

None

Related Tables

None

DeleteWorkFileTypeOneRecord

Job Competency Work File Management

Minor Business Rule

Object Name: N0800200

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this function is to end or delete type 1 records in the F08006WF (Job Competency Work
File).  Type 1 record represent at what level the competency is attached to the organization.

Setup Notes and Prerequisites

Special Logic

Technical Specification

Find the type 1 record to end/delete.  If the date to end is before the begin date of the record or
the Draft Flag is 1, then delete the record.  If the date to end is after the begin date, then end date
the record.

Data Structure

D0800200C - Delete Job Competency Work File Type One Record

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnParentKeyIDInternal	PUKID	MATH_NUMERIC	REQ	INPUT
A unique number that the system uses to identify a record in a file.
mnUniqueKeyIDInternal	UKID	MATH_NUMERIC	REQ	INPUT
This field is a unique number used to identify a record in a file.
szOrganizationType	OTPS	char	REQ	INPUT
A user-defined code (00/TS) that identifies the type of organization structure, such as financial or responsibility. Each type of organization structure can have a separate hierarchy.
szJobCompetencyCode	JCC	char	REQ	INPUT
A code that uniquely identifies each job competency. Competencies are high-level human attributes that help an employee achieve the goals and objectives of the company. These competencies are also the foundation of an employee's job and job description.
szJobGroup	JGRP	char	OPT	INPUT
A grouping of similar jobs that are linked together to form a unit. The jobs might be similar in functions within the organization, job duties, tasks, responsibilities, job evaluation methods, or pay philosophies. Typical job units are clerical or administrative; technical, engineering, scientific, and professional; factory jobs; management; and executive. Consider dividing groups into separate populations based on the differences between exempt and non-exempt employees, according to the rules and regulations of the Fair Labor Standards Act. For example, consider assigning all your managers to the Managers job group. A job category defines a specific job, and all related job categories are classified by a job group. You can define job group codes using user defined code table 08/JG.
szOrganizationalBusinessUnit	ORMCU	char	OPT	INPUT
A business unit that is included in the organizational structure for job competencies. You use organizational business units to assign job competency information to levels within your organizational structure. This business unit is independent of an employee's home business unit and security business unit.
szJobType	JBCD	char	OPT	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	OPT	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.
szJobCompetencySource	JCCS	char	REQ	INPUT
Obsolete data item, always enter a blank
cDraftFlag	DFLAG	char	REQ	INPUT
If the draft flag is 1, then the work file records are not date effective, and will be deleted, not end dated.
jdNewDateEndingEffective	EFTE	JDEDATE	REQ	INPUT
The new date the record should be ended.
jdDateBeginningEffective	EFTB	JDEDATE	REQ	INPUT
The beginning date of the original type 1 record written.

Related Functions

None

Related Tables

None

DeleteWorkFileTypeTwoRecord

Job Competency Work File Management

Minor Business Rule

Object Name: N0800200

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this function is to remove override flags from the type 2 records in F08006WF (Job
Competency Work File) which occur during the period of time where the overrides no longer apply.

Setup Notes and Prerequisites

Special Logic

Technical Specification

Assign the Default Override flag the value of 2.

Find the Type 2 records within the date range, or the only record if this is a draft.

For each record found, determine what the new * pattern will be by removing a * from the override
fields with a character passed into the function parameter.

Determine if the new * pattern is any different from the * pattern of the record that ends one day
prior to the currently selected one.  If it is different then update the currently selected record with
the new star pattern (or delete it if the new * pattern is blank).  If it is not, then delete the
record and expand the previous record in the file to include the time period of the currently selected
one.

Determine if the new * pattern is any different from the * pattern of the fetched record.  This is
only necessary when the end of the delete has been reached and the current record spans across the end
of the delete date.  If it is different, then end the fetched record and update its * pattern, then
write a new record beginning one day after with the * pattern of the original fetched record.

Once the period of time for deleting the overrides is finished, keep looking through the file to see
if the * pattern is any different (and to see if the record data ranges should be consolidated).

Data Structure

D0800200D - Delete Job Competency Work File Type Two Record

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnParentKeyIDInternal	PUKID	MATH_NUMERIC	REQ	INPUT
A unique number that the system uses to identify a record in a file.
mnUniqueKeyIDInternal	UKID	MATH_NUMERIC	REQ	INPUT
This field is a unique number used to identify a record in a file.
szOrganizationType	OTPS	char	REQ	INPUT
A user-defined code (00/TS) that identifies the type of organization structure, such as financial or responsibility. Each type of organization structure can have a separate hierarchy.
szJobCompetencyCode	JCC	char	REQ	INPUT
A code that uniquely identifies each job competency. Competencies are high-level human attributes that help an employee achieve the goals and objectives of the company. These competencies are also the foundation of an employee's job and job description.
szJobGroup	JGRP	char	OPT	INPUT
A grouping of similar jobs that are linked together to form a unit. The jobs might be similar in functions within the organization, job duties, tasks, responsibilities, job evaluation methods, or pay philosophies. Typical job units are clerical or administrative; technical, engineering, scientific, and professional; factory jobs; management; and executive. Consider dividing groups into separate populations based on the differences between exempt and non-exempt employees, according to the rules and regulations of the Fair Labor Standards Act. For example, consider assigning all your managers to the Managers job group. A job category defines a specific job, and all related job categories are classified by a job group. You can define job group codes using user defined code table 08/JG.
szOrganizationalBusinessUnit	ORMCU	char	OPT	INPUT
A business unit that is included in the organizational structure for job competencies. You use organizational business units to assign job competency information to levels within your organizational structure. This business unit is independent of an employee's home business unit and security business unit.
szJobType	JBCD	char	OPT	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	OPT	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.
cOptionOverridesExistFlag	OVEX1	char	OPT	INPUT
Enter a character in this parameter if the options are being ended for the date range entered.
cIncludeOverridesExistFlag	OVEX2	char	OPT	INPUT
Enter a character in this parameter if the include in gap analysis/performance appraisal flag is being ended for the date range entered.
cDescription1OverridesExist	OVEX3	char	OPT	INPUT
Enter a character in this parameter if the user defined competency description 1 is being ended for the date range entered.
cDescription2OverridesExist	OVEX4	char	OPT	INPUT
Enter a character in this parameter if the user defined competency description 2 is being ended for the date range entered.
cDescription3OverridesExist	OVEX5	char	OPT	INPUT
Enter a character in this parameter if the user defined competency description 3 is being ended for the date range entered.
cDescription4OverridesExis	OVEX6	char	OPT	INPUT
Enter a character in this parameter if the user defined competency description 4 is being ended for the date range entered.
cDescription5OverridesExis	OVEX7	char	OPT	INPUT
Enter a character in this parameter if the user defined competency description 5 is being ended for the date range entered.
cDescription6OverridesExis	OVEX8	char	OPT	INPUT
Enter a character in this parameter if the user defined competency description 6 is being ended for the date range entered.
szJobCompetencySource	JCCS	char	REQ	INPUT
Obsolete parameter, enter a blank.
jdNewDateEndingEffective	EFTE	JDEDATE	REQ	INPUT
This is the date that the overrides are being ended on.
cDraftFlag	DFLAG	char	REQ	INPUT
A code that indicates whether an organizational structure is in draft mode and has not yet been activated. Valid values are: 1 Yes 0 No
jdDeleteThruDate	EFTE	JDEDATE	OPT	INPUT
This is the end of the period where the overrides are being deleted. For example, on 6/1/99 the user is ending option overrides that begin on 1/1/99 and the override records all had an original end date of 12/31/99. In this case the overrides are being deleted as of 6/1/99 (jdNewDateEndingEffective) and the delete thru date is 12/31/99 (jdDeleteThruDate). This way, if there are any other option overrides beyond the ones currently being deleted the work file record will still reflect them.

Related Functions

None

Related Tables

None