GPNL_SECTORPrompt Table: GPNL_SECTOR_TBL
EFFDTGPNL_RISKGRPDefault Value: 1
GPNL_SECRSK_TBL(SQL Table) |
Index Back |
|---|---|
Sector Risk group table NLDSector Risk Group table for the social security in the Netherlands |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPNL_SECTOR |
Number(3,0) | SMALLINT NOT NULL |
WALVIS
Prompt Table: GPNL_SECTOR_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | GPNL_RISKGRP |
Number(2,0) | SMALLINT NOT NULL |
WALVIS
Default Value: 1 |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |