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 |