PJC_XLA_EMPLOYEE_REF_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
PERSON_NAME PERSON_NUMBER PERSON_TYPE PERSON_ID PERSON_EFFECTIVE_START_DATE PERSON_EFFECTIVE_END_DATE ASSIGNMENT_ID ASSIGNMENT_NAME ASSIGNMENT_NUMBER PERSON_ACCOUNT_CCID PERSON_BU PERSON_LEGAL_ENTITY_NAME DEPARTMENT_NAME SYSTEM_PERSON_TYPE EMP_ASSIGNMENT_CATEGORY

Query

SQL_Statement

SELECT Personname.list_name person_name, person.person_number , personassignment.person_type_id PERSON_TYPE, person.person_id , person.effective_start_date person_effective_start_date , person.effective_end_date person_effective_end_date, personassignment.assignment_id, personassignment.assignment_name, personassignment.assignment_number, Personassignment.DEFAULT_CODE_COMB_ID person_account_ccid, personassignment.Business_Unit_id PERSON_BU, personassignment.legal_entity_id PERSON_LEGAL_ENTITY_NAME, Personassignment.organization_id DEPARTMENT_NAME, personassignment.system_person_type SYSTEM_PERSON_TYPE, personassignment.EMPLOYMENT_CATEGORY EMP_ASSIGNMENT_CATEGORY FROM per_all_people_f person , per_all_assignments_f personassignment, PER_PERSON_NAMES_F personname WHERE personassignment.person_id = person.person_id AND personassignment.EFFECTIVE_LATEST_CHANGE = 'Y' AND TRUNC(SYSDATE) BETWEEN TRUNC(personassignment.effective_start_date) AND TRUNC(personassignment.effective_end_date) AND personname.person_id=person.person_id AND TRUNC(SYSDATE) BETWEEN TRUNC(personname.effective_start_date) AND TRUNC(personname.effective_end_date) AND TRUNC(SYSDATE) BETWEEN TRUNC(person.effective_start_date) AND TRUNC(person.effective_end_date) AND personname.name_type = 'GLOBAL' and personassignment.person_type_id is not null