Alias: IVDEN#
The INF_CV_ENTITIES table is used to import entity codes and their attendant data into the software data structures. The Entity Code is a user-defined code that uniquely identifies the entity. It is often an abbreviation of the name or initials, or an acronym by which the organization refers to itself.Tables loaded:
- P2K_CM_ENTITIES (first record for each position code only)
- P2K_CM_ENTITY_DETAILS (first record and subsequent effective splits)
Table Columns#
Column name | Data Type / Size | Mand. | Notes |
---|---|---|---|
ID | Number(10) | Used internally to define a unique identification for the record. This field would not be loaded. | |
ENTITY_CODE | Varchar2(16) | Y | Validation: Must be a unique entity code. |
GL_COMPANY_CODE | Varchar2(16) | Validation: Must be a valid GL_COMPANY_CODE defined on P2K_CM_GL_COMPANIES. Derivation: Will be derived from the GL_COMPANY_CODE for the PARENT_ENTITY, if a PARENT_ENTITY has been defined. | |
PARENT_ENTITY | Varchar2(16) | Validation: Must be a valid ENTITY_CODE previously defined on P2K_CM_ENTITIES. | |
STANDING | Varchar2(30) | Validation: Must be either a valid lexicon code, or a valid lexicon description from X_STANDING. Suggestion: Normally, you would only load active entities, so you could populate this field with a constant value of “A”. | |
EFFECTIVE | Date() | Validation: Must be a valid date format. Suggestion: If you are not loading multiple date-effective records for the same entity code, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time. | |
EXPIRY | Date() | Validation: Must be a valid date format, with a date after the effective date. Suggestion: If you are not loading multiple date-effective records for the same entity code, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time | |
CHANGE_CODE | Varchar2(16) | Validation: The Change Code provided must be defined on P2K_CM_CHANGE_REASONS | |
ENTITY_NAME | Varchar2(50) | Y | |
LOCATION_CODE | Varchar2(16) | Validation: Must be a valid LOCATION_CODE defined on P2K_CM_LOCATIONS. Derivation: Will be derived from the LOCATION_CODE for the PARENT_ENTITY, if a PARENT_ENTITY has been defined. | |
INDUSTRY_CODE | Varchar2(16) | Validation: Must be a valid INDUSTRY_CODE defined on P2K_CM_INDUSTRIES. Derivation: Will be derived from the INDUSTRY_CODE for the PARENT_ENTITY, if a PARENT_ENTITY has been defined. | |
LEGISLATION | Varchar2(30) | Validation: Must be either a valid lexicon code, or a valid lexicon description from X_LEGISLATION. Derivation: Will be derived from the LEGISLATION for the PARENT_ENTITY, if a PARENT_ENTITY has been defined. If you do not provide a value for this field, or a PARENT_ENTITY, then a value of ‘00’ will be defaulted. Suggestion: Normally, you could populate this field with a constant value representing the legislation. | |
LANGUAGE_CODE | Varchar2(30) | Validation: Must be either a valid lexicon code, or a valid lexicon description. Derivation: Will be derived from the LANGUAGE_CODE for the PARENT_ENTITY, if a PARENT_ENTITY has been defined. Suggestion: Most users will load this field with “ENG” for English. | |
CURRENCY | Varchar2(30) | Validation: Must be either a valid lexicon code or a valid lexicon description from X_CURRENCY. Derivation: Will be derived from the CURRENCY for the PARENT_ENTITY, if a PARENT_ENTITY has been defined. | |
DUNS_NUMBER | Varchar2(16) | ||
WEB_ADDRESS | Varchar2(200) | ||
CREATE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
CREATE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
CHANGE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
CHANGE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |