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