[{TableOfContents }] !!!SUNDRY LINES INTERFACE FILE The Sundry Lines Interface File screen is used to import miscellaneous and sundry transactions into the software data structures. Sundry transaction lines are transactions, usually of recurring nature, that are not attached to a specific pay period and that have a processing frequency associated with them. Sundry Lines Interface File data is maintained on the [INF_CV_SUNDRYLINES] table. !!Tab 1 ;[ID|ID]:This field uniquely identifies the sundry lines record within the data base. ;[Entity|ENTITY_CODE]:This field identifies the entity associated with the sundry line. ;[Person Code|PERSON_CODE]:This field identifies the person associated with the sundry line. ;[Employment Type|EMPLOYMENT_TYPE]:The person's employment type is displayed in this field. ;[Date of Hire|HIRE_DATE]:The employee's date of hire is displayed in this field. ;[Frequency|FREQUENCY_CODE]:Processing frequencies indicates how often this payroll item (deduction, benefit, etc.) is processed from [P2K_PR_FREQUENCIES]. ;[Sundry Line Type|SUNDRY_LINE_TYPE]:This field indicates whether the sundry line is for a regular amount, an arrears amount, or a retro pay amount. ;[Start Date|START_DATE]/[End Date|END_DATE]:These dates show the beginning and ending time of the sundry transaction. ;[Pay Component|PC_CODE]:This field shows the pay component associated with sundry line. Only pay components with the toggle ‘Enter Sundry’ turned on from the [IPPC] form will be accessible. ;[Unit|UNIT_CODE]:This is the unit code from the sundry’s assignment ;[Group|GROUP_CODE]:This is the group code from the sundry’s assignment ;[Position|POSITION_CODE]:This is the position code from the sundry’s assignment ;[Job|JOB_CODE]:This is the job code from the sundry’s assignment ;[Leave Type|LEAVE_TYPE_CODE]:The leave type associated with the sundry will be displayed in this field. ;[Plan|PLAN_CODE]:This field displays the benefit plan associated with the sundry line. ;[User Calc|USER_CALC_CODE]:This field shows the UserCalc that may be attached to the pay component chosen. ;[Country Name|COUNTRY_CODE]:The entity's associated country is displayed in this field. ;[State/Province|STATE_PROVINCE_CODE]:The entity's associated state or province is displayed in this field. ;[Tax Jurisdiction|GEO_CODE]:The entity's tax jurisdiction is displayed in this field. \\ ---- !!Tab 2 ;[Assignment Start Date|ASSIGNMENT_START_DATE]:The first date of the associated assignment is displayed in this field. ;[Assignment|ASSIGNMENT_CODE]:The associated assignment is displayed in this field. ;[Time Used|TIMES_REMAINING]: ;[Pay Point Type|PAY_POINT_TYPE]:This field indicates the type of logic that is assigned to a pay point. ;[Pay Line Task|PAY_POINT_TASK]:This field identifies the item being processed within the pay point in the payroll calculation. ;[Pay Point Seq #|PAY_POINT_SEQUENCE]: ;[Time Entered|TIME_ENTERED]: ;[Time Basis|TIME_BASIS]: ;[WC Class|WCB_CLASS]: ;[Distribution Mask|DISTRIBUTION_MASK]: ;[Reference Information|REFERENCE_INFO]: ;[Audit Text|AUDIT_TEXT]: ;[Work Order|WORK_ORDER]: ;[Cost Center|COST_CENTER_CODE]: ;[Income Proration|INCOME_PRORATION]: ;[Calendar|CALENDAR_CODE]: ;[Pay Component|PC_CODE]: ;[PC Action|PC_ACTION]: ;[Type|PC_DETAIL_TYPE]: ;[Element|ELEMENT_CODE]: \\ ---- !!Tab 3 ;[User Variable|USER_VARIABLE_CODE]: ;[Calculation Method|PC_CALC_METHOD]: ;[Description|DESCRIPTION]: ;[Wage Rate|WAGE_RATE]: ;[O/R Wage Rate|WAGE_RATE_OVERRIDE]: ;[Basis|RATE_BASIS]: ;[O/R Basis|RATE_BASIS_OVERRIDE]: ;[Amount $|AMOUNT]: ;[O/R Amount $|AMOUNT_OVERRIDE]: ;[O/R User Rate|USER_VARIABLE_OVERRIDE]: ;[Distribution DR Mask|DISTRIBUTION_DR_MASK]: ;[Distribution CR Mask|DISTRIBUTION_CR_MASK]: ;[Rate Source|PC_RATE_SOURCE]: ;[Higher of Rate|HIGHER_OF_RATE]: ;[Pay Number|PAY_NUMBER]: ;[Statistic|STAT_CODE]: [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IVPSL] [{InsertPage page='Internal.IVPSL' default='Click to create a new discussion page'}] }] ;[Assignment|ASSIGNMENT_CODE]:The assignment type from the employee’s assignment screen will allow you to enter the sundry that is applicable to this assignment code only. ;[Freq|FREQUENCY_CODE]:Processing frequencies indicates how often this payroll item (deduction, benefit, etc.) is processed from [P2K_PR_FREQUENCIES]. ;[Cal|CALENDAR_CODE]:This field is used to associate ate Sundry Calendar from [IDCL] to a Sundry Line. This field is used: *when a sundry line has a 'Sundry Period to Date' maximum and the user needs to define the length of the period in the Sundry Calendar. *in any situation where a transaction re-occurs at an interval different than the pay period. *to place a maximum deduction amount during a period of time that is not the same as the Pay period. e.g. an employee has a monthly maximum deduction amount in a bi-weekly payroll. ;[Start Date|START_DATE]:This field shows the date that the sundry transaction commences. ;[End Date|END_DATE]:This field shows the date that the sundry transaction ends. ;[PC|PC_CODE]:A pay component code is a unique number code from 1 to 9,999 assigned to uniquely identify the pay component. Only pay components with the toggle ‘Enter Sundry’ turned on from the [IPPC] form will be accessible. ;[Abbreviation|PC_ABBREVIATION]:This field holds a short description of the pay component. This abbreviation will be printed on check and deposit statements, lists and pay registers. ;[Value|TIME_ENTERED]:This field shows the amount or value of the sundry item. Time_Entered needs to be completed if the pay component chosen is for time. ;[Basis|TIME_BASIS]:The basis is the unit of measure that the associated value is being stored or displayed in. ;:Time_Basis will default from the pay component set up but may be overridden. ;:When entering sundry lines, use ‘$’ (Amount) as the rate basis. DO NOT USE ‘PP’ (Pay Period) if the entered amount is for money. ;[Prorate|INCOME_PRORATION]:This field allows you to prorate the annual value of an employee’s sundry. e.g. An employee receives a $1,000 annual bilingual sundry. The employee only works for 3 months, with this toggle on, they will receive 1/4 of the salary. ;[History|ACT_VIEW_SUNDRY_HISTORY]:This button will open a view only dialog displaying the pay history. ;[Filter By|]: ;[Show All|ACT_SHOW_ALL]:If this toggle is ON, all sundries will be displayed. If this toggle is OFF, only active sundries will be displayed. \\ ---- !!Details tab By applying the PC rules of the pay component, you will derive all of the required values associated with the sundry line. These results will be displayed in the Sundry Line details. ;[PC|PC_CODE]:This field shows the pay component code(s) that default in from the Sundry transaction pay component code entered at the top of the screen. For example, if a deduction component is entered on the Sundry transaction then the deduction and declining balance pay component may be generated on the pay detail line. PC_Code will default from the PC entered on the sundry line but you make a selection from the LOV (F9) provided. ;[Abbreviation|PC_ABBREVIATION]:This field shows a short alpha description of the pay component. This abbreviation will be printed on check and deposit statements, lists and pay registers. PC_Abbreviation will default from the pay component chosen. The information in this tab is generated when the Sundry Line is saved. ;[Type|PC_DETAIL_TYPE]:This field indicates how the pay component amount is used. For example, the pay component may be used to store time, an amount, a limit, or a declining balance. PC_Detail_Type will default from the pay component but may be overridden. ;[Amount|AMOUNT]:This field shows the amount calculated as a result of applying the PC Calc Method. ;[Override|AMOUNT_OVERRIDE]:You may manually enter the amount to be used in the pay calculation into this field. Amount_Override will be populated by the system based on the pay component rules but may be overridden. ;[Description|DESCRIPTION]:This field provides a free form description of the sundry line. Description that will be system populated but you may manually enter. ;[Wage Rate|WAGE_RATE]:This field shows the wage rate derived from the pay component rule. Wage_Rate is calculated from the wage rate source then re-derived based on the basis indicated. ;[Wage Override|WAGE_RATE_OVERRIDE]:You may override the wage rate in this field. ;[Basis|RATE_BASIS]: The rate basis is the unit of measure that the associated rate is being stored or displayed in, for example, hourly, weekly, biweekly, semi-monthly, monthly, or annual. Rate_Basis will default a value from the pay component. ;[Rate Override|RATE_BASIS_OVERRIDE]:The rate basis is the unit of measure that the associated rate is being stored or displayed in, for example, hourly, weekly, biweekly, semi-monthly, monthly, or annual. Rate Basis may be overridden in the entry screen, or through the transaction loader process. Rate_Basis_Override that will be derived from the basis indicated on the sundry line but may be overridden. ;[Distribution DR|DISTRIBUTION_DR_MASK]:The distribution mask contains the distribution derived from the assignment, position, or job, overlaid by the distribution mask based on the debit GL code of the pay component. ;[Distribution CR|DISTRIBUTION_CR_MASK]:The distribution mask contains the distribution derived from the assignment, position, or job, overlaid by the distribution mask based on the credit GL code of the pay component. ;[User Variable|USER_VARIABLE_CODE]: This field shows the user variable that may be used according to the pay component details set up. ;[Override|USER_VARIABLE_OVERRIDE]:You may manually enter the user variable amount. For example, the user variable field may indicate a rate of 1.5 but for this particular transaction you may wish to enter 1.55. ;[Element|ELEMENT_CODE]:This field shows the element that is to be used according to the pay component details set up. Element_Code will default from a value from the pay component or be manually entered. ;[Action|PC_ACTION]:The PC Action determines whether a transaction item entered under this pay component will be accumulated to the total value of the pay component, replace a prior transaction item, trigger a user calculation, or suppress a user calculation. PC_Action will default from the pay component and may be overridden. ;[Rate Source|PC_RATE_SOURCE]:Indicates from where the wage rate is derived. ;:PC_Rate_Source will default from the pay component. ;[Calc Meth|PC_CALC_METHOD]:Indicates the method by which an amount is calculated. PC_Calc_Method will default from the pay component but may be overridden. \\ ---- !!Line Info tab ;[Position|POSITION_CODE]:This is the position code from the sundry’s assignment. Position_Code will default based on the sundry line but may be overridden. ;[Job|JOB_CODE]: This is the Job code from the sundry’s assignment. Job_Code will default based on the sundry line but may be overridden. ;[Jurisdiction|JURISDICTION_NAME]:This jurisdiction field is not currently being used. ;[User Calc|USER_CALC_CODE]:This field shows the UserCalc that may be attached to the pay component chosen. ;[Pay Point Type|PAY_POINT_TYPE]:This field indicates when this pay component needs to be picked up for processing during the pay calculation. Pay_Point_Type is a mandatory fixed lexicon ([X_PAY_POINT_TYPE]) that will default from the pay componentchosen for this sundry. ;[Seq.|PAY_POINT_SEQUENCE]:This field displays the unique sequence number assigned to each item processed in a pay point. Items processed in a pay point may include multiple pay lines, UserCalcs, Benefit Plans and Leave Policies. Pay_Point_Sequence will default from the pay component chosen for this pay line. ;[Reference|REFERENCE_INFO PSL]: This field allows you to enter a note or reference for the sundry. This reference information may be either anecdotal or more structured (e.g. Union Code or Court Number). If the Reference field on [IPPC] is defined as 'Enter Vendor Code', you will select a code from an LOV. If there is no link, you may use this field to provide a description directly on the [IPSN] screen.You will be able to enter up to 200 characters as reference on the pay lines. This entry will not be checked against values within any lexicon. ;[Sundry Type|SUNDRY_LINE_TYPE]:Indicates whether the sundry line is for a regular amount, an arrears amount, or a retro pay amount. ;[Times Used|TIMES_REMAINING]:The Times Used field is not currently being used. ;[Distribution|DISTRIBUTION_MASK]:This field holds the sundry’s overridden distribution mask applicable for all its sundry details within the DR and CR journal entry posting. You may use the Distribution Editor button to enter the Distribution. The Distribution button provides the predefined G/L Segment information. The values and descriptions come from the G/L Segment set up. As the values are manually entered or selections chosen from the LOV available the sections are concatenated together at the bottom of the form. ;[Work Order|WORK_ORDER]:Work Order is used to define work orders attached to a specific sundry. The Work Order Validation is defined on the ‘Define G/L Company’ ([IDGC]) form. The work order on each pay line can be unedited (no validation) or validated from an external system that has been pre-programmed. ;[Cost Center|COST_CENTER_CODE]:Cost Center is used to define a short cut for the cost center information attached to a specific sundry. ;[Pay Point Task|PAY_POINT_TASK]:A pay point task identifies the kind of process within the pay point. ;[WC Class|WCB_CLASS]:This field shows the Workers’ Compensation derived from the assignment indicated for this sundry line. WCB_Class will default from the assignment type indicated. ;[Audit Text|AUDIT_TEXT]:This field will display the exception text generated for this line. Audit_Text will be updated by the system. \\ ---- !!Premiums tab ;[Premium|PREMIUM_CODE]:This field will identify the premium associated with the sundry. ;[Rate|PREMIUM_RATE]:This field shows the premium rate that is used in the premium calculation. ;[Basis|RATE_BASIS]:The rate basis is the unit of measure that the associated rate is being stored or displayed in, for example, hourly, weekly, biweekly, semi-monthly, monthly, or annual. ;[Override Rate|PREMIUM_RATE]:Premium override rate you have entered that is used in the premium calculation. ;[Basis|RATE_BASIS]:The rate basis is the unit of measure that the associated rate is being stored or displayed in, for example, hourly, weekly, biweekly, semi-monthly, monthly, or annual. \\ ---- !!History tab This tab provides historical information regarding sundry transactions that have been processed through [IPPH].