IVTTP
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_EVENTSITES table.

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

Alias: IVTTP#

(INF_CV_TEAMPOSTS)

Team Post Details

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
WORK_DIVISION_CODEVarchar2(16)Y
WORK_AREA_CODEVarchar2(16)Y
WORK_STATION_CODEVarchar2(16)Y
WORK_TEAM_CODEVarchar2(16)Y
START_DATEDate()Y
UNIT_CODEVarchar2(16)
JOB_CODEVarchar2(16)
DEPARTMENT_CODEVarchar2(16)
STATION_POST_RANKNumber(5)Y
ACTING_TEAM_LEADERVarchar2(4)
SCHEDULE_METHODVarchar2(30)
RELATIVE_START_DAYNumber(5)
EFFECTIVEDate()
EXPIRYDate()
CHANGE_CODEVarchar2(16)
ASSIGNED_WSENumber(5)
START_TIMENumber(5)
PERSON_CODEVarchar2(16)
EMPLOYMENT_TYPEVarchar2(30)
HIRE_DATEDate()
ASSIGNMENT_START_DATEDate()
ASSIGNMENT_CODEVarchar2(16)
SHIFT_PATTERN_CODEVarchar2(16)
SHIFT_PATTERN_START_DATEDate()
COST_CENTER_CODEVarchar2(16)