CUR_PROT_BEL_VW

(SQL View)
 Index Back

Vw-Actual Protection

BV_CURR_PROT_VW : gives an overview of the current protection-situation of an employment

SELECT A.EMPLID ,A.EMPL_RCD ,A.PROT_ID_BEL ,A.EFFDT ,A.END_DT FROM PS_PROTECT_BEL A WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_PROTECT_BEL B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT <= %CURRENTDATEIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

Prompt Table: PER_ORG_ASGN_VW

3 PROT_ID_BEL Character(3) VARCHAR2(3) NOT NULL Protection Type
001=WC - 1st time candidate
002=WC - 2nd time candidate NE
003=WC - elected
004=SHE - 1st time candidate
005=SHE - 2nd time candidate NE
006=SHE - elected
007=Union delegation
008=Pregnancy leave
009=Paternity leave
010=Career interruption
011=Educational leave
012=New technologies
013=Equal treatment
014=Remarks labour rules
015=Head of SHE and adjuncts
016=Industrial physician
017=Political leave
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 END_DT Date(10) DATE end date