INF_CV_PAYLINES
Back to current versionRestore this version

Alias: IVPPL#

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

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
ENTITY_CODEVarchar2(16)Y
PERSON_CODEVarchar2(16)Y
EMPLOYMENT_TYPEVarchar2(30)
HIRE_DATEDate()
PAY_NUMBERNumber(5)Y
PAY_LINE_STATUSVarchar2(30)Y
UNIT_CODEVarchar2(16)
GROUP_CODEVarchar2(16)
LEAVE_TYPE_CODEVarchar2(16)
PLAN_CODEVarchar2(16)
USER_CALC_CODEVarchar2(16)
JOB_CODEVarchar2(16)
DEPARTMENT_CODEVarchar2(16)
POSITION_CODEVarchar2(16)
ASSIGNMENT_START_DATEDate()
ASSIGNMENT_CODEVarchar2(16)Y
PC_CODE_HEADERNumber(4)
COUNTRY_CODEVarchar2(16)
STATE_PROVINCE_CODEVarchar2(16)
GEO_CODEVarchar2(16)
PAY_POINT_TYPEVarchar2(30)
PAY_POINT_TASKVarchar2(30)
PAY_POINT_SEQUENCENumber(5)
START_DATEDate()
END_DATEDate()
JOURNALIZEDVarchar2(4)
POSTED_EXPERIENCEVarchar2(4)
POSTED_CAREER_PLANNINGVarchar2(4)
POSTED_SAFETYVarchar2(4)
POSTED_BENEFITSVarchar2(4)
POSTED_ATTENDANCEVarchar2(4)
WORK_IN_PROCESSVarchar2(4)
AUDITEDVarchar2(4)
TIME_ENTEREDNumber(18)
TIME_BASISVarchar2(30)
STD_WAGE_RATENumber(18)
STD_WAGE_RATE_BASISVarchar2(30)
PAY_LINE_SOURCEVarchar2(30)
WCB_CLASSVarchar2(30)
DISTRIBUTION_MASKVarchar2(50)
REFERENCE_INFOVarchar2(50)
DETAIL_GENERATEDVarchar2(4)
RATE_OVERRIDDENVarchar2(4)
AUDIT_TEXT_HEADERVarchar2(4000)
ARREARS_COLLECTEDVarchar2(4)
RETRO_PAYVarchar2(4)
WORK_ORDERVarchar2(50)
CONTRACT_CALENDAR_CODEVarchar2(16)
TRANSACTION_POINTER_HEADERVarchar2(30)
REASON_FOR_TIMEVarchar2(30)
PC_CODE_DETAILNumber(4)
ELEMENT_CODEVarchar2(16)
USER_VARIABLE_CODEVarchar2(16)
PREMIUM_CODEVarchar2(16)
PAY_LINE_DETAIL_STATUSVarchar2(30)
PC_ACTIONVarchar2(30)
PC_DETAIL_TYPEVarchar2(30)
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)
AMOUNT_PROCESSEDNumber(18)
USER_VARIABLE_OVERRIDENumber(18)
DISTRIBUTION_DR_MASKVarchar2(50)
DISTRIBUTION_CR_MASKVarchar2(50)
PC_RATE_SOURCEVarchar2(30)
HIGHER_OF_RATEVarchar2(4)
RETRO_AMOUNTNumber(18)
AUDIT_TEXT_DETAILSVarchar2(4000)
STAT_CODEVarchar2(16)
REFERENCE_IDNumber(10)
JOURNALIZED_BYVarchar2(30)
WC_REGIST_TYPEVarchar2(30)
WCB_CLASS_DETAILSVarchar2(30)
ENTERED_VALUENumber(18)
ENTERED_VALUE_SOURCEVarchar2(50)
TRANSACTION_POINTER_DETAILSVarchar2(30)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.