XLE_ENTITY_PROFILES_
XLE_ENTITY_PROFILES contains the general information, which identifies a party with the classification of legal entity.
Details
-
Schema: FUSION
-
Object owner: XLE
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
XLE_ENTITY_PROFILES_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, LEGAL_ENTITY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Unique identifier of the legal entity. | |
| PARTY_ID | NUMBER | 18 | Party identifier for the legal entity. | ||
| LEGAL_ENTITY_IDENTIFIER | VARCHAR2 | 30 | Unique number used to identify a legal entity; either manually set by the user or composed of the country of registration and the registration number of the identifying jurisdiction if automatically generated. This is only relevant for third party legal entity. | ||
| NAME | VARCHAR2 | 240 | Name of the legal entity that belongs to your own corporate structure (enterprise). | ||
| GEOGRAPHY_ID | NUMBER | 18 | Region or district assigned to a representative, agent, or the like, as for making sales. | ||
| TRANSACTING_ENTITY_FLAG | VARCHAR2 | 1 | Whether or not the legal entity is allowed to generate business transactions. Not currently used. | ||
| EFFECTIVE_FROM | DATE | Effective start date of the legal entity. | |||
| EFFECTIVE_TO | DATE | Effective end date of the legal entity. | |||
| LE_INFORMATION_CONTEXT | VARCHAR2 | 30 | Descriptive Flexfield: financial additional information descriptive flexfield segment context. | ||
| LE_INFORMATION1 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 1. | ||
| LE_INFORMATION2 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 2. | ||
| LE_INFORMATION3 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 3. | ||
| LE_INFORMATION4 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 4. | ||
| LE_INFORMATION5 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 5. | ||
| LE_INFORMATION6 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 6. | ||
| LE_INFORMATION7 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 7. | ||
| LE_INFORMATION8 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 8. | ||
| LE_INFORMATION9 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 9. | ||
| LE_INFORMATION10 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 10. | ||
| LE_INFORMATION11 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 11. | ||
| LE_INFORMATION12 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 12. | ||
| LE_INFORMATION13 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 13. | ||
| LE_INFORMATION14 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 14. | ||
| LE_INFORMATION15 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 15. | ||
| LE_INFORMATION16 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 16. | ||
| LE_INFORMATION17 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 17. | ||
| LE_INFORMATION18 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 18. | ||
| LE_INFORMATION19 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 19. | ||
| LE_INFORMATION20 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 20. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| 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. | ||
| 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_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. | |||
| ACTIVITY_CODE | VARCHAR2 | 150 | Primary activity of the legal entity. This is an extension of the financial additional information descriptive flexfield columns from LE_INFORMATION1 to LE_INFORMATION_20. | ||
| SUB_ACTIVITY_CODE | VARCHAR2 | 150 | Subordinate activity of the legal entity. This is an extension of the financial additional information descriptive flexfield columns from LE_INFORMATION1 to LE_INFORMATION_20. | ||
| TYPE_OF_COMPANY | VARCHAR2 | 50 | Type of company. This is an extension of the financial additional information descriptive flexfield columns from LE_INFORMATION1 to LE_INFORMATION_20. | ||
| PSU_FLAG | VARCHAR2 | 1 | Payroll Statutory Unit is a legal entity that is registered to report payroll tax and social insurance. In most cases, a Legal Employer is also a Payroll Statutory Unit, but a Payroll Statutory Unit can represent multiple Legal Employers. | ||
| LEGAL_EMPLOYER_FLAG | VARCHAR2 | 1 | Whether the legal entity can be an employer. Value values are Yes or No. | ||
| PARENT_PSU_ID | NUMBER | 18 | Parent payroll statutory unit identifier. | ||
| ENTERPRISE_ID | NUMBER | 18 | Enterprise or business group identifier. | ||
| LE_INFORMATION_NUMBER1 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| LE_INFORMATION_NUMBER2 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| LE_INFORMATION_NUMBER3 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| LE_INFORMATION_NUMBER4 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| LE_INFORMATION_NUMBER5 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| LE_INFORMATION_DATE1 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| LE_INFORMATION_DATE2 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| LE_INFORMATION_DATE3 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| LE_INFORMATION_DATE4 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| LE_INFORMATION_DATE5 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment | |||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XLE_ENTITY_PROFILES_N1_ | Non Unique | Default | LEGAL_ENTITY_ID |
| XLE_ENTITY_PROFILES_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, LEGAL_ENTITY_ID |