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 / 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

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