HR_DIM_SG12_BEL

(SQL Table)
Index Back

DIMONA Segment 12- Start file

DIMONA Segment record. Belgium Only!

# 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