Alias: IVPPL#

The INF_CV_SUNDRYLINES table is used to import pay transactions into the software data structures.

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
PAY_NUMBERNumber(5)NUMBER5Y
PAY_LINE_STATUSVarchar2(30)VARCHAR30Y
UNIT_CODEVarchar2(16)CODE
GROUP_CODEVarchar2(16)CODE
LEAVE_TYPE_CODEVarchar2(16)CODE
PLAN_CODEVarchar2(16)CODE
USER_CALC_CODEVarchar2(16)CODE
JOB_CODEVarchar2(16)CODE
DEPARTMENT_CODEVarchar2(16)CODE
POSITION_CODEVarchar2(16)CODE
ASSIGNMENT_START_DATEDate()DATE
ASSIGNMENT_CODEVarchar2(16)CODEY
PC_CODE_HEADERNumber(4)CODE NUMERIC
COUNTRY_CODEVarchar2(16)CODE
STATE_PROVINCE_CODEVarchar2(16)CODE
GEO_CODEVarchar2(16)CODE
PAY_POINT_TYPEVarchar2(30)VARCHAR30
PAY_POINT_TASKVarchar2(30)VARCHAR30
PAY_POINT_SEQUENCENumber(5)NUMBER5
START_DATEDate()DATE
END_DATEDate()DATE
JOURNALIZEDVarchar2(4)VARCHAR4
POSTED_EXPERIENCEVarchar2(4)VARCHAR4
POSTED_CAREER_PLANNINGVarchar2(4)VARCHAR4
POSTED_SAFETYVarchar2(4)VARCHAR4
POSTED_BENEFITSVarchar2(4)VARCHAR4
POSTED_ATTENDANCEVarchar2(4)VARCHAR4
WORK_IN_PROCESSVarchar2(4)VARCHAR4
AUDITEDVarchar2(4)VARCHAR4
TIME_ENTEREDNumber(18)AMT12V6
TIME_BASISVarchar2(30)VARCHAR30
STD_WAGE_RATENumber(18)AMT12V6
STD_WAGE_RATE_BASISVarchar2(30)VARCHAR30
PAY_LINE_SOURCEVarchar2(30)VARCHAR30
WCB_CLASSVarchar2(30)VARCHAR30
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
REFERENCE_INFOVarchar2(50)VARCHAR50
DETAIL_GENERATEDVarchar2(4)VARCHAR4
RATE_OVERRIDDENVarchar2(4)VARCHAR4
AUDIT_TEXT_HEADERVarchar2(4000)VARCHAR4000
ARREARS_COLLECTEDVarchar2(4)VARCHAR4
RETRO_PAYVarchar2(4)VARCHAR4
WORK_ORDERVarchar2(50)VARCHAR50
CONTRACT_CALENDAR_CODEVarchar2(16)CODE
TRANSACTION_POINTER_HEADERVarchar2(30)VARCHAR30
REASON_FOR_TIMEVarchar2(30)VARCHAR30
PC_CODE_DETAILNumber(4)CODE NUMERIC
ELEMENT_CODEVarchar2(16)CODE
USER_VARIABLE_CODEVarchar2(16)CODE
PREMIUM_CODEVarchar2(16)CODE
PAY_LINE_DETAIL_STATUSVarchar2(30)VARCHAR30
PC_ACTIONVarchar2(30)VARCHAR30
PC_DETAIL_TYPEVarchar2(30)VARCHAR30
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
AMOUNT_PROCESSEDNumber(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
RETRO_AMOUNTNumber(18)AMT12V6
AUDIT_TEXT_DETAILSVarchar2(4000)VARCHAR4000
STAT_CODEVarchar2(16)CODE
REFERENCE_IDNumber(10)NUMBER10
JOURNALIZED_BYVarchar2(30)VARCHAR30
WC_REGIST_TYPEVarchar2(30)VARCHAR30
WCB_CLASS_DETAILSVarchar2(30)VARCHAR30
ENTERED_VALUENumber(18)AMT12V6
ENTERED_VALUE_SOURCEVarchar2(50)VARCHAR50
TRANSACTION_POINTER_DETAILSVarchar2(30)VARCHAR30
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