Person Lookups
This topic identifies common lookups that are person-related and have user or extensible configuration levels. Review these lookups, and update them as appropriate to suit enterprise requirements using the Manage Common Lookups task.
Person Information Lookups
Person information lookups are described in the following table:
|
Lookup Type |
Description |
Configuration Level |
|---|---|---|
|
ORA_PER_EXT_IDENTIFIER_TYPES |
Type of a person's identifier in an external application, such as time device badge identifier, third-party payroll identifier, or third-party payroll alternate identifier |
User |
|
PER_NATIONAL_IDENTIFIER_TYPE |
Type of a person's national identifier, such as social security number, civil registration number, or national insurance number |
User |
|
PERSON_TYPE_STATUS |
Status of a user person type, such as active or inactive |
User |
|
EMAIL_TYPE |
Type of a person's email address, such as home email or work email Note: A person can have only one work email by default.
If you want to add a secondary work email, you must define another
lookup type.
|
Extensible |
|
ADDRESS_TYPE |
Type of a person's address, such as home address or mailing address |
Extensible |
|
PHONE_TYPE |
Type of a person's phone, such as home phone or mobile phone |
Extensible |
|
PER_CM_MTHD |
Communication methods for a person, such as email or instant messenger |
Extensible |
|
PER_CONTACT_TIMES |
Times of day when a specified phone number can be used, such as evenings or weekends |
Extensible |
|
PER_ETHNICITY |
Person's ethnicity, such as Hispanic, Asian, or American Indian |
User |
|
PER_RELIGION |
Person's religion, such as Christianity, Hinduism, or Islam |
Extensible |
|
PROFESSION |
Person's profession reported on a visa or work permit, such as engineer, nurse, or teacher |
Extensible |
|
TITLE |
Person's title, such as Miss, Doctor, or Professor, forming part of the person's name |
Extensible |
|
HONORS |
Higher qualifications, such as CPA, PhD, or DDS, forming part of the person's name |
Extensible |
|
PER_HIGHEST_EDUCATION_LEVEL |
Person's highest level of academic qualification, such as BSc, Diploma, or MA. |
User |
|
MILITARY_RANK |
Person's military rank, such as private, sergeant, or corporal, forming part of the person's name |
Extensible |
|
BLOOD TYPE |
Person's blood group, such as A rhesus negative or B rhesus positive |
User |
|
CONTACT |
Relationship between a person and the person's contact, such as partner, child, or brother |
User |
|
MAR_STATUS |
Person's marital status, such as single, married, or legally separated |
User |
|
SEX |
Person's gender, such as male or female. |
User |
|
PER_VISA_PERMIT_TYPE |
Person's visa permit type, such as study visa, visit visa, or work visa. |
User |
For some of the person lookups that have a configuration level of User, Oracle has mapped and delivered corresponding system lookup types. This is because Oracle delivers reports and processes that only permit specific values. If you add or modify existing lookup codes, you need to map new or modified lookup codes to the Oracle-delivered lookup codes. If this isn't done, the report will be incorrect. Use the Manage Extended Lookup Codes task in the Setup and Maintenance work area to map the user or extensible lookup codes to system lookup codes.
|
User-Configurable Lookup Type |
System Lookup Type |
|---|---|
|
CONTACT |
ORA_PER_CONTACT |
|
MAR_STATUS |
ORA_PER_MAR_STATUS |
|
PER_HIGHEST_EDUCATION_LEVEL |
ORA_PER_HIGHEST_EDUCATION_LEVE |
|
PER_NATIONAL_IDENTIFIER_TYPE |
ORA_PER_NATIONAL_IDENTIFIER_TY |
|
PER_ETHNICITY |
ORA_PER_ETHNICITY |
|
PER_VISA_PERMIT_TYPE |
ORA_PER_VISA_PERMIT_TYPE |
|
SEX |
ORA_PER_SEX |
These are some key points.
-
If you change any of the details in an Oracle delivered lookup code in the user lookup types, you take ownership of the lookup code. The lookup code won't be updated when Oracle delivers any updates to that lookup code. But, if you delete the lookup code in the user lookup type, it will be replaced when Oracle delivers updates to the lookup type.
-
If the lookup code is specific to a country then the country is selected in the Extended Lookup Codes table. If a lookup code has multiple countries, then there will be multiple entries, one for each country in the Extended Lookup Codes table. Alternatively, if no country is selected, the lookup code is considered global.
Document Information Lookups
Document information lookups are described in the following table.
|
Lookup Type |
Description |
Configuration Level |
|---|---|---|
|
PER_DRIVERS_LICENSE_TYPE |
Type of a person's driver's license, such as permanent or temporary |
Extensible |
|
PER_CITIZENSHIP_STATUS |
Status of a person's citizenship, such as active or expired |
Extensible |
|
PER_PASSPORT_TYPE |
Type of a person's passport, such as emergency or regular |
Extensible |
|
PER_VISA_PERMIT_TYPE |
Type of a person's visa or work permit, such as temporary worker or residence permit |
User |
|
PER_VISA_PERMIT_STATUS |
Status of a person's visa or work permit, such as pending or active |
Extensible |
Disability Information Lookups
Disability information lookups are described in the following table.
|
Lookup Type |
Description |
Configuration Level |
|---|---|---|
|
DISABILITY_CATEGORY |
Type of a person's disability, such as hearing loss or visual impairment |
User |
|
DISABILITY_REASON |
Causes of a person's disability, such as accident or illness |
Extensible |
|
DISABILITY_STATUS |
Status of a person's disability registration, such as approved or pending |
User |
|
ORA_PER_SELF_DISCLOSE_DISABILITY |
Type of self-disclosure responses for a disability based on the country selection. |
User |
|
ORA_PER_DISABILITY_COUNTRY |
List of all countries for which disability information can be defined. This lookup is used to manage the display of countries when workers specify their own disabilities. |
Extensible |