Post Turnover per Department {MISTAB-2}

This menu option describes movements in the post structure of Departments over a specific time period.

It gives an indication of the staff turnover in terms of appointments and resignations for the time period. However, the turnover is given against the background of the number of posts at the beginning of the period, the number of posts at the end of the period, total number of staff, and the total amount spent on salaries.

The data can be used to monitor or plan changes in the post establishment. Short Overview of this option and its use (mandatory).

The corresponding ORACLE View is named M13v_Dept_Posts_Turnover and it contains following columns:

A.    Request_Detail. The unique request number, user ID and the date when the particular set of data was generated.

B.    Request_Number. The unique request number.

C.    Heading_Line_1_Part_1.   This column contains a description of the type of data in the view.

D.    Heading_Line_1_Part_2. This column contains the parameters supplied by the user when the particular set of data was generated.

E.    Status_Field_Number_1. This column contains the number of records that were read, the number of errors and the number of
warnings encountered when the particular set of data was generated. The sequence is Records read: Errors: Warnings

F.    Row_Number. This column contains a row number for the set of data as stored on the database.

G.    Fact_School. The code of the Faculty or School indicated on the Department {GCS-4} as defined in {GCS-3}.

H.    Faculty_School_Name. The name of the Faculty or School indicated on the Department {GCS-4} as defined in {GCS-3}.

I.    Department_Code. The code of the Primary Department indicated on the Post definition {PACS-4b2} as defined in {GCS-4}

J.    Department_Name. The Name of the Primary Department indicated on the Post definition {PACS-4b2} as defined in {GCS-4}

K.    Post_Code. The code of the Post defined in {PACS-4b1}

L.    Post_Name. The description of the Post as defined in {PACS-4b1}.

M.    Post_Type_Code   indicated on the Post Definition in option {PACS-4b1} defined in {PACS-6}

N.    Post_Type_Name. Name of the Post Type Code indicated on the Post Definition in option {PACS-4b1} entered in {PACS-6}

O.    Posts_at_Start_Date. The number of active Posts at the start date.

P.    Posts_at_End_Date. The number of active Posts at the start date.

Q.    Personnel_at_Start_date. The number of Personnel at the Start Date.

R.    Appointments. The number of appointments made during the period.

S.    Resignations. The number of resignations during the period.

T.    Pers_more_than_1x_in_same_post. It is possible for a particular personnel member to be appointed more than once in the period
between the start- and end dates against the same post. The data in this column counts the number of cases that this happened.

U.    Gross_Remuneration. The gross amount spent on salaries (before tax), where the Cost Center is between the Start Cost Center and
the End Cost Center and the Account is between the Start Account and the End Account.

User Selection	Prompt Text ^{* an item between square brackets [ ] is the default answer}	Type & Length	Comments
	Start/End Date of Post	DD-MON-YYYY
	Faculty Code or ALL	N4
	Department Code or ALL	N4
	Cost Centre or ALL	A6
	Account Code or ALL	A8

Sort Order	Per	Comments
	None

System Select
	No special system selection

Example:

Processing Rules
	No special processing rules