IVPPRN
Back to current versionRestore this version

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.
INF_CV_PAYRUNS|ENTITY_CODE|Varchar2(16)|Y|
PAY_RUN_NUMBERNumber(10)Y
USER_NAMEVarchar2(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)