HR_DIM_SEG8_BEL(SQL Table) |
Index Back |
|---|---|
DIMONA Segment 8DIMONA Segment 8 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DIMONA_NR_1_BEL | Character(6) | VARCHAR2(6) NOT NULL | DIMONA Sequence Number 1. |
| 2 | DIMONA_NR_2_BEL | Character(5) | VARCHAR2(5) NOT NULL | DIMONA Sequence Number 2. |
| 3 | DIMONA_NIV_BEL | Character(1) | VARCHAR2(1) NOT NULL | DIMONA Data Level. |
| 4 | DIMONA_BLK_BEL | Character(2) | VARCHAR2(2) NOT NULL | Belgium Functionality: DIMONA SQUARE |
| 5 | DIMONA_ZONE_1_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 1 |
| 6 | DIMONA_STREET_BEL | Character(35) | VARCHAR2(35) NOT NULL | Street Label |
| 7 | DIMONA_ZONE_2_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 2 |
| 8 | DIMONA_HOUSE_BEL | Character(5) | VARCHAR2(5) NOT NULL | DIMONA House Number |
| 9 | DIMONA_ZONE_3_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 3 |
| 10 | DIMONA_BUS_NR_BEL | Character(4) | VARCHAR2(4) NOT NULL | Bus Number |
| 11 | DIMONA_ZONE_4_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 4 |
| 12 | NSZ_POSTAL2_NLD | Character(9) | VARCHAR2(9) NOT NULL | Name....Postal. Used By Illness Interface... Netherlands Social Insurance. |
| 13 | DIMONA_ZONE_5_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 5 |
| 14 | DIMONA_BIRTHPL_BEL | Character(40) | VARCHAR2(40) NOT NULL | Birth Place |
| 15 | DIMONA_ZONE_6_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 6 |
| 16 | DIMONA_LAND_CD_BEL | Character(5) | VARCHAR2(5) NOT NULL | DIMONA Country Code |