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