POSN_IDX_SEC_VW (SQL View)	Index Back
Search Vw-Position Mgmt This 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 Security View in Position Data Index.

POSN_IDX_SEC_VW

(SQL View)

Search Vw-Position Mgmt

This 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 Security View in Position Data Index.

SELECT A.POSITION_NBR , A.EFFDT , A.EFFSEQ , SEC.DESCR FROM PS_POSITION_DATA_E A , PS_DEPT_SEC2_SRCH SEC WHERE A.DEPTID = SEC.DEPTID AND SEC.SETID = ( SELECT SC.SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.RECNAME = 'DEPT_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

4 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
4	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security