SET_LAB_VLD_VW (SQL View)	Index Back
Valid Labor Agreements SetIDs This view shows all SETIDs that are valid to be used for a Labor Agreement, These setids must have setcntrlvalues that exist in the REG_REGION_TBL (ie are actually controlled by a regulatory region)

SET_LAB_VLD_VW

(SQL View)

Valid Labor Agreements SetIDs

This view shows all SETIDs that are valid to be used for a Labor Agreement, These setids must have setcntrlvalues that exist in the REG_REGION_TBL (ie are actually controlled by a regulatory region)

SELECT DISTINCT(A.SETID) , B.DESCR FROM PS_SET_CNTRL_REC A , PS_SETID_TBL B WHERE A.RECNAME = 'EMPL_CTG' AND A.SETCNTRLVALUE IN ( SELECT REG_REGION FROM PS_REG_REGION_TBL) AND A.SETID = B.SETID

Related Language Record: SET_LAB_VLD_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description