IVPPRN
Back to current versionRestore this version

Table of Contents

CANADIAN PAY RUN INTERFACE FILE#

The Canadian Pay Run Interface File screen is used to import historical payroll information at a payrun level into the software data structures.

Canadian Pay Run Interface File data is maintained on the INF_CV_PAYRUNS table.

ID
This field uniquely identifies the Canadian pay run record within the data base.
|Varchar2(16)|Y|
|Number(10)|Y|
|Varchar2(30)|Y|
PAYROLL_CODEVarchar2(16)Y
PAY_POINT_SET_CODEVarchar2(16)Y
PAY_CALENDAR_CODEVarchar2(16)Y
PAY_PERIODNumber(10)Y
PAY_RUN_STAGEVarchar2(30)YValidation: Must be one of the fixed lexicon values from X_PAY_RUN_STAGE
PAY_PERIOD_FUTURENumber(10)
COUNTRY_CODEVarchar2(16)
BANK_TRANSIT_CODEVarchar2(16)
BANK_ACCOUNTVarchar2(30)
STARTING_NUMBERNumber(10)
PAY_RUN_START_TIMESTAMPDate() Validation: Must be a valid date.
PAY_RUN_END_TIMESTAMPDate() Validation: Must be a valid date.
EMPLOYEE_COUNTNumber(5)
REVERSAL_PAY_COUNTNumber(5)
ADJUSTMENT_PAY_COUNTNumber(5)
CURRENT_PAY_COUNTNumber(5)
FUTURE_PAY_COUNTNumber(5)
ADVANCE_PAY_COUNTNumber(5)
BONUS_PAY_COUNTNumber(5)
RETROACTIVE_PAY_COUNTNumber(5)
DISBURSEDVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
TRIAL_RUNVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
JOURNALIZEDVarchar2(4)
JOURNALIZED_FUNDVarchar2(4)

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation