Populate Warrant Disbursement Information on PRLVP

The Payroll Labor Distribution Consolidation (PLDC) batch process populates Warrant disbursement information for Garnishments (GARN), Levies (LEVY), and Family Court Support (FAMC) deductions on the Payroll Vendor Payment Requests (PRLVP) transaction. This special processing is enabled when Configuration Flag 1 is Yes on the PAM Processing Configuration OPROC and the Payroll Document ID batch parameter on PLDC is P. Based on the type of warrant being processed, different disbursement information is populated on the PRLVP transaction. The Warrant Type is determined by the Valid Document Type 1 field on Benefit Type (DEDT), Employee Fringe Benefit Type (BENT), or Employer Fringe Benefit Type (EFBT) for the deduction. If this field contains the transaction codes GARN, LEVY or FAMC the deduction is considered a warrant deduction.
The disbursement information that is populated for each warrant type is as follows:

Disbursement Information Populated for all Warrant typesDisbursement Information Populated for all Warrant types

Warrant Field	Description/Location
Document ID	The Transaction Code found in the Valid Document Type 1 field is inserted as a prefix to the PRLVP Document ID (example: GARN0000123412).
Vendor Code	Located on the DED_PARM or DED_PLAN tables.
Handling Code	Located on the DED_PLAN table.
Disbursement Category Code	Located on the DED_PLAN table.
Single Payment Indicator	Located on the DED_PLAN table.
Vendor Name	Located on the DED_PARM or DED_PLAN tables.
Amount	Amount taken for the deduction in payroll processing.

Information Unique to Garnishment and Levy WarrantsInformation Unique to Garnishment and Levy Warrants

Warrant Field	Description/Location
Address ID	The Address ID is the Deduction Plan code for the warrant deduction.
Employee ID	Populated on the Accounting Line Description: Located on the EMPL table.
Department Code	Populated on the Accounting Line Description: Located on the EMPL_ASGNMT table.
Pay Location	Populated on the Accounting Line Description: Located on the EMPL_ASGNMT table.
Case Number	Populated on the Accounting Line Description: If GARN, use the first fifteen bytes of GARN_DOCKET_NO on the DED_PARM table. If LEVY, use the EMPL_SSN from the EMPL table.
Employee Name	Populated on the Accounting Line Description: Located on the EMPL table.

Information Unique to Family Court Support warrantsInformation Unique to Family Court Support warrants

When the vendor disbursement format matches the Configuration Text field 4 on PAM Processing Configuration OPROC.

Warrant Field	Description/Location
Case Number	Populated on the Accounting Line Description: FMLY_CRT_CASE_NO column on the DED_PARM table.
Check Date	Populated on the Accounting Line Description: The check date processed during payroll processing.
Employee SSN	Populated on the Accounting Line Description: EMPL_SSN column on the EMPL table.
Employee Name	Populated on the Accounting Line Description: Located on the EMPL table.
Support Reference ID	Populated on the Accounting Line Description: FMLY_CRT_DOCT_NO column on the DED_PARM table.

When the vendor disbursement format does not match the Configuration Text field 4 on PAM Processing Configuration OPROC.

Warrant Field	Description/Location
Address Line 1	Located on the DED_PARM table.
Address Line 2	Located on the DED_PARM table
City	Located on the DED_PARM table.
State	Located on the DED_PARM table.
Zip	Located on the DED_PARM table.
Country	Located on the DED_PARM table.
County	Located on the DED_PARM table.
Check Date	Populated on the Accounting Line Description: The check date processed during payroll processing.
Employee ID	Populated on the Accounting Line Description: Located on the EMPL table.
Employee Name	Populated on the Accounting Line Description: Located on the EMPL table.
Case Number	Populated on the Accounting Line Description: FMLY_CRT_CASE_NO column on the DED_PARM table.
Support Reference ID	Populated on the Accounting Line Description: FMLY_CRT_DOCT_NO column on the DED_PARM table.

The following is a format used to populate information on the Accounting Line Description field on the PRLVP transaction based on the warrant type. Note: Information that is too long for the allocated space will be cut off.

Accounting Line Description format for Garnishment and Levy warrantsAccounting Line Description format for Garnishment and Levy warrants

When the vendor disbursement format matches the Configuration Text field 4 on PAM Processing Configuration OPROC.

Position	Warrant Information
1-14	Employee ID: In “EMP: nnnnnnnnn” format
15	Space
16-26	Department: In “DEPT CD: XX” format
27-28	Space
29-41	Pay Location: In “PAY
LOC:	XX” format
42	Space
43-63	Case Number: In “CASE: nnnnnnnnnn” format
64	Space
65-100	Employee Name: In “OR firstname middleinitial lastname” format
Example	EMP: 123456789 DEPT CD: 40 PAY LOC: 05 CASE: RCCI98765 OR Joe Smith

Accounting Line Description Format for Family Court Support WarrantsAccounting Line Description Format for Family Court Support Warrants

When the vendor disbursement format matches the Configuration Text field 4 on PAM Processing Configuration OPROC.

Position	Warrant Information
1-7	DEDCS - This value will always be present
8-27	Case Number
28	*
29-34	Check Date: In “YYMMDD” format
35	*
36-45	Amount
46	*
47-55	Employee Social Security Number
56-58	Y
59-68	Employee Name: In “lastname, firstname” format
69-79	0900001 \ - This value will always be present
Example	DEDCSSDU34567508013000000800000013768439YSTANLEY,M0900001*/

When the vendor disbursement format does not match the Configuration Text field 4 on PAM Processing Configuration OPROC.

Position	Warrant Information
1-6	Check Date: In “MMDDYY” format
7	Space
8-17	Employee ID
18	Space
19-55	Employee Name: In “lastname, firstname” format)
56	Space
57-76	Case Number
77	Space
78-97	Support Reference ID Number
Example	013008 78532693 Johnson, Mike CSS4634596 445678JJHGGFDRT87555