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 EEM_ASOF
!!Get Employee P2K_PU.GET_EAS
At line 3 changed one line
!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.
!Functionality: Determine the [EAS_ID] from the [P2K_HR_ASSIGNMENTS] table using the [EEM_ID], an [ASSIGNMENT_CODE]
At line 7 changed 3 lines
|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.
|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.
At line 15 changed 3 lines
* 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.
* 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
At line 21 changed one line
{{P2K_PU.GET_EEM_ASOF(~)}}
{{P2K_PU.GET_EAS(~)}}
At line 23 changed one line
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'
will get the [EAS_ID] value for the passed [EEM_ID] and [ASSIGNMENT_CODE] '00'.
At line 25 changed one line
{{P2K_PU.GET_EEM_ASOF(~,'03')}}
{{P2K_PU.GET_EAS(~),'PRIMARY')}}
At line 27 changed one line
will get the EEM_ID value for the passed person code if the employment type is '02-Retiree'.
will get the EEM_ID value for the passed [EEM_ID] and [ASSIGNMENT_CODE] 'PRIMARY'.
At line 29 changed 2 lines
{{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'
{{P2K_PU.GET_EAS(P2K_PU.GET_EEM_ASOF(~,'01','01-Jan-2017'),'02')}}
At line 32 changed one line
!Notes
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'
At line 34 removed 3 lines
----
![Notes|Edit:Internal.GET_EEM_ASOF]
This page (revision-5) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop