The Post Holdings CSV file allows you to import Employee Post Holding information to existing employee post holding records using the Pay Framework Upload.

The Post Holdings CSV file must be structured as follows:

Field No. Length Description
1 10

Employee number

The employee number to which subsequent data in the spreadsheet row applies. Must be a valid employee number

Mandatory
2 10

Post holding to update

Mandatory
3 10

Grade number

Mandatory if grade effective date exists
4 10

Grade effective date

Must be a valid date in the format DD/MM/YYYY

Mandatory if grade number exists
5 6

Grade reason for change

Must exist in the RSNCHG narrative category.

Optional
6 5

Spinal point

Mandatory if grade number exists and grade is spinal
7 10

Grade override date

Must be a valid date in the format DD/MM/YYYY

Optional
8 6

Grade override reason

Must exist in the RSNCHG narrative category.

Optional
9 5

Grade override step

Optional
10 10

Grade carry forward

Optional
11 10

Service condition

Optional
12 10

Service condition start date

Must be a valid date in the format DD/MM/YYYY

Optional
13 6

Position status

Must exist in the POSTPS narrative category.

Optional
14 10

Position status start date

Must be a valid date in the format DD/MM/YYYY

Optional
15 10

Work pattern

Optional
16 10

Work pattern start date

Must be a valid date in the format DD/MM/YYYY

Optional
17 6

Work pattern reason for change

Must exist in the RSNCHG narrative category

Mandatory if Work pattern exists
18 7

Contract hours

Optional
19 10

Contract hours start date

Must be a valid date in the format DD/MM/YYYY

Optional
20 7

Contract hours weeks per year

Optional
21 10

Location

Optional
22 10

Location start date

Must be a valid date in the format DD/MM/YYYY

Optional
23 6

Location change reason

Must exist in the RSNCHG narrative category

Mandatory if Location exists
24 70

Notes line 1

Optional
25 3

Work pattern offset

Optional
26 7

Number of contract hours to be worked

Optional
27 7

Number of weeks per year to be worked

Optional
28 7

Contract hours FTE

Optional
29 12

Basic grade salary amount or annual rate

The associated grade must have a basic salary pay element defined

Optional
30 1

Work pattern No Times indicator

Must be Y, N or blank

Optional
31 6

Occupancy type

Must exist in the OCCTYP narrative category

Optional
32 10

Projected end date of post holding

Must be a valid date in the format DD/MM/YYYY

Optional
33 1

Post grade HESA indicator

Must be Y, N, A or _ (to clear the indicator)

Optional
34 10

Post holding start date

Must be a valid date in the format DD/MM/YYYY to update an earlier occurrence of the post holding where the employee has occupied the post holding more than once

Leave blank to update latest occurrence of post holding

Optional