Program Reference Table (PRFT)

The Program Reference Table (PRFT) is used to establish the relationship between a Program Budget Unit, Allotment Program, and Appropriation Program within a specific Fund, Agency, and Budget Fiscal Year. This table is used to validate the Program Budget Unit for a Fund and Agency, and will infer the Appropriation Program and Allotment Program when the Program Budget Unit is entered on accounting transactions.

The Program Reference Table (PRFT) will also be utilized to determine the cash control level.


Budg FY	Key field. Enter the applicable fiscal year.
Fund	Key field. Enter the Fund associated with the Program Budget Unit, Allotment Program, and Appropriation Program.
Agency	Key field. Enter the agency associated with the Program Budget Unit, Allotment Program, and Appropriation Program. See Agency Index (AGCY) for valid values.
Prog Budg Unit	Key field. Enter the Program Budget Unit that is associated with the Allotment Program and Appropriation Program.
Allt Prog	Key field. Enter the Allotment Program that is associated with the Program Budget Unit and Appropriation Program.
Appr Prog	Key field. Enter the Appropriation Program that is associated with the Program Budget Unit and Allotment Program.
Cash Control Ind	Required. Enter a value to indicate which level cash will be controlled at. Valid values are: 1 Controls Cash at FUND level (BFY/Fund). 2 Controls Cash at AGENCY level (BFY/Agency/Appropriation). 3 Controls Cash at Appropriation level (BFY/Agency/Appropriation). 4 Controls Cash at Allotment level (BFY/Agency/Appropriation/Allotment) 5 Controls Cash at Program Budget Unit level (BFY/Agency/Appropriation/Allotment/Program Budget Unit)
Override Cash Ind	Required. Indicate whether the cash edits will be overriden. Valid values are: N Do not override cash edits. Y Override Cash Edits A Override Cash Edits (temporarily). (This should only be used while two accounting years are open simultaneously, and then changed to N when the cash carryforward is done).
Name	Optional. Enter the name of the program reference structure.
CAFR Ind	Required. Indicate whether the Program Budget Unit is included in the Comprehensive Annual Financial Report. Valid values are: Y Program Budget Unit is included in CAFR N Program Budget Unit is not included in CAFR
Int Incl	Required. Indicate whether interest is attributable to the Program Budget Unit. Valid values are: Y Interest is attributable to this Program Budget Unit. N Interest is not attributable to this Program Budget Unit.
Inv Pool	Required. Valid values are user-defined.
Inactive Ind	Required. Indicate whether the Program Budget Unit is inactive. Valid values are: Y Program Budget Unit is inactive. N Program Budget Unit is active.