Project

General

Profile

Download (2.77 KB)

Bug #2828 » PHRPYCU0300REG_20240625.sql

Tri Rizqiaty, 06/25/2024 03:32 PM

 
1 
??USE [MinovaES_Pertalife_Prod]
2
3 
GO
4
5 
/****** Object:  StoredProcedure [dbo].[PHRPYCU0300REG]    Script Date: 25/06/2024 15.20.26 ******/
6
7 
SET ANSI_NULLS ON
8
9 
GO
10
11 
SET QUOTED_IDENTIFIER ON
12
13 
GO
14
15 
ALTER PROCEDURE [dbo].[PHRPYCU0300REG]
16
17 
AS
18
19
20
21 
SELECT
22
23 
	  [StartDate]
24
25 
      ,[EndDate]
26
27 
      ,[WageTypeDefinition]
28
29 
      ,[WTDefinitionDesc]
30
31 
      ,[CalculationDescription]
32
33 
      ,[Sequence]
34
35 
      ,[GrossupSequence]
36
37 
      ,[WageGroup]
38
39 
      ,[Type]
40
41 
      ,CASE
42
43 
			WHEN Regular = 'N' THEN 'Y'
44
45 
			ELSE Regular
46
47 
		END AS Regular
48
49 
      ,[Taxable]
50
51 
      ,[PreTax]
52
53 
      ,[Valuation]
54
55 
      ,[Overwrite]
56
57 
      ,[IsPesangon]
58
59 
      ,[Base]
60
61 
      ,[Percentage]
62
63 
      ,[MinAmount]
64
65 
      ,[MaxAmount]
66
67 
      ,[AmountRangeMsgType]
68
69 
      ,CASE
70
71 
			WHEN Regular = 'N' THEN '5000'
72
73 
			ELSE TaxSubsidy
74
75 
		END AS TaxSubsidy --,[TaxSubsidy]
76
77 
      ,[Prorate1]
78
79 
      ,[Prorate2]
80
81 
      ,[Prorate3]
82
83 
      ,[ProrateType]
84
85 
      ,[ProrateMethod]
86
87 
      ,[DebitAcc]
88
89 
      ,[CreditAcc]
90
91 
      ,[BudgetAcc]
92
93 
      ,[IncludeToBudget]
94
95 
      ,[IncludeToVacancyBudget]
96
97 
      ,[SPTNo]
98
99 
      ,[RecapNo]
100
101 
      ,[IsActive]
102
103 
      ,[Deduction]
104
105 
      ,[DeductionPercentage]
106
107 
      ,[WageTypeGenerated]
108
109 
      ,[WTGeneratedPercentage]
110
111 
      ,[WageTypeForeign]
112
113 
      ,[WTForeignConvType]
114
115 
      ,[Notes]
116
117 
      ,[CreateBy]
118
119 
      ,[CreateDate]
120
121 
      ,[ChangeBy]
122
123 
      ,[ChangeDate]
124
125 
      ,[WTAuthorizationGroup]
126
127 
FROM PHRPYCU0300
(3-3/4)