SAFF and SAFFE fields
The following table describes the fields that are in both SAFF and SAFFE file formats.
Column | Description | M (Mandatory) O (Optional) C (Clearing House) | Source | ||
|---|---|---|---|---|---|
A | Line No. | M | Starting at 1, and incrementing | ||
| B | Source Entity ID | M | Payroll ABN | ||
| C | Source Entity ID Type | M | Provided by Clearing House | ||
| D | Source Electronic Service Address | Provided by Clearing House | |||
| E | Electronic Error Messaging | Provided by Clearing House | |||
| F | ABN | M | Payroll ABN | ||
| G | Organisation Name | M | As per Supplier/Payer ABN screen | ||
| H | Family Name | M | ABN contact details as per Supplier/ABN screen | ||
| I | Given Name | M | ABN contact details as per Supplier/ABN screen | ||
| J | Other given name | O | ABN contact details as per Supplier/ABN screen | ||
| K | Email address | M | ABN contact details as per Supplier/ABN screen | ||
| L | Contact phone | M | ABN contact details as per Supplier/ABN screen | ||
| M | ABN | M | Payroll ABN | ||
| N | Organisation Name | M | As per Supplier/Payer ABN screen | ||
| O | Bank BSB | M | Bank Details from Bank Interface Code attached to ABN via Supplier/ABN screen | ||
| P | Account Number | M | Bank Details from Bank Interface Code attached to ABN via Supplier/ABN screen | ||
| Q | Account Name | M | Bank Details from Bank Interface Code attached to ABN via Supplier/ABN screen | ||
R | ABN | M | From the employee’s fund – held on the Superannuation Fund screen | ||
| S | USI | M | From the employee’s fund – held on the Superannuation Fund screen | ||
| T | Organisational Name Text | M | Provided by Clearing House (Super Fund Description) | ||
| U | Electronic Service Address | M | |||
| V | Payment Method Code | M | Provided by Clearing House | ||
| W | Transaction Date | C | Provided by Clearing House | ||
| X | Payment Reference Number | C | Provided by Clearing House | ||
| Y | BPAY Code | Not Used | |||
| Z | Payment Amount | M | Total contributions for employee | ||
AA | BSB | M | Super Funds Bank Details as per Superannuation Funds / Super Bank Details or provided by Clearing House | ||
AB | Account Number | M | Super Funds Bank Details as per Superannuation Funds / Super Bank Details or provided by Clearing House | ||
AC | Account Name | M | Super Funds Bank Details as per Superannuation Funds / Super Bank Details or provided by Clearing House | ||
| AD | ABN | M | Payroll ABN | ||
| AE | Location ID | O | |||
| AF | Organisation Name Text | M | As per Supplier/Payer ABN screen | ||
| AG | Super Fund Generated Employer ID | O | |||
| AH | TFN | O | Employee Tax File Number | ||
| AI | Person Name title | O | |||
| AJ | Person Name suffix | O | |||
| AK | Family Name | M | Employee Surname | ||
AL | Given Name | M | Employee Given Name | ||
| AM | Other Given Name | O | |||
| AN | Sex | M | |||
AO | Birth date | M | In the format YYYY-MM-DD | ||
AP | Address Usage Code | C | If the residential address is:
| ||
AQ | Address Line1 | M | Employee Address | ||
| AR | Address Line 2 | O | |||
| AS | Address Line 3 | O | |||
| AT | Address Line 4 | O | |||
| AU | Locality | M | If postcode = 9999 then blank | ||
| AV | Post Code | M | If postcode = 9999 then blank | ||
| AW | State | M | if postcode is 9999 ,output ‘OTH’ else | ||
AX | Country | If postcode is not equal “9999” then AU else Country code from control table for Country field | |||
AY | Email Address Text | O | Employee private email address if not blank else Employee business email address | ||
AZ | Phone landline | O | Employee contact number with area code (for example, 0723391670) Employee phone number | ||
| BA | Phone mobile | O | Employee’s private mobile number | ||
BB | Member Client Identifier | O | Membership No. from employee’s Super Fund Details screen.
| ||
| BC | Payroll Number | O | Employee Payroll | ||
| BD | Employment End Date | O | Termination Date if employee status is t | ||
| BE | Employment End Reason | O | Termination Reason if employee status is t | ||
| BF | Pay period start date | M | From date parameter format CCYY-MM-DD | ||
| BG | Pay period end date | M | Upto date parameter format CCYY-MM-DD | ||
BH | SG Amount | O | If the fund is not Defined Benefit (the user field 5 in Superannuation Funds screen is not y), then Sum of dollars for pay code for the fund with special type = R | ||
BI | Award/Productivity Amount | O | If the fund is not Defined Benefit (the user field 5 in Superannuation Funds screen is not y), then Sum of dollars for pay code for the fund with special type = X | ||
| BJ | Personal Contribution Amount | O | If the fund is not Defined Benefit (the user field 5 in Superannuation Funds screen is not y), then Sum of dollars for pay code for the fund with special type = E | ||
| BK | Sal Sac | O | If the fund is not Defined Benefit (the user field 5 in Superannuation Funds screen is not y), then Sum of dollars for pay code for the fund with special type = S and B | ||
BL | Voluntary | O | If the fund is not Defined Benefit (the user field 5 in Superannuation Funds screen is not y), then Sum of dollars for pay code for the fund in element sapc | ||
| BM | Spouse | O | Sum of dollars for pay code for the fund in element spse | ||
| BN | Child | O | Sum of dollars for pay code for the fund in element sacc | ||
| BO | Other Third Party | O | Sum of dollars for pay code for the fund in element satp |
SAFFE additional fields
The following table describes the additional fields that are only in the SAFFE file format.
Column | Description | M (Mandatory) O (Optional) C (Clearing House) | Source |
|---|---|---|---|
| BP | Employment Start Date | O | |
| BQ | At Work Indicator | O | |
| BR | Annual Salary for Benefit Amount | ||
| BS | Annual Salary for Contribution Amount | ||
| BT | Annual Salary for Contribution Effective start date | ||
| BU | Annual Salary for Contribution Effective end date | ||
BV | Annual Salary for Insurance Amount | If the employee is hourly paid, this shows their period salary. Otherwise, this field can be blank. | |
| BW | Weekly hours worked number | Calculate using base hour payroll frequency for employees payroll code. | |
| BX | Occupation Description | ||
| BY | Insurance Opt out indicator | In the employee’s Super Fund Details screen, if User Field 4 = y, output True else False | |
| BZ | Fund Registration Date | From the employee’s Super Fund Details screen | |
| CA | Benefit Category Text | Fund Category from the Employee’s Super Fund Details screen | |
| CB | Employent Status Code | Employment Condition (Employee Position Information Screen) | |
| CC | Super Contribution Commence Date | ||
| CD | Super Contribution Cease Date | ||
| CE | Member Registration Amendment Reason TExt | ||
| CF | Defined Benefit Member pre tax Contribution | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y), then Sum of dollars for pay code for the fund with special type = S and B | |
| CG | Defined Benefit Member post tax Contribution | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y), then Sum of dollars for pay code for the fund with special type = E | |
| CH | Defined Benefit Employer Contribution | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y), then Sum of dollars for pay code for the fund with special type = R | |
| CI | Defined Benefit Notional Member Pre tax contribution | ||
| CJ | Defined Benefit Notional Member Post tax contribution | ||
| CK | Defined Benefit Notional Employer contribution | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y), then Sum of dollars for pay code in the element sddf | |
CL | Ordinary Time Earnings | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y), Output value from pay element qote within the date range entered. | |
| CM | Actual Periodic Salary or Wages Earned | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y), Pick up the date effective period salary from the salary history screen for the employee/fund | |
| CN | |||
| CO | |||
| CP | Service Fraction | Taken from FTE% (Pay screen) | |
| CQ | Service Fraction Effective date | Date of earliest movement with value in CP field | |
| CR | Full Time Hours | ||
| CS | Contract Hours | ||
| CT | Actual Hours Paid | ||
| CU | Employee Location Identifier | ||
| CV | Service Fraction | Taken from FTE% (Pay screen) | |
| CW | Service Fraction Start Date | Date of earliest movement with value in CV field | |
| CX | Service Fraction End Date | ||
| CY | Defined Benefit Employer Rate | ||
| CZ | Defined Benefit Employer Rate Start Date | ||
| DA | Defined Benefit Employer Rate End Date | ||
| DB | Defined Benefit Member Rate | ||
| DC | Defined Benefit Member Rate Start Date | ||
| DD | Defined Benefit Member Rate End Date | ||
DE | Defined Benefit Annual Salary 1 | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y),
or
| |
DF | Defined Benefit Annual Salary 1 Start Date | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y),
The most recent data for the employee/fund.
| |
| DG | Defined Benefit Annual Salary 1 End Date | ||
DH | Defined Benefit Annual Salary 2 | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y), see DI field
or
| |
DI | Defined Benefit Annual Salary 2 Start Date | If the fund is Defined Benefit (user field 5 in Superannuation Funds screen = y),
The history prior to the most recent for the employee/fund.
| |
| DJ | Defined Benefit Annual Salary 2 End Date | ||
| DK | |||
| DL | |||
| DM | |||
| DN | |||
| DO | |||
| DP | |||
| DQ | |||
| DR | |||
| DS | |||
| DT | Leave Without Pay Pay Code | ||
| DU | Leave Without Pay Pay Code Start Date | ||
| DV | Leave Without Pay Pay Code End Date | ||
DW | Annual Salary for Insurance Effective Date | If employee is salaried, Date from of earliest movement where salary = BV field, If employee is h, then date of earliest movement where the employee is on the class/level selected in BV field | |
| DX | |||
| DY | Employee Status Effective Date | Date of earliest movement where value in field CB | |
| DZ | |||
| EA | Employee location Identifier |
© 2023 Fusion5. All rights reserved.
