CacheJobAndCompetencyTreeStructu

Cache Job And Competency Tree Structure

Minor Business Rule

Object Name: B0800151

Parent DLL: CHRM

Location: Client/Server

Language: C

Functional Description

Purpose
This function provides the caching manipulation for the Job and Competency Tree Structures.  The
cache holds information specific to the tree on the form.  When the tree is changed, those changes are
stored in cache.  When the user presses Submit, the changes stored in cache are committed to the
database.
Setup Notes and Prerequisites
Records can be Read, Added, Deleted, or Updated to the cache, depending on Cache Action Code, CACTN,
passed in. The following is a list of the modes used to select cache processing options:
Input
Processing TypeType
============
Cache Get 1
Cache Add 2
Cache Update 3
Cache Delete 4
Cache Delete All 5
Cache Get Next 6
Cache Add/Update 7 (Do Not Use)
Cache End  8
Cache Close Cursor 9

Return errors through Error Message ID, DTAI.

The cache Key is as follows:

There are 4 indexes for this cache.  Enter an index number corresponding index as follows:

1 (unique):
Job Number (JOBS)
Node Value (MATH01)

2 (not unique):
Job Number (JOBS)
Parent Business Unit (MCU1)
Node Type (EV01)
Organizational Business Unit (ORMCU)
Job Type (JBCD)

3 (not unique):
Job Number (JOBS)
Add or Delete Flag (EV01)

4 (not unique):
Job Number (JOBS)
Organizational Business Unit (ORMCU)
Node Type (EV01)

Special Logic

Technical Specification

Based on the action code passed, this function will perform an action on the Job and Competency Tree
Structure cache.  The function can be used in Event Rules the same way as Table I/O to manipulate
cache records.

Data Structure

D0800151 - Cache Job And Competency Tree Structure

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobnumberA	JOBS	MATH_NUMERIC	REQ	INPUT
The job number (work station ID) which executed the particular job.
mnNodeValue	MATH01	MATH_NUMERIC	OPT	NONE
Special Input Expected Any number that uniquely identifies the tree node from others in the same tree. ^
cNodeType	EV01	char	OPT	NONE
^
szNodeDescription	D200	char	OPT	NONE
^
szParentBusinessUnit	MCU1	char	OPT	NONE
The primary level in a business unit hierarchy. A parent in one hierarchy can be a child in a different hierarchy.
szOrganizationalBusinessUnit	ORMCU	char	OPT	NONE
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.
szJobCompetencyCode	JCC	char	OPT	NONE
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.
szJobType	JBCD	char	OPT	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 apply that information to the employees who are linked to that job type.
szJobStep	JBST	char	OPT	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 type to determine pay rates by job in the Pay Rates table.
cAddOrDeleteFlag	EV01	char	OPT	NONE
^
cNodeOpenOrClosedFlag	EV01	char	OPT	NONE
^
mnSequenceNumber	SEQ	MATH_NUMERIC	OPT	NONE
^
szErrorMessageID	DTAI	char	OPT	OUTPUT
Special Output Returned An error message ID is returned if the function was not able to complete the request. Blank is returned if the function completed without errors. ^
idCacheCursor	GENLNG	ID	REQ	BOTH
^
szCacheActionCode	CACTN	char	REQ	INPUT
Significant Data Values 1 = Get 2 = Add 3 = Update 4 = Delete 5 = Delete All 6 = Get Next. When finished performing this function, call the cache function again to CLOSE the CURSOR. This is very important because memory leaks will occur if the cursor is not closed. 7 = DO NOT USE 8 = End. This will end all instances of the cache. 9 = Close cursor
mnNumberKeys	NKEYS	MATH_NUMERIC	REQ	INPUT
^
cSuppressErrorMessage	SUPPS	char	OPT	NONE
Significant Data Values 1 = Suppress errors ^
mnIndexID	NKEYS	MATH_NUMERIC	REQ	INPUT
Significant Data Values 1 (unique): Job Number (JOBS) Node Value (MATH01) 2 (not unique): Job Number (JOBS) Parent Business Unit (MCU1) Node Type (EV01) Organizational Business Unit (ORMCU) Job Type (JBCD) 3 (not unique): Job Number (JOBS) Add or Delete Flag (EV01) 4 (not unique): Job Number (JOBS) Organizational Business Unit (ORMCU) Node Type (EV01)
jdF0800601DateBeginEffective	EFTB	JDEDATE	OPT	NONE
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.
jdF0800601DateEndEffective	EFTE	JDEDATE	OPT	NONE
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.
mnUniqueID	UKID	MATH_NUMERIC	OPT	NONE
This field is a unique number used to identify a record in a file.
mnParentUniqueID	PUKID	MATH_NUMERIC	OPT	NONE
A unique number that the system uses to identify a record in a file.

Related Functions

None

Related Tables

None