14.1 sp112_postings

This table records the history of an employee's assignments to each of the different teams. These allocations determine where the employee is displayed in the Gantt display, and also determines which users are allowed to allocate activities to the employee, or to update his personnel or skill details.

On any particular day, an employee may belong to only one team. On the same day, the employee may be on loan to one other team.

HouseKeeping

This table is tidied by sp_dbtidy's Global group

Table Definition

Field	Type	Default	Nullable
employee_no	number(9)
team_no	number(9)
posting_type	number(1)
start_date	date
end_date	date

Keys

primary key (employee_no, start_date)

foreign key (employee_no) references 14.1 sp210_employees (employee_no)

foreign key (team_no) references /wiki/spaces/SCH141/pages/27001323 (team_no)

foreign key (posting_type) references 14.1 sp286_posting_types (posting_type)

Column Descriptions

Field	Description
employee_no	Employee identifier.
team_no	Team identifier.
posting_type	Type of assignment: 0 - permanent 1 - loan
start_date	Date on which the assignment commences. Uses employee's Time Zone.
end_date	Date on which the assignment ends. If this column is null then the assignment is taken to continue indefinitely. Uses employee's Time Zone.