POSITION_NBRI=Invalid
P=Pending
V=Valid
X=Never Encumbered
HP_RTBC_PS_SRCH(SQL View) |
Index Back |
|---|---|
Budget Status by Pos SearchBudget Status by Position Number Search Record |
| SELECT LG.POSITION_NBR , LG.HP_BUDGET_STATUS FROM PS_HP_BDCK_LOG_POS LG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 2 | HP_BUDGET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control budget status
I=Invalid P=Pending V=Valid X=Never Encumbered |