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

Back to current versionRestore this version

EVENT SITE INTERFACE FILE#

The Event Site Interface File screen is used to import salary scales and steps into the software data structures.

Event Site Interface File data is maintained on the INF_CV_SCALES table.

ID

This field identifies the event site record within the data base.

Alias: IVTES#

(INF_CV_EVENTSITES)

Event Sites

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
WORK_DIVISION_CODE	Varchar2(16)	Y
WORK_AREA_CODE	Varchar2(16)
WORK_STATION_CODE	Varchar2(16)
EVENT_SITE_CODE	Varchar2(16)	Y
JOB_NUMBER	Varchar2(30)	Y
INCEPTION_DATE	Date()	Y
EVENT_SITE_STATUS	Varchar2(30)
START_DATE	Date()	Y
END_DATE	Date()	Y
APPROVED	Varchar2(4)
DISTRIBUTION_MASK	Varchar2(50)
DESCRIPTION	Varchar2(50)
USER_OVERRIDE	Varchar2(4)
REFERENCE_INFO	Varchar2(2000)