[{TableOfContents }] !!!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. \\ \\ ---- !!Tab 1 ;[ID|ID]:This field uniquely identifies the assignment record within the data base. ;[Entity|ENTITY_CODE]:This field identifies the entity associated with the assignment. ;[Person Code|PERSON_CODE]:The employee associated with the assignment is displayed in this field. ;[Employment Type|EMPLOYMENT_TYPE]:The employment type associated with the assignment is displayed in this field. ;[Date of Hire|HIRE_DATE]:The hire date associated with this assignment is displayed in this field. ;[Assignment|ASSIGNMENT_CODE]:This field identifies the assignment. ;[Type|ASSIGNMENT_TYPE]:The assignment type is displayed in this field. ;[Status|ASSIGNMENT_STATUS]:The assignment status is displayed in this field. ;[Start Date|ASSIGNMENT_START_DATE]:This field will display the start date of the assignment. ;[End Date|ASSIGNMENT_END_DATE]:This field will display the end date of the assignment. ;[Prime 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. ;[Description|DESCRIPTION]:This field provides a short description of the assignment. ;[Date of Next Review|NEXT_REVIEW_DATE]:This field shows the date of the next assignment review. ;[TS Seniority Date|TS_SENIORITY_DATE]:This field is used to calculate the length of service for seniority purposes, and/or benefit and leave entitlements, and pension calculations. ;[Effective As Of|EFFECTIVE]/[Expires On|EXPIRY]:If the group is temporary, these fields will define the dates the work rule is effective. ;[Change Reason|CHANGE_CODE]: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. ;[Status|STATUS_CODE]:This field defines what employment status qualifies an employee to use this time code. This may be left blank. ;[Position|POSITION_CODE]:This is the position to which the employee is assigned. ;[Department|DEPARTMENT_CODE]:The department associated with the assignment is displayed in this field. \\ \\ ---- !!Tab 2 ;[Unit|UNIT_CODE]:This is the unit with which the employee is affiliated. ;[Job|JOB_CODE]:This field shows the job that the employee is hired to perform. ;[Works Out Of|LOCATION_CODE_WORK_IN]:This field displays the work locations where the employee may normally be found, or where their primary duties are performed. ;[Country Name|COUNTRY_CODE]:The country where the work is performed is displayed in this field. ;[State, County|STATE_PROVINCE_CODE]:The state/province where the work is performed is displayed in this field. ;[Tax Jurisdiction|GEO_CODE]:The tax jurisdiction where the work is performed is displayed in this field. ;[Group|GROUP_CODE]:This is the group code that determines the policy rules under which the employee must be processed. ;[Auth Area|AUTHORIZATION_CODE]:The authorization area associated with the assignment is displayed here. ;[Work Rule|WORK_RULE (Field)]:The work rule associated with the assignment is displayed in this field. ;[Sends Pays To|LOCATION_CODE_PAYDEST]:This field indicates where the employee's pay will be sent. ;[Replaced By|PERSON_CODE_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. ;[Supervised By|PERSON_CODE_SUPERVISED_BY]:The person who supervises this position will be identified in this field. ;[Range|RANGE_CODE]:The salary range associated with this assignment is displayed in this field. ;[Scale|SCALE_CODE]:The scale associated with this assignment is displayed in this field. ;[Scale/Step|STEP_CODE]:The scale/step associated with this assignment is displayed in this field. ;[FTE|FTE]:The FTE associated with this assignment is displayed in this field. ;[Work Type|WORK_TYPE]:Work type is an assignment classification. ;[WC Class|WCB_CLASS]:This field associates the job to a specific Workers’ Compensation classification used to determine the WC category for reporting and WC Contribution. ;[Hours Per Day|HOURS_PER_DAY]:This field holds the average number of hours per day for this assignment. ;[Hours Per Week|HOURS_PER_WEEK]:This field holds the average number of hours per week for this assignment. \\ \\ ---- !!Tab 3 ;[Hours Per Pay|HOURS_PER_PAY]:This field holds the average number of hours per pay for this assignment. ;[Periods Elected|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|CONTRACT_DAYS]:If this is a contract assignment, this field shows the number of days within the contract. ;[Contract Limit|CONTRACT_LIMIT]:If this is a contract assignment, this field displays the wage limit for the contract period. ;[Use FTE Wages|USE_FTE_WAGES]:This field indicates the FTE wage for the position. ;[Wage Rate|WAGE_RATE]:This field displays the employee's wage rate, as expressed in terms of the rate basis listed below. ;[Basis|RATE_BASIS]:This field holds the unit of measure that the associate wage rate is being expressed in. ;[Out of Range|OUT_OF_RANGE]:This field indicates if the displayed wage is outside of the minimum or maximum values for the salary range. ;[Scale Overridden|SCALE_OVERRIDDEN]:This field indicates if the displayed wage rate has been keyed manually, and is different from the rate on the scale step. ;[Assignment Title|ASSIGNMENT_TITLE]:The assignment title is displayed in this field. ;[Job Seniority Date|JOB_SENIORITY_DATE]:This field displays the job seniority date used to track a seniority date that is related to the assignment. ;[Responsibility Level|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. ;[Phone #|PHONE_NUMBER]:The phone number associated with the assignment is displayed in this field. ;[Phone Extn|PHONE_EXTENSION]:The phone extension associated with the assignment is displayed in this field. ;[Email|EMAIL_ADDRESS]:The email address associated with the assignment is displayed in this field. ;[Service Rating|SERVICE_RATING]:This field indicates that an employee is on a probationary status either for service or seniority purposes. ;[First Date on Leave|LEAVE_DATE]:This field shows the date the employee’s leave commences. ;[Returned From Leave Date|LEAVE_RETURN_DATE]:This field shows the date the employee will return from the leave. ;[Leave Reason|LEAVE_REASON]:A reason for the leave of absence may be entered here. ;[Start Date of Pay|PAY_STARTING_DATE]: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. \\ \\ ---- !!Tab 4 ;[Trigger Retro|TRIGGER_RETRO]:This field indicates if the assignment record may be specifically included in an execution of UPRETRO for retroactive wage increases. ;[Provide Public Service|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|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|SUPERVISORY]:This field indicates if the position is to be reported as ‘Supervisory’ on specific government reports (e.g. Official Language Report - [REOLA]). ;[Burden Method|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|BURDEN_PERCENT]:This field specifies the burden percentage corresponding to the burden method defined in the previous field. ;[Long Term Assignment|LONG_TERM_ASSIGNMENT]:This field indicates if the assignment is long term. ;[Requires Time Sheet|REQUIRES_TIME_SHEET]:This field indicates if the assignment requires a time sheet. ;[Premium|PREMIUM_CODE]:This field displays the user-defined premium code that uniquely identifies this premium within the organization. ;[Premium Rate Basis|PREMIUM_RATE_BASIS]:This field is a display-only field, indicating the value default defined for this premium in the Define Premiums ([ISPM]) screen. ;[Premium Rate|PREMIUM_RATE]:This field is a display-only field, indicating the default value defined for this premium in the Define Premiums ([ISPM]) screen. ;[Split Sequence|SPLIT_SEQUENCE]:This field defines the sequential order of a distribution mask when splitting a cost over multiple distributions. ;[Distribution|DISTRIBUTION_CODE]: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|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|SPLIT_PERCENT]:If a split rule is ‘by percent’ then this field will indicate a percent. ;[Amount $|SPLIT_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. ;[Additional|ADDITIONAL]: ;[Start Date|START_DATE]\[End Date|END_DATE]:These dates indicate the dates this distribution may be used. ;[GL Fund|GL_FUND_CODE]:The GL fund associated with the premium is displayed in this field \\ \\ ---- !!Tab 5 ;[User Percent|USER_PERCENT]:If ‘Split By Percent’ has been selected as the split rule, then the user percentage will be displayed in this field. ;[User Field Value 1 - 10|USER_FIELD_VALUE_nn]: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. ---- ![Notes|Edit:Internal.IVEAS] [{InsertPage page='Internal.IVEAS' default='Click to create a new notes page'}]