JobFamilies
JobFamilies
Columns
| Name | Type | Description |
| JobFamilyId [KEY] | Long | System generated primary key column. |
| EffectiveStartDate [KEY] | Date | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. |
| EffectiveEndDate [KEY] | Date | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. |
| JobFamilyName | String | Denoted the name for the Job Family. |
| JobFamilyCode | String | Denoted the code for the Job Family. |
| ActionReasonId | Long | ActionReasonId of JobFamilies |
| ActiveStatus | String | Indicates if a job family is active or inactive. |
| CreationDate | Datetime | CreationDate of JobFamilies |
| LastUpdateDate | Datetime | LastUpdateDate of JobFamilies |
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 |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |