Defined Benefits Additional Member Registration Fields (Cell EH3 EN3) – – Format / Notional Cell Field Business Rules (if applicable) Business Definition Datatype Mandatory The pay period start date the member registration data relates to. This is the Member Registration DateItemType EH3 Max length = 10 date which is equal to each succeeding alternate ‘public service’ payday pay Period Start Date Allowable values Thursday from 5 July 1990 “0 – 9”, “–”, Format YYYY-MM-DD Mandatory The pay period end date the member registration data relates to. This is the Member Registration DateItemType Max length = 10 EI3 day before date which is equal to each ‘public service’ payday Pay Period End Date Allowable values “0 – 9”, “–”, succeeding alternate Wednesday from 4 July 1990. Format YYYY-MM-DD This is to denote an election of of This is used by employee’s ‘choice fund’. corporate funds (DB or Accumulation) to determine whether a member is part EJ3 Choice Flag Stringitemtype of the default fund or has elected a Choice Fund. Values are to be agreed between employer and fund. Effective Date of The date at which the most recent choice election (either to elect choice or EK3 Dateitemtype Choice return to default) occurred. Values could be set based on the Australian and New Zealand Standard Classification of Occupations (ANZSCO): 1 - Managers 2 - Professionals Superannuation Fund 3 - Technicians and Trades Workers Details Occupation EL3 NonNegativeIntegerItemType 4 - Community and Personal Service Occupation Code for Insurance purposes determined by the employee's duties Code for Insurance Workers Description 5 - Clerical and Administrative Workers 6 - Sales Workers 7 - Machinery Operators and Drivers 8 Labourers – Flag for Contractors to indicate whether the contract length is greater than or Contract length Stringitemtype Must be set to either or equal to 12 months in order to determine the correct insurance. ‘Yes’ ‘No’. EM3 greater than 12 (booleanItemtype) Yes = Contract period of 12 months or more months No = Contract period of less than 12 months To correctly capture contract length that determines insurance cover as insurance cover can differ based on whether the contract is less than 12
Defined Benefits – Additional Member Registration Fields (Cell EH3 – EN3) Cell Field Format / Notional Datatype Business Rules (if applicable) Business Definition EH3 Member Registration pay Period Start Date DateItemType Mandatory Max length = 10 Allowable values “0 – 9”, “–”, Format YYYY-MM-DD The pay period start date the member registration data relates to. This is the ‘public service’ payday date which is equal to each succeeding alternate Thursday from 5 July 1990 EI3 Member Registration Pay Period End Date DateItemType Mandatory Max length = 10 Allowable values “0 – 9”, “–”, Format YYYY-MM-DD The pay period end date the member registration data relates to. This is the day before ‘public service’ payday date which is equal to each succeeding alternate Wednesday from 4 July 1990. EJ3 Choice Flag Stringitemtype This is to denote an employee’s election of ‘choice of fund’. This is used by corporate funds (DB or Accumulation) to determine whether a member is part of the default fund or has elected a Choice Fund. Values are to be agreed between employer and fund. EK3 Effective Date of Choice Dateitemtype The date at which the most recent choice election (either to elect choice or return to default) occurred. EL3 Superannuation Fund Details Occupation Code for Insurance Description NonNegativeIntegerItemType Values could be set based on the Australian and New Zealand Standard Classification of Occupations (ANZSCO): 1 - Managers 2 - Professionals 3 - Technicians and Trades Workers 4 - Community and Personal Service Workers 5 - Clerical and Administrative Workers 6 - Sales Workers 7 - Machinery Operators and Drivers 8 – Labourers Occupation Code for Insurance purposes determined by the employee's duties EM3 Contract length greater than 12 months Stringitemtype (booleanItemtype) Must be set to either ‘Yes’ or ‘No’. Yes = Contract period of 12 months or more No = Contract period of less than 12 months Flag for Contractors to indicate whether the contract length is greater than or equal to 12 months in order to determine the correct insurance. To correctly capture contract length that determines insurance cover as insurance cover can differ based on whether the contract is less than 12
SuperStream_alternative_file_format_(SAFF)_v0.12_draft_4-4-17.docx