TDP Record

Multiple TDP records can be created for an employee with more than one TDP deduction code per check.

The Non-TDP Deduction Reason Code is displayed in the Deduction Reason field if the record contains a TDP deduction amount of zero. If the TDP deduction amount is greater than zero, the TDP deduction reason 01 is assigned.

All TDP records are created with the TDP Adjustment Type 01, except TDP deductions on voided checks from previous pay runs or negative deductions, which are assigned TDP Adjustment Type 06.

The TDP record data is loaded into the mipaydet table.

The following table lists the TDP record's field names, table fields, and the data source.

Field Name	Table field	Data source
Employee ID	empl_no	Key link to the miorsdtl1 table (DTL1 record data).
TDP deduct amount	ded_amt	The deduction amount from the check history record with the TDP deduction code.
TDP Agreement Number	agr_num	The employee’s TDP agreement number from the payroll authorization record with the TDP deduction code.
TDP Invoice Number	inv_num	The employee’s TDP invoice number from the payroll authorization record with the TDP deduction code.
Pay Period End Date	payend	The pay period end date of the pay run from the check history record.
Deduction Number	ded_cd	The TDP deduction number.
Deduction Reason	ded_reason	01 - TDP deduction amount is greater than zero. The Non-TDP Deduction Reason Code is displayed if the TDP deduction amount is zero.
Payroll Check Number	pay_check_no	The payroll check number from which the TDP deduction was withheld.
Accounts Payable Check Number	check_no	The check number of the accounts payable checks that are sent to the state. This field is no longer used.
Adjustment Type	adj_type	06 - TDP deduction amount is negative, or the deduction is from a voided check from a previous pay run Otherwise, Adjustment Type 01 is used
Report period	rpt_prid	User input during the data load process