HP_BDCK_PN_L_VW (SQL View)	Index Back
Budget Check for Posn vw LNG Budget check view for position (Language)

HP_BDCK_PN_L_VW

(SQL View)

Budget Check for Posn vw LNG

Budget check view for position (Language)

SELECT P.POSITION_NBR , PL.LANGUAGE_CD , PL.DESCR FROM PS_HP_BDCK_LOG_POS P , PS_POSITION_DATA PD , PS_POSN_DATA_LANG PL WHERE P.POSITION_NBR = PD.POSITION_NBR AND PD.EFFDT = ( SELECT MAX(PD1.EFFDT) FROM PS_POSITION_DATA PD1 WHERE PD1.POSITION_NBR = P.POSITION_NBR AND PD1.EFFDT <= %CurrentDateIn) AND PD.POSITION_NBR = PL.POSITION_NBR AND PD.EFFDT = PL.EFFDT

Related Language Record for HP_BDCK_POS_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description