HP_RESET_POS_VW (SQL View)	Index Back
Reset Pos Lock Srch view Search view of budget check log of position with an update in progress status.

HP_RESET_POS_VW

(SQL View)

Reset Pos Lock Srch view

Search view of budget check log of position with an update in progress status.

SELECT POSITION_NBR , HP_UPD_IN_PROGRESS FROM PS_HP_BDCK_LOG_POS WHERE HP_UPD_IN_PROGRESS = 'Y'

# 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_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

#	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_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