[Home] [Help] [Dependency Information]
Object Name: | HRBV_ORGANIZATION_UNIT |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Organization Units (from HR_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL tables)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Translated name of the organization |
DATE_FROM | DATE | Yes | Start date of the organization. | |
DATE_TO | DATE | End date of the organization. | ||
INTERNAL_ADDRESS | VARCHAR2 | (80) | Internal address line. | |
COMMENTS | LONG | (0) | Comments. | |
INTERNAL_EXTERNAL_FLAG | VARCHAR2 | (4000) | Identifies whether the organization is treated as an employment unit within the business group. | |
ORGANIZATION_TYPE | VARCHAR2 | (4000) | User-defined organization types, for example Region, Division, Department. | |
_DF:AOU | CHAR | (32) | Descriptive Flex placeholder | |
INTERNAL_EXTERNAL_FLAG_CODE | VARCHAR2 | (30) | Code of INTERNAL_EXTERNAL_FLAG | |
TYPE_CODE | VARCHAR2 | (30) | Code of ORGANIZATION_TYPE | |
LEGISLATION_CODE | VARCHAR2 | (4000) | Identifies the legislation of the Business group where the Organization is created. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
COST_ALLOCATION_KEYFLEX_ID | NUMBER | (9) | Foreign key to PAY_COST_ALLOCATION_KEYFLEX. | |
LOCATION_ID | NUMBER | (15) | Foreign key to HR_LOCATIONS. Default work site location for all assignments to this organization. | |
ORGANIZATION_ID | NUMBER | (15) | Yes | System-generated primary key column. |
SOFT_CODING_KEYFLEX_ID | NUMBER | (15) | Foreign key to HR_SOFT_CODING_KEYFLEX | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
BG_SECURITY_FLAG_CODE | CHAR | (1) | Business group security flag code |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_NAME
, DATE_FROM
, DATE_TO
, INTERNAL_ADDRESS
, COMMENTS
, INTERNAL_EXTERNAL_FLAG
, ORGANIZATION_TYPE
, _DF:AOU
, INTERNAL_EXTERNAL_FLAG_CODE
, TYPE_CODE
, LEGISLATION_CODE
, BUSINESS_GROUP_ID
, COST_ALLOCATION_KEYFLEX_ID
, LOCATION_ID
, ORGANIZATION_ID
, SOFT_CODING_KEYFLEX_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_ORGANIZATION_UNIT;
|
|
|