Jobs
Jobs
Columns
| Name | Type | Description |
| JobId [KEY] | Long | System generated primary key column. |
| JobCode | String | Code of the job. |
| JobFamilyId | Long | Foreign Key to PER_JOB_FAMILY_F table. |
| ActiveStatus | String | Indicates if a job is active or inactive. |
| FullPartTime | String | Indicates if a job is full-time or part-time. |
| JobFunctionCode | String | Code of the job function. |
| ManagerLevel | String | Indicates the management level of the job. |
| MedicalCheckupRequired | String | Indicates if the job requires medical checkup. |
| StandardWorkingHours | Double | Number of standard working hours. |
| StandardWorkingFrequency | String | Frequency for the standard working hours. |
| StandardAnnualWorkingDuration | Double | The standard annual working duration for the job. |
| AnnualWorkingDurationUnits | String | The unit of measure in hours, days, weeks, or months for the standard annual working duration. |
| RegularTemporary | String | Indicates if a job is regular or temporary. |
| SetId | Long | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. |
| 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. |
| Name | String | Denotes name for the Job. |
| ApprovalAuthority | Long | Integer number to identify levels across jobs which are used for approvals if the job list builder is used. |
| GradeLadderId | Long | Foreign Key to PER_GRADE_LADDERS_F |
| CreationDate | Datetime | CreationDate of Jobs |
| LastUpdateDate | Datetime | LastUpdateDate of Jobs |
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 |