This is version 1 2 3 4 5 6 7 8 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Alias: IVSPM#

The INF_CV_PREMIUMS table is used to import premium codes and their attendant data into the software data structures. Premiums are additional or supplementary pay amounts that are made to employees over and above their base pay. Premiums are determined by unit

Table Columns#

Column name	Data Type / Size	Mand.	Notes
ID	Number(10)		Used internally to define a unique identification for the record. This field would not be loaded.
ENTITY_CODE	Varchar2(16)	Y
UNIT_CODE	Varchar2(16)	Y
PREMIUM_CODE	Varchar2(16)	Y
DESCRIPTION	Varchar2(50)
PREMIUM_TYPE_CODE	Varchar2(16)
PREMIUM_TYPE_SEQUENCE	Number(5)
EFFECTIVE	Date()	Y
EXPIRY	Date()
CHANGE_CODE	Varchar2(16)
PC_CODE_DOLLARS	Number(4)
PC_CODE_TIME	Number(4)
PREMIUM_CALC_RULE	Varchar2(30)	Y
RATE_BASIS	Varchar2(30)
PREMIUM_RATE	Number(18)
PREMIUM_PRORATED	Varchar2(4)
FREQUENCY_CODE	Varchar2(16)
PAY_POINT_TYPE	Varchar2(30)
PAY_POINT_SEQUENCE	Number(5)
REPLACEMENT_OPTION	Varchar2(4)
HIGHEST_RATE_OF_DAY	Varchar2(4)
PREMIUM_WAGE_SOURCE	Varchar2(30)
USER_VARIABLE_CODE	Varchar2(16)
CUSTOM_PREMIUM_LOGIC	Varchar2(30)
CREATE_DATE	Date()		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USER	Varchar2(30)		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATE	Date()		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USER	Varchar2(30)		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.