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
IVTTP
IVTTP

Version management

Difference between version and

At line 1 changed 3 lines
!!!Alias: [IVTTP]
(INF_CV_TEAMPOSTS)
\\
[{TableOfContents }]
!!!TEAM POST INTERFACE FILE
At line 5 changed one line
Team Post Details
The Team Post Interface File screen is used to import team posts into the software data structures.
At line 7 changed 30 lines
!!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)| |
Team Post Interface File data is maintained on the [INF_CV_TEAMPOSTS] table.
At line 8 added 26 lines
;[ID|ID]:This field identifies the team post record within the data base.
;[Entity|ENTITY_CODE]:This field displays the entity associated with the team post.
;[Work Division|WORK_DIVISION_CODE]:This field displays the work division associated with the team post.
;[Work Area|WORK_AREA_CODE]:This field displays the work area associated with the team post.
;[Station|WORK_STATION_CODE]:This field displays the work station associated with the team post.
;[Work Team|WORK_TEAM_CODE]:This field is used to specify the work team for the station post.
;[Start Date|START_DATE]:The start date of the team is defined in this field.
;[Unit|UNIT_CODE]:This field displays the unit associated with the team post.
;[Job|JOB_CODE]:This field displays the job associated with the team post.
;[Department|DEPARTMENT_CODE]:This field displays the department associated with the team post.
;[Rank|STATION_POST_RANK]:This field indicates the order in which the replacement job being defined will fill the position. If a job is ranked as `1' it will be chosen as the first to fill this position, etc.
;[Acting Team Leader|ACTING_TEAM_LEADER]:This field indicates if the team leader is in an acting position.
;[Schedule Method|SCHEDULE_METHOD]:This field indicates the method of scheduling the teams post.
;[Relative Start Day|RELATIVE_START_DAY]:This field indicates which day of predefined shift a team would begin with.
;[Effective As Of|EFFECTIVE]/[Expires On|EXPIRY]:If the team post is time sensitive, the start and end date of the team post are defined in these fields.
;[Change Reason|CHANGE_CODE]:This field displays the ‘Change Reason’ code, which provides the rationale as to why information has been created or changed as of an effective date.
;[Assigned WSE|ASSIGNED_WSE]:This field specifies an assigned Work Shift Equivalent number for the team post.
;[Start Time|START_TIME]:The start date of the team is defined in this field.
;[Person Code|PERSON_CODE]:The individual associated with the team post is listed in this field.
;[Employment Type|EMPLOYMENT_TYPE]:The employment type associated with the team post is listed in this field.
;[Date of Hire|HIRE_DATE]:The date the employee was hired is listed in this field.
;[Start Date|ASSIGNMENT_START_DATE]:The start date of the assignment associated with the team post is listed in this field.
;[Assignment|ASSIGNMENT_CODE]:The assignment associated with the team post is listed in this field.
;[Shift Pattern|SHIFT_PATTERN_CODE]:This field displays the override shift pattern.
;[Shift Pattern Start Date|SHIFT_PATTERN_START_DATE]:The start date of the shift may be provided here.
;[Cost Center|COST_CENTER_CODE]:This field displays the override cost center.
At line 39 removed one line
[{If var='loginstatus' contains 'authenticated'
At line 42 changed 2 lines
![Discussion|Edit:Internal.IVTTP]
[{InsertPage page='Internal.IVTTP' default='Click to create a new discussion page'}]
![Notes|Edit:Internal.IVTTP]
[{InsertPage page='Internal.IVTTP' default='Click to create a new notes page'}]
At line 45 removed one line
}]
This page (revision-13) was last changed on 26-Nov-2021 10:22 by JMyersTop