Alias: IVPPRN#

(INF_CV_PAYRUNS)
Pay Runs

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