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