Using QDRO Aliases

When you run a calculation for a QDRO alternate payee, QDRO_AMT is the amount recorded for that person under the specified plan.

When you run a calculation for an employee, QDRO_AMT is the sum of all amounts recorded against that person under the specified plan.

For example, John has two ex-spouses. Sophia is entitled to 2,000 USD of his benefit from Plan A; Vanessa is entitled to 1,000 USD from plan A and 500 USD from plan B. The QDRO_AMT has the following values, depending on whose calculation is running and which plan is being processed:

Person	Plan A	Plan B
John (employee)	3,000 USD	500 USD
Sophia (QDRO payee 1)	2,000 USD	-
Vanessa (QDRO payee 2)	1,000 USD	500 USD

The QDRO_FLAG alias returns the COURT_DOC_ID.

The QDRO_EE_BD alias is only valid when you run a calculation for a QDRO alternate payee. It provides the birth date of the original employee. For example, during calculations for Sophia and Vanessa, this alias would provide John's birth date. During calculations for John, this alias does not have any value.