[{TableOfContents }] !!!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|ID]:This field identifies the event site record within the data base. !!!Alias: [IVTTP] (INF_CV_TEAMPOSTS) \\ Team Post Details !!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)|Y| |[WORK_STATION_CODE]|Varchar2(16)|Y| |[WORK_TEAM_CODE]|Varchar2(16)|Y| |[START_DATE]|Date()|Y| |[UNIT_CODE]|Varchar2(16)| | |[JOB_CODE]|Varchar2(16)| | |[DEPARTMENT_CODE]|Varchar2(16)| | |[STATION_POST_RANK]|Number(5)|Y| |[ACTING_TEAM_LEADER]|Varchar2(4)| | |[SCHEDULE_METHOD]|Varchar2(30)| | |[RELATIVE_START_DAY]|Number(5)| | |[EFFECTIVE]|Date()| | |[EXPIRY]|Date()| | |[CHANGE_CODE]|Varchar2(16)| | |[ASSIGNED_WSE]|Number(5)| | |[START_TIME]|Number(5)| | |[PERSON_CODE]|Varchar2(16)| | |[EMPLOYMENT_TYPE]|Varchar2(30)| | |[HIRE_DATE]|Date()| | |[ASSIGNMENT_START_DATE]|Date()| | |[ASSIGNMENT_CODE]|Varchar2(16)| | |[SHIFT_PATTERN_CODE]|Varchar2(16)| | |[SHIFT_PATTERN_START_DATE]|Date()| | |[COST_CENTER_CODE]|Varchar2(16)| | [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IVTTP] [{InsertPage page='Internal.IVTTP' default='Click to create a new discussion page'}] }]