HR_DI_SO_BEL(SQL Table) |
Index Back |
|---|---|
DIMONA ShouldDIMONA Data that should be reported with the current run |
| # | 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_START_DT_BEL | Date(10) | DATE | DIMONA Start Date |
| 9 | HR_DI_END_DT_BEL | Date(10) | DATE | DIMONA End Date |
| 10 | HR_DI_STATUS_BEL | Character(1) | VARCHAR2(1) NOT NULL |
DIMONA Status
C=Complete E=Error P=In Progress R=Rejected S=Cancel |
| 11 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 12 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 13 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 14 | UNION_CD | Character(3) | VARCHAR2(3) NOT NULL | Union Code |
| 15 | HR_DI_REF_SEQ_BEL | Number(9,0) | DECIMAL(9) NOT NULL | DIMONA declaration reference sequence number |