TL_GRP_POSN_VW (SQL View)	Index Back
Posn Descr - Employment Titles POSITION_VIEW is a view which retrieves only the title from the Position Data record. It is used for the Reports-To Position title on Employment, since Position Data is already brought into the panel via related-display to Job.Position_Nbr.

TL_GRP_POSN_VW

(SQL View)

Posn Descr - Employment Titles

POSITION_VIEW is a view which retrieves only the title from the Position Data record. It is used for the Reports-To Position title on Employment, since Position Data is already brought into the panel via related-display to Job.Position_Nbr.

SELECT POSITION_NBR ,EFFDT ,DESCR ,DESCRSHORT FROM PS_POSITION_DATA

Related Language Record: TL_GRP_POS_V_LG

# 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

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

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

#	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
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description