View: HRI_CL_PER_V

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.HRI_CL_PER_V

View Text

SELECT PER.PERSON_ID ID
, SUBSTRB(PER.FIRST_NAME
, 1
, 1) ||'. '|| LAST_NAME VALUE
, PER.EFFECTIVE_START_DATE START_DATE
, PER.EFFECTIVE_END_DATE END_DATE
, PER.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NVL(PER.CURRENT_APPLICANT_FLAG
, 'N') APL_FLAG_CODE
, NVL(PER.CURRENT_EMPLOYEE_FLAG
, 'N') EMP_FLAG_CODE
, NVL(PER.CURRENT_NPW_FLAG
, 'N') CWK_FLAG_CODE
, NVL(PER.CURRENT_EMP_OR_APL_FLAG
, 'N') EMP_OR_APL_FLAG_CODE
, DECODE(PER.CURRENT_EMPLOYEE_FLAG
, 'N'
, NVL(PER.CURRENT_NPW_FLAG
, 'N')
, NVL(PER.CURRENT_EMPLOYEE_FLAG
, 'N')) WORKER_FLAG_CODE
, PER.FULL_NAME FULL_NAME
, PER.LAST_NAME LAST_NAME
, PER.FIRST_NAME FIRST_NAME
, PER.MIDDLE_NAMES MIDDLE_NAMES
, PER.TITLE TITLE
, PER.PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, PER.SUFFIX SUFFIX
, PER.HONORS HONORS
, PER.KNOWN_AS KNOWN_AS
, PER.APPLICANT_NUMBER APPLICANT_NUMBER
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PER.NPW_NUMBER NPW_NUMBER
, PER.NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
FROM PER_ALL_PEOPLE_F PER WITH READ ONLY

Columns