Feature #2439
Fitur untuk menghapus data tabel transaksi, employee, organization melalui menu
0%
Description
dear tim developer minta support untuk pembuatan menu delete isi tabel untuk memudahkan dalam implementasi ke client baru.
Updated by Kezia Pawitra Yulianti 10 months ago
- Due date changed from 12/18/2023 to 12/29/2023
- Status changed from New to Assigned
Menu ini di pakai untuk kebutuhan cleansing data saat bikin port baru untuk client baru
Kalau bisa di infokan tabel2 apa aja yg perlu di cleansing (dr sisi table type nya seperti master data, transaksi)
Dan untuk tabel2 yg sifatnya Product atau System, jangan ikut di cleansing ya
Tks
Updated by Muhammad Bintar 10 months ago
ini ya shofwan tabel2 nya
MODULE PA
DELETE FROM dbo.PHRPA0001
DELETE FROM dbo.PHRPA0002
DELETE FROM dbo.PHRPA0003
DELETE FROM dbo.PHRPA0004
DELETE FROM dbo.PHRPA0005
DELETE FROM dbo.PHRPA0006
DELETE FROM dbo.PHRPA0007
DELETE FROM dbo.PHRPA0008
DELETE FROM dbo.PHRPA0009
DELETE FROM dbo.PHRPA0010
DELETE FROM dbo.PHRPA0011
DELETE FROM dbo.PHRPA0012
DELETE FROM dbo.PHRPA0013
DELETE FROM dbo.PHRPA0014
DELETE FROM dbo.PHRPA0015
DELETE FROM dbo.PHRPA0016
DELETE FROM dbo.PHRPA0017
DELETE FROM dbo.PHRPA0018
DELETE FROM dbo.PHRPA0019
DELETE FROM dbo.PHRPA0020
DELETE FROM dbo.PHRPA0021
DELETE FROM dbo.PHRPA0022
DELETE FROM dbo.PHRPA0023
DELETE FROM dbo.PHRPA0024
DELETE FROM dbo.PHRPA0025
DELETE FROM dbo.PHRPA0026
DELETE FROM dbo.PHRPA0029
DELETE FROM dbo.PHRPA0032
DELETE FROM dbo.PHRPA0033
DELETE FROM dbo.PHRPA0034
DELETE FROM dbo.PHRPA0035
DELETE FROM dbo.PHRPA0037
DELETE FROM dbo.PHRPA0039
DELETE FROM dbo.PHRPA0040
DELETE FROM dbo.PHRPA0041
DELETE FROM dbo.PHRPA0042
DELETE FROM dbo.PHRPA0043
DELETE FROM dbo.PHRPA0045
DELETE FROM dbo.PHRPA0046
DELETE FROM dbo.PHRPA0047
DELETE FROM dbo.PHRPA0048
DELETE FROM dbo.PHRPA0049
DELETE FROM dbo.PHRPA0052
DELETE FROM dbo.PHRPA0055
DELETE FROM dbo.PHRPA0057
DELETE FROM dbo.PHRPA0060
DELETE FROM dbo.PHRPA0125
MODULE Transaksi Payroll
DELETE FROM PHRPYTR0300
DELETE FROM PHRPYTR0300SIM
DELETE FROM PHRPYTR0301
DELETE FROM PHRPYTR0301CUM
DELETE FROM PHRPYTR0301RET
DELETE FROM PHRPYTR0301RETSIM
DELETE FROM PHRPYTR0301SIM
DELETE FROM PHRPYTR0302
DELETE FROM PHRPYTR0303
DELETE FROM PHRPYTR0304
DELETE FROM PHRPYTR0800
module OM
Delete From PHROM0001
Delete From PHROM0002
Delete From PHROM0003
Delete From PHROM0004
Delete From PHROM0005
Delete From PHROM0006
Delete From PHROM0007
Delete From PHROM0008
Delete From PHROM0009
Delete From PHROM0010
Delete From PHROM0011
Delete From PHROM0013
Delete From PHROM0014
Delete From PHROM0015
Delete From PHROM0016
Delete From PHROM0017
Delete From PHROM0018
Delete From PHROM0019
Delete From PHROM0020
Delete From PHROM0021
Delete From PHROM0022
Delete From PHROM0025
Delete From PHROM0026
Delete From PHROM0027
Delete From PHROM0028
Delete From PHROM0029
Delete From PHROM0031
Delete From PHROM0032
Delete From PHROM0033
Delete From PHROM0034
Delete From PHROM0035
Delete From PHROM0036
Delete From PHROM0037
Delete From PHROM0041
Delete From PHROM0042
Delete From PHROM0045
Delete From PHROM0046
Delete From PHROM0047
Delete From PHROM0048
Delete From PHROM0050
Delete From PHROM0052
Delete From PHROM0055
Delete From PHROM0101
Module Applicant Master Data
Delete From PHRRC0001
Delete From PHRRC0002
Delete From PHRRC0003
Delete From PHRRC0004
Delete From PHRRC0006
Delete From PHRRC0007
Delete From PHRRC0008
Delete From PHRRC0009
Delete From PHRRC0012
Delete From PHRRC0013
Delete From PHRRC0021
Delete From PHRRC0024
Delete From PHRRC0026
Delete From PHRRC0027
Delete From PHRRC0037
Delete From PHRRC0045
terus ini update objectid nya supaya kereset semua organization, positionid, dll
UPDATE [dbo].[PCMEPORMOBJ]
SET [LastID] = '00000001'
terus yang ini update untuk objectid requestid di reset kembali ke angka 1
UPDATE [dbo].[PCMEPAPPCONFIG]
SET [Value] = '1'
WHERE
ConfigName='WorkFlowLastReqID'