EMPLIDEMPL_RCDCONTRACT_NBR_BELR_EMPLID_BELR_EMPL_RCD_NBR_BELR_CONTRACT_NBR_BELEFFDTUPG_CNTREPS_TAO(SQL Table) |
Index Back |
|---|---|
Contract Replacement - BelgiumThis record is used for the Belgium Employment Terms to stored the contract replacement data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | CONTRACT_NBR_BEL |
Number(3,0) | SMALLINT NOT NULL | Contract Seq. Number |
| 4 | R_EMPLID_BEL |
Character(11) | VARCHAR2(11) NOT NULL | Replacing ID |
| 5 | R_EMPL_RCD_NBR_BEL |
Number(3,0) | SMALLINT NOT NULL | Replacing Employment Nbr |
| 6 | R_CONTRACT_NBR_BEL |
Number(3,0) | SMALLINT NOT NULL | Replacing Contract Number |
| 7 | EFFDT |
Date(10) | DATE | Effective Date |
| 8 | MANDAT_REPL_BEL | Character(1) | VARCHAR2(1) NOT NULL | Mandatory Replacement |
| 9 | END_MAN_REP_DT_BEL | Date(10) | DATE | End Date Mandatory Replacement |
| 10 | END_REP_DT_BEL | Date(10) | DATE | End Replacement |