POSN_SUB_LANG (SQL View)	Index Back
Search Vw-Position Mgmt POSITION_SRCH is a search view which uses departmental security to grant access to the positions based on the departments to which they are assigned. Users will only see positions located in departments for which they have security clearance. It is used as the search record for the Position Data panels in Position Management in all access modes except for Add mode. If you wish to enforce departmental security when a user adds a position which is already in the database, this record should be used as the search record for Add mode as well.

POSN_SUB_LANG

(SQL View)

Search Vw-Position Mgmt

POSITION_SRCH is a search view which uses departmental security to grant access to the positions based on the departments to which they are assigned. Users will only see positions located in departments for which they have security clearance. It is used as the search record for the Position Data panels in Position Management in all access modes except for Add mode. If you wish to enforce departmental security when a user adds a position which is already in the database, this record should be used as the search record for Add mode as well.

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

Related Language Record for POSN_SUB_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 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
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description