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 Record | |
| 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 |