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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。