SUC_ROL_ADD_LNG (SQL View)	Index Back
Search Vw-Succsn Plan-Key Posn KEY_POSN_SRCH is a view which is used as the search record for key positions in the Succession Planning menu and Succession Plan trees. Only positions which have been designated as key positions will be retrieved by this view. KEY_POSN_SRCH also includes departmental security on positions as defined in the departmental security tree. Only positions which are BOTH key and in departments the user is cleared to see will appear for a particular user.

SUC_ROL_ADD_LNG

(SQL View)

Search Vw-Succsn Plan-Key Posn

KEY_POSN_SRCH is a view which is used as the search record for key positions in the Succession Planning menu and Succession Plan trees. Only positions which have been designated as key positions will be retrieved by this view. KEY_POSN_SRCH also includes departmental security on positions as defined in the departmental security tree. Only positions which are BOTH key and in departments the user is cleared to see will appear for a particular user.

SELECT A.POSITION_NBR ,A.LANGUAGE_CD ,A.DESCR FROM PS_POSN_DATA_LANG A , PS_CM_ROLE B , PS_POSITION_DATA P WHERE P.POSITION_NBR=A.POSITION_NBR AND A.POSITION_NBR = B.POSITION_NBR AND P.EFFDT=A.EFFDT AND (A.EFFDT>=%CurrentDateIn OR A.EFFDT= ( SELECT MAX(D.EFFDT) FROM PS_POSITION_DATA D WHERE D.POSITION_NBR = P.POSITION_NBR AND D.EFFDT<=%CurrentDateIn))

Related Language Record for SUCC_ROLE_ADD_S

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Default Value: 00000000

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 Default Value: 00000000
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description