CONTR_ENDS_BEL(SQL Table) |
Index Back |
|---|---|
End Contract - BelgiumThis record is used for the Belgium Employment Terms |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 2 | Character(25) | VARCHAR2(25) NOT NULL | Contract Number | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL |
End Contract Type
Prompt Table: CNT_END_TBL_BEL |
|
| 4 | CNT_END_RSN_BEL | Character(2) | VARCHAR2(2) NOT NULL |
End Contract Reason
Prompt Table: CNT_RSN_TBL_BEL |
| 5 | START_WORK_DT_BEL | Date(10) | DATE | Start Date Worked |
| 6 | END_WORK_DT_BEL | Date(10) | DATE | End Date Worked |
| 7 | MANDAT_REPL_BEL | Character(1) | VARCHAR2(1) NOT NULL |
Mandatory Replacement
Y/N Table Edit Default Value: N |
| 8 | END_MAN_REP_DT_BEL | Date(10) | DATE | End Date Mandatory Replacement |
| 9 | NOTIFIC_PERIOD_BEL | Number(3,0) | SMALLINT NOT NULL | Notification Period Months |
| 10 | NOTIFIC_PERWKS_BEL | Number(3,0) | SMALLINT NOT NULL | Notification Period Weeks |
| 11 | PAID_START_DT_BEL | Date(10) | DATE | Start Date Payment |
| 12 | PAID_END_DT_BEL | Date(10) | DATE | End Date Payment |
| 13 | START_DT | Date(10) | DATE NOT NULL |
Start Date
Default Value: %date |
| 14 | END_DT | Date(10) | DATE NOT NULL | end date |