PAY SuperStream Registration Report XBRL

Description
Categories: BI Publisher
Columns: Pai Reg Assignment Id, Employee Context Id, Pai Reg Tfn Not Provided, Pai Reg Tfn, Pai Reg First Name, Pai Reg Family Name, Pai Reg Middle Name, Pai Reg Title, Pai Reg Dob, Pai Reg Sex ...
Application: Payroll
Source: SuperStream Registration Report XBRL
Short Name: PYAUSUPREGI_XML
DB package: PAY_AU_SUPER_STREAM_ARCHIVE
SELECT PAI_REG.ASSIGNMENT_ID PAI_REG_ASSIGNMENT_ID,
       'EMPLOYEE'||PAI_REG.ACTION_INFORMATION6 EMPLOYEE_CONTEXT_ID,
       PAI_REG.ACTION_INFORMATION7 PAI_REG_TFN_NOT_PROVIDED,
       PAI_REG.ACTION_INFORMATION8 PAI_REG_TFN,
       PAI_REG.ACTION_INFORMATION9 PAI_REG_FIRST_NAME,
       PAI_REG.ACTION_INFORMATION10 PAI_REG_FAMILY_NAME,
       PAI_REG.ACTION_INFORMATION27 PAI_REG_MIDDLE_NAME,
       PAI_REG.ACTION_INFORMATION25 PAI_REG_TITLE,
       PAI_REG.ACTION_INFORMATION11 PAI_REG_DOB,
       PAI_REG.ACTION_INFORMATION12 PAI_REG_SEX,
       'RES' PAI_REG_ADDRESS_USAGE,
       PAI_REG.ACTION_INFORMATION13 PAI_REG_ADDRESS_LINE1,
       PAI_REG.ACTION_INFORMATION14 PAI_REG_ADDRESS_LINE2,
       PAI_REG.ACTION_INFORMATION15 PAI_REG_LOCALITY,
       PAI_REG.ACTION_INFORMATION16 PAI_REG_STATE,
       PAI_REG.ACTION_INFORMATION17 PAI_REG_COUNTRY,
       PAI_REG.ACTION_INFORMATION18 PAI_REG_POSTRAL_CODE,
       PAI_REG.ACTION_INFORMATION19 PAI_REG_EMPLOYEE_NUMBER,
       PAI_REG.ACTION_INFORMATION20 PAI_REG_WEEKLY_HOURS,
       PAI_REG.ACTION_INFORMATION21 PAI_REG_EMPLOYMENT_STATUS,
       PAI_REG.ACTION_INFORMATION22 PAI_REG_DATE_START,
       PAI_REG.ACTION_INFORMATION23 PAI_REG_TERM_DATE,
       PAI_REG.ACTION_INFORMATION24 PAI_REG_TERM_REASON,
       PAI_INFO.ACTION_INFORMATION6 PAI_INFO_MEMBER_NO,
       PAI_INFO.ACTION_INFORMATION7 PAI_INFO_FUND_REGI_DATE,
       PAI_INFO.ACTION_INFORMATION8 PAI_INFO_SAL_BENEFIT,
       PAI_INFO.ACTION_INFORMATION9 PAI_INFO_SAL_CONTR,
       PAI_INFO.ACTION_INFORMATION10 PAI_INFO_SAL_START_DATE,
       PAI_INFO.ACTION_INFORMATION11 PAI_INFO_SAL_END_DATE,
       PAI_INFO.ACTION_INFORMATION12 PAI_INFO_SAL_INSURANCE,
       PAI_INFO.ACTION_INFORMATION13 PAI_INFO_OCCUPATION,
       PAI_INFO.ACTION_INFORMATION14 PAI_INFO_INSURANCE_OPT,
       PAI_INFO.ACTION_INFORMATION15 PAI_INFO_AT_WORK,
       PAI_INFO.ACTION_INFORMATION16 PAI_INFO_CONTR_START_DATE,
       PAI_INFO.ACTION_INFORMATION17 PAI_INFO_CONTR_END_DATE,
       PAI_INFO.ACTION_INFORMATION18 PAI_INFO_AMEND_REASON
 FROM PAY_ACTION_INFORMATION PAI_REG, PAY_ACTION_INFORMATION PAI_INFO
 WHERE PAI_REG.ACTION_CONTEXT_ID = :P_PAYROLL_ACTION_ID
 AND PAI_REG.ACTION_INFORMATION_CATEGORY = 'AU_SUPER_STREAM_REGI_EMP'
 AND PAI_REG.ACTION_CONTEXT_TYPE = 'PA'
 AND PAI_REG.ACTION_INFORMATION1 = :P_SUPER_FUND_NAME
 AND PAI_REG.ACTION_INFORMATION2 = :P_SUPER_FUND_USI
 AND PAI_REG.ACTION_INFORMATION3 LIKE NVL(:P_BATCH_NO, '%')
 AND PAI_REG.ASSIGNMENT_ID = PAI_INFO.ASSIGNMENT_ID
 AND PAI_INFO.ACTION_CONTEXT_ID = :P_PAYROLL_ACTION_ID
 AND PAI_INFO.ACTION_INFORMATION_CATEGORY = 'AU_SUPER_STREAM_REGI_INFO'
 AND PAI_INFO.ACTION_CONTEXT_TYPE = 'PA'
 AND PAI_INFO.ACTION_INFORMATION1 = :P_SUPER_FUND_NAME
 AND PAI_INFO.ACTION_INFORMATION2 = :P_SUPER_FUND_USI
 ORDER BY PAI_REG.ACTION_INFORMATION6