GPNL_INS_GRPEFFDTDefault Value: %date
GPNL_ORDER_NBRGPNL_INS_CDPrompt Table: %GP_EDIT_FLD1
Default Value: 1
Prompt Table: GPNL_INS_PREMM
GPNL_INS_GR_DTL(SQL Table) |
Index Back |
|---|---|
Insurance Group Detail NLDInsurance Group Detail NLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPNL_INS_GRP |
Character(3) | VARCHAR2(3) NOT NULL | Insurance Group |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPNL_ORDER_NBR |
Number(2,0) | SMALLINT NOT NULL | Order Number |
| 4 | GPNL_INS_CD |
Character(6) | VARCHAR2(6) NOT NULL |
GPNL_INS_CD
Prompt Table: %GP_EDIT_FLD1 |
| 5 | GPNL_INS_NBR | Character(3) | VARCHAR2(3) NOT NULL |
Insurance Number
Default Value: 1 Prompt Table: GPNL_INS_PREMM |