PROCESS_INSTANCED=Death
E=Else
M=Military Service
S=Salary Limit Reached
T=Termination
HR_EDM_NLD_AET(SQL Table) |
Index Back |
|---|---|
First Day Notification NLDCache record for First Day (Hire Date) notification for the Netherlands. (Eerstedagmelding) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 6 | NOTICEDATE | Date(10) | DATE | NoticeDate |
| 7 | END_DATE | Date(10) | DATE | End Date |
| 8 | EDM_MSG_ID_NLD | Character(32) | VARCHAR2(32) NOT NULL | First Hire Date Declaration. |
| 9 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 10 | EDM_DESCR10_NLD | Character(10) | VARCHAR2(10) NOT NULL | Description field of length 10 |
| 11 | NL_REASON_END | Character(1) | VARCHAR2(1) NOT NULL |
Reason for ending Health Insur
D=Death E=Else M=Military Service S=Salary Limit Reached T=Termination |
| 12 | WP_PATH | Character(200) | VARCHAR2(200) NOT NULL | Path for Agreement Document |