EMPLIDPrompt Table: CONTRACT_DATA
CONTRACT_NUMPrompt Table: CONTRACT_DATA
ORIG_EMPLID_BELPrompt Table: CNT_EMPL_BEL_VW
ORIG_CNT_NUM_BELPrompt Table: CNT_NUM_BEL_VW
EFFDTDefault Value: %date
Y/N Table Edit
Default Value: N
Default Value: 100
ORIGS_BEL_VW(SQL View) |
Index Back |
|---|---|
Replacement Contract ViewThis record is used for the Belgium Employment Terms. |
| SELECT ORIG_EMPLID_BEL ,ORIG_CNT_NUM_BEL ,EMPLID ,CONTRACT_NUM ,EFFDT ,MANDAT_REPL_BEL ,END_MAN_REP_DT_BEL ,END_REP_DT_BEL ,REPLACE_PERC_BEL FROM PS_CONTR_REPS_BEL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: CONTRACT_DATA |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract Number
Prompt Table: CONTRACT_DATA |
| 3 | 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 |
| 4 | ORIG_CNT_NUM_BEL |
Character(25) | VARCHAR2(25) NOT NULL |
Original Contract Nbr
Prompt Table: CNT_NUM_BEL_VW |
| 5 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 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 |