INF_CV_PAYRUNS
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 nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PAY_RUN_NUMBERNumber(10)NUMBER10Y
USER_NAMEVarchar2(30)VARCHAR30Y
PAYROLL_CODEVarchar2(16)CODEY
PAY_POINT_SET_CODEVarchar2(16)CODEY
PAY_CALENDAR_CODEVarchar2(16)CODEY
PAY_PERIODNumber(10)NUMBER10Y
PAY_RUN_STAGEVarchar2(30)VARCHAR30Y
PAY_PERIOD_FUTURENumber(10)NUMBER10
COUNTRY_CODEVarchar2(16)CODE
BANK_TRANSIT_CODEVarchar2(16)CODE
BANK_ACCOUNTVarchar2(30)VARCHAR30
STARTING_NUMBERNumber(10)NUMBER10
PAY_RUN_START_TIMESTAMPDate()TIMESTAMP
PAY_RUN_END_TIMESTAMPDate()TIMESTAMP
EMPLOYEE_COUNTNumber(5)NUMBER5
REVERSAL_PAY_COUNTNumber(5)NUMBER5
ADJUSTMENT_PAY_COUNTNumber(5)NUMBER5
CURRENT_PAY_COUNTNumber(5)NUMBER5
FUTURE_PAY_COUNTNumber(5)NUMBER5
ADVANCE_PAY_COUNTNumber(5)NUMBER5
BONUS_PAY_COUNTNumber(5)NUMBER5
RETROACTIVE_PAY_COUNTNumber(5)NUMBER5
DISBURSEDVarchar2(4)VARCHAR4
TRIAL_RUNVarchar2(4)VARCHAR4
JOURNALIZEDVarchar2(4)VARCHAR4
JOURNALIZED_FUNDVarchar2(4)VARCHAR4
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30

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