PER_PERSON_NAMES_F_

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.