This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 . It is not the current version, and thus it cannot be edited.

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_NUMBER	Number(10)	Y
USER_NAME	Varchar2(30)	Y
PAYROLL_CODE	Varchar2(16)	Y
PAY_POINT_SET_CODE	Varchar2(16)	Y
PAY_CALENDAR_CODE	Varchar2(16)	Y
PAY_PERIOD	Number(10)	Y
PAY_RUN_STAGE	Varchar2(30)	Y	Validation: Must be one of the fixed lexicon values from X_PAY_RUN_STAGE
PAY_PERIOD_FUTURE	Number(10)
COUNTRY_CODE	Varchar2(16)
BANK_TRANSIT_CODE	Varchar2(16)
BANK_ACCOUNT	Varchar2(30)
STARTING_NUMBER	Number(10)
PAY_RUN_START_TIMESTAMP	Date()		Validation: Must be a valid date.
PAY_RUN_END_TIMESTAMP	Date()		Validation: Must be a valid date.
EMPLOYEE_COUNT	Number(5)
REVERSAL_PAY_COUNT	Number(5)
ADJUSTMENT_PAY_COUNT	Number(5)
CURRENT_PAY_COUNT	Number(5)
FUTURE_PAY_COUNT	Number(5)
ADVANCE_PAY_COUNT	Number(5)
BONUS_PAY_COUNT	Number(5)
RETROACTIVE_PAY_COUNT	Number(5)
DISBURSED	Varchar2(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_RUN	Varchar2(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
JOURNALIZED	Varchar2(4)
JOURNALIZED_FUND	Varchar2(4)