GPMY_EPF_PYE(SQL Table) |
Index Back |
|---|---|
EPF Payee Data MYSEPF Payee Data MYS |
| # | 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 NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | GPMY_EPF_INITIALS | Character(3) | VARCHAR2(3) NOT NULL | Initials |
| 6 | GPMY_EPF_NBR | Character(10) | VARCHAR2(10) NOT NULL |
EPF Number
Prompt Table: GPMY_EPF_ORG_VW |
| 7 | GPMY_MMBRSHIP_NBR | Character(14) | VARCHAR2(14) NOT NULL | Membership Number |
| 8 | GPMY_FOREIGN_WRKR | Character(1) | VARCHAR2(1) NOT NULL |
Use Foreign Worker Rate
Y/N Table Edit Default Value: N |
| 9 | GPMY_WITHDRAWAL | Character(1) | VARCHAR2(1) NOT NULL |
EPF Age 55 Withdrawal Status
Y/N Table Edit |
| 10 | GPMY_PERCENTAGE | Number(6,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 11 | GPMY_AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Amount |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 13 | GPMY_PERCENTAGE2 | Number(6,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 14 | GPMY_AMOUNT2 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Amount |
| 15 | CURRENCY_CD2 | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 16 | GPMY_CONTR_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Contribution Type
EM=Employer Only EP=Employer and Payee PY=Payee Only Default Value: EP |
| 17 | GPMY_IC_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
IC Indicator
A=Not Applicable N=New IC O=Old IC Default Value: N |