POSN_MGR_SRC_VW (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_MGR_SRC_VW

(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 ,A.EFFDT ,0 ,A.DESCR ,A.POSN_STATUS ,A.BUSINESS_UNIT ,A.DEPTID ,A.JOBCODE ,A.REPORTS_TO FROM PS_POSITION_DATA A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(effdt) FROM PS_POSITION_DATA p1 WHERE A.position_nbr = p1.position_nbr AND P1.effdt <= %CurrentDateIn) AND A.position_nbr NOT IN ( SELECT position_nbr FROM ps_hr_direct_rep_4 ) AND A.position_nbr NOT IN ( SELECT position_nbr FROM ps_hr_direct_rep_5 ) AND A.position_nbr NOT IN ( SELECT position_nbr FROM ps_hr_direct_rep_5 ) AND A.REPORTS_TO IN( SELECT POSITION_NBR FROM ps_hr_direct_rep_4 D2 ) AND REPORTS_TO<>' '

Related Language Record: POSN_M_SRCH_LVW

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

5 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
A=Approved
P=Proposed
R=Frozen

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: JOBCODE_TBL

9 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	POSN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Position Status A=Approved P=Proposed R=Frozen
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
8	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
9	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number