Symptoms

How to know the destination Plan Period of a switch plan order?

Cause

Resolution

The Plan Period information is not included into Order Details, therefore it is only possible to obtain such information from PBA-E database using query example below:

pba=> select "PlanPeriodID" from "OrdDet" where "DetID" = 622693 \x\g\x
Expanded display is on.
-[ RECORD 1 ]+-----
PlanPeriodID | 8414

Here 622693 is the Details ID from the Change order (Details of type "recurring fee"). 8414 - can be found in the list of existing Plan Periods in the new (destination) Service Plan:

8414    1   Month(s)

There is a feature request to improve Order Detalization and include additional information into the Order Description: PBA-28873.

Internal content