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 |