USPS Reports Guide –
USPS Reports by Number –
Report 947 Transactions Held on Addenda Table – Aging
This report is a monthly aging report and lists all transactions on the Addenda Record Vendor Summary – Held SDD Vendor Transactions – Status 'A' Only (HQVND) screen. These will include all payments that have not processed either due to a cumulative negative amount for a given employee or due to the agency delaying or extending the payment date by submitting a Letter of Authorization (LOA). All transactions/records displayed will be summarized by agency, employee, case ID, cause number, payment date and document number and will include all records with an unpaid status (A or P) with a payment date in the prior month or earlier. If any aged transactions are found for a child support order (employee/case ID/cause number) all unpaid records will be displayed.
Note: All aged items should be carefully researched and updated on HQVND appropriately. If the transaction remains negative, due to an employee termination, the transaction can be updated with a LOA with appropriate documentation indicating the money has been returned by the vendor. This report relates only to child support payments processed to the Texas State Disbursement Unit (TxSDU).
Report Criteria
| Category | Payroll Administration |
|---|---|
| Distribution | Agency |
| Frequency | Automatically runs the last working day of each month. |
| Form | N/A |
| Sort Sequence | Vendor ID, payment date (ascending, or oldest first), employee SSN, case/cause and status |
| Page Break | Agency, Vendor |
| Parameters | N/A |
| Databases Used | HO4, H0C, HQS |
| Selection Criteria | Status = A and payment date in prior month or earlier. |
| Produce Output? | Yes |
| Request Screen | Not requestable by the agencies. |
| Produce Report? | No |
| Additional Notes |
Report Headings
- VENDOR:
- Displays the TINS vendor number that supports the single direct deposit for addenda processing and the TINS vendor name that supports the single direct deposit for addenda processing.
- PAYMENT DT
- Displays the payment due date from the Addenda record.
- SSN
- Displays the employee's Social Security number (SSN).
- CASE ID
- Displays up to 20-characters of the Case ID from the Addenda record.
- CAUSE NO
- Displays up to 15-characters of the Cause Number from the Addenda record.
- ST
- Displays a valid payment "status" for the Addenda record.
Valid values include:A indicates a transaction was accepted on a final payroll but has been held on the Addenda table in USPS as a "negative balance" based on the roll up key which is rolled up by agency, employee, case ID, cause number, payment date and document number. P indicates a transaction is pending payment. In the event a transaction caused this transaction to be non-positive (negative), the status would be A. C indicates a transaction previously with a status of P that was manually deleted by a LOA. D indicates a transaction previously with a status of A that was manually deleted by a LOA. - CREATE DT
- Displays the date of MM/DD/YYYY indicating the date the deduction was processed in USPS and matches the addenda information in USPS.
- ORIG DOC
- Displays the original payroll document number recorded on the addenda information in USPS.
- INRECS DOC
- Displays the INREC document number used to post the deduction offset transaction to USAS
- DEDUCT AMT
- Displays the deduction amount of the transaction.
- TOTAL AGED FOR VENDOR
- Displays the total dollar amount aged by vendor.
- VENDOR PAYMENTS DELAYED AT AGENCY REQUEST
- This section will include the payment related information for any transactions delayed because the agency submitted a LOA to delay the payment date. For each transaction, the payment date, SSN, case ID, cause number, status, create date, original document, INREC document and deduction amount will be displayed.
- TOTAL DELAYED FOR VENDOR
- Displays the total dollar amount delayed by the agency by vendor.
Sample Report
REPORT: 947 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 3
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
TRANSACTIONS HELD ON ADDENDA TABLE - AGING RUN TIME: 14:06:35
VENDOR: XXXXXXXXXXXXXX TEXAS STATE DISBURSEMENT UNIT
PAYMENT DT SSN CASE ID CAUSE NO ST CREATE DT ORIG DOC INRECS DOC DEDUCT AMT
11/19/20XX XXXXXXXXX XXXXXXX XXXXXXXX P 11/19/20XX 88116GGG 88116GGG 30.00
11/19/20XX XXXXXXXXX XXXXXXX XXXXXXXX P 11/18/20XX 88116FFF 88116GGG 5.00
11/19/20XX XXXXXXXXX XXXXXXX XXXXXXXX P 11/16/20XX 88116EEE 88116GGG 20.00-
11/20/20XX XXXXXXXXX XXXXXXX XXXXXXXX P 11/16/20XX 88116DDD 88116DDD 10.00
11/19/20XX XXXXXXXXX XXXXXXX XXXXXXXX P 11/01/20XX 88116JJJ 88116JJJ 200.00
03/02/20XX XXXXXXXXX XXXXXXX XXXXXXXX P 05/01/20XX 89026III 89026III 200.00
12/19/20XX XXXXXXXXX XXXXXXX XXXXXXXX A 04/15/20XX L8116009 200.00-
12/20/20XX XXXXXXXXX XXXXXXX XXXXXXXX P 11/01/20XX 88116JJJ 89016RPT 200.00
12/19/20XX XXXXXXXXX XXXXXXX XXXXXXXX A 05/10/20XX L8116JJJ 200.00-
TOTAL AGED FOR VENDOR 225.00
VENDOR PAYMENTS DELAYED AT AGENCY REQUEST
11/20/20XX XXXXXXXXX XXXXXXX XXXXXXX P 11/16/20XX 88116DDD 88116DDD 10.00
ORIGINAL PAYMENT DT: 11/19/20XX
12/20/20XX XXXXXXXXX XXXXXXX XXXXXX P 11/01/20XX 88116JJJ 89016RPT 200.00
ORIGINAL PAYMENT DT: 12/19/20XX
TOTAL DELAYED FOR VENDOR 210.00