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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| BusinessGroupId | Long | BusinessGroupId |
| EffectiveDate | Date | EffectiveDate |
| FilterAttributes | String | FilterAttributes |
| IsBenchmarkJob | Bool | IsBenchmarkJob |
| SearchTerms | String | SearchTerms |
| SetId | Long | SetId |
| Finder | String | finder |