PAY SuperStream Registration Report XBRL

Description
Categories: BI Publisher, Human Resources
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