EMPLIDCONTRACT_NUMEFFDTDefault Value: %date
ORIG_EMPLID_BELPrompt Table: CNT_EMPL_BEL_VW
ORIG_CNT_NUM_BELPrompt Table: CNT_NUM_BEL_VW
Y/N Table Edit
Default Value: N
Default Value: 100
CONTR_REPS_BEL(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 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | ORIG_EMPLID_BEL |
Character(11) | VARCHAR2(11) NOT NULL |
Original Employee ID used by Belgium to track the original contract data.
Prompt Table: CNT_EMPL_BEL_VW |
| 5 | ORIG_CNT_NUM_BEL |
Character(25) | VARCHAR2(25) NOT NULL |
Original Contract Nbr
Prompt Table: CNT_NUM_BEL_VW |
| 6 | MANDAT_REPL_BEL | Character(1) | VARCHAR2(1) NOT NULL |
Mandatory Replacement
Y/N Table Edit Default Value: N |
| 7 | END_MAN_REP_DT_BEL | Date(10) | DATE | End Date Mandatory Replacement |
| 8 | END_REP_DT_BEL | Date(10) | DATE | End Replacement |
| 9 | REPLACE_PERC_BEL | Number(6,2) | DECIMAL(5,2) NOT NULL |
The Replacement Percentage is used for Belgian Contract replacements.
Default Value: 100 |