ADDL_HB_ARG(SQL Table) |
Index Back |
|---|---|
Health BenefitsHealth Benefits - Additional Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: EMPLMT_SRCH_GBL |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: EMPLMT_SRCH_GBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | SOC_SEC_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL |
Social Security Field
Prompt Table: SOC_SEC_TBL_ARG |
| 6 | SSECPLAN_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL |
Social Security Plan Field
Prompt Table: SSECPL_ARG_VW |
| 7 | AFILIATE_NBR_ARG | Character(30) | VARCHAR2(30) NOT NULL | Afiliate Number Field |
| 8 | IDEXPIR_DT_ARG | Date(10) | DATE | S.S. Card Expiration Date |
| 9 | HPROV_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL |
Health Provider Code
Prompt Table: HPROV_TBL_ARG |
| 10 | MEDPLAN_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL |
Health Provider Plan Code
Prompt Table: HPPLAN_ARG_VW |
| 11 | HPAFILIATE_NBR_ARG | Character(30) | VARCHAR2(30) NOT NULL | H.P. Afiliate Number |
| 12 | HPIDEXPIR_DT_ARG | Date(10) | DATE | Health Provider Card Expiration Date |