FPMACTLEGAL_VW (SQL View)	Index Back
Civ Serv Pos/Action View

FPMACTLEGAL_VW

(SQL View)

Civ Serv Pos/Action View

SELECT DISTINCT A.FP_LEGALSTAT_CD , B.ACTION FROM ps_fpmlegalsta_tbl A , PS_FPMACTION_TBL B WHERE A.EFF_STATUS = 'A' AND B.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM ps_fpmlegalsta_tbl A1 WHERE A1.EFF_STATUS = 'A' AND A1.FP_LEGALSTAT_CD = A.FP_LEGALSTAT_CD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FP_LEGALSTAT_CD Character(3) VARCHAR2(3) NOT NULL Civil Service Position Code

2 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: FPMACTION_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_LEGALSTAT_CD	Character(3)	VARCHAR2(3) NOT NULL	Civil Service Position Code
2	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: FPMACTION_TBL