EMPLIDEMPL_RCDEFFDTDefault Value: %date
SEQ_NUMDefault Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL
Y/N Table Edit
Default Value: N
GPDE_SI_MUL_DTL(SQL Table) |
Index Back |
|---|---|
Multiple Employment DetailsOn this record the user can specify whether an EE has other employments. Compensation amounts that derive from these emploments can be entered as monthly amounts. The amounts entered reflect the gross that is subject to social insurance. |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | GPDE_SI_MULAMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Glidezone Calculation Factor |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 7 | GPDE_SI_MUL_AV_FR | Character(1) | VARCHAR2(1) NOT NULL |
Multiple employment gross is mandatory insurable in AV
Y/N Table Edit Default Value: N |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |