T5Q_SUPERSTREAM

Super Stream Master Table | #transactional | Component: Australia
Column Name Description
MANDT Client
RUNID HR B2A: Global Object ID
PERNR Personnel Number
SRNO Super Stream Unique running sequence number
Column Name Description
💲 Currency Key (T500C.WAERS):
PYAMT Super Stream Payment Amount
SAGAM Employer Super Annuation Guarantee Amount
AWDAM Employer Contributions Award Or Productivity Amount
PCONT Employee Personal Contributions Amount
SALSC Employer Contributions Salary Sacrificed Amount
VOLAM Employer Voluntary contribution amount
SPCON Spouse Contribution Amount
CHCON Child Contribution Amount
OTCON Third Party Contribution Amount
ANBEN Annual Salary for Benefits Amount
ANCON Annual Salary for Contributions Amount
AINAM Annual Salary for Insurance Amount
MPRTX Defined Benefit Member Pre Tax Contribution
MPOTC Defined Benefit Member Post Tax Contribution
DBERC Defined Benefit Employer Contribution
NMPRT Defined Benefit Notional Member Pre Tax Contribution
NMPOT Defined Benefit Notional Member Post Tax Contribution
NOERC Defined Benefit Notional Employer Contribution
ORTER Ordinary Time Earnings
APSWE Actual Periodic Salary or Wages Earned
SUAPD Superannuable Allowances Paid
NSUAP Notional Superannuable Allowances
ANSA1 Defined Benefit Annual Salary 1
ANSA2 Defined Benefit Annual Salary 2
ANSA3 Defined Benefit Annual Salary 3
ANSA4 Defined Benefit Annual Salary 4
ANSA5 Defined Benefit Annual Salary 5
ADICP ADIC Payment
NADIC Negative ADIC Payment
NEPSC Negative Employer Productivity Superannuation Contribution
NEMCO Negative Member Contribution
Column Name Description
Column Name Description
BONDT Off-cycle payroll payment date
PAYDT Pay date for payroll result
SDATE Date of updation of Record
STIME Time of update of record
TRNDT Payment Date
BDATE Date of Birth
EMPEN Employee Employment End date
PSTDT Pay Period Start Date
PENDT Pay Period End Date
EMSTD Employment Start Date
ACONS Super Contribution Start Date
ACONE Super Contribution End Date
FNDRG Super Fund Registration Date
COSDT Super Contribution Commence Date
COEDT Super Contribution Cease Date
SERED Service Fraction Effective Date
DSERS Service Fraction Start Date
DSERE Service Fraction End Date
EMPRS Defined Benefit Employer Rate Start Date
EMPRE Defined Benefit Employer Rate End Date
MERAS Defined Benefit Member Rate Start Date
MERAE Defined Benefit Member Rate End Date
ANSD1 Defined Benefit Annual Salary 1 Start Date
ANSE1 Defined Benefit Annual Salary 1 End Date
ANSD2 Defined Benefit Annual Salary 2 Start Date
ANSE2 Defined Benefit Annual Salary 2 End Date
ANSD3 Defined Benefit Annual Salary 3 Start Date
ANSE3 Defined Benefit Annual Salary 3 End Date
ANSD4 Defined Benefit Annual Salary 4 Start Date
ANSE4 Defined Benefit Annual Salary 4 End Date
ANSD5 Defined Benefit Annual Salary 5 Start Date
ANSE5 Defined Benefit Annual Salary 5 End Date
LWPCS Leave Without Pay Code Start Date
LWPCE Leave Without Pay Code End Date
ASIED Annual Salary for Insurance Effective Date
ASBED Annual Salary for Benefits Effective Date
EMSED Employee Status Effective Date
EBEND Employee Benefit Category Effective Date
DEMLS Employee Location Identifier Start Date
DEMLE Employee Location Identifier End Date
PTHED Part Time Hours Effective Date
MRPSD Member Registration Pay Period Start Date
MRPED Member Registration Pay Period End Date
Column Name Description
STATUS Status of Record Show values
PAYTY Payroll type Show values
NEGSP Negatives Supported Show values
LWPCD Leave Without Pay Code Show values
Column Name Description Domain name
SEQNR Sequence Number NUM5
IABKRS Payroll Area ABKRS
INPER In-period for payroll CHAR6
FPPER For-period for garnishment PRIOD
PAYID Payroll Identifier CHAR1
SUSER User Name UNAME
PRN2 Payment Reference Number
FCODE Superannuation Fund Code SUBTY_591A
FILID FILE ID CHAR50
BUKRS Company Code BUKRS
LINID LINE ID NUMC8
SOUID Source Entity ID NUMC11
SOENT Source Entity ID Type CHAR41
SOADD Source Electronic Service Address CHAR120
ERMSG Electronic Error Messaging CHAR10
SEABN HR AU: Super Stream Source ABN NUM11
SORGN Sender Organization Name CHAR120
SFNAM Sender Family Name CHAR40
SGNAM Sender Given Name CHAR40
SONAM Sender Other Given Name CHAR40
SEMAL Sender E-mail Address Text CHAR120
STELN Telephone Contact Number CHAR10
PAABN Payer ABN NUM11
PORGN Payer Organization Name
PABSB Bank State Branch Number CHAR15
PAACN Financial Institution Account Number CHAR20
PACNT Financial Institution Account Name CHAR40
PYABN HR AU: Super Stream Target ABN NUM11
PYUSI Unique Superannuation Identification Number CHAR14
PYORG Fund Organization Name
PYTAD End Point URL CHAR120
PYMTH Payment Method CHAR15
PRNUM Payment Reference Number
BPAYC BPay Biller Code CHAR10
PYBSB Bank State Branch Number CHAR15
PYACN Financial Institution Account Number CHAR20
PYACT Financial Institution Account Name CHAR40
ERABN Employer ABN NUM11
LOCID Location ID CHAR20
EORGN Employer Organizational Name Text
FNDGE Superannuation Fund Generated Employer Identifier P13Q_EMPLR
TAXFN Tax File Number (TFN) P13Q_TAXFN
NTITL Person Name Title Text TITEL
NSUFX Person Name Suffix text TITEL
PFNAM Member Family Name CHAR40
PGNAM Member Given Name CHAR40
PONAM Member Other Given Name CHAR40
SEXCD Sex Code CHAR7
ADRCO Address Usage Code CHAR4
ADDL1 Address Details Line 1 Text CHAR70
ADDL2 Address Details Line 2 Text CHAR70
ADDL3 Address Details Line 3 Text CHAR70
ADDL4 Address Details Line 4 Text CHAR70
LOCNM Locality Name Text CHAR70
PSTCD Postal Code PSTLZ
STACO State or Territory Code CHAR70
CNTRY Country/Region Key LAND1
MEMAL E-mail Address CHAR120
MEMTL Member Telephone Minimal Number Landline
MEMMB Member Telephone Minimal Number Mobile
MEMID Member Client Identifier P13Q_MEMNO
PAYNO Payroll Number Identifier PERSNO
EMPET Employment End Reason Text TEXT30
ATWRK At Work Indicator CHAR7
WHRSW Weekly Hours Worked Number DEC3_2
OCCUD Occupation Description CHAR40
INSIN Insurance Opt Out Indicator CHAR10
BENCT Benefit Category CHAR120
EMPST HR AU: Employment Status Of Employee CHAR20
MEMRT Member Registration Text CHAR40
SERFR Service Fraction P13_SERFR
FUTHR Full Time Hours P13_FTH
CONHR Contracted Hours P13_FTH
ACHRP Actual Hours Paid P13_FTH
EMLOC Employee Location Identifier CHAR20
DSERF Defined Benefits Registration Service Fraction P13_SERFR
EMPRT Defined Benefit Employer Rate DEC03_2
MERAT Defined Benefit Member Rate DEC03_2
DEMLC Employee Location Identifier CHAR20
CODUD Contribution Due Days NUM01
FULTH Full Time Hours DEC03_2
PARTH Part Time Hours DEC03_2