Table of Contents
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) |
