Organizations
Organizations
Columns
Name | Type | Description |
EffectiveStartDate [KEY] | Date | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. |
EffectiveEndDate [KEY] | Date | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. |
OrganizationId [KEY] | Long | System generated primary key column. |
Name | String | Denotes the translated name for the Organization Unit. |
Title | String | Denotes the translated title for the Organization Unit. |
ClassificationCode | String | Foreign key to HR_ORG_CLASSIFICATIONS table. |
InternalAddressLine | String | Internal address of the organization. |
LocationId | Long | Identifier of location to which the Organization Unit belongs. |
OrganizationCode | String | OrganizationCode of Organizations |
Status | String | Status of Organizations |
CreationDate | Datetime | CreationDate of Organizations |
LastUpdateDate | Datetime | LastUpdateDate of Organizations |
OrgCode | String | Custom OrganizationCode to be used instead of auto generated code. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |