INF_CV_SUNDRYLINES
Back to current versionRestore this version

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)

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