HR_DI_RESLT_BEL(SQL Table) | 
Index Back | 
|---|---|
DIMONA Result DataDIMONA Data that are reported | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL | 
Employee ID
 Default Value: PER_ORG_ASGN.EMPLID Prompt Table: PERS_SRCH_GBL  | 
|
| 2 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
| 3 | Date(10) | DATE | DIMONA Event Date | |
| 4 | Number(3,0) | SMALLINT NOT NULL | DIMONA Event Date | |
| 5 | Character(1) | VARCHAR2(1) NOT NULL | 
DIMONA Event Type
 1=End of Employment 2=Start of Employment  | 
|
| 6 | Character(1) | VARCHAR2(1) NOT NULL | 
DIMONA Action
 1=End of Employment 2=Start of Employment 3=Update 4=Cancel N=None  | 
|
| 7 | Number(5,0) | INTEGER NOT NULL | Current DIMONA Run | |
| 8 | 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 |