COMPANYPAYGROUPA=Distribution in Progress
E=Encumbrance in Progress
G=GL Interface in Progress
N=None
P=Pending Encumbrance Calc
Y=Year End in Progress
HP_CMPYG_CTL_VW(SQL View) |
Index Back |
|---|---|
Company & Paygroup Cntl ViewCompany & Paygroup Cntl View |
| SELECT COMPANY , PAYGROUP , HP_BATCH_IN_PROG FROM PS_HP_CMPYG_CTL WHERE HP_BATCH_IN_PROG <> 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | 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 |