nerdexam
Oracle

1Z0-548 · Question #3

To define a checklist for a new hire, identify the Table Name that needs to be Included in the live event reason associated with the checklist.

The correct answer is C. PER_PERSON_TYPE_USAGES_F. The PER_PERSON_TYPE_USAGES_F Table should be used, which keeps track on an employee's person type, associated to the latter at creation of employee record Note: There are two tables (per_all_people_f,per_person_type_usages_f) where you can find the person_types for an employee. D

Employee Management

Question

To define a checklist for a new hire, identify the Table Name that needs to be Included in the live event reason associated with the checklist.

Options

  • APER_ALL_PEOPLE_F
  • BPER_ALL_ASSIGNMENTS_F
  • CPER_PERSON_TYPE_USAGES_F
  • DPER_PERIODS_OF_SERVICE
  • EPER PAY PROPOSALS

How the community answered

(37 responses)
  • B
    3% (1)
  • C
    89% (33)
  • D
    5% (2)
  • E
    3% (1)

Explanation

The PER_PERSON_TYPE_USAGES_F Table should be used, which keeps track on an employee's person type, associated to the latter at creation of employee record Note: There are two tables (per_all_people_f,per_person_type_usages_f) where you can find the person_types for an employee. Developers usually gets misguided to which person_type_id we need to consider.The answer is we should always need to use the table per_person_type_usages_f to retrieve the correct person_id. Though the person_type_id in the two tables appear to be same but they are different and that can perty much mislead us.

Topics

#new hire checklist#live event reason#PER_PERSON_TYPE_USAGES_F#table name

Community Discussion

No community discussion yet for this question.

Full 1Z0-548 Practice