View: HR_ATH_EMPLOYEE_V

Product:	PER - Human Resources
Description:	View to support Authoria Integration
Implementation/DBA Data:	APPS.HR_ATH_EMPLOYEE_V

View Text

SELECT TO_CHAR(PAF.PERSON_ID) EMPLOYEE_ID
, HR_AUTH_INT.GET_PASSWORD(PAF.PERSON_ID) PIN
, TO_CHAR(PAF.BUSINESS_GROUP_ID) EMPLOYER_ID
, TO_CHAR(PAF.ORGANIZATION_ID) EMPLOYEE_GROUPID
, MAX(PPS.DATE_START) START_DATE
, NVL(PPS.ACTUAL_TERMINATION_DATE
, TO_DATE('12/31/4712'
, 'MM/DD/YYYY')) END_DATE
, PPF.FULL_NAME NAME
, TO_CHAR(PPF.DATE_OF_BIRTH
, 'MM/DD/YYYY') BIRTH_DATE
, PAA.ADDRESS_LINE1 ADDRESS
, PAA.REGION_1 CITY
, PAA.REGION_2 STATE
, PAA.POSTAL_CODE ZIP
, JOB.NAME JOB_TITLE
, GRADE.NAME JOB_GRADE
FROM PER_PERIODS_OF_SERVICE PPS
, PER_ALL_ASSIGNMENTS_F PAF
, PER_ADDRESSES PAA
, PER_ALL_PEOPLE_F PPF
, PER_JOBS JOB
, PER_GRADES GRADE
WHERE PPS.PERIOD_OF_SERVICE_ID = PAF.PERIOD_OF_SERVICE_ID
AND PPS.PERSON_ID = PAF.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PAF.ASSIGNMENT_TYPE = 'E'
AND PAF.PERSON_ID = PAA.PERSON_ID
AND PAA.PRIMARY_FLAG = 'Y'
AND PAF.PERSON_ID = PPF.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PAF.JOB_ID = JOB.JOB_ID(+)
AND PAF.GRADE_ID = GRADE.GRADE_ID(+) GROUP BY PAF.PERSON_ID
, PAF.BUSINESS_GROUP_ID
, PAF.ORGANIZATION_ID
, PPS.ACTUAL_TERMINATION_DATE
, PPF.FULL_NAME
, PPF.DATE_OF_BIRTH
, PAA.ADDRESS_LINE1
, PAA.REGION_1
, PAA.REGION_2
, PAA.POSTAL_CODE
, JOB.NAME
, GRADE.NAME

Columns