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 |