HR_DIM_SEG7_BEL(SQL Table) |
Index Back |
|---|---|
DIMONA Segment 7DIMONA Segment 7 |
| # | 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_EE_SIS_BEL | Character(10) | VARCHAR2(10) NOT NULL | DIMONA Employee SIS Nummer |
| 7 | DIMONA_ZONE_2_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 2 |
| 8 | DIMONA_INSZ_BEL | Character(11) | VARCHAR2(11) NOT NULL | DIMONA INSZ Identification |
| 9 | DIMONA_ZONE_3_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 3 |
| 10 | DIMONA_NAME_BEL | Character(48) | VARCHAR2(48) NOT NULL | DIMONA Name |
| 11 | DIMONA_ZONE_4_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 4 |
| 12 | DIMONA_FRSTNM_BEL | Character(24) | VARCHAR2(24) NOT NULL | DIMONA First Name |
| 13 | DIMONA_ZONE_5_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 5 |
| 14 | DIMONA_INITIAL_BEL | Character(1) | VARCHAR2(1) NOT NULL | Initiale |
| 15 | DIMONA_ZONE_6_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 6 |
| 16 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 17 | DIMONA_ZONE_7_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 7 |
| 18 | DIMONA_BIRTHPL_BEL | Character(40) | VARCHAR2(40) NOT NULL | Birth Place |
| 19 | DIMONA_ZONE_8_BEL | Character(2) | VARCHAR2(2) NOT NULL | DIMONA Square 8 |
| 20 | DIMONA_LAND_CD_BEL | Character(5) | VARCHAR2(5) NOT NULL | DIMONA Country Code |
| 21 | DIMONA_ZONE_9_BEL | Character(2) | VARCHAR2(2) NOT NULL | Dimona Square 9. |
| 22 | SEX_FLG | Character(1) | VARCHAR2(1) NOT NULL | Gender |