ASSIGNMENT INTERFACE FILE#
The Assignment Interface File screen is used to import work rule codes into the software data structures.
Assignment Interface File data is maintained on the INF_CV_ASSIGNMENTS table.
Assignment Information Tab#
Employee#
- ID
- This field uniquely identifies the assignment record within the data base.
- Entity
- This field identifies the entity associated with the assignment.
- Person Code
- The employee associated with the assignment is displayed in this field.
- Employment Type
- The employment type associated with the assignment is displayed in this field.
- Hire Date
- The hire date associated with this assignment is displayed in this field.
- Assignment Code
- This field identifies the assignment.
- Prime Assignment
- This field indicates if the assignment will be regarded as the primary assignment for attendance and benefits purposes, regardless of the type indicated.
- Type
- The assignment type is displayed in this field.
Assignment#
- Description
- This field provides a short description of the assignment.
- Assignment Status
- The assignment status is displayed in this field.
- Start Date
- This field will display the start date of the assignment.
- End Date
- This field will display the end date of the assignment.
- Date of Next Review
- This field shows the date of the next assignment review.
- Effective As Of/Expires On
- If the group is temporary, these fields will define the dates the work rule is effective.
- Change Reason
- This field displays the ‘Change Reason’ code, which provides the rationale as to why information has been created or changed as of an effective date.
Definition Tab#
Definition#
- Title
- This is the official or formal title of the position or job for this assignment. The assignment title is inherited from the position (or job) title, but may be overridden.
- Job
- This field shows the job that the employee is hired to perform.
- Unit
- This is the unit with which the employee is affiliated.
- Department
- This is the department to which the employee is assigned.
- Work Rule
- The work rule associated with the assignment is displayed in this field.
- Long Term Assignment
- This field indicates if the assignment is long term.
- Requires Time Sheet
- This field indicates if the assignment requires a time sheet.
Status#
- Provide Public Service
- This field indicates if the position is to be reported as ‘Provide Public Service’ on specific government reports (e.g. Official Language Report - REOLA).
- Provide Internal Service
- This field indicates if the position is to be reported as ‘Provide Internal Service’ on specific government reports (e.g. Official Language Report - REOLA).
- Supervisory
- This field indicates if the position is to be reported as ‘Supervisory’ on specific government reports (e.g. Official Language Report - REOLA).
- Status
- This field defines what employment status qualifies an employee to use this time code. This may be left blank.
- First Date on Leave
- This field shows the date the employee’s leave commences.
- Leave Reason
- A reason for the leave of absence may be entered here.
- Returned From Leave Date
- This field shows the date the employee will return from the leave.
- Replaced By #
- This field shows the number and the name of the person replacing the employee. This field is for documentation purposes only and the information displayed will not be used for processing.
- Job Profile
- This field is the 'job posting' information that is linked to the recruitment application.
Compensation Tab#
Compensation#
- FTE
- Full Time Equivalent (FTE) is a factor that indicates how an employee's weekly hours compare with the standard full time number of hours from the work rule, position, job or group. An FTE factor of 1.0000 indicates a full-time assignment, one of less than 1.0000 indicates a part-time assignment. The FTE is re-derived, if the weekly hours, the work rule or the job is changed.
- O/R Work Calendar
- This field may contain an override work calendar to be used in place of the work calendar defined on the work rule.
- Hours Per Pay
- This field holds the average number of hours per pay for this assignment.
- Periods Elected
- If this is a contract assignment, this field shows the number of pay periods that the wage is to be paid over for the contract period.
- Contract Days
- If this is a contract assignment, this field shows the number of days within the contract.
- Contract Limit
- If this is a contract assignment, this field displays the wage limit for the contract period.
- Periods Elected
- If this is a contract assignment, this field shows the number of pay periods that the wage is to be paid over for the contract period.
- Start Date of Pay
- For contract assignment only: This field displays the date upon which the employee is to begin being paid. This may be different than the hire date.
Miscellaneous#
- Range
- Salary range provides minimum and maximum guidelines for the salary payable for the job, with which an employee's salary may be compared. This range is inherited from the position or job, however, it may be overridden.
- Scale Step
- The Wage Scale and Step fields determine the wage that is derived from the wage scale table. Scale/Step is inherited from the position or job, and may be overridden.
- Wage Rate
- The employee's wage rate, expressed in terms of the rate basis, below. On this screen, there is an in line calculator for ease of wage changes.
- Basis
- The rate basis is the unit of measure that the associate wage rate is being stored or displayed in. It is either inherited from the position (or job), or defaulted from the wage scale and step. This basis may, however, be overridden (i.e. hourly, weekly, biweekly, semi-monthly, monthly or annually).
- Use FTE Wages
- This field indicates the FTE wage for the position.
- Wage Rate
- This field displays the employee's wage rate, as expressed in terms of the rate basis listed below.
- Out of Range
- This field indicates if the displayed wage is outside of the minimum or maximum values for the salary range.
- Scale Overridden
- This field indicates if the displayed wage rate has been keyed manually, and is different from the rate on the scale step.
- Trigger Retro
- This field indicates if the assignment record may be specifically included in an execution of UPRETRO for retroactive wage increases.
Location Tab#
- Responsibility Level
- ‘Responsibility Level’ is a security access feature. A user may only access information on an employee who’s assignment responsibility is lower than, or equal to that defined for user access on IMSV. The data for this field is inherited from the position, but it may be overridden.
- Service Rating
- This field indicates that an employee is on a probationary status either for service or seniority purposes.
- Job Seniority Date
- This field displays the job seniority date used to track a seniority date that is related to the assignment.
- Work Type
- Burden Method
- This field specifies the burden method to be used for this in the Journalize Labor (UPGL) process. If this field is not specified, the burden method defined on the IDGR will be used.
- Burden Percent
- This field specifies the burden percentage corresponding to the burden method defined in the previous field.
- Auth Area
- The authorization area associated with the assignment is displayed here.
- Works Out Of
- This field displays the work locations where the employee may normally be found, or where their primary duties are performed.
- Country Name
- The country where the work is performed is displayed in this field.
- State, County
- The state/province where the work is performed is displayed in this field.
- Tax Jurisdiction
- The tax jurisdiction where the work is performed is displayed in this field.
- Sends Pays To
- This field indicates where the employee's pay will be sent.
- Phone #
- The phone number associated with the assignment is displayed in this field.
- Phone Extn
- The phone extension associated with the assignment is displayed in this field.
- The email address associated with the assignment is displayed in this field.
Premiums and Distributions Tab#
- Premium
- This field displays the user-defined premium code that uniquely identifies this premium within the organization.
- Premium Rate
- This field is an override for the Premium Rate that is derived from the Premium Code.
- O/R Rate Basis
- This field is an override for the Premium Rate basis that is derived from the Premium Code.
- Split Sequence
- This field defines the sequential order of a distribution mask when splitting a cost over multiple distributions.
- Distribution
- This field shows the distribution code receiving the portion of costs. This is normally the distribution of the wages associated with the assignment.
- Split Rule
- The distribution split rule indicates whether the distribution is being split by a percentage, by flat amount or by the Distribution pick list of authorized assignments.
- Split Percentage
- If a split rule is ‘by percent’ then this field will indicate a percent.
- User Percentage
- If a split rule is ‘by percent’ then this field will indicate a percent.
- Amount $
- If you have selected ‘Split By Flat Amount’ as the split rule, then the amount to be given to the distribution code is indicated in this field.
- Start Date\End Date
- These dates indicate the dates this distribution may be used.
- GL Fund
- The GL fund associated with the premium is displayed in this field
User Fields Tab#
- User Field Value 1 - 12
- This field is used for conversion. This value is applied against the user-defined field for each table which must have been previously defined in the P2K_AM_USER_FIELDS table.
