HR_DIM_RSLT_BEL(SQL Table) |
Index Back |
|---|---|
DIMONA Result TableDIMONA Result table... |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | PROCESS_DATE |
Date(10) | DATE |
Process Date
Default Value: %date |
| 4 | NOTIFIED_TM |
Time(15) | TIMESTAMP |
Time First Notified
Default Value: %time |
| 5 | DATETIME_STAMP | DateTime(26) | TIMESTAMP |
DateTime Stamp
Default Value: %datetime |
| 6 | HIRE_DT | Date(10) | DATE | First Start Date |
| 7 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 8 | DIMONA_NR_BEL | Character(12) | VARCHAR2(12) NOT NULL | DIMONA Nr |
| 9 | DIMONA_ACTION_BEL | Character(1) | VARCHAR2(1) NOT NULL |
DIMONA Sort Notifications.
1=Hire 2=Terminate 3=Update 4=Cancel |
| 10 | DIMONA_STATUS_BEL | Character(1) | VARCHAR2(1) NOT NULL |
DIMONA Notification Status
1=DIMONA Notification Done 2=DIMONA Notification cancelled 3=DIMONA Notification Re-done 4=DIMONA Notification Delete |
| 11 | START_DATE | Date(10) | DATE |
Start Date for Gen Standing PO
Default Value: %date |