View: HRIFV_US_PERDTL

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRIFV_US_PERDTL

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ /* UNIQUE ATTRIBUTES */ BGR.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PEO.EFFECTIVE_END_DATE EFFECTIVE_END_DATE /* REGULAR ATTRIBUTES */
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PEO.NATIONAL_IDENTIFIER SOCIAL_SECURITY_NUMBER
, DECODE(PEO.PER_INFORMATION1
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('US_ETHNIC_GROUP'
, PEO.PER_INFORMATION1)) ETHNIC_ORIGIN
, DECODE(PEO.PER_INFORMATION2
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION2)) I9
, FND_DATE.CANONICAL_TO_DATE(PEO.PER_INFORMATION3) I9_EXPIRY_DATE
, DECODE(PEO.PER_INFORMATION4
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('US_VISA_TYPE'
, PEO.PER_INFORMATION4)) VISA_TYPE
, DECODE(PEO.PER_INFORMATION5
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('US_VETERAN_STATUS'
, PEO.PER_INFORMATION5)) VIETNAM_VETS_STATUS
, DECODE(PEO.PER_INFORMATION6
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION6)) STUDENT
, DECODE(PEO.PER_INFORMATION7
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('US_NEW_HIRE_STATUS'
, PEO.PER_INFORMATION7)) NEW_HIRE_STATUS
, PEO.PER_INFORMATION8 EXCLUSION_REASON
, DECODE(PEO.PER_INFORMATION9
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION9)) CHILD_SUPPORT_OBLIGATION
, DECODE(PEO.REGISTERED_DISABLED_FLAG
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PEO.REGISTERED_DISABLED_FLAG )) REGISTERED_DISABLED /* DESCRIPTIVE FLEXFIELD */
, '_DF:PER:PER_PEOPLE:PEO' /* IDS */
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
FROM PER_BUSINESS_GROUPS BGR
, PER_PEOPLE_F PEO
WHERE PEO.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND BGR.LEGISLATION_CODE = 'US'
AND PEO.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PEO.BUSINESS_GROUP_ID) WITH READ ONLY

Columns