# |
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_FIL_SRT_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA File Sort
|
3 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
4 |
DIMONA_PARIT_BEL |
Character(7) |
VARCHAR2(7) NOT NULL |
Industrial Committe
|
5 |
DIMONA_INSZ_BEL |
Character(11) |
VARCHAR2(11) NOT NULL |
DIMONA INSZ Identification
|
6 |
DIMONA_NAME_BEL |
Character(48) |
VARCHAR2(48) NOT NULL |
DIMONA Name
|
7 |
DIMONA_FRSTNM_BEL |
Character(24) |
VARCHAR2(24) NOT NULL |
DIMONA First Name
|
8 |
NSZ_DUMMY1_1_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy
|
9 |
NSZ_DUMMY1_2_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Used By Illness Interface...
Netherlands Social Insurance.
|
10 |
NSZ_DUMMY1_3_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Used By Illness Interface...
Netherlands Social Insurance.
|
11 |
DIMONA_NR_BEL |
Character(12) |
VARCHAR2(12) NOT NULL |
DIMONA Nr
|
12 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
13 |
DIMONA_COMMENT_BEL |
Character(20) |
VARCHAR2(20) NOT NULL |
DIMONA User Comment
|
14 |
DIMONA_IDENT_BEL |
Character(10) |
VARCHAR2(10) NOT NULL |
DIMONA Identification
|