ACTIV_CTG_L1_VW (SQL View)	Index Back
Active EE Subcategory Level 1 Prompt View for Employee Subcategory Level 1 : use to get the active rows.

ACTIV_CTG_L1_VW

(SQL View)

Active EE Subcategory Level 1

Prompt View for Employee Subcategory Level 1 : use to get the active rows.

SELECT A.SETID ,A.LABOR_AGREEMENT ,A.EMPL_CTG ,A.EFFDT FROM PS_EMPL_CTG_L1 A WHERE A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
3	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date