DepartmentsLovV2
DepartmentsLovV2
Columns
| Name | Type | Description |
| OrganizationId [KEY] | Long | OrganizationId of DepartmentsLovV2 |
| EffectiveStartDate [KEY] | Date | EffectiveStartDate of DepartmentsLovV2 |
| EffectiveEndDate [KEY] | Date | EffectiveEndDate of DepartmentsLovV2 |
| Name | String | Name of DepartmentsLovV2 |
| Title | String | Title of DepartmentsLovV2 |
| LocationCode | String | LocationCode of DepartmentsLovV2 |
| LocationName | String | LocationName of DepartmentsLovV2 |
| SetName | String | SetName of DepartmentsLovV2 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BusinessGroupId | Long | BusinessGroupId |
| ClassificationCode | String | ClassificationCode |
| EffectiveDate | Date | EffectiveDate |
| FilterAttributes | String | FilterAttributes |
| SearchTerms | String | SearchTerms |
| SetId | Long | SetId |
| Status | String | Status |
| Finder | String | finder |