This is version 1 2 3 4 5 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Alias: IVPPRN#

The INF_CV_PAYRUNS table is used to import historical payroll information at a payrun level into the software data structures.

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID
ENTITY_CODE	Varchar2(16)	CODE	Y
PAY_RUN_NUMBER	Number(10)	NUMBER10	Y
USER_NAME	Varchar2(30)	VARCHAR30	Y
PAYROLL_CODE	Varchar2(16)	CODE	Y
PAY_POINT_SET_CODE	Varchar2(16)	CODE	Y
PAY_CALENDAR_CODE	Varchar2(16)	CODE	Y
PAY_PERIOD	Number(10)	NUMBER10	Y
PAY_RUN_STAGE	Varchar2(30)	VARCHAR30	Y
PAY_PERIOD_FUTURE	Number(10)	NUMBER10
COUNTRY_CODE	Varchar2(16)	CODE
BANK_TRANSIT_CODE	Varchar2(16)	CODE
BANK_ACCOUNT	Varchar2(30)	VARCHAR30
STARTING_NUMBER	Number(10)	NUMBER10
PAY_RUN_START_TIMESTAMP	Date()	TIMESTAMP
PAY_RUN_END_TIMESTAMP	Date()	TIMESTAMP
EMPLOYEE_COUNT	Number(5)	NUMBER5
REVERSAL_PAY_COUNT	Number(5)	NUMBER5
ADJUSTMENT_PAY_COUNT	Number(5)	NUMBER5
CURRENT_PAY_COUNT	Number(5)	NUMBER5
FUTURE_PAY_COUNT	Number(5)	NUMBER5
ADVANCE_PAY_COUNT	Number(5)	NUMBER5
BONUS_PAY_COUNT	Number(5)	NUMBER5
RETROACTIVE_PAY_COUNT	Number(5)	NUMBER5
DISBURSED	Varchar2(4)	VARCHAR4
TRIAL_RUN	Varchar2(4)	VARCHAR4
JOURNALIZED	Varchar2(4)	VARCHAR4
JOURNALIZED_FUND	Varchar2(4)	VARCHAR4
CREATE_DATE	Date()	DATE
CREATE_USER	Varchar2(30)	VARCHAR30
CHANGE_DATE	Date()	DATE
CHANGE_USER	Varchar2(30)	VARCHAR30