Personal data file format

Generally, when doing a bulk take-on of new employees, you first load your data file using Employee personal data load.

The Employee personal data load also allows you to load (enhanced) demographics data and gender diversity data if your organisation uses either of these features.   In that case, see also demographics data file format and gender diversity data file format.

What file do I need to prepare?

You need to create a tab-delimited (.txt) file containing the required data.

    Information

    Remember to exclude column headings from the file.

    Here's the format to use.  An asterisk (*) shows which data is mandatory. 

    Column >
    A*
    B*C*
    D*
    E*
    F*
    G*H*I*J*K

    Employee Code
    Employee TitleEmployee Surname
    Employee Given NamesPreferred Name
    Birth Date
    Employee SexStatus Code
    Status Date
    Country of OriginCountry of Citizenship
    Characters >
    108403020
    91
    4
    9
    4
    1

    Must be zero filled to match the setting under Installation Constants.




    Format:

    ddmmyy

    ddMmmyy

    ddmmccyy

    ddMmmccyy


    Must be e for all employees
    Format:

    ddmmyy

    ddMmmyy

    ddmmccyy

    ddMmmccyy




    Column >
    L
    MN
    O
    P
    Q
    RST*
    UV

    Nationality 
    EthnicityIndigenous 
    Disability Category
    Honors 
    Date Comm (prior service) 
    External Admin UnitReference Number 
    Start Date (Date Commenced Agency)
    Date Permanent
    Date Confirmed
    Characters >
    4
    4
    1
    4
    10

    4
    35









    Format:

    ddmmyy

    ddMmmyy

    ddmmccyy

    ddMmmccyy



    Format:

    ddmmyy

    ddMmmyy

    ddmmccyy

    ddMmmccyy

    Format:

    ddmmyy

    ddMmmyy

    ddmmccyy

    ddMmmccyy

    Format:

    ddmmyy

    ddMmmyy

    ddmmccyy

    ddMmmccyy


    Column >
    W
    XY*
    Z
    AA*
    AB*
    ACADAE
    AFAG

    Probation Date
    NarrativePrivate Address 1
    Private Address 2
    Private Suburb (Private Address 3)
    Private Post CodePrivate NZ Mailtown/City & Fiji City

    Private NZ Post Code
    Private Country
    Private Phone Number
    Work Mobile
    Characters >

    40
    30
    3030
    102010202020

    Format:

    ddmmyy

    ddMmmyy

    ddmmccyy

    ddMmmccyy







    Required for NZ, otherwise n



    Required for NZ, otherwise n






    Column >
    AH
    AIAJ*
    AK
    AL*
    AM*
    ANAOAP
    AQ
    AR

    Private Email Address
    Private MobilePostal Address 1
    Postal Address 2
    Postal Suburb (Postal Address 3)
    Postal Post Code
    Postal NZ Mailtown/City & Fiji CityPostal NZ Post Code
    Postal Country
    Work Email Address
    Emergency Contact 1 (EC1) Name
    Characters >
    64
    2030303010
    20
    102064
    30









    Required for NZ, otherwise n


    Column >
    AS
    ATAU
    AV
    AW
    AX
    AYAZBA
    BB
    BC

    EC1 Address 1
    EC1 Address 2EC1 Suburb (EC1 Address 3)
    EC1 Post Code
    EC1 Country
    EC1 Phone Number
    EC1 RelationshipEC1 Work NumberEC1 Mobile NumberEmergency Contact (EC2) Name
    EC2 Relationship
    Characters >
    30
    3030
    101020420
    20304


    Column >
    BD
    BEBF
    BG
    BH
    BI
    BJBKBL
    BM
    BN

    EC2 Phone Number
    EC2 Work NumberEC2 Mobile Number
    EC2 Address 1
    EC2 Address 2
    EC2 Suburb (EC2 Address 3) 
    EC2 Post CodeEC2 CountryUser field 1
    User field 2
    User field 3
    Characters >
    20
    20203030
    301010303030


    Column >
    BO
    BPBQ
    BR
    BS
    BT
    BU
    BVBW
    BX
    BY

    User field 4
    User field 7User Field 8
    Next of Kin Name (3)
    Next of Kin Relationship (3)
    Next of Kin Phone No (3)
    Next of Kin Work Phone (3)
    Next of Kin Mobile (3)
    Next of Kin (3) Address 1
    Next of Kin (3) Address 2
    Next of Kin Suburb (3)
    Characters >
    30
    101530
    4
    2020203030
    30


    Column >
    BZ
    CA
    CB
    CC
    CD
    CE
    CF
    CG

    Next of Kin Post Code (3)
    Next of Kin Country (3)ESS Access (y/n)
    Employee User Name
    Alternate ESS Template
    Previous BMS id
    Previous Emp Code
    Gender Information
    Characters >
    10
    1013045050200



    Enter y or n.

    Will default to n.








    Next topic

    Demographics data file format






    © 2023 Fusion5. All rights reserved.