EMPLIDEMPL_RCDEFFDTDefault Value: %date
GPAR_AD_HB_VW(SQL View) |
Index Back |
|---|---|
Additional Health BenefitsAdditional Health Benefits Information ARG used by My Simplification Feature |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.SOC_SEC_CD_ARG , A.SSECPLAN_CD_ARG , A.AFILIATE_NBR_ARG , A.IDEXPIR_DT_ARG , A.HPROV_CD_ARG , A.MEDPLAN_CD_ARG , A.HPAFILIATE_NBR_ARG , A.HPIDEXPIR_DT_ARG FROM PS_ADDL_HB_ARG A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ADDL_HB_ARG B , PS_JOB C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EMPLID = C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD AND B.EFFDT <= C.EFFDT AND B.EFF_STATUS = 'A') |
| # | 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 | SOC_SEC_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL | Social Security Field |
| 5 | SSECPLAN_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL | Social Security Plan Field |
| 6 | AFILIATE_NBR_ARG | Character(30) | VARCHAR2(30) NOT NULL | Afiliate Number Field |
| 7 | IDEXPIR_DT_ARG | Date(10) | DATE | S.S. Card Expiration Date |
| 8 | HPROV_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL | Health Provider Code |
| 9 | MEDPLAN_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL | Health Provider Plan Code |
| 10 | HPAFILIATE_NBR_ARG | Character(30) | VARCHAR2(30) NOT NULL | H.P. Afiliate Number |
| 11 | HPIDEXPIR_DT_ARG | Date(10) | DATE | Health Provider Card Expiration Date |