HP_CMPYG_CTL (SQL Table)	Index Back
Company Paygroup Control Company Paygroup Control record used for Commitment Accounting Actuals Distribution and Encumbrance process.

HP_CMPYG_CTL

(SQL Table)

Company Paygroup Control

Company Paygroup Control record used for Commitment Accounting Actuals Distribution and Encumbrance process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HP_CMPYG_IDX Number(4,0) SMALLINT NOT NULL Company Paygroup Index Code
Default Value: 0

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

4 HP_BATCH_IN_PROG Character(1) VARCHAR2(1) NOT NULL This field is to indicate if batch encumbrance or batch expense is in progress. If it is "Encumbrance" or "Actual Expense", then no RTBC activities are allowed.
A=Distribution in Progress
E=Encumbrance in Progress
G=GL Interface in Progress
N=None
P=Pending Encumbrance Calc
Y=Year End in Progress

5 HP_LAST_KK_DOC_ID Number(31,0) DECIMAL(31) NOT NULL Last Commitment Control Document ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HP_CMPYG_IDX	Number(4,0)	SMALLINT NOT NULL	Company Paygroup Index Code Default Value: 0
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
4	HP_BATCH_IN_PROG	Character(1)	VARCHAR2(1) NOT NULL	This field is to indicate if batch encumbrance or batch expense is in progress. If it is "Encumbrance" or "Actual Expense", then no RTBC activities are allowed. A=Distribution in Progress E=Encumbrance in Progress G=GL Interface in Progress N=None P=Pending Encumbrance Calc Y=Year End in Progress
5	HP_LAST_KK_DOC_ID	Number(31,0)	DECIMAL(31) NOT NULL	Last Commitment Control Document ID