F05120DeleteHistory

Competency - History Trigger Functions

Minor Business Rule

Object Name: N0500141

Parent DLL: CFND

Location: Client/Server

Language: NER

Data Structure

D0500141 - Competency - History

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szResourceType	RRTY	char	OPT	INPUT
A code that identifies the type of resource for which you are entering competency information. This is a user defined code (05/RT). Valid values are: 01 Individual 02 Asset, such as equipment
mnAddressNumber	AN8	MATH_NUMERIC	OPT	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
szCompentencyType	CMPE	char	OPT	INPUT
A code that identifies a competency table or category for which you can track employee competencies. Valid values are: 01 Training 02 Skill 03 Accomplishment 04 Certification 05 Degree 06 Language It is a user defined code (05/CY), but the values are hard-coded and cannot be changed. Therefore, each of the competencies that you track must pertain to one of these competency types. Adding additional values to this list requires system customizations.
szCompentencyCode	CMPC	char	OPT	INPUT
A code that specifies a competency within a competency type. For example, a competency for the competency type "Skill" might be "C programming" or "Driving a forklift."
jdChangeDate	CHDE	JDEDATE	OPT	INPUT
The date on which the employee changed the goal.
mnTimeOfTheDay	TMDY	MATH_NUMERIC	OPT	INPUT
The computer clock in hours:minutes:seconds.
mnCompetencyLevel	CMPV	MATH_NUMERIC	OPT	INPUT
A code that refers to the level of proficiency that a person or asset has demonstrated for a specific competency type and competency code.
jdExpirationDate	CMPX	JDEDATE	OPT	INPUT
The date on which the certification expires.

Related Functions

Related Tables

F05120InsertHistory

F05120InsertHistory

Competency - History Trigger Functions

Minor Business Rule

Object Name: N0500141

Parent DLL: CFND

Location: Client/Server

Language: NER

Data Structure

D0500141 - Competency - History

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szResourceType	RRTY	char	OPT	INPUT
A code that identifies the type of resource for which you are entering competency information. This is a user defined code (05/RT). Valid values are: 01 Individual 02 Asset, such as equipment
mnAddressNumber	AN8	MATH_NUMERIC	OPT	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
szCompentencyType	CMPE	char	OPT	INPUT
A code that identifies a competency table or category for which you can track employee competencies. Valid values are: 01 Training 02 Skill 03 Accomplishment 04 Certification 05 Degree 06 Language It is a user defined code (05/CY), but the values are hard-coded and cannot be changed. Therefore, each of the competencies that you track must pertain to one of these competency types. Adding additional values to this list requires system customizations.
szCompentencyCode	CMPC	char	OPT	INPUT
A code that specifies a competency within a competency type. For example, a competency for the competency type "Skill" might be "C programming" or "Driving a forklift."
jdChangeDate	CHDE	JDEDATE	OPT	INPUT
The date on which the employee changed the goal.
mnTimeOfTheDay	TMDY	MATH_NUMERIC	OPT	INPUT
The computer clock in hours:minutes:seconds.
mnCompetencyLevel	CMPV	MATH_NUMERIC	OPT	INPUT
A code that refers to the level of proficiency that a person or asset has demonstrated for a specific competency type and competency code.
jdExpirationDate	CMPX	JDEDATE	OPT	INPUT
The date on which the certification expires.

Related Functions

Related Tables