HP_DOC_POS_VW (SQL View)	Index Back
Position log view Search view budget check position log based on Doc ID xref.

HP_DOC_POS_VW

(SQL View)

Position log view

Search view budget check position log based on Doc ID xref.

SELECT D.HP_KK_DOC_ID , D.HP_KK_DOC_LINE_NBR , P.POSITION_NBR , P.HP_UPD_IN_PROGRESS FROM PS_HP_BDCK_LOG_POS P , PS_ENCUMB_DIST E , PS_HP_DOC_ID_XREF D WHERE D.HP_KK_DOC_ID = E.HP_KK_DOC_ID AND D.HP_KK_DOC_LINE_NBR = E.HP_KK_DOC_LINE_NBR AND E.POSITION_NBR = P.POSITION_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HP_KK_DOC_ID Number(31,0) DECIMAL(31) NOT NULL Commitment Control Document ID

2 HP_KK_DOC_LINE_NBR Number(3,0) SMALLINT NOT NULL Commitment Control Document Line #

3 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

4 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	HP_KK_DOC_ID	Number(31,0)	DECIMAL(31) NOT NULL	Commitment Control Document ID
2	HP_KK_DOC_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Commitment Control Document Line #
3	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
4	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