Set Job Data Dates Based on Status - Function


At times we got a different requirement to customize dates or job data based status

I am describing Record and Field Formula that used by PeopleSoft to set JOB Status fields and Dates based on EMPL_STATUS or HR_STATUS




FUNCLIB_HR_JOB.SET_STATUS_FLG.FieldFormula
Record : FUNCLIB_HR_JOB
Field : SET_STATUS_FLG
Event : FieldFormula
Function : SetStatusAndDates

·         ORIG_HIRE_DT (on PER_ORG_INST)
·         HIRE_DT
·         LAST_HIRE_DT
·         TERMINATION_DT
·         ASGN_START_DT
·         LST_ASGN_ST_DT
·         ASGN_END_DT
·         LAST_DATE_WORKED
·         EXPECTED_END_DATE
·         EXPECTED_RETURN_DT