HP_BDCK_LOG_POS

(SQL Table)
Index Back

Budget Check log for Position

Budget Check log for Position

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Prompt Table: POSITION_DATA

2 HP_CRITICAL_TXN Character(1) VARCHAR2(1) NOT NULL Critical Transaction indicator

Y/N Table Edit

3 HP_RTBC_PERFORMED Character(1) VARCHAR2(1) NOT NULL RTBC Performed indicator

Y/N Table Edit

4 HP_RTBC_TRIGGER Character(1) VARCHAR2(1) NOT NULL RTBC Triggered indicator
B=Batch
J=Job Component
L=Initial Load
P=Position Component
R=Real Time
5 HP_BUDGET_STATUS Character(1) VARCHAR2(1) NOT NULL Commitment Control budget status
I=Invalid
P=Pending
V=Valid
X=Never Encumbered
6 HP_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Budget Check Override Indicator

Y/N Table Edit

7 HP_UPD_IN_PROGRESS Character(1) VARCHAR2(1) NOT NULL This field is to indicate if update is in progress for a particular Doc ID. If it is "Yes", then the Doc ID is locked until the update is completed.

Y/N Table Edit

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 HP_LSTUPD_ENC_TIME DateTime(26) TIMESTAMP Last Encumbrance Update Time Stamp