[{TableOfContents }] !!!DISBURSEMENTS INTERFACE FILE The Disbursements Interface File screen is used to import historical employee payroll information at a disbursement level into the software data structures. Disbursements Interface File data is maintained on the [INF_CV_DISBURSEMENTS] table. ;[ID|ID]:This field uniquely identifies the disbursement record within the data base. ;[Entity|ENTITY_CODE]:This field identifies the entity associated with the disbursement record. ;[Person Code|PERSON_CODE]:This field identifies the person associated with the disbursement record. ;[Employment Type|EMPLOYMENT_TYPE]:This field identifies the employment type associated with the disbursement record. ;[Date of Hire|HIRE_DATE]:The date the associated person was hired will be displayed in this field. ;[Pay #|PAY_NUMBER]:This field displays the pay # for the disbursement. ;[Pay Issue Date|PAY_ISSUE_DATE]:This field displays the date the disbursements were issued. ;[Distribution Amount|DISBURSEMENT_AMOUNT]:This field displays the total dollar amount of the disbursement. ;[Pay Destination|PAY_DESTINATION]: ;[Country Name|COUNTRY_CODE]: ;[Bank Transit|BANK_TRANSIT_CODE]:The transit number of the bank where this deposit is being made is shown in this field. ;[Bank Account|BANK_ACCOUNT]:This field shows the dollar amount of the deposit being made. ;[Starting Number|STARTING_NUMBER]: ;[Check #|CHECK_NUMBER]:This field displays the check number of the check issued with this pay period. ;[Check Amount|CHECK_AMOUNT]:This field shows the dollar amount of the check. ;[Check Status|CHECK_STATUS]:This field indicates the status of the check. ;[Check Type|CHECK_TYPE]:This field categorizes the check into a specific type. ;[Pay to the Order of|PAID_TO_ORDER_OF]:This field indicates to whom the check is issued. ;[Clear Amount|CLEAR_AMOUNT]: ;[Date Cleared|CLEAR_DATE]:The date that the check was cleared will be displayed in this field. ;[Check Printed|CHECK_PRINTED]:This field indicates if the check has been printed. ;[Previous Outstanding|PREVIOUS_OUTSTANDING]: ;[Reconcile Date|RECONCILE_DATE]:The date that the check was reconciled will be displayed in this field. ;[Override Check Date|OVERRIDE_CHECK_DATE]: [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IVPDS] [{InsertPage page='Internal.IVPDS' default='Click to create a new discussion page'}] }] ;[Pay #|PAY_NUMBER]:This field displays the pay # for the disbursement. ;[Pay Period|PAY_PERIOD]:This field displays the pay period for the disbursement. ;[Pay Category|PAY_CATEGORY_CODE]:This field displays the pay category for the disbursement. ;[Pay Run|PAY_RUN_NUMBER]:This field displays the pay run number for the disbursement. ;[Batch #|BATCH_NUMBER]:This field displays the batch number for the disbursement. ;[Pay Issued|PAY_ISSUE_DATE]:This field displays the date the disbursements were issued. ;[Disbursement Amount|DISBURSEMENT_AMOUNT]:This field displays the total dollar amount of the disbursement. ---- !!Checks tab This tab will display any checks associated with the pay date. The information here will be defaulted in from the [P2K_PR_CHECKS] table. ;[Check #|CHECK_NUMBER]:This field displays the check number of the check issued with this pay period. ;[Amount|CHECK_AMOUNT]:This field shows the dollar amount of the check. ;[Check Type|CHECK_TYPE]:This field categorizes the check into a specific type. *Computer Check *Hand Written Check *Replacement Check *Void Check ;[Check Status|CHECK_STATUS]:This field indicates the status of the check. ;[Paid to Order Of|PAID_TO_ORDER_OF]:This field indicates to whom the check is issued. ;[Cleared|CLEAR_DATE]:The date that the check was cleared will be displayed in this field. ;[Reconciled|RECONCILE_DATE]:The date that the check was reconciled will be displayed in this field. ;[Print|CHECK_PRINTED]:If this toggle is ON, the check has been printed. ---- !!Deposits tab ;[Deposit #|DEPOSIT_NUMBER]:This field will display the number of the deposit made during this pay period. ;[Account #|BANK_ACCOUNT]:The account where this deposit is being made to is displayed in this field. ;[Transit|BANK_TRANSIT_CODE]:The transit number of the bank where this deposit is being made is shown in this field. ;[Bank Name|BANK_NAME]:This field shows the name of the bank where this deposit is being made. ;[Amount|DEPOSIT_AMOUNT]:This field shows the dollar amount of the deposit being made. ;[Start Date|DEPOSIT_START_DATE]:This field shows the date this deposit was created. ;[Status|DEPOSIT_STATUS]:This field displays the status of the deposit. *Deposit Issued *Deposit Returned *Deposit Reversed ;[Pren. Date|PRENOTE_DATE]:The date for which this deposit is pre-noted will be displayed in this field. ;[Print|DEPOSIT_PRINTED]:If this toggle is ON, this deposit has been printed. ---- !!Earnings, Deduction, Benefit & Other tabs ;[PC|PC_CODE]:This field shows the [pay component|PAY COMPONENTS] being defined ;[Abbreviation|PC_ABBREVIATION]:The abbreviated name of this [pay component|PAY COMPONENTS] will be displayed in this field. ;[Rate|RATE]:This is the rate used to derive the amount in this [pay component|PAY COMPONENTS]. (If applicable) ;[Basis|RATE_BASIS]:This field shows the basis used for this rate. ;[Time|TIME]:This field shows the time associated with this [pay component|PAY COMPONENTS]. (If applicable) ;[Amount $|AMOUNT]:This field displays the calculated amount for this [pay component|PAY COMPONENTS]. ;[Current|CTD_VALUE]:This field shows this [pay component’s|PAY COMPONENTS] amount for the pay period. ;[Month|MTD_VALUE]:This field shows this [pay component’s|PAY COMPONENTS] amount for the month up to this pay period. ;[Quarter|QTD_VALUE]:This field shows this [pay component’s|PAY COMPONENTS] amount for the quarter up to this pay period. ;[Year|YTD_VALUE]:This field shows this [pay component’s|PAY COMPONENTS] year to date amount up to this pay period. ;[Fiscal|FTD_VALUE]:This field shows this [pay component’s|PAY COMPONENTS] amount for the fiscal up to this pay period. ---- !!Notes tab The Notes tab will display any associated messages. ;[Note Type|NOTE_TYPE_CODE]:If the notes are to show on your disbursements, you must select ‘[UPDISB]’ as the Note Type. ;[Note Text|NOTE_TEXT]:This field is used to hold the actual message that will appear on the disbursement. ---- !!Invoices TAB This tab will show payments made to vendor invoices. The vendor is assigned an ‘employee number’ so they may be added to a vendor payroll. ;[Person Code|PERSON_CODE]:This field will identify any employee (by their employee number) from whom a deduction was taken for the vendor invoice. ;[Last Name|LAST_NAME]: The last name of the employee is displayed. ;[First Name|FIRST_NAME]:The first name of employee is displayed. ;[Invoice Number|INVOICE_NUMBER]:The invoice being paid with this disbursement will be indicated in this field. ;[Date|START_DATE]:The date of the invoice is provided in this field. ;[Period Start Date|PAY_PERIOD_START_DATE]:The first day of the pay period will be indicated here. ;[Period End Date|PAY_PERIOD_END_DATE]:The last day of the pay period will be indicated here. ;[Pay Issue Date|PAY_ISSUE_DATE]:The date indicated here is the pay issue date of the employee pay. ;[Pay Run Number|PAY_RUN_NUMBER]:This field displays the pay run number of the employee pay. ;[PC|PC_CODE]:The [pay component|PAY COMPONENTS] associated with the vendor deduction. ;[Abbreviation|PC_ABBREVIATION]:The abbreviated description of the [pay component|PAY COMPONENTS] will be shown here. ;[Amount|INVOICE_AMOUNT]:The total amount of the employee deduction will be shown here. ;[Invoice Reference|INVOICE_REFERENCE]:This field holds the invoice number associated with the employee deduction. ---- !!Accruals tab The Accruals tab displays the attendance leave accrual values for the employee for the disbursement record. These records are ‘as of’ the last pay calculated, when there are multiple pays for a disbursement. ;[Pay Period|PAY_PERIOD]:This field shows the pay period for which these accruals are given. ;[End Date|PAY_PERIOD_END_DATE]:This field shows the end date of the pay period. ;[Pay #|PAY_NUMBER]:This field displays the pay number in the year for which the accruals are given. ;[Category|PAY_CATEGORY_CODE]:This field shows the category of pay. e.g. regular, replacement, future ;[Leave Type|LEAVE_TYPE_CODE]:This field displays the type of leave currently being viewed.e.g. sick, vacation, bereavement ;[Basis|LEAVE_POLICY_BASIS]:This field defines the time period (hour, day, week, year) used with the value provided in the previous field. ;[Description|DESCRIPTION]:A short description of the leave type is provided in this field. ;[Evaluation Date|EVALUATION_DATE]:This field shows the date in which the accruals were evaluated. ;[Prior Year Owing|PRIOR_YEAR_TIME_OWING]:This field shows any time left over from the previous year. ;[Prior Year Adjustment|PRIOR_YEAR_TIME_ADJ]:If an adjustment has been made to the prior year owing, that adjustment will be shown here. ;[Total Prior Year|DRV_TOTAL_TIME_OWING]:This field will display the sum of the prior year with any adjustments made to it. ;[Current Year Entitlement|CURR_YEAR_TIME_ENTITLEMENT]:This is the time entitlement for the current year. ;[Total Allowed|DRV_TOTAL_TIME_ALLOWED]:If there is a limit to the amount that can be taken, this field will show that amount. ;[Less Year Taken|CURR_YEAR_TIME_TAKEN]:This field shows the current amount taken this year. ;[Current Time Earned|CURR_TIME_EARNED]:This field defines the current amount of time the employee has earned for this leave. ;[Current Time Used|CURR_TIME_USED]:This field defines the current amount of time the employee has used for this leave. ;[Current Time Owing|CURR_TIME_OWING]:This is amount of time currently owning. ;[Term Time Owing|TERMINATION_TIME_OWING]:This is the time owed to the employee upon termination. ;[Prior Year Owing|PRIOR_YEAR_AMOUNT_OWING]:This field shows the dollar amount of any accrual from the previous year. ;[Prior Year Adjustment|PRIOR_YEAR_AMOUNT_ADJ]:If an adjustment needs to be made to the previous amount owing, that adjustment will be shown here. ;[Total Prior Year|DRV_TOTAL_AMOUNT_OWING]:This field will display the sum of the prior year dollar amount with adjustments made to it. ;[Current Year Earned|CURR_YEAR_AMOUNT_EARNED]:This field shows the dollar amount of the time earned during the current year. ;[Total Earned|DRV_TOTAL_AMOUNT_EARNED]:This is the total of the amount earned during the prior and current year. ;[Current Amount Owing|CURR_AMOUNT_OWING]:This is the dollar amount currently owing. ;[Term Amount Owing|TERMINATION_AMOUNT_OWING]:This is the amount owed to the employee upon termination