FND Design Data [Home] [Help]

View: PER_ALL_WORKFORCE_V

Product: PER - Human Resources
Description: View of employees, and contingent workers if profile option setup permits
Implementation/DBA Data: ViewAPPS.PER_ALL_WORKFORCE_V
View Text

SELECT PER.PERSON_ID
, PER.FULL_NAME
, PER.ORDER_NAME
, PER.EMPLOYEE_NUMBER WORKER_NUMBER
, PER.EMPLOYEE_NUMBER
, PER.APPLICANT_NUMBER
, PER.NPW_NUMBER
, PER.CURRENT_EMPLOYEE_FLAG
, PER.CURRENT_NPW_FLAG
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID
FROM PER_ALL_PEOPLE_F PER
WHERE PER.CURRENT_EMPLOYEE_FLAG = 'Y' UNION ALL SELECT PER.PERSON_ID
, PER.FULL_NAME
, PER.ORDER_NAME
, PER.NPW_NUMBER WORKER_NUMBER
, PER.EMPLOYEE_NUMBER
, PER.APPLICANT_NUMBER
, PER.NPW_NUMBER
, PER.CURRENT_EMPLOYEE_FLAG
, PER.CURRENT_NPW_FLAG
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID
FROM PER_ALL_PEOPLE_F PER
WHERE NVL(FND_PROFILE.VALUE('HR_TREAT_CWK_AS_EMP')
, 'N')='Y'
AND PER.CURRENT_NPW_FLAG = 'Y'

Columns

Name
PERSON_ID
FULL_NAME
ORDER_NAME
WORKER_NUMBER
EMPLOYEE_NUMBER
APPLICANT_NUMBER
NPW_NUMBER
CURRENT_EMPLOYEE_FLAG
CURRENT_NPW_FLAG
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID