Oracle Applications

Oracle for Beginners

Oracle Apps – R12 – Core HR Lookups

Posted by shameemakhtar on June 17, 2009

There are a list of Lookups that are available in core HR and that you can extend for your own purpose.

See below the list of lookups and their purpose:

TITLE Represents TITLE in People Screen.
SEX Represents Gender in People Screen.
PERSON_TYPE Represents Person Types in People Screen.
ORG_TYPE Represents the Organization Type.
MAR_STATUS Represents Marital Status in People Screen.
NATIONALITY Represents Nationality in People Screen.
REGISTERED_DISABLED Represents Registered Disabled in People Screen.
ADDRESS_TYPE Represents Address Type in People Screen.
ABSENCE_CATEGORY Represents Absence Category in Absence Screen.
ABSENCE_REASON Represents Absence Reason in Absence Screen.
APL_ASSIGN_REASON Represents Assignment Change Reason in Application Screen.
APL_INTERVIEW_TYPE Represents Interview Type in Interview Screen.
EMP_EVENT_TYPE Represents Type in Bookings Screen.
PER_CM_MTHD Represents Delivery Methods in Communication Delivery Methods Screen.
PROFICIENCY_SOURCE Represents Source of Proficiency Rating in Competence Profile Screen.
CERTIFICATION_METHOD Represents Source of Certification Method in Competence Profile Screen.
CONTACT Represents Relationship Type in Contact Screen.
CONTRACT_TYPE Represents Contract Type in Contract Screen.
CONTRACT_STATUS Represents Contract Status in Contract Screen.
CONTRACT_STATUS_REASON Represents Contract Status Reason in Contract Screen.
DOCUMENT_STATUS Represents Document Status in Contract Screen.
CONTRACT_START_REASON Represents Contract Start Reason in Contract Screen.
CONTRACT_END_REASON Represents Contract End Reason in Contract Screen.
DISABILITY_CATEGORY Represents Disability Category in Disability Screen.
DISABILITY_REASON Represents Disability Reason in Disability Screen.
TERM_APL_REASON Represents Reason for Ending an Application in End Application Screen.
LEAV_REAS Represents Leaving Reason in End Employment Screen.
CONSULTATION_TYPE Represents Consultation Type in Medical Assessment Screen.
CONSULTATION_RESULT Represents Consultation Result in Medical Assessment Screen.
PHONE_TYPE Represents Phone Type in Phones Screen.
PER_SUBJECT_STATUSES Represents Status of Qualification in Qualifications Screen.
PER_SUBJECT Represents Subject in Qualification Screen.
PER_WORK_HOURS Represents Work Hours in Work Preferences Screen.
PER_WORK_SCHEDULE Represents Work Schedule in Work Preferences Screen.
PER_FTE_CAPACITY Represents FTE Capacity in Work Preferences Screen.
VACANCY_CATEGORY Represents Vacancy Category in Requisition and Vacancy Screen.
VACANCY_STATUS Represents Vacancy Status in Requisition and Vacancy Screen.
REC_TYPE Represents Source Type for Recruitment Activity in Requisition and Vacancy Screen.
FREQUENCY Represents Frequency for Review Salary, Review Performance, and Working Hours in Assignment Screen.
QUALIFYING UNITS Represents Units for Probation Period and Notice Period in Assignment Screen.
PQP_EMPLOYER_TYPE Represents Employer Type in Employment History Screen.
PQP_EMPLOYER_SUBTYPE Represents Employer Sub Type in Employment History Screen.
DOCUMENT_CATEGORY Represents Document Category in Documents of Record Screen.

12 Responses to “Oracle Apps – R12 – Core HR Lookups”

  1. Ambien said

    Your own report features established useful to us.

    It’s really educational and you’re simply certainly extremely educated in this region. You possess popped our eye to be able to numerous thoughts about this particular topic with intriguing, notable and strong written content.

  2. If you’ve done office parties or corporate work, make sure to mention that as well.
    But you can’t just stand there grinning like an idiot until they finish laughing.
    Brad Garret is a stand-up comedian but also well known for his acting

  3. Hmm is anyone else experiencing problems with the images on this
    blog loading? I’m trying to determine if its a problem on my end or if it’s the blog.
    Any suggestions would be greatly appreciated.

  4. Indiana said

    I was curious if you ever considered changing
    the layout of your blog? Its very well written; I love what youve got to say.
    But maybe you could a little more in the way of content so people could connect with it better.
    Youve got an awful lot of text for only having 1 or two images.
    Maybe you could space it out better?

  5. I’m amazed, I have to admit. Rarely do I come across a blog that’s both educative and engaging,
    and without a doubt, you have hit the nail on the head.
    The problem is an issue that too few people are speaking intelligently about.
    I am very happy that I found this during my search for something concerning this.

  6. top news said

    This paragraph gives clear idea for the new viewers of blogging, that actually how to do running a blog.

  7. Hurrah, that’s what I was exploring for, what a material!
    existing here at this website, thanks admin of
    this site.

  8. I’ve read some excellent stuff here. Certainly worth bookmarking for revisiting.
    I wonder how so much attempt you put to make this sort of excellent informative website.

  9. You are so awesome! I do not believe I have read through a single thing like this before.
    So nice to find somebody with unique thoughts on this issue.

    Seriously.. many thanks for starting this up.
    This site is something that is required on the internet,
    someone with a little originality!

  10. Virgie Hudgins said

    Good comments , I was fascinated by the info – Does anyone know where my company could grab a fillable a form copy to use ?

  11. martha dibenedetto said

    Good commentary , I loved the analysis – Does someone know where my company can locate a fillable OMB SF 429 copy to fill in ?

  12. […] via Oracle Apps – R12 – Core HR Lookups […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s