Payroll Cluster Table Scrambling in TDMS 4.0

[Former Member]

Hi Experts,

My client is implementing TDMS 4.0. Wherein they have requested us to scramble payroll amount (BETRG) field so that a masked amount appears on the payslip of the employees.

Would appreciate any suggestions on how the TDMS rule should be created to accommodate this functionality. And what table and field details need to added to the rule.

Thanks in Advance.

[Former Member · Accepted solution]

Hello Shifa,

For example, if you want to scramble BETRG in bank transfer data in US payroll. then the rule should be configured as below.

1. Create a scrambling rule.

2. Go to Table-Fields tab

3. Switch to expert mode.

4. enter table name as PCL2-RU.(RU - > US payroll data).

5. Enter field name as BT-BETRG (BT->Banking info).

6. Enter routine name as SCRAMBLE_CLUSTER_DATA.

Then activate the created rule in the package.

Regards,

Ashok

[Former Member · Accepted solution]

Thank You Ashok.

After some more brainstorming and tryouts I was able scramble the payroll cluster tables. The rule that needs to be used is as follows.

Table Name	Field Name	Primary Table field	Routine Name	Is a Cluster Table	Do not Scramble	Keysets
PA0008	BET01	Checked	SCRAMBLE_DATA_CLUSTER			PERNR
PCL2-RX	RT-BETRG		SCRAMBLE_DATA_CLUSTER	Checked

Note: Here RX is the RELID for country grouping 99, so for US this will be RU.

Some points to be kept in mind while scrambling RT table are:

• Cluster tables need to have a reference table & field (PA0008 & BET01 above, from which it reads the amount field).
• Primary table field needs to be unchecked for cluster tables.
• Routine name needs to be SCRAMBLE_DATA_CLUSTER.
• 'Is a cluster table' field needs to be checked only for the cluster table rule.
• Cluster tables cannot be simulated.
• No keysets can be added for cluster tables.

Regards,

Shifa