JobCompetencyTransProcessor

Job Competency Transaction Processing

Minor Business Rule

Object Name: N0800170

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description
Job Competency Transaction Processing

Purpose

1)To allow the flexibility of copying one Job Competency(FROM) to another Job Competency(TO). This
includes all supporting information in related tables.

2)To allow the deletion of Job Competencies if there are no records in supporting tables.

Setup Notes and Prerequisites

Next numbers setup for System Code 08 and Next Numbering Index number 4.

Special Logic

Technical Specification
Copy Parmeters:
Action Code (A = Add)
From Job Competency (a Valid JCC)
To Job Competency (a JCC that does not exist)
Copy Job Competency Descriptions (any value, not blank or null)
Copy Job Competency Descriptions All Translations (any value, not blank or null)
User Defined Competency Code 1-6 (any value, not blank or null)

When Action code is equal to 'A'
Select the From  row  in the Job Competency Master F0800602 table
and insert the column values in the To Job Competency Master row in the F0800602 table.

Select the From  row  in the Job Competency Options - Overrides F0800606 table
and insert the column values in the To Job Competency Options - Overrides row in the F0800606
table.

When the Copy Job Competency Description is not equal to blank or null and the Copy Job
Competency Descriptions all Translations is not equal to blank or null, determine which User Defined
Competency(1-6)or all have been selected for copying.
Select the From  row  in the User Defined Job Competency Description Reference F0800612 table
and insert the column values in the To User Defined Job Competency Description Reference
F0800612 table.

-or-

When the Copy Job Competency Description is not equal to blank or null and the Copy Job
Competency Descriptions all Translations is equal to blank or null, determine which User Defined
Competency(1-6)or all have been selected for copying and only copy the default domestic language.
Select the From  row  in the User Defined Job Competency Description Reference F0800612 table
and insert the column values in the To User Defined Job Competency Description Reference
F0800612 table.

Delete Parameters:
Action Code (D = Delete)
From Job Competency (a Valid JCC)

When Action Code is equal to 'D' and there are rows present in the F0800603, or F0800604, or
F0800605, or F0800607, or F0800609, or F0800610, or the F0800612 table for the From Job Competency
issue an error '4847' preventing the delete.

-else-

When Action code is equal to 'D' and there are no error select the From row in the Job
Competency Master F0800602 table and delete the row in the Job Competency Master F0800602 table.
Select the From row in the Job Competency Default - Overrides F0800611 table and delete the row in the
Job Competency Default - Overrides F0800611 table. Select the From row  in the Job Competency Rules
F0800606 table and delete the row in the Job Competency Rules F0800606 table.

Data Structure

D0800170 - Job Competency Transaction Processing

Parameter Name Data Item Data Type Req/Opt I/O/Both

cActionCode ACTN char REQ INPUT

A code that specifies the action that is performed. Valid values are: A Add C Change

szFromOrganizationType OTPS char OPT BOTH

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.

szFromJobCompetencyCode JCC char OPT BOTH

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.

jdDateBeginningEffective EFTB JDEDATE OPT BOTH

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

jdDateEndingEffective EFTE JDEDATE OPT BOTH

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.

szToJobCompetencyCode JCC char OPT BOTH

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.

szToOrganizationType OTPS char OPT BOTH

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.

cCpyJobCompetencyDesc EV01 char OPT BOTH

An option that specifies the type of processing for an event.

szUserDefinedCompetencyDes_1 USDD char OPT NONE

User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job
competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a
description for Employees, a description for Managers, and a description for HR professionals.

szUserDefinedCompetencyDes_2 USDD char OPT NONE

User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job
competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a
description for Employees, a description for Managers, and a description for HR professionals.

szUserDefinedCompetencyDes_3 USDD char OPT NONE

User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job
competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a
description for Employees, a description for Managers, and a description for HR professionals.

szUserDefinedCompetencyDes_4 USDD char OPT NONE

User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job
competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a
description for Employees, a description for Managers, and a description for HR professionals.

szUserDefinedCompetencyDes_5 USDD char OPT NONE

User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job
competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a
description for Employees, a description for Managers, and a description for HR professionals.

szUserDefinedCompetencyDes_6 USDD char OPT NONE

User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job
competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a
description for Employees, a description for Managers, and a description for HR professionals.

szProgramId PID char OPT NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

cCpyJobCompDescAllTranslations EV01 char OPT NONE

An option that specifies the type of processing for an event.

szErrorMsgID VC04A char OPT NONE

This is a generic field used as a work field in Everest.

szToJobCompetencyDescription DL01 char OPT NONE

A user defined name or remark.

mnFromUniqueIDInternal UKID MATH_NUMERIC OPT NONE

This field is a unique number used to identify a record in a file.

cCpyJobCompCode_EV01 EV01 char OPT BOTH

An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cActionCode	ACTN	char	REQ	INPUT
A code that specifies the action that is performed. Valid values are: A Add C Change
szFromOrganizationType	OTPS	char	OPT	BOTH
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.
szFromJobCompetencyCode	JCC	char	OPT	BOTH
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.
jdDateBeginningEffective	EFTB	JDEDATE	OPT	BOTH
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdDateEndingEffective	EFTE	JDEDATE	OPT	BOTH
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.
szToJobCompetencyCode	JCC	char	OPT	BOTH
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.
szToOrganizationType	OTPS	char	OPT	BOTH
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.
cCpyJobCompetencyDesc	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
szUserDefinedCompetencyDes_1	USDD	char	OPT	NONE
User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a description for Employees, a description for Managers, and a description for HR professionals.
szUserDefinedCompetencyDes_2	USDD	char	OPT	NONE
User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a description for Employees, a description for Managers, and a description for HR professionals.
szUserDefinedCompetencyDes_3	USDD	char	OPT	NONE
User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a description for Employees, a description for Managers, and a description for HR professionals.
szUserDefinedCompetencyDes_4	USDD	char	OPT	NONE
User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a description for Employees, a description for Managers, and a description for HR professionals.
szUserDefinedCompetencyDes_5	USDD	char	OPT	NONE
User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a description for Employees, a description for Managers, and a description for HR professionals.
szUserDefinedCompetencyDes_6	USDD	char	OPT	NONE
User Defined Competency Descriptions are attached to a job competency to assist the end user in understanding and/or working with job competencies. There can be a number of different job competency descriptions for a single job competency. For example, there could be a description for Employees, a description for Managers, and a description for HR professionals.
szProgramId	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
cCpyJobCompDescAllTranslations	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szErrorMsgID	VC04A	char	OPT	NONE
This is a generic field used as a work field in Everest.
szToJobCompetencyDescription	DL01	char	OPT	NONE
A user defined name or remark.
mnFromUniqueIDInternal	UKID	MATH_NUMERIC	OPT	NONE
This field is a unique number used to identify a record in a file.
cCpyJobCompCode_EV01	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.