EMPLIDEMPL_RCDEFFDTDefault Value: %date
GPDE_BV_PRVDR_NBRP=Pension Fund
U=Support Fund
GPDE_BV_PRV_VW(SQL View) |
Index Back |
|---|---|
BVV Provider Data on EE levelBVV Provider Data on EE level |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD ,C.EFFDT ,C.GPDE_BV_PRVDR_NBR ,C.GPDE_BV_TYPE ,C.GPDE_BV_DFLT_PRVDR ,D.GPDE_BV_PRVDR_NAME FROM PS_JOB A ,PS_GP_PYGRP B ,PS_GPDE_AL_PE_BVDT C ,PS_GPDE_BV_PRVDR D WHERE A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A2.EMPLID = A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.EFFDT = A.EFFDT) AND B.GP_PAYGROUP = A.GP_PAYGROUP AND C.PAY_ENTITY = B.PAY_ENTITY AND D.GPDE_BV_TYPE = C.GPDE_BV_TYPE AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_GPDE_BV_PRVDR D1 WHERE D1.GPDE_BV_TYPE = D.GPDE_BV_TYPE AND D1.EFFDT <= C.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | GPDE_BV_PRVDR_NBR |
Number(4,0) | SMALLINT NOT NULL | BVV Provider Number |
| 5 | GPDE_BV_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Fund Type (Pension/Relief Fund)
P=Pension Fund U=Support Fund |
| 6 | GPDE_BV_DFLT_PRVDR | Character(1) | VARCHAR2(1) NOT NULL | Default Provider |
| 7 | GPDE_BV_PRVDR_NAME | Character(50) | VARCHAR2(50) NOT NULL | BVV Name |