BNE_CONTACT_GRPEFFDTDefault Value: %date
BNE_COMPONENT_IDPrompt Table: BNE_CNTCT_SRCH
Prompt Table: BEN_CONTACT_HDR
Y/N Table Edit
BNE_CNTCT_CMPNT(SQL Table) |
Index Back |
|---|---|
Enrollment Contact ComponentsIndicate the contacts for each component |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BNE_CONTACT_GRP |
Character(10) | VARCHAR2(10) NOT NULL | Enrollment contact group |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | BNE_COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Component name
Prompt Table: BNE_CNTCT_SRCH |
| 4 | BENEF_CONTACT_ID | Number(3,0) | SMALLINT NOT NULL |
Used to identify a contact name/address
Prompt Table: BEN_CONTACT_HDR |
| 5 | DISPLAY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display Only Flag
Y/N Table Edit |