sql: select pay.PAYROLL_PERIOD 薪资月份, legal.name 公司名称, hrd.x_optgroup_name as "Operating Group", hrd.x_stream_name as "Business Stream", hrd.x_pdtgroup_name as "Product Group", hrd.x_division_name as "Division", hrb.name as "Department", job_se.name 职务系列, pay.EMPLOYEE_NUMBER 员工号, per.formal_name 中文姓名, per.first_name1 英文姓名, country.name 国籍, per_id.national_id 身份证号码, emp_sta.name 状态, arch_sub.基本工资, arch_sub.特殊津贴, arch_sub.住房津贴, arch_sub.其他, job.name 职位, emp.job_level 级别, hr.x_seniority_date 资历起算日期, hr.probation_period_end_date 试用期到期日期, hr.termination_date 离职日期, hrl.name 工作地, bank.bank_account_holder 收款人姓名, bank.bank_name 开户行名称, bank.bank_account 银行帐号, pay.A01 基本工资, pay.A031+pay.A03 补发, pay.SPEC_SPECIALALLOWANCE+pay.SPEC13_SPECIALALLOWANCE13MTH 特殊津贴, pay.HOU_A_HOUSINGALLOWANCE+pay.HOU_ASH_HOUSINGALLOWANCE+pay.HOU_ASH13_HOUSINGALLOWANCE 房屋津贴, pay.ALLC13_FIXEDALLOWANCE13MTH+pay.AF_PER13_PERFORMANCEINCENTIVE13MTH+pay.AF_SPE13_SPECIALWORKALLOWANCE13MTH 其他基本项_13m, pay.A08_DE_MEALALLOWANCE+pay.ALW_MEAL_MEALALLOWANCE 餐费津贴, pay.ALW_POSI_LFL_PERFORMANCEPAYFORPOSITION 绩效_岗位, pay.ALW_TRAN_LFL_TRANSPORTALLOWANCE 交通津贴, pay.ALW_MON_LFL_PERFORMANCEPAYFORGENERAL 绩效_综合, pay.ALW_SA_LFL_PERFORMANCEPAYFORSKILL 绩效_技能, pay.ALW_OTH3_PERFORMANCEPAYFOROTHER 绩效_其他, pay.POSI_ALL_POSITION_ALLOWANCE 岗位津贴, pay.ALW_SHIF_LFL_SHIFTALLOWANCE 倒班津贴, pay.ALW_RELO_LFL_RELOCATIONALLOWANCE 异地津贴, pay.ALLC_FIXEDALLOWANCE+pay.SERV_ALL_SERVICEAWARD+pay.AF_SPE_SPECIALWORKALLOWANCE+pay.AF_PER_PERFORMANCEINCENTIVE 固定津贴, pay.PCNA_PHONECLUSTERNETWORKALLOWANCE 通讯费津贴, pay.ALW_OTH1_OTHERALLOWANCE 其他津贴1, pay.ALW_OTH2_OTHERALLOWANCE 其他津贴2, pay.SFTALL_SHIFTALLOWANCE 倒班补贴, pay.POSI_POSITIONALLOWANCE 岗位补贴, pay.RELO_RELOCATIONSUBSIDY 异地补贴, pay.A08_MEALALLOWANCE+pay.OT_MEAL_OTMEALALLOWANCE 餐费补贴, pay.TRAN_ALL_TRANSPORTATIONALLOWANCE 交通补贴, pay.TEM_ALL_HIGHTEMPERATUREALLOWANCE 高温费, pay.PPA_POWDERPRESSINGALLOWANCE 压粉津贴, pay.INTERN_INTERNPAYMENT 实习生补贴, pay.BACKUP_OTHERALLOWANCE 其他补贴, pay.A07_OVERTIMEPAYMENT 加班费, pay.BON_13_DOUBLEPAYWITHNORMALTAX+pay.BON_13C_DOUBLEPAYWITHNORMALTAX+pay.A04_DOUBLEPAYWITHAPPORTIONTAX+pay.A04C_DOUBLEPAYWITHAPPORTIONTAX 双薪, pay.ATT_BONS_FULLATTENDANCEAWARD 全勤奖金, pay.BON_COM_COMMISSION 销售奖金, pay.BON_PER_PERFORMANCEBONUS+pay.PER_BONS_PERFORMANCEAWARD 绩效奖金, pay.INC_MON_MONTHLYINCENTIVEWITHNORMALTAX 月度奖金, pay.INC_QUA_QUARTERLYINCENTIVEWITHNORMALTAX 季度奖金, pay.RETENB_RETENTIONBONUS 留任奖金, pay.SB_APP_SPECIALBONUSWITHAPPORTIONMENTTAX+pay.A59_SPECIALBONUS+pay.TETU_BON_RETURNINGBONUS 特别奖, pay.RE_FEE_REFERRALFEE 推荐奖金, pay.PS_APP_PSWITHAPPORTIONMENTTAX+pay.A06_PROFITSHARINGWITHNORMALTAX 奖金, pay.LTI_LTI_DIVIDEND+pay.LTI_APP_LTI_SHAREAWARDGAINS 长期激励奖, pay.A12_ANNUALLEAVEPAYMENT 未休福利年假报酬, pay.SAL_PAYMENTFORSAL 未休法定年假报酬, pay.CP_MW_COMPENSATIONFORMINIMUMWAGE 最低工资补款, pay.CP_SLMW_SICKLEAVECOMPENSATIONFORMINIMUMWAGE 病假最低工资补款, pay.ML_BK_MATERNITYLEAVEBACKPAYMENT 产假补款, pay.WI_BK_WORKINJURYBACKPAYMENT 工伤补款, pay.A56_PAYMENTINLIEUOFNOTICE 代通知金, pay.ML_PAY_MATERNITYLEAVESSIHFADVANCEPAY 产假社保垫付, pay.A54_OTHERSPAYMENT+pay.SUBSIDY_SPECIALSUBSIDY 其他税前支付（计入平均工资）, pay.A64_OTHERSPAYMENT 其他税前支付, pay.A53_SICKLEAVEDEDUCTION 病假扣款, pay.A52_NOPAYLEAVE 事假扣款, pay.ML_DE_MATERNITYLEAVEDEDUCTION 产假扣款, pay.LLD_LACTATIONLEAVEDEDUCTION 哺乳假扣款, pay.DE_ABS_ABSENCE 旷工扣款, pay.DE_LATE_LATEEARLYLEAVE 迟到早退扣款, pay.ML_SHD_MATERNITYLEAVESSIANDHFDEDUCTION 产假社保扣回, pay.A55_OTHERSDEDUCTION+pay.SHORTNO_SHORTNOTICE 其他税前扣除（计入平均工资）, pay.A65_OTHERSDEDUCTION 其他税前扣除, pay.A01+pay.A03+pay.A031+pay.SPEC_SPECIALALLOWANCE+pay.SPEC13_SPECIALALLOWANCE13MTH+pay.HOU_A_HOUSINGALLOWANCE+pay.HOU_ASH_HOUSINGALLOWANCE+pay.HOU_ASH13_HOUSINGALLOWANCE+ pay.ALLC13_FIXEDALLOWANCE13MTH+pay.AF_PER13_PERFORMANCEINCENTIVE13MTH+pay.AF_SPE13_SPECIALWORKALLOWANCE13MTH+pay.A08_DE_MEALALLOWANCE+pay.ALW_MEAL_MEALALLOWANCE+ pay.ALW_POSI_LFL_PERFORMANCEPAYFORPOSITION+pay.ALW_TRAN_LFL_TRANSPORTALLOWANCE+pay.ALW_MON_LFL_PERFORMANCEPAYFORGENERAL+pay.ALW_SA_LFL_PERFORMANCEPAYFORSKILL+pay.ALW_OTH3_PERFORMANCEPAYFOROTHER+ pay.POSI_ALL_POSITION_ALLOWANCE+pay.ALW_SHIF_LFL_SHIFTALLOWANCE+pay.ALW_RELO_LFL_RELOCATIONALLOWANCE+pay.ALLC_FIXEDALLOWANCE+pay.SERV_ALL_SERVICEAWARD+pay.AF_SPE_SPECIALWORKALLOWANCE+ pay.AF_PER_PERFORMANCEINCENTIVE+pay.PCNA_PHONECLUSTERNETWORKALLOWANCE+pay.ALW_OTH1_OTHERALLOWANCE+pay.ALW_OTH2_OTHERALLOWANCE+pay.SFTALL_SHIFTALLOWANCE+pay.POSI_POSITIONALLOWANCE+ pay.RELO_RELOCATIONSUBSIDY+pay.A08_MEALALLOWANCE+pay.OT_MEAL_OTMEALALLOWANCE+pay.TRAN_ALL_TRANSPORTATIONALLOWANCE+pay.TEM_ALL_HIGHTEMPERATUREALLOWANCE+pay.PPA_POWDERPRESSINGALLOWANCE+ pay.INTERN_INTERNPAYMENT+pay.BACKUP_OTHERALLOWANCE+pay.A07_OVERTIMEPAYMENT+pay.BON_13_DOUBLEPAYWITHNORMALTAX+pay.BON_13C_DOUBLEPAYWITHNORMALTAX+pay.A04_DOUBLEPAYWITHAPPORTIONTAX+ pay.A04C_DOUBLEPAYWITHAPPORTIONTAX+pay.ATT_BONS_FULLATTENDANCEAWARD+pay.BON_COM_COMMISSION+pay.BON_PER_PERFORMANCEBONUS+pay.PER_BONS_PERFORMANCEAWARD+pay.INC_MON_MONTHLYINCENTIVEWITHNORMALTAX+ pay.INC_QUA_QUARTERLYINCENTIVEWITHNORMALTAX+pay.RETENB_RETENTIONBONUS+pay.SB_APP_SPECIALBONUSWITHAPPORTIONMENTTAX+pay.A59_SPECIALBONUS+pay.TETU_BON_RETURNINGBONUS+pay.RE_FEE_REFERRALFEE+ pay.PS_APP_PSWITHAPPORTIONMENTTAX+pay.A06_PROFITSHARINGWITHNORMALTAX+pay.LTI_LTI_DIVIDEND+pay.LTI_APP_LTI_SHAREAWARDGAINS+pay.A12_ANNUALLEAVEPAYMENT+pay.SAL_PAYMENTFORSAL+ pay.CP_MW_COMPENSATIONFORMINIMUMWAGE+pay.CP_SLMW_SICKLEAVECOMPENSATIONFORMINIMUMWAGE+pay.ML_BK_MATERNITYLEAVEBACKPAYMENT+pay.WI_BK_WORKINJURYBACKPAYMENT+pay.A56_PAYMENTINLIEUOFNOTICE+ pay.ML_PAY_MATERNITYLEAVESSIHFADVANCEPAY+pay.A54_OTHERSPAYMENT+pay.SUBSIDY_SPECIALSUBSIDY+pay.A64_OTHERSPAYMENT+pay.A53_SICKLEAVEDEDUCTION+pay.A52_NOPAYLEAVE+pay.ML_DE_MATERNITYLEAVEDEDUCTION+ pay.LLD_LACTATIONLEAVEDEDUCTION+pay.DE_ABS_ABSENCE+pay.DE_LATE_LATEEARLYLEAVE+pay.ML_SHD_MATERNITYLEAVESSIANDHFDEDUCTION+pay.A55_OTHERSDEDUCTION+pay.SHORTNO_SHORTNOTICE+pay.A65_OTHERSDEDUCTION 税前工资, pay.CI 应税商业保险, pay.ADDIIT_INCM_INCOMEONLYIMPACTIIT 其他应税, pay.ECCOM_ECONOMICCOMPENSATION+pay.EXGRATIA_EXGRATIAPAYMENT+pay.PILON_PAYMENTINLIEUOFNOTICE 经济补偿, pay.ESD_EMPLOYMENT_SUBSIDYFOR_DISABLED 一次性伤残就业补助, pay.MEDSUB_MEDICALSUBSIDY 医疗补助, pay.PEN_PENSIONINSURANCE+pay.INBK_PI_BackPayforPensionInsurance 养老个人, pay.MED_MEDICALINSURANCE+pay.IN_AMI_ADDITIONALMEDICALINSURANCE+pay.INBK_AMI_BACKPAYFORADDITIONALMEDICALINSURANCE+pay.IN_CII_CRITICALILLNESSINSURANCE+pay.INBK_CII_BACKPAYFORCRITICALILLNESSINSURANCE+pay.INBK_MI_BackPayforMedicalInsurance 医疗个人, pay.UNEM_UNEMPLOYMENTINSURANCE+pay.INBK_UI_BackPayforUnemploymentInsurance 失业个人, pay.HFIN_HOUSINGFUND+pay.INBK_HF_BackPayforHousingFund+pay.HF_TAX_HousingFundfortaxable+pay.INBK_HF_TAX_BackPayfortaxableHousingFund 公积金个人, pay.UNFIXALL_UNFIXEDALLOWANCE+pay.DONATION+pay.DONAT_DONATION+pay.DutyFree 免税额, pay.CONTINUING_EDUCATION+pay.ELDERLY_CARE+pay.INTEREST_ON_HOME_LOANS+pay.RENT+pay.CHILDREN_EDUCATION 专项附加扣除, pay.OTHER_DEDUCTION 税延养老_商业健康保险, pay.ADDIIT_INCM_INCOMEONLYIMPACTIIT 免税调整, pay.IIT_INDIVIDUALINCOMETAXATION+pay.IITLAB_IITFORLABOR 个税, pay.IITBNS_IITFORAPPORTIONMENTTAX 全年一次性奖金个税, pay.IITSEV_IITFORSEVERANCEPAYMENT 经济补偿金个税, pay.IIT_ADJ_TAXADJUSTMENT 个税调整, pay.IIT_INDIVIDUALINCOMETAXATION+pay.IITLAB_IITFORLABOR+pay.IITBNS_IITFORAPPORTIONMENTTAX+pay.IITSEV_IITFORSEVERANCEPAYMENT+pay.IIT_ADJ_TAXADJUSTMENT 个人所得税个人部分小计, pay.IIT_ER_INDIVIDUALINCOMETAXCOMPANY 个人所得税单位支付, pay.UF 工会费, pay.DONAT_DONATION 捐款, pay.S_PAY_SPECIALPAYMENT+pay.REIMBURE_REIMBURSEMENT_COMPENSATION+pay.A60_CASHADVANCE 税后支付额, pay.DEDUCT_SPECIALDEDUCTION 税后扣除额, pay.ML_SHD_T_MATERNITY_LEAVE_SSI_AND_HF_DEDUCTION_AFTER_TAX 产假社保收回税后, pay.PRCSAL_SALARY_PAID_BY_HK_OFFICE+pay.PRC13_13TH_MONTH_SALARY_PAID_BY_HK_OFFICE+pay.PRCPS_PS_PAID_BY_HK_OFFICE 香港支付, pay.LTIPBHK_LTIPAIDBY_HK 香港支付长期激励奖, pay.A01+pay.A03+pay.A031+pay.SPEC_SPECIALALLOWANCE+pay.SPEC13_SPECIALALLOWANCE13MTH+pay.HOU_A_HOUSINGALLOWANCE+pay.HOU_ASH_HOUSINGALLOWANCE+pay.HOU_ASH13_HOUSINGALLOWANCE+ pay.ALLC13_FIXEDALLOWANCE13MTH+pay.AF_PER13_PERFORMANCEINCENTIVE13MTH+pay.AF_SPE13_SPECIALWORKALLOWANCE13MTH+pay.A08_DE_MEALALLOWANCE+pay.ALW_MEAL_MEALALLOWANCE+ pay.ALW_POSI_LFL_PERFORMANCEPAYFORPOSITION+pay.ALW_TRAN_LFL_TRANSPORTALLOWANCE+pay.ALW_MON_LFL_PERFORMANCEPAYFORGENERAL+pay.ALW_SA_LFL_PERFORMANCEPAYFORSKILL+pay.ALW_OTH3_PERFORMANCEPAYFOROTHER+ pay.POSI_ALL_POSITION_ALLOWANCE+pay.ALW_SHIF_LFL_SHIFTALLOWANCE+pay.ALW_RELO_LFL_RELOCATIONALLOWANCE+pay.ALLC_FIXEDALLOWANCE+pay.SERV_ALL_SERVICEAWARD+pay.AF_SPE_SPECIALWORKALLOWANCE+ pay.AF_PER_PERFORMANCEINCENTIVE+pay.PCNA_PHONECLUSTERNETWORKALLOWANCE+pay.ALW_OTH1_OTHERALLOWANCE+pay.ALW_OTH2_OTHERALLOWANCE+pay.SFTALL_SHIFTALLOWANCE+pay.POSI_POSITIONALLOWANCE+ pay.RELO_RELOCATIONSUBSIDY+pay.A08_MEALALLOWANCE+pay.OT_MEAL_OTMEALALLOWANCE+pay.TRAN_ALL_TRANSPORTATIONALLOWANCE+pay.TEM_ALL_HIGHTEMPERATUREALLOWANCE+pay.PPA_POWDERPRESSINGALLOWANCE+ pay.INTERN_INTERNPAYMENT+pay.BACKUP_OTHERALLOWANCE+pay.A07_OVERTIMEPAYMENT+pay.BON_13_DOUBLEPAYWITHNORMALTAX+pay.BON_13C_DOUBLEPAYWITHNORMALTAX+pay.A04_DOUBLEPAYWITHAPPORTIONTAX+ pay.A04C_DOUBLEPAYWITHAPPORTIONTAX+pay.ATT_BONS_FULLATTENDANCEAWARD+pay.BON_COM_COMMISSION+pay.BON_PER_PERFORMANCEBONUS+pay.PER_BONS_PERFORMANCEAWARD+pay.INC_MON_MONTHLYINCENTIVEWITHNORMALTAX+ pay.INC_QUA_QUARTERLYINCENTIVEWITHNORMALTAX+pay.RETENB_RETENTIONBONUS+pay.SB_APP_SPECIALBONUSWITHAPPORTIONMENTTAX+pay.A59_SPECIALBONUS+pay.TETU_BON_RETURNINGBONUS+pay.RE_FEE_REFERRALFEE+ pay.PS_APP_PSWITHAPPORTIONMENTTAX+pay.A06_PROFITSHARINGWITHNORMALTAX+pay.LTI_LTI_DIVIDEND+pay.LTI_APP_LTI_SHAREAWARDGAINS+pay.A12_ANNUALLEAVEPAYMENT+pay.SAL_PAYMENTFORSAL+ pay.CP_MW_COMPENSATIONFORMINIMUMWAGE+pay.CP_SLMW_SICKLEAVECOMPENSATIONFORMINIMUMWAGE+pay.ML_BK_MATERNITYLEAVEBACKPAYMENT+pay.WI_BK_WORKINJURYBACKPAYMENT+pay.A56_PAYMENTINLIEUOFNOTICE+ pay.ML_PAY_MATERNITYLEAVESSIHFADVANCEPAY+pay.A54_OTHERSPAYMENT+pay.SUBSIDY_SPECIALSUBSIDY+pay.A64_OTHERSPAYMENT+pay.A53_SICKLEAVEDEDUCTION+pay.A52_NOPAYLEAVE+pay.ML_DE_MATERNITYLEAVEDEDUCTION+ pay.LLD_LACTATIONLEAVEDEDUCTION+pay.DE_ABS_ABSENCE+pay.DE_LATE_LATEEARLYLEAVE+pay.ML_SHD_MATERNITYLEAVESSIANDHFDEDUCTION+pay.A55_OTHERSDEDUCTION+pay.SHORTNO_SHORTNOTICE+pay.A65_OTHERSDEDUCTION+ pay.ECCOM_ECONOMICCOMPENSATION+pay.EXGRATIA_EXGRATIAPAYMENT+pay.PILON_PAYMENTINLIEUOFNOTICE+pay.ESD_EMPLOYMENT_SUBSIDYFOR_DISABLED+pay.MEDSUB_MEDICALSUBSIDY+pay.PEN_PENSIONINSURANCE+ pay.MED_MEDICALINSURANCE+pay.IN_AMI_ADDITIONALMEDICALINSURANCE+pay.INBK_AMI_BACKPAYFORADDITIONALMEDICALINSURANCE+pay.IN_CII_CRITICALILLNESSINSURANCE+pay.INBK_CII_BACKPAYFORCRITICALILLNESSINSURANCE+ pay.UNEM_UNEMPLOYMENTINSURANCE+pay.HFIN_HOUSINGFUND+pay.IIT_INDIVIDUALINCOMETAXATION+pay.IITLAB_IITFORLABOR+pay.IITBNS_IITFORAPPORTIONMENTTAX+pay.IITSEV_IITFORSEVERANCEPAYMENT+pay.IIT_ADJ_TAXADJUSTMENT+ pay.UF+pay.DONAT_DONATION+pay.S_PAY_SPECIALPAYMENT+pay.REIMBURE_REIMBURSEMENT_COMPENSATION+pay.A60_CASHADVANCE+pay.DEDUCT_SPECIALDEDUCTION+pay.ML_SHD_T_MATERNITY_LEAVE_SSI_AND_HF_DEDUCTION_AFTER_TAX+ pay.PRCSAL_SALARY_PAID_BY_HK_OFFICE+pay.PRC13_13TH_MONTH_SALARY_PAID_BY_HK_OFFICE+pay.PRCPS_PS_PAID_BY_HK_OFFICE+pay.LTIPBHK_LTIPAIDBY_HK+pay.INBK_PI_BackPayforPensionInsurance+pay.INBK_MI_BackPayforMedicalInsurance+ pay.INBK_UI_BackPayforUnemploymentInsurance+pay.INBK_HF_BackPayforHousingFund+pay.HF_TAX_HousingFundfortaxable+pay.INBK_HF_TAX_BackPayfortaxableHousingFund 税后实发, pay.ER_PEN_PENSIONINSURANCE+pay.ER_INBK_PI_BackPayforPensionInsurance 养老公司, pay.ER_MED_MEDICALINSURANCE+pay.ER_IN_AMI_ADDITIONALMEDICALINSURANCE+pay.ER_INBK_AMI_BACKPAYFORADDITIONALMEDICALINSURANCE+pay.ER_IN_CII_CRITICALILLNESSINSURANCE+pay.ER_INBK_CII_BACKPAYFORCRITICALILLNESSINSURANCE+pay.ER_INBK_MI_BACKPAYFORMEDICALINSURANCE 医疗公司, pay.ER_UNEM_UNEMPLOYMENTINSURANCE+pay.ER_INBK_UI_BACKPAYFORUNEMPLOYMENTINSURANCE 失业公司, pay.ER_MAT_MATERNITYINSURANCE+pay.ER_INBK_MTI_BackPayforMaternityInsurance 生育公司, pay.ER_INJU_INJURYINSURANCE+pay.ER_INJ_SUPP_INJURYINSURANCESUPPLEMENTARY+pay.ER_INBK_INJ_SUPP_BACKPAYFORINJURYINSURANCESUPPLEMENTARY+pay.ER_INBK_INI_BackPayforInjuryInsurance 工伤公司, pay.ER_INBK_HTF_BACKPAYFORHEATINGFEE+pay.ER_IN_HF_HeatingFee 采暖费公司, pay.ER_PEN_PENSIONINSURANCE+pay.ER_INBK_PI_BackPayforPensionInsurance+ pay.ER_MED_MEDICALINSURANCE+pay.ER_IN_AMI_ADDITIONALMEDICALINSURANCE+pay.ER_INBK_AMI_BACKPAYFORADDITIONALMEDICALINSURANCE+pay.ER_IN_CII_CRITICALILLNESSINSURANCE+ pay.ER_INBK_CII_BACKPAYFORCRITICALILLNESSINSURANCE+pay.ER_INBK_MI_BACKPAYFORMEDICALINSURANCE+ pay.ER_UNEM_UNEMPLOYMENTINSURANCE+pay.ER_INBK_UI_BACKPAYFORUNEMPLOYMENTINSURANCE+ pay.ER_MAT_MATERNITYINSURANCE+pay.ER_INBK_MTI_BackPayforMaternityInsurance+ pay.ER_INJU_INJURYINSURANCE+pay.ER_INJ_SUPP_INJURYINSURANCESUPPLEMENTARY+pay.ER_INBK_INJ_SUPP_BACKPAYFORINJURYINSURANCESUPPLEMENTARY+pay.ER_INBK_INI_BackPayforInjuryInsurance+ pay.ER_INBK_HTF_BACKPAYFORHEATINGFEE+pay.ER_IN_HF_HeatingFee 社保公司, pay.ER_HFIN_HOUSINGFUND+pay.ER_INBK_HF_BackPayforHousingFund+pay.ER_HF_TAX_HousingFundfortaxable+pay.ER_INBK_HF_TAX_BackPayfortaxableHousingFund 公积金公司, pay.ER_AF_AGENCYFEE+pay.ER_AF_ADJ_AdjustedAgencyFee 人事代理费, pay.ER_IN_HESF_HANDICAPPEDEMPLOYMENTSECURITYFUND+pay.ER_INBK_HESF_BACKPAYFORHANDICAPPEDEMPLOYMENTSECURITYFUND 残保金, pay.ER_FIMF_FILEMANAGEMENTFEE 档案管理费, pay.ER_UF_UNIONFEE 工会经费支付, pay.BACKUP_OTHERALLOWANCE 商业保险支付, pay.ER_SF1_SERVICEFEE1 服务费1, pay.ER_SF2_SERVICEFEE2 服务费2, pay.ER_SF3_SERVICEFEE3 服务费3, pay.A01+pay.A03+pay.A031+pay.SPEC_SPECIALALLOWANCE+pay.SPEC13_SPECIALALLOWANCE13MTH+pay.HOU_A_HOUSINGALLOWANCE+pay.HOU_ASH_HOUSINGALLOWANCE+pay.HOU_ASH13_HOUSINGALLOWANCE+ pay.ALLC13_FIXEDALLOWANCE13MTH+pay.AF_PER13_PERFORMANCEINCENTIVE13MTH+pay.AF_SPE13_SPECIALWORKALLOWANCE13MTH+pay.A08_DE_MEALALLOWANCE+pay.ALW_MEAL_MEALALLOWANCE+ pay.ALW_POSI_LFL_PERFORMANCEPAYFORPOSITION+pay.ALW_TRAN_LFL_TRANSPORTALLOWANCE+pay.ALW_MON_LFL_PERFORMANCEPAYFORGENERAL+pay.ALW_SA_LFL_PERFORMANCEPAYFORSKILL+pay.ALW_OTH3_PERFORMANCEPAYFOROTHER+ pay.POSI_ALL_POSITION_ALLOWANCE+pay.ALW_SHIF_LFL_SHIFTALLOWANCE+pay.ALW_RELO_LFL_RELOCATIONALLOWANCE+pay.ALLC_FIXEDALLOWANCE+pay.SERV_ALL_SERVICEAWARD+pay.AF_SPE_SPECIALWORKALLOWANCE+ pay.AF_PER_PERFORMANCEINCENTIVE+pay.PCNA_PHONECLUSTERNETWORKALLOWANCE+pay.ALW_OTH1_OTHERALLOWANCE+pay.ALW_OTH2_OTHERALLOWANCE+pay.SFTALL_SHIFTALLOWANCE+pay.POSI_POSITIONALLOWANCE+ pay.RELO_RELOCATIONSUBSIDY+pay.A08_MEALALLOWANCE+pay.OT_MEAL_OTMEALALLOWANCE+pay.TRAN_ALL_TRANSPORTATIONALLOWANCE+pay.TEM_ALL_HIGHTEMPERATUREALLOWANCE+pay.PPA_POWDERPRESSINGALLOWANCE+ pay.INTERN_INTERNPAYMENT+pay.BACKUP_OTHERALLOWANCE+pay.A07_OVERTIMEPAYMENT+pay.BON_13_DOUBLEPAYWITHNORMALTAX+pay.BON_13C_DOUBLEPAYWITHNORMALTAX+pay.A04_DOUBLEPAYWITHAPPORTIONTAX+ pay.A04C_DOUBLEPAYWITHAPPORTIONTAX+pay.ATT_BONS_FULLATTENDANCEAWARD+pay.BON_COM_COMMISSION+pay.BON_PER_PERFORMANCEBONUS+pay.PER_BONS_PERFORMANCEAWARD+pay.INC_MON_MONTHLYINCENTIVEWITHNORMALTAX+ pay.INC_QUA_QUARTERLYINCENTIVEWITHNORMALTAX+pay.RETENB_RETENTIONBONUS+pay.SB_APP_SPECIALBONUSWITHAPPORTIONMENTTAX+pay.A59_SPECIALBONUS+pay.TETU_BON_RETURNINGBONUS+pay.RE_FEE_REFERRALFEE+ pay.PS_APP_PSWITHAPPORTIONMENTTAX+pay.A06_PROFITSHARINGWITHNORMALTAX+pay.LTI_LTI_DIVIDEND+pay.LTI_APP_LTI_SHAREAWARDGAINS+pay.A12_ANNUALLEAVEPAYMENT+pay.SAL_PAYMENTFORSAL+ pay.CP_MW_COMPENSATIONFORMINIMUMWAGE+pay.CP_SLMW_SICKLEAVECOMPENSATIONFORMINIMUMWAGE+pay.ML_BK_MATERNITYLEAVEBACKPAYMENT+pay.WI_BK_WORKINJURYBACKPAYMENT+pay.A56_PAYMENTINLIEUOFNOTICE+ pay.ML_PAY_MATERNITYLEAVESSIHFADVANCEPAY+pay.A54_OTHERSPAYMENT+pay.SUBSIDY_SPECIALSUBSIDY+pay.A64_OTHERSPAYMENT+pay.A53_SICKLEAVEDEDUCTION+pay.A52_NOPAYLEAVE+pay.ML_DE_MATERNITYLEAVEDEDUCTION+ pay.LLD_LACTATIONLEAVEDEDUCTION+pay.DE_ABS_ABSENCE+pay.DE_LATE_LATEEARLYLEAVE+pay.ML_SHD_MATERNITYLEAVESSIANDHFDEDUCTION+pay.A55_OTHERSDEDUCTION+pay.SHORTNO_SHORTNOTICE+pay.A65_OTHERSDEDUCTION+ pay.ECCOM_ECONOMICCOMPENSATION+pay.EXGRATIA_EXGRATIAPAYMENT+pay.PILON_PAYMENTINLIEUOFNOTICE+pay.ESD_EMPLOYMENT_SUBSIDYFOR_DISABLED+pay.MEDSUB_MEDICALSUBSIDY+pay.IIT_ER_INDIVIDUALINCOMETAXCOMPANY+ pay.ER_PEN_PENSIONINSURANCE+pay.ER_INBK_PI_BACKPAYFORPENSIONINSURANCE+pay.ER_MED_MEDICALINSURANCE+pay.ER_INBK_MI_BACKPAYFORMEDICALINSURANCE+pay.ER_IN_AMI_ADDITIONALMEDICALINSURANCE+ pay.ER_INBK_AMI_BACKPAYFORADDITIONALMEDICALINSURANCE+pay.ER_IN_CII_CRITICALILLNESSINSURANCE+pay.ER_INBK_CII_BACKPAYFORCRITICALILLNESSINSURANCE+pay.ER_UNEM_UNEMPLOYMENTINSURANCE+ pay.ER_INBK_UI_BACKPAYFORUNEMPLOYMENTINSURANCE+pay.ER_MAT_MATERNITYINSURANCE+pay.ER_INBK_MI_BACKPAYFORMEDICALINSURANCE+pay.ER_INJU_INJURYINSURANCE+pay.ER_INBK_INJ_SUPP_BACKPAYFORINJURYINSURANCESUPPLEMENTARY+ pay.ER_INJ_SUPP_INJURYINSURANCESUPPLEMENTARY+pay.ER_INBK_INJ_SUPP_BACKPAYFORINJURYINSURANCESUPPLEMENTARY+pay.ER_IN_HF_HeatingFee+pay.ER_INBK_HTF_BACKPAYFORHEATINGFEE+pay.ER_HFIN_HOUSINGFUND+ pay.ER_INBK_HF_BACKPAYFORHOUSINGFUND+pay.ER_HF_TAX_HousingFundfortaxable+pay.ER_INBK_HF_TAX_BackPayfortaxableHousingFund+pay.ER_AF_AGENCYFEE+pay.ER_AF_ADJ_ADJUSTEDAGENCYFEE+pay.ER_IN_HESF_HANDICAPPEDEMPLOYMENTSECURITYFUND+ pay.ER_INBK_HESF_BACKPAYFORHANDICAPPEDEMPLOYMENTSECURITYFUND+pay.ER_FIMF_FILEMANAGEMENTFEE+pay.ER_UF_UNIONFEE+pay.ER_SF1_SERVICEFEE1+pay.ER_SF2_SERVICEFEE2+pay.ER_SF3_SERVICEFEE3 当月实际人工成本合计, pay.ER_ACCRUED1 双薪预提, pay.ER_ACCRUED2 PS预提, pay.ER_ACCRUED3 残保金预提, pay.ER_ACCRUED4 工会经费预提, pay.ER_A_CIPREN 商保预提, pay.A01+pay.A03+pay.A031+pay.SPEC_SPECIALALLOWANCE+pay.SPEC13_SPECIALALLOWANCE13MTH+pay.HOU_A_HOUSINGALLOWANCE+pay.HOU_ASH_HOUSINGALLOWANCE+pay.HOU_ASH13_HOUSINGALLOWANCE+ pay.ALLC13_FIXEDALLOWANCE13MTH+pay.AF_PER13_PERFORMANCEINCENTIVE13MTH+pay.AF_SPE13_SPECIALWORKALLOWANCE13MTH+pay.A08_DE_MEALALLOWANCE+pay.ALW_MEAL_MEALALLOWANCE+ pay.ALW_POSI_LFL_PERFORMANCEPAYFORPOSITION+pay.ALW_TRAN_LFL_TRANSPORTALLOWANCE+pay.ALW_MON_LFL_PERFORMANCEPAYFORGENERAL+pay.ALW_SA_LFL_PERFORMANCEPAYFORSKILL+pay.ALW_OTH3_PERFORMANCEPAYFOROTHER+ pay.POSI_ALL_POSITION_ALLOWANCE+pay.ALW_SHIF_LFL_SHIFTALLOWANCE+pay.ALW_RELO_LFL_RELOCATIONALLOWANCE+pay.ALLC_FIXEDALLOWANCE+pay.SERV_ALL_SERVICEAWARD+pay.AF_SPE_SPECIALWORKALLOWANCE+ pay.AF_PER_PERFORMANCEINCENTIVE+pay.PCNA_PHONECLUSTERNETWORKALLOWANCE+pay.ALW_OTH1_OTHERALLOWANCE+pay.ALW_OTH2_OTHERALLOWANCE+pay.SFTALL_SHIFTALLOWANCE+pay.POSI_POSITIONALLOWANCE+ pay.RELO_RELOCATIONSUBSIDY+pay.A08_MEALALLOWANCE+pay.OT_MEAL_OTMEALALLOWANCE+pay.TRAN_ALL_TRANSPORTATIONALLOWANCE+pay.TEM_ALL_HIGHTEMPERATUREALLOWANCE+pay.PPA_POWDERPRESSINGALLOWANCE+ pay.INTERN_INTERNPAYMENT+pay.BACKUP_OTHERALLOWANCE+pay.A07_OVERTIMEPAYMENT+pay.BON_13_DOUBLEPAYWITHNORMALTAX+pay.BON_13C_DOUBLEPAYWITHNORMALTAX+pay.A04_DOUBLEPAYWITHAPPORTIONTAX+ pay.A04C_DOUBLEPAYWITHAPPORTIONTAX+pay.ATT_BONS_FULLATTENDANCEAWARD+pay.BON_COM_COMMISSION+pay.BON_PER_PERFORMANCEBONUS+pay.PER_BONS_PERFORMANCEAWARD+pay.INC_MON_MONTHLYINCENTIVEWITHNORMALTAX+ pay.INC_QUA_QUARTERLYINCENTIVEWITHNORMALTAX+pay.RETENB_RETENTIONBONUS+pay.SB_APP_SPECIALBONUSWITHAPPORTIONMENTTAX+pay.A59_SPECIALBONUS+pay.TETU_BON_RETURNINGBONUS+pay.RE_FEE_REFERRALFEE+ pay.PS_APP_PSWITHAPPORTIONMENTTAX+pay.A06_PROFITSHARINGWITHNORMALTAX+pay.LTI_LTI_DIVIDEND+pay.LTI_APP_LTI_SHAREAWARDGAINS+pay.A12_ANNUALLEAVEPAYMENT+pay.SAL_PAYMENTFORSAL+ pay.CP_MW_COMPENSATIONFORMINIMUMWAGE+pay.CP_SLMW_SICKLEAVECOMPENSATIONFORMINIMUMWAGE+pay.ML_BK_MATERNITYLEAVEBACKPAYMENT+pay.WI_BK_WORKINJURYBACKPAYMENT+pay.A56_PAYMENTINLIEUOFNOTICE+ pay.ML_PAY_MATERNITYLEAVESSIHFADVANCEPAY+pay.A54_OTHERSPAYMENT+pay.SUBSIDY_SPECIALSUBSIDY+pay.A64_OTHERSPAYMENT+pay.A53_SICKLEAVEDEDUCTION+pay.A52_NOPAYLEAVE+pay.ML_DE_MATERNITYLEAVEDEDUCTION+ pay.LLD_LACTATIONLEAVEDEDUCTION+pay.DE_ABS_ABSENCE+pay.DE_LATE_LATEEARLYLEAVE+pay.ML_SHD_MATERNITYLEAVESSIANDHFDEDUCTION+pay.A55_OTHERSDEDUCTION+pay.SHORTNO_SHORTNOTICE+pay.A65_OTHERSDEDUCTION+ pay.ECCOM_ECONOMICCOMPENSATION+pay.EXGRATIA_EXGRATIAPAYMENT+pay.PILON_PAYMENTINLIEUOFNOTICE+pay.ESD_EMPLOYMENT_SUBSIDYFOR_DISABLED+pay.MEDSUB_MEDICALSUBSIDY+pay.IIT_ER_INDIVIDUALINCOMETAXCOMPANY+ pay.ER_PEN_PENSIONINSURANCE+pay.ER_INBK_PI_BACKPAYFORPENSIONINSURANCE+pay.ER_MED_MEDICALINSURANCE+pay.ER_INBK_MI_BACKPAYFORMEDICALINSURANCE+pay.ER_IN_AMI_ADDITIONALMEDICALINSURANCE+ pay.ER_INBK_AMI_BACKPAYFORADDITIONALMEDICALINSURANCE+pay.ER_IN_CII_CRITICALILLNESSINSURANCE+pay.ER_INBK_CII_BACKPAYFORCRITICALILLNESSINSURANCE+pay.ER_UNEM_UNEMPLOYMENTINSURANCE+ pay.ER_INBK_UI_BACKPAYFORUNEMPLOYMENTINSURANCE+pay.ER_MAT_MATERNITYINSURANCE+pay.ER_INBK_MI_BACKPAYFORMEDICALINSURANCE+pay.ER_INJU_INJURYINSURANCE+pay.ER_INBK_INJ_SUPP_BACKPAYFORINJURYINSURANCESUPPLEMENTARY+ pay.ER_INJ_SUPP_INJURYINSURANCESUPPLEMENTARY+pay.ER_INBK_INJ_SUPP_BACKPAYFORINJURYINSURANCESUPPLEMENTARY+pay.ER_IN_HF_HeatingFee+pay.ER_INBK_HTF_BACKPAYFORHEATINGFEE+pay.ER_HFIN_HOUSINGFUND+ pay.ER_INBK_HF_BACKPAYFORHOUSINGFUND+pay.ER_HF_TAX_HousingFundfortaxable+pay.ER_INBK_HF_TAX_BackPayfortaxableHousingFund+pay.ER_AF_AGENCYFEE+pay.ER_AF_ADJ_ADJUSTEDAGENCYFEE+pay.ER_IN_HESF_HANDICAPPEDEMPLOYMENTSECURITYFUND+ pay.ER_INBK_HESF_BACKPAYFORHANDICAPPEDEMPLOYMENTSECURITYFUND+pay.ER_FIMF_FILEMANAGEMENTFEE+pay.ER_UF_UNIONFEE+pay.ER_SF1_SERVICEFEE1+pay.ER_SF2_SERVICEFEE2+pay.ER_SF3_SERVICEFEE3+ pay.ER_ACCRUED1+pay.ER_ACCRUED2+pay.ER_ACCRUED3+pay.ER_ACCRUED4+pay.ER_A_CIPREN 总成本 from payroll_ledger as pay left join hr_employee as hr on hr.id=pay.EMPLOYEE_ID left join emp_job as emp on emp.id=hr.job_info_id left join legal_entity as legal on emp.legal_entity_id = legal.id left join job_classification as job on job.id=emp.job_classification_id LEFT JOIN per_person AS person ON hr.person_id = person.id left join per_personal as per on per.id=person.per_personal left join res_country as country on country.id=per.nationality_id AND country.active = TRUE left join per_national_id as per_id on per_id.person_id=per.person_id AND per_id.is_primary = True left join employee_status emp_sta on emp_sta.id=emp.employee_status left join job_sequence job_se on job_se.id=emp.job_sequence_id AND job_se.active = TRUE left join hr_department hrd on hrd.id=emp.department_id left join hr_business_unit hrb ON hrb.id=emp.business_unit_id left join hr_location hrl on hrl.id=emp.location_id AND hrl.active = TRUE – left join person_bank_information bank on bank.person_id=per.person_id LEFT JOIN (SELECT per_bank.person_id as person_id, max(per_bank.id) AS information_id FROM person_bank_information as per_bank left JOIN res_selection AS bank_identification_use ON per_bank.use = bank_identification_use.id WHERE person_id IS NOT NULL AND bank_identification_use.code='bank_card_usage.main' GROUP BY person_id) AS bank_rel ON person.id = bank_rel.person_id LEFT JOIN person_bank_information AS bank ON bank_rel.information_id = bank.id left join ( select payroll.employee_id, pay.PAYROLL_PERIOD, sum(case when payroll_con.code='A01' then payroll.AMOUNT ELSE 0 end) as 基本工资, sum(case when payroll_con.code='SPEC' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='SPEC13' then payroll.AMOUNT ELSE 0 end) as 特殊津贴, sum(case when payroll_con.code='HOU_ASH' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='HOU_ASH13' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='HOU_A' then payroll.AMOUNT ELSE 0 end) as 住房津贴, sum(case when payroll_con.code='ALLC' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALLC13' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='AF_PER' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='AF_PER13' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='AF_SPE' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='AF_SPE13' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='A08_DE' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_Meal' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_POSI_LFL' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='POSI_ALL' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_TRAN_LFL' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_MON_LFL' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_SA_LFL' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_RELO_LFL' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='SERV_ALL' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='PCNA' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_OTH1' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_OTH2' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_OTH3_LFL' then payroll.AMOUNT ELSE 0 end + case when payroll_con.code='ALW_SHIF_LFL' then payroll.AMOUNT ELSE 0 end) as 其他 from payroll_ledger pay left join payroll_archive payroll on payroll.EMPLOYEE_ID=pay.EMPLOYEE_ID left join payroll_archive_config payroll_con on payroll_con.id=payroll.payroll_item_id where payroll.effective_date <= to_date(PAYROLL_PERIOD ||'01','yyyyMMdd') AND (payroll.expired_date IS NULL or payroll.expired_date >=to_date(PAYROLL_PERIOD ||'01','yyyyMMdd')) group by payroll.employee_id,pay.PAYROLL_PERIOD) arch_sub on arch_sub.employee_id=pay.employee_id and pay.PAYROLL_PERIOD=arch_sub.PAYROLL_PERIOD