HR_SRCH_POSN_VW (SQL View)	Index Back
Compensation Global Search Added lastupddttm to track changes as part of Global Search.

HR_SRCH_POSN_VW

(SQL View)

Compensation Global Search

Added lastupddttm to track changes as part of Global Search.

SELECT POSN.POSITION_NBR , POSN.EFFDT , POSN.EFF_STATUS , POSN.DESCR ,POSN.GVT_ORG_TTL_DESCR ,POSN.DESCRSHORT ,POSN.DESCRLONG , POSN.BUSINESS_UNIT , POSN.DEPTID , POSN.JOBCODE , POSN.POSN_STATUS , POSN.JOB_SHARE , POSN.REPORTS_TO , POSN.LASTUPDDTTM FROM PS_POSITION_DATA POSN WHERE %EffdtCheck(POSITION_DATA, POSN, %CurrentDateIn) AND POSN.EFF_STATUS='A'

Related Language Record: POSN_DATA_LANG

# 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 NOT NULL Effective Date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

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

5 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 DESCRLONG Long Character CLOB Long Description

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

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

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

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

12 JOB_SHARE Character(1) VARCHAR2(1) NOT NULL Job Sharing Permitted
Y/N Table Edit

13 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
Prompt Table: POSITION_DATA

14 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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 NOT NULL	Effective Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	GVT_ORG_TTL_DESCR	Character(70)	VARCHAR2(70) NOT NULL	Organization Position Title
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	DESCRLONG	Long Character	CLOB	Long Description
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
10	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
11	POSN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Position Status A=Approved P=Proposed R=Frozen
12	JOB_SHARE	Character(1)	VARCHAR2(1) NOT NULL	Job Sharing Permitted Y/N Table Edit
13	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number Prompt Table: POSITION_DATA
14	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.