HR_DI_RESLT_BEL

(SQL Table)
Index Back

DIMONA Result Data

DIMONA Data that are reported

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: PER_ORG_ASGN.EMPLID

Prompt Table: PERS_SRCH_GBL

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 HR_DI_EVENT_DT_BEL Date(10) DATE DIMONA Event Date
4 HR_DI_EVENT_SQ_BEL Number(3,0) SMALLINT NOT NULL DIMONA Event Date
5 HR_DI_EVT_TYPE_BEL Character(1) VARCHAR2(1) NOT NULL DIMONA Event Type
1=End of Employment
2=Start of Employment
6 HR_DI_ACTION_BEL Character(1) VARCHAR2(1) NOT NULL DIMONA Action
1=End of Employment
2=Start of Employment
3=Update
4=Cancel
N=None
7 HR_DI_RUN_BEL Number(5,0) INTEGER NOT NULL Current DIMONA Run
8 HR_DI_CANCEL_BEL Character(1) VARCHAR2(1) NOT NULL DIMONA Cancellation

Y/N Table Edit

Default Value: N

9 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
10 HR_DI_START_DT_BEL Date(10) DATE DIMONA Start Date
11 HR_DI_END_DT_BEL Date(10) DATE DIMONA End Date
12 HR_DI_STATUS_BEL Character(1) VARCHAR2(1) NOT NULL DIMONA Status
C=Complete
E=Error
P=In Progress
R=Rejected
S=Cancel
13 ACTION Character(3) VARCHAR2(3) NOT NULL Action
14 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
15 HR_DI_REGNBR_BEL Character(12) VARCHAR2(12) NOT NULL DIMONA Nr
16 HR_DI_REP_DT_BEL Date(10) DATE DIMONA Reporting Date
17 HR_DI_SENDERID_BEL Character(6) VARCHAR2(6) NOT NULL Belgium Functionality: DIMONA (RSZ) Sender Identification

Prompt Table: HR_DI_SEND_BEL

18 HR_DI_FILE_NM_BEL Character(100) VARCHAR2(100) NOT NULL DIMONA Process - Dimona Declaration File Name
19 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
20 HR_DI_REF_NBR_BEL Character(20) VARCHAR2(20) NOT NULL DIMONA declaration reference number
21 HR_DI_REF_SEQ_BEL Number(9,0) DECIMAL(9) NOT NULL DIMONA declaration reference sequence number
22 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created