This page (revision-5) was last changed on 26-Nov-2021 10:22 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by khiggs

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
5 26-Nov-2021 10:22 1 KB Kevin Higgs to previous
4 26-Nov-2021 10:22 1 KB khiggs to previous | to last
3 26-Nov-2021 10:22 1 KB khiggs to previous | to last
2 26-Nov-2021 10:22 1 KB khiggs to previous | to last
1 26-Nov-2021 10:22 1 KB khiggs to last

Page References

Incoming links Outgoing links
P 2 K_PU.GET_EAS
P2K_PU.GET_EAS

Version management

Difference between version and

At line 1 changed one line
!!Get Employee P2K_PU.GET_EAS
!!Get Employee EEM_ASOF
At line 3 changed one line
!Functionality: Determine the [EAS_ID] from the [P2K_HR_ASSIGNMENTS] table using the [EEM_ID], an [ASSIGNMENT_CODE]
!Functionality: The purpose of this function is capture the corresponding [EEM_ID] from [P2K_HR_EMPLOYMENTS] using a [PERSON_CODE], [EMPLOYMENT_TYPE] and as of date.
At line 7 changed 2 lines
|EEM_ID | ''Required''. The [EEM_ID] for the employment.
|ASSIGNMENT_CODE | ''Optional''. The [ASSIGNMENT_CODE] as defined on the [P2K_HR_ASSIGNMENTS] table for the matching [EEM_ID]. If not provided then the value '00' is used.
|PERSON_CODE | ''Required''. The [PERSON_CODE] for the employee.
|EMPLOYEE_TYPE | ''Optional''. The [EMPLOYMENT_TYPE] as defined on the [IMLN] lexicon [X_EMPLOYMENT_TYPE]. If not provided then the value '00' is used.
|AS_OF | ''Optional''. The employment that has this date that fall between the [HIRE_DATE] and the [TERMINATION_DATE] will be returned. If not provided then the current date is used as the as of date. If the employment has overlapping dates, the record with the greatest hire date based on the as of date will be returned. If the employment has a null value for a [TERMINATION_DATE] than the end of time will be used as a date.
At line 14 changed 3 lines
* If no [EAS_ID] can be found a null value will be returned
* If TOo_MANY_ROWS than -1 will be returned
* All other errors will result in a 0
* If no data is found (the employee cannot be found using either code), zero a null value is returned
* If any error occurs during data retrieval, 0 is returned
* If the employment has overlapping dates (To many employments), the record with the greatest hire date based on the as of date will be returned.
At line 20 changed one line
{{P2K_PU.GET_EAS(~)}}
{{P2K_PU.GET_EEM_ASOF(~)}}
At line 22 changed one line
will get the [EAS_ID] value for the passed [EEM_ID] and [ASSIGNMENT_CODE] '00'.
will get the EEM_ID value for the passed person code, for the employment record with the most future hire date prior to today (current date) with an employment type of '01-Employee'
At line 24 changed one line
{{P2K_PU.GET_EAS(~),'PRIMARY')}}
{{P2K_PU.GET_EEM_ASOF(~,'03')}}
At line 26 changed one line
will get the EEM_ID value for the passed [EEM_ID] and [ASSIGNMENT_CODE] 'PRIMARY'.
will get the EEM_ID value for the passed person code if the employment type is '02-Retiree'.
At line 28 changed one line
{{P2K_PU.GET_EAS(P2K_PU.GET_EEM_ASOF(~,'01','01-Jan-2017'),'02')}}
{{P2K_PU.GET_EEM_ASOF(~,'01','01-Jan-2017')}}
will get the EEM_ID value for the passed person code, for the employment record with a [HIRE_DATE] less than and [TERMINATION_DATE] greater than '01-Jan-2017' with an employment type of '01-Employee'
At line 30 changed one line
will determine the correct [EEM_ID] as of the provided date for an employees with the [EMPLOYMENT_TYPE] of '01-Employee'. It will then capture the [EAS_ID] from the passed [EEM_ID] and matching [ASSIGNMENT_CODE] of '02'
!Notes
At line 34 added 3 lines
----
![Notes|Edit:Internal.GET_EEM_ASOF]
This page (revision-5) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop