Job
Jobs are categories or general groupings used to create specific positions. For example, in healthcare, the jobs might include Nurse, Doctor, or Pharmacy Technician. Jobs provide default values as well as default pay and cost information for positions.
For a PayBasis job definition, there are groups that use different sets of information such as:
- Annual/monthly jobs includes information such as Salary and MaximumSalary.
- Hourly jobs includes information such as Salary, AnnualHours, and PayPeriods.
- Annual/monthly table base jobs includes information such as SalaryTable, SalaryGrade, SalaryStep, ProgressionRule, and MaximumSalary.
- Hourly table base jobs includes information such as SalaryTable, SalaryGrade, SalaryStep, ProgressionRule, AnnualHours, and PayPeriods.
The common properties for all job types are:
- JobName
- JobDescription
- Active
- Identifier
- PayBasis
- WorkLocation
- PhasingMethod
- BPDENTITY
- BaseSalaryAccount
The process uses these tables and stored procedures:
- The staging table is DAT_ATCDATA_JOB_STAGE.
- The stored procedure to validate staged data is
depm_integration_wb_job_prepare_staging. - The stored procedure to process staged data is
depm_integration_wb_job. - The data is imported to:
-
- The DAT_ATCDATA_JOB_TRANSFORMED table.
- The ATCDATA_JOB and WBCCONFIG_ACTION_ORDER cubes.
The output tables are:
- ATT_ATCDATA_JOB contains the dynamic attribute cube data.
- DIM_WBDJOB_ELEMENTS contains the elements for the WBDJOB dimension.
- DIM_WBDJOB_PARENTS contains the parent/child relationships for the WBDJOB dimension.
The entity ID and account ID must exist prior to importing data.
If you are importing job data, and if in use, then you must also import salary table data, salary grade data, salary step data, progression rules, and progression rule data.
This table describes DAT_ATCDATA_JOB_STAGE:
| Field | Required | Description |
|---|---|---|
| JobName | Y | Name of the job. |
| JobDescription | N | Description of the job. |
| Active | N | Indicates if the job is active or inactive. The valid values are:
The default is 1. |
| Identifier | Y | Unique identifying code for the job per entity. Used as the element name. |
| PayBasis | Y | One-character code for pay basis. The valid values are:
|
| Salary | Y/N | Salary amount. This is required if not using salary table. PayBasis is one of S/M/H. |
| SalaryTable | Y/N | Valid salary table identifier. This is required if using salary table.
PayBasis is T. |
| SalaryGrade | Y/N | Valid salary grade name. This is required if using salary table.
PayBasis is T. |
| SalaryStep | Y/N | Valid step number in salary step. This is required if using salary table.
PayBasis is T. |
| BaseSalaryAccount | Y | Valid base salary account ID from the account dimension. The account must be activated in the configuration set in which data will be loaded. |
| ProgressionRule | N | Valid progression rule name associated with the job, if applicable. This is optional for jobs using salary table. The PayBasis is T. |
| WorkLocation | N | Specify where the job is based. Free text. |
| SalaryPercentage | N | The default salary percent used when creating a position for this job.
The percent must be expressed as a number without division by 100. For example, 25 instead of 0.25. |
| BenefitPercentage | N | The default benefit percent used when creating a position for this job.
The percent must be expressed as a number without division by 100. For example, 25 instead of 0.25. |
| AnnualHours | Y/N | Positive number of hours in a year for job. This is required for hourly
jobs. PayBasis is H or T. |
| MaximumSalary | N | Maximum salary paid for job. Only for annual or monthly PayBasis. Includes annual and monthly salary table jobs. |
| PhasingMethod | N | Cost spread over time. Valid phasing method ID name. The default value is Even. |
| PayPeriods | Y/N | Number of pay periods. This is required for Hourly (PayBasis = H or T). |
| BPDENTITY | Y | Unique entity ID from BPDENTITY. The related field is ID in the DIM_BPDENTITY_ELEMENTS table. |