| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %DATE
|
| 3 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Default Value: JOB.ESTABID
Prompt Table:
ESTAB_TBL
|
| 4 |
GPIN_CLASS_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Classification Code
01=Architects, Engineers
02=Physicians, Surgeons
03=Accountant, Auditors
04=Lawyers
05=Teachers
06=Rest Technical, Professional
07=Administrative Exec., Clerical
08=Sales Workers
09=Service workers
10=Production & related workers
|
| 5 |
GPIN_HRA_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Accomodation Type
01=House Rent
02=Company Lease
03=None
Default Value: 01
|
| 6 |
GPIN_HRA_RENT_PAID |
Number(6,0) |
INTEGER NOT NULL |
Actual Rent Paid
|
| 7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 8 |
GPIN_RESIDENT_STS |
Character(2) |
VARCHAR2(2) NOT NULL |
Resident Status
01=Resident
02=Non-Resident
Default Value: 01
|
| 9 |
GPIN_HRA_LOCATION |
Character(2) |
VARCHAR2(2) NOT NULL |
Location
01=Metropolitan
02=Non-Metropolitan
Default Value: 01
|
| 10 |
GPIN_HRA_FURN |
Character(2) |
VARCHAR2(2) NOT NULL |
Furnished
01=Furnished
02=Un-Furnished
03=Not Applicable
Default Value: 01
|
| 11 |
GPIN_NBR_CHILD |
Number(2,0) |
SMALLINT NOT NULL |
Number of Children
|
| 12 |
GPIN_DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled person
Y/N Table Edit
Default Value: N
|
| 13 |
GPIN_SR_CITIZEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Senior Citizen
Y/N Table Edit
Default Value: N
|
| 14 |
SEVERE_DISABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
SEVERE DISABILITY
Y/N Table Edit
|
| 15 |
DISABLED_DEPENDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Dependent
|
| 16 |
SVR_DSABLD_DPNDNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Severe Disabled Dependent
|
| 17 |
GPIN_LWF_ELIGIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag is used to enroll emplyee for LWF contribution.
Y/N Table Edit
Default Value: N
|
| 18 |
GPIN_IS_DIR |
Character(1) |
VARCHAR2(1) NOT NULL |
Direcrot or Person with substantial interest in the company.
Y/N Table Edit
Default Value: N
|
| 19 |
GPIN_SNR_CTZ_DPNDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Senior citizen dependent.
|
| 20 |
GPIN_IND_PAR_SNR |
Character(1) |
VARCHAR2(1) NOT NULL |
Senior Citizen Parents
|
| 21 |
GPIN_80DDB |
Character(1) |
VARCHAR2(1) NOT NULL |
Medical Ailment
Y/N Table Edit
|
| 22 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
GPIN_STATE_VW
|
| 23 |
GPIN_VRSNR_CTZ_DPN |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will store the flag showing whether the dependents are Very senior Citizens having age greater than 80 years old
Y/N Table Edit
|
| 24 |
GPIN_VRSNR_CTZ_PRN |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will store the flag showing whether the Parents are Very senior Citizens having age greater than 80 years old
Y/N Table Edit
|
| 25 |
GPIN_PT_SLVL_VAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Sublevel value
Prompt Table:
GPIN_PT_TBL
|