PAY STP Archive Validation
Description
- Categories
- BI Publisher
- Application
- Payroll
- Source
- STP Archive Validation Report
- Short Name
- PYAUSTPVALID_XML
Imported from BI Publisher
Australian Single Touch Payroll Validation report
DB package:
Australian Single Touch Payroll Validation report
DB package:
SQL 50 lines
SELECT X_PAYEE_PAYROLL_ID ,X_PAYEE_FAMILY_NAME ,X_PAYEE_FIRST_NAME ,X_PAYEE_TFN ,to_char(to_date(X_PERIOD_START_DATE,'YYYY-MM-DD'),'DD-MM-YYYY') X_PERIOD_START_DATE ,to_char(to_date(X_PERIOD_END_DATE,'YYYY-MM-DD'),'DD-MM-YYYY') X_PERIOD_END_DATE ,FINAL_EVENT_IND ,X_TFN_TERM_IND ,X_TFN_EMP_TYPE_CODE ,X_TFN_RESIDENCY_STATUS ,X_TFN_TAX_FREE_THRESHOLD ,X_TFN_HELP_IND ,X_TFN_SFSS_IND ,X_TFN_DECL_DATE ,X_PERIOD_GROSS_PAYMENT ,X_PERIOD_TOTAL_INB_PAYGW ,X_GROSS_PAYMENT ,X_CDEP_PAYMENT ,X_TOTAL_INB_PAYGW ,X_EXEMPT_FOREIGN_INCOME ,X_LUMP_SUM_A_PAYMENT ,X_LUMP_SUM_B_PAYMENT ,X_LUMP_SUM_D_PAYMENT ,X_LUMP_SUM_E_PAYMENT ,X_DEDUCTION_AMOUNT_UF ,X_DEDUCTION_AMOUNT_WG ,X_SUPER_GURANTEE ,X_RESC ,X_FB_NON_EXEMPT ,X_FB_EXEMPT ,X_FW_J_GROSS_PAYMENTS ,X_FW_J_FOREIGN_TAX_PAID ,X_FW_J_TOTAL_TAX_WITHHELD ,X_FW_F_GROSS_PAYMENTS ,X_FW_F_FOREIGN_TAX_PAID ,X_FW_F_TOTAL_TAX_WITHHELD ,X_WHM_GROSS ,X_WHM_PAYGW ,(X_PRE_JUL_83_COMPONENT_ASG_YTD + X_INV_PAYMENT_ASG_YTD) X_PRE_JUL_83_COMPONENT ,X_POST_JUN_83_TAXED_ASG_YTD ,X_LUMP_SUM_C_DEDUCTION ,(X_ALLOWANCE_1_VALUE + X_ALLOWANCE_2_VALUE + X_ALLOWANCE_3_VALUE + X_ALLOWANCE_4_VALUE + X_ALLOWANCE_5_VALUE + X_ALLOWANCE_6_VALUE + X_ALLOWANCE_7_VALUE + X_ALLOWANCE_8_VALUE + X_ALLOWANCE_9_VALUE + X_ALLOWANCE_10_VALUE + X_ALLOWANCE_11_VALUE + X_ALLOWANCE_12_VALUE + X_ALLOWANCE_13_VALUE + X_ALLOWANCE_14_VALUE + X_ALLOWANCE_15_VALUE + X_ALLOWANCE_16_VALUE + X_ALLOWANCE_17_VALUE + X_ALLOWANCE_18_VALUE + X_ALLOWANCE_19_VALUE + X_ALLOWANCE_20_VALUE + X_ALLOWANCE_21_VALUE + X_ALLOWANCE_22_VALUE + X_ALLOWANCE_23_VALUE + X_ALLOWANCE_24_VALUE + X_ALLOWANCE_25_VALUE + X_ALLOWANCE_26_VALUE + X_ALLOWANCE_27_VALUE + X_ALLOWANCE_28_VALUE + X_ALLOWANCE_29_VALUE + X_ALLOWANCE_30_VALUE) ALLOWANCE_TOTAL_AMOUNT ,pay_au_stp_archive.get_etp_codes(ASSIGNMENT_ACTION_ID) AS X_ETP_CODE FROM pay_au_stp_archive_v WHERE payroll_action_id = :P_PAYROLL_ACTION_ID AND X_BAL_ZERO_FLAG <> 'YES' ORDER BY X_PAYEE_PAYROLL_ID |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| P_PAYROLL_ACTION_ID | Number |