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 / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
FREQUENCY_CODEVarchar2(16)CODEY
SUNDRY_LINE_TYPEVarchar2(30)VARCHAR30Y
START_DATEDate()DATEY
END_DATEDate()DATEY
PC_CODE_HEADERNumber(4)CODE NUMERICY
UNIT_CODEVarchar2(16)CODE
GROUP_CODEVarchar2(16)CODE
POSITION_CODEVarchar2(16)CODE
JOB_CODEVarchar2(16)CODE
LEAVE_TYPE_CODEVarchar2(16)CODE
PLAN_CODEVarchar2(16)CODE
USER_CALC_CODEVarchar2(16)CODE
COUNTRY_CODEVarchar2(16)CODE
STATE_PROVINCE_CODEVarchar2(16)CODE
GEO_CODEVarchar2(16)CODE
ASSIGNMENT_START_DATEDate()DATE
ASSIGNMENT_CODEVarchar2(16)CODEY
TIMES_REMAININGNumber(5)NUMBER5
PAY_POINT_TYPEVarchar2(30)VARCHAR30
PAY_POINT_TASKVarchar2(30)VARCHAR30
PAY_POINT_SEQUENCENumber(5)NUMBER5
TIME_ENTEREDNumber(18)AMT12V6
TIME_BASISVarchar2(30)VARCHAR30
WCB_CLASSVarchar2(30)VARCHAR30
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
REFERENCE_INFOVarchar2(50)VARCHAR50
AUDIT_TEXTVarchar2(4000)VARCHAR4000
WORK_ORDERVarchar2(50)VARCHAR50
COST_CENTER_CODEVarchar2(16)CODE
INCOME_PRORATIONVarchar2(4)VARCHAR4
CALENDAR_CODEVarchar2(16)CODE
PC_CODE_DETAILSNumber(4)CODE NUMERIC
PC_ACTIONVarchar2(30)VARCHAR30Y
PC_DETAIL_TYPEVarchar2(30)VARCHAR30Y
ELEMENT_CODEVarchar2(16)CODE
USER_VARIABLE_CODEVarchar2(16)CODE
PC_CALC_METHODVarchar2(30)VARCHAR30
DESCRIPTIONVarchar2(50)DESCRIPTION
WAGE_RATENumber(18)AMT12V6
WAGE_RATE_OVERRIDENumber(18)AMT12V6
RATE_BASISVarchar2(30)VARCHAR30
RATE_BASIS_OVERRIDEVarchar2(30)VARCHAR30
AMOUNTNumber(18)AMT12V6
AMOUNT_OVERRIDENumber(18)AMT12V6
USER_VARIABLE_OVERRIDENumber(18)AMT12V6
DISTRIBUTION_DR_MASKVarchar2(50)DISTRIBUTION
DISTRIBUTION_CR_MASKVarchar2(50)DISTRIBUTION
PC_RATE_SOURCEVarchar2(30)VARCHAR30
HIGHER_OF_RATEVarchar2(4)VARCHAR4
PAY_NUMBERNumber(5)NUMBER5
STAT_CODEVarchar2(16)CODE
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top