Functional Description
Purpose
This function adds a record to the F0800603 (Job Group Competencies), which contains information
about Job Competencies attached to and overridden at the Job Group level.
Setup Notes and Prerequisites
The calling program must check first for any records that started before the one being added, this
program only checks for records that begin after the one being added.
Special Logic
Technical Specification
If a Parent Unique ID is passed into the parameter, then the function will add an override record
with a different Unique ID and Parent Unique ID. If the Parent Unique ID is 0, then the function will
add an attached F0800603 record with the same Unique ID and Parent Unique ID.
Determine the Start and End Dates to write to the file. If the Draft Flag is not 1, then the start
date is the jdDateEffectiveRates passed in and the end date is 12/31/2899 (the largest date allowed by
all supported databases). If the draft flag is 1, then the start and stop dates are null.
Get the UKID if there are any existing records in the F0800603 in the future.
The record found is within the date range of the new record.
1. Extend the date period of the exiting record
2. Return the existing UKID and PUKID to the calling program.
If the UKID was not already found, get a next number, and insert the record. Return the UKID and
PUKID to the calling program.
Return the dates of the record entered.
D0800182K - Add F0800603 Records
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
jdDateEffectiveRates | EFT | JDEDATE | REQ | INPUT |
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
| ||||
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
| ||||
szJobGroup | JGRP | char | REQ | 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,
| ||||
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
| ||||
szProgramId | PID | char | OPT | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdStructureDateBeginEffective | 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.
| ||||
jdStructureDateEndingEffective | 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
| ||||
mnCurrentLevelUniqueID | UKID | MATH_NUMERIC | REQ | OUTPUT |
This field is a unique number used to identify a record in a file. | ||||
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 | ||||
szUserId | USER | char | OPT | INPUT |
The code that identifies a user profile. | ||||
szWorkStationId | JOBN | char | OPT | INPUT |
The code that identifies the work station ID that executed a particular job. | ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | INPUT |
The date that specifies the last update to the file record. | ||||
mnTimeLastUpdated | UPMT | MATH_NUMERIC | OPT | INPUT |
The time that specifies when the program executed the last update to this record. | ||||
mnParentKeyIDInternal | PUKID | MATH_NUMERIC | OPT | BOTH |
A unique number that the system uses to identify a record in a file. | ||||
jdDateBeginningEffective | EFTB | JDEDATE | OPT | OUTPUT |
This returns the Beginning effective date written to the F0800603.
| ||||
jdDateEndingEffective | EFTE | JDEDATE | OPT | OUTPUT |
This returns the Ending effective date written to the F0800603.
|
None |
None |