This page (revision-13) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
13 26-Nov-2021 10:22 3 KB JMyers to previous
12 26-Nov-2021 10:22 6 KB JMyers to previous | to last
11 26-Nov-2021 10:22 6 KB JMyers to previous | to last
10 26-Nov-2021 10:22 6 KB JMyers to previous | to last
9 26-Nov-2021 10:22 6 KB JMyers to previous | to last
8 26-Nov-2021 10:22 6 KB JMyers to previous | to last
7 26-Nov-2021 10:22 5 KB JMyers to previous | to last
6 26-Nov-2021 10:22 5 KB JMyers to previous | to last
5 26-Nov-2021 10:22 5 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 2 changed one line
!!!EVENT SITE INTERFACE FILE
!!!TEAM POST INTERFACE FILE
At line 4 changed one line
The Event Site Interface File screen is used to import salary scales and steps into the software data structures.
The Team Post Interface File screen is used to import team posts into the software data structures.
At line 6 changed one line
Event Site Interface File data is maintained on the [INF_CV_EVENTSITES] table.
Team Post Interface File data is maintained on the [INF_CV_TEAMPOSTS] table.
At line 8 changed one line
;[ID|ID]:This field identifies the event site record within the data base.
;[ID|ID]:This field identifies the team post record within the data base.
;[|ENTITY_CODE]:
;[|WORK_DIVISION_CODE]:
;[|WORK_AREA_CODE]:
;[|WORK_STATION_CODE]:
;[|WORK_TEAM_CODE]:
;[|START_DATE]:
;[|UNIT_CODE]:
;[|JOB_CODE]:
;[|DEPARTMENT_CODE]:
;[|STATION_POST_RANK]:
;[|ACTING_TEAM_LEADER]:
;[|SCHEDULE_METHOD]:
;[|RELATIVE_START_DAY]:
;[|EFFECTIVE]:
;[|EXPIRY]:
;[|CHANGE_CODE]:
;[|ASSIGNED_WSE]:
;[|START_TIME]:
;[|PERSON_CODE]:
;[|EMPLOYMENT_TYPE]:
;[|HIRE_DATE]:
;[|ASSIGNMENT_START_DATE]:
;[|ASSIGNMENT_CODE]:
;[|SHIFT_PATTERN_CODE]:
;[|SHIFT_PATTERN_START_DATE]:
;[|COST_CENTER_CODE]:
At line 10 removed 3 lines
!!!Alias: [IVTTP]
(INF_CV_TEAMPOSTS)
\\
At line 14 removed 34 lines
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)| |