EMPL_CTG_VW (SQL View)	Index Back
view of EMPL_CTG table Uses SETID_LBR_AGREEMENT field instead of SETID field used in EMPL_CTG. Shows only current EFFDT and EFF_STATUS = 'A'

EMPL_CTG_VW

(SQL View)

view of EMPL_CTG table

Uses SETID_LBR_AGREEMENT field instead of SETID field used in EMPL_CTG. Shows only current EFFDT and EFF_STATUS = 'A'

SELECT A.SETID , A.LABOR_AGREEMENT , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.COMMENTS FROM PS_EMPL_CTG A WHERE A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_EMPL_CTG A2 WHERE A.SETID= A2.SETID AND A.LABOR_AGREEMENT = A2.LABOR_AGREEMENT AND A2.EFFDT<=%CurrentDateIn ) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID_LBR_AGRMNT Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetId

2 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

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

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

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

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

7 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_LBR_AGRMNT	Character(5)	VARCHAR2(5) NOT NULL	Labor Agreement SetId
2	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	COMMENTS	Long Character	CLOB	Comment