PERSON_NAME_ID |
NUMBER |
|
18 |
Yes |
System generated part of the primary key. Surrogate key. |
EFFECTIVE_START_date |
date |
|
|
Yes |
date Effective Entity is indicates : indicate the date at the beginning of the date range within which the row is effective . |
EFFECTIVE_END_date |
date |
|
|
Yes |
Date Effective Entity: indicates the date at the end of the date range within which the row is effective. |
PERSON_ID |
NUMBER |
|
18 |
|
Identifies the person to whom this name belongs |
BUSINESS_GROUP_ID |
NUMBER |
|
18 |
|
identifier of Enterprise , used for multi – tenancy partitioning . foreign key to hr_organization_unit . |
legislation_code |
varchar2 |
4 |
|
|
Country context for the Name data. |
NAME_TYPE |
varchar2 |
30 |
|
|
This column tells us whether the name is Global or Local. |
LAST_NAME |
varchar2 |
150 |
|
|
Person’s Last Name |
FIRST_NAME |
varchar2 |
150 |
|
|
Person’s First name |
MIDDLE_NAMES |
varchar2 |
80 |
|
|
Person ‘s middle name |
title |
varchar2 |
30 |
|
|
Person’s title, means of addressing person. |
pre_name_adjunct |
varchar2 |
150 |
|
|
prefix to a person ‘s last name , generally not consider when sort |
SUFFIX |
varchar2 |
80 |
|
|
Part of name appended to the last name |
KNOWN_AS |
varchar2 |
80 |
|
|
Preferred first name for the user. |
PREVIOUS_LAST_NAME |
varchar2 |
150 |
|
|
previous Last Name of the person if any . |
HONORS |
varchar2 |
80 |
|
|
Higher qualification forming part of a person’s name. |
MILITARY_RANK |
varchar2 |
80 |
|
|
Rank in military service |
display_name |
varchar2 |
240 |
|
|
Derived denormalized name formatted for on-screen display. Formatting depends on the Legislation Code, expect First Name as first component in this format. |
FULL_NAME |
varchar2 |
2000 |
|
|
System constructed version of name, used in more formal display purposes |
list_name |
varchar2 |
240 |
|
|
Constructed version of a person’s name, intended for use in an alphabetically-ordered list. The value may naturally differ depending on the Legislation Code.Expect the Last Name as the first component in this format in most cases. |
order_name |
varchar2 |
240 |
|
|
system – construct version of name used for sort . In Fusion we is store will always store a value here . |
NAM_INFORMATION_CATEGORY |
varchar2 |
30 |
|
|
Descriptive flexfield structure defining column |
NAM_INFORMATION1 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION2 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION3 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION4 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION5 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
nam_information6 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION7 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION8 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION9 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
nam_information10 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION11 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION12 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION13 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
nam_information14 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION15 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION16 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION17 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
nam_information18 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION19 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
nam_information20 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION21 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION22 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION23 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION24 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION25 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION26 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION27 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION28 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION29 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION30 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
NAM_INFORMATION_NUMBER1 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER2 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER3 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER4 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER5 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER6 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER7 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER8 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER9 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER10 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
nam_information_number11 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER12 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER13 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER14 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER15 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
nam_information_number16 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER17 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER18 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER19 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_NUMBER20 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date1 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date2 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date3 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date4 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date5 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date6 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date7 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date8 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date9 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date10 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date11 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date12 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date13 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date14 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
NAM_INFORMATION_date15 |
date |
|
|
|
descriptive Flexfield : segment of the descriptive flexfield . |
attribute_category |
varchar2 |
30 |
|
|
Descriptive Flexfield: structure definition of the user descriptive flexfield. |
ATTRIBUTE1 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE2 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE3 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
attribute4 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE5 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE6 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE7 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE8 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE9 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE10 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE11 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE12 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE13 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE14 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE15 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
attribute16 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE17 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE18 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE19 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE20 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE21 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE22 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE23 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
attribute24 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE25 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE26 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE27 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE28 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE29 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE30 |
varchar2 |
150 |
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER1 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER2 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
attribute_number3 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER4 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
attribute_number5 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER6 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER7 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER8 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
attribute_number9 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
attribute_number10 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER11 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER12 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER13 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
attribute_number14 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER15 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER16 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER17 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER18 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_NUMBER19 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
attribute_number20 |
NUMBER |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date1 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date2 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date3 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date4 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date5 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date6 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date7 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date8 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date9 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date10 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date11 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date12 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date13 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date14 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
ATTRIBUTE_date15 |
date |
|
|
|
descriptive Flexfield : segment of the user descriptive flexfield . |
OBJECT_VERSION_NUMBER |
NUMBER |
|
9 |
|
Used to implement optimistic locking . This number is incremente every time that the row is update . The number is compare at the start and end of a transaction to detect whether another session has update the row since it was query . |
CREATED_BY |
varchar2 |
64 |
|
|
Who column: indicates the user who created the row. |
CREATION_date |
TIMESTAMP |
|
|
|
Who column: indicates the date and time of the creation of the row. |
LAST_UPdate_date |
TIMESTAMP |
|
|
Yes |
Who column: indicates the date and time of the last update of the row. |
LAST_UPdate_LOGIN |
varchar2 |
32 |
|
|
Who column: indicates the session login associated to the user who last updated the row. |
LAST_UPdateD_BY |
varchar2 |
64 |
|
Yes |
Who column: indicates the user who last updated the row. |
CHAR_SET_CONTEXT |
varchar2 |
4 |
|
|
specify the character set in which the detail are store . |
AUDIT_ACTION_TYPE_ |
varchar2 |
10 |
|
|
Action Type – have values like INSERT, UPdate and DELETE. |
AUDIT_CHANGE_BIT_MAP _ |
varchar2 |
1000 |
|
|
Used to store a bit map of 1s and 0s for each column in the table. |
AUDIT_IMPERSONATOR_ |
varchar2 |
64 |
|
|
Original Impersonator User. |