Labels

2017 absence absence management Account accounting AIM aliases AME and API application application utilities lookups approval assignments ATO Australia Bank bi publisher budget business business groups CAGR candidates cartisian product case CEMLI Center Stage channels Classification competency concurrent Configuration configuration profile constants contextualization conversion correction cost costing coverage area customization data database date DateTracked deductions define design develop DFF diagnostics document earnings ebs EIT Element employee enhancements erp excel expression extension failure Fastformula FBT Flexfield FND fndload foreign key forms Formula fringe benefit FRM-40654 from FTE Functions fund fusion GL global transfer grade help hierarchy HR HRMS human resource management system implementation income information interfaces internet interview job join key flexfield KFF KPI language learning leave legal employer legislation links lists localization location management New Year obia obiee OLF onboarding oracle oracle applications oracle descriptive flex field oracle descriptive flexfield oracle ebs oracle erp oracle fusion HCM oracle hrms oracle hrms interview questions oracle hrms modules oracle hrms modules list oracle hrms organization oracle hrms table oracle hrms tables oracle hrms tutorial oracle irecruitment oracle legal entities oracle lookups oracle organization hierarchy oracle payroll oracle payroll interview questions oracle payroll tables oracle self service order by Organization organization type otbi package package body package specification patch payg Payment payroll people group perform person personalisation phase pl/sql position primary key process profile programs project qualifier Query question questions Recruiting Center Recruitment regex regular expression reporting tool reports requests requirement requisition resume retropay RICE salary schema security profile select SIT smartorg sql statutory stores STP Super Superannuation system systems Table Taleo taleo 15B Taleo Recruitment tax termination test testing trunc update user group user management user type value set variables View Views Web ADI webadi where work relationship

Sunday, 26 April 2015

Application Utilities Lookups

Lookups provide lists of valid values for certain items of information. This has two key advantages: 
  • It ensures that all users use the same terminology, which makes it easier to inquire and report on the information.
  • It speeds up data entry because you can enter just enough to identify the value, and the system completes the entry.
In Oracle HRMS, a list of values is called a lookup type. Each value comprises a code, a meaning, and sometimes, a legislative tag.
Navigation to access Lookup Form: [HR Superuser Resp] >> Other Definitions >> Application Utilities Lookups
A number of lookup types are included in Oracle HRMS. Some contain codes as startup data. You can never delete these codes, but you can change their meaning. For some lookup types, you can also disable the codes that are supplied. Your ability to disable codes and add new codes is determined by the access level of the lookup type:
  • User - You can add codes and you can disable supplied codes
  • Extensible - You can add new codes, but you cannot disable supplied codes because the system uses them
  • System - You can neither add codes nor disable supplied codes. You can only change the meaning or description of supplied codes 

To add lookup values to an existing lookup type:

Query the lookup type to which you want to add a value. You cannot add values if the access level is System.
If you want to add lookup values specific to the security group/business group linked to your current responsibility, un-check the Global Security Group check box. Existing lookup values are available to all business groups.

Enter the code, meaning and optionally a description for each value. Leave the Tag column blank.

Caution: Do not change or remove any legislation codes that are shown in the Tag column for existing lookup values. This may have implications elsewhere in your HRMS system.
If you do not enter a start date, the new lookup is valid immediately. If you do not enter an end date, the new lookup is valid indefinitely.

Save your work
Frequently used HR and Payroll Lookups: 

Description Field
Lookup Type
Category (absence)
ABSENCE_CATEGORY
Reason (for absence)
ABSENCE_REASON
Account Type (for bank details)
ACC_TYPE
Address Type
ADDRESS_TYPE
Balance Type Category
BACKFEED_BT_CATEGORY
Bank account name
BANK_ACCOUNT_NAME
Bank account number
BANK_ACCOUNT_NUMBER
Bank branch
BANK_BRANCH
Bank name
BANK_NAME
Bank account type
BANK_ACCOUNT_TYPE
Competence Type
COMPETENCE_TYPE
Type (relationship of one person to another)
CONTACT
Document Category
DOCUMENT_CATEGORY
Employment Category
EMP_CAT
Employee Category
EMPLOYEE_CATG
Days of the week
HXT_DAY_OF_WEEK
Industry (for salary survey)
INDUSTRY
Reason (for leaving)
LEAV_REAS
Marital Status
MAR_STATUS
Nationality
NATIONALITY
Reason (Termination of Contract Workers)
NPW_TERMINATION_REASONS
Organization Type
ORG_TYPE
Communication delivery method, Report Method
PER_CM_MTHD
Cluster
PER_COMPETENCE_CLUSTER
Format Type
PER_NAME_FORMATS
Address Type
ADDRESS_TYPE
Phone Type
PHONE_TYPE
Reason (for salary proposal)
PROPOSAL_REASON
Units (qualifying units for probation period)
QUALIFYING_UNITS
Survey Age (for salary surveys)
SURVEY_AGE
Survey Company (for salary surveys)
SURVEY_COMPANY
Job Name (for salary surveys)
SURVEY_JOB_NAME
Region (for salary surveys)
SURVEY_REGION
Seniority (for salary surveys)
SURVEY_SENIORITY
Person Title (Prefix)
TITLE
Status (of a vacancy)
VACANCY_STATUS
Availability Schedule
WORK_SCHEDULE


Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)