LM_POSOBJ_EF_VW (SQL View)	Index Back
Group by on LM_POSTN_OBJV tbl Group by on LM_POSTN_OBJV table - Groups by Position Number and Effective Date

LM_POSOBJ_EF_VW

(SQL View)

Group by on LM_POSTN_OBJV tbl

Group by on LM_POSTN_OBJV table - Groups by Position Number and Effective Date

SELECT DISTINCT A.LM_POSITION_NBR ,A.EFFDT ,A.EFF_STATUS FROM PS_LM_POSTN_OBJV A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_POSITION_NBR Character(15) VARCHAR2(15) NOT NULL Position Number

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_POSITION_NBR	Character(15)	VARCHAR2(15) NOT NULL	Position Number
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A