Alias: IVPSL#

The INF_CV_SUNDRYLINES table is used to import miscellaneous and sundry transactions into the software data structures. Sundry transaction lines are transactions, usually of recurring nature, that are not attached to a specific pay period and that have a processing frequency associated with them.

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10)
ENTITY_CODEVarchar2(16)Y
PERSON_CODEVarchar2(16)Y
HIRE_DATEDate()
FREQUENCY_CODEVarchar2(16)Y
SUNDRY_LINE_TYPEVarchar2(30)Y
START_DATEDate()Y
END_DATEDate()Y
PC_CODE_HEADERNumber(4)Y
UNIT_CODEVarchar2(16)
GROUP_CODEVarchar2(16)
POSITION_CODEVarchar2(16)
JOB_CODEVarchar2(16)
LEAVE_TYPE_CODEVarchar2(16)
PLAN_CODEVarchar2(16)
USER_CALC_CODEVarchar2(16)
COUNTRY_CODEVarchar2(16)
STATE_PROVINCE_CODEVarchar2(16)
GEO_CODEVarchar2(16)
ASSIGNMENT_START_DATEDate()
ASSIGNMENT_CODEVarchar2(16)Y
TIMES_REMAININGNumber(5)
PAY_POINT_TYPEVarchar2(30)
PAY_POINT_TASKVarchar2(30)
PAY_POINT_SEQUENCENumber(5)
TIME_ENTEREDNumber(18)
TIME_BASISVarchar2(30)
WCB_CLASSVarchar2(30)
DISTRIBUTION_MASKVarchar2(50)
REFERENCE_INFOVarchar2(50)
AUDIT_TEXTVarchar2(4000)
WORK_ORDERVarchar2(50)
COST_CENTER_CODEVarchar2(16)
INCOME_PRORATIONVarchar2(4)
CALENDAR_CODEVarchar2(16)
PC_CODE_DETAILSNumber(4)
PC_ACTIONVarchar2(30)Y
PC_DETAIL_TYPEVarchar2(30)Y
ELEMENT_CODEVarchar2(16)
USER_VARIABLE_CODEVarchar2(16)
PC_CALC_METHODVarchar2(30)
DESCRIPTIONVarchar2(50)
WAGE_RATENumber(18)
WAGE_RATE_OVERRIDENumber(18)
RATE_BASISVarchar2(30)
RATE_BASIS_OVERRIDEVarchar2(30)
AMOUNTNumber(18)
AMOUNT_OVERRIDENumber(18)
USER_VARIABLE_OVERRIDENumber(18)
DISTRIBUTION_DR_MASKVarchar2(50)
DISTRIBUTION_CR_MASKVarchar2(50)
PC_RATE_SOURCEVarchar2(30)
HIGHER_OF_RATEVarchar2(4)
PAY_NUMBERNumber(5)
STAT_CODEVarchar2(16)
CREATE_DATEDate()
CREATE_USERVarchar2(30)
CHANGE_DATEDate()
CHANGE_USERVarchar2(30)
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top