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 |