| # |
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 |
GPIT_REG_CONTR_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Contribution Regime
1=INPS
2=INPDAI
3=INPGI
4=ENPALS
Default Value: 1
|
| 6 |
GPIT_FLAG_NEW_ENR |
Character(1) |
VARCHAR2(1) NOT NULL |
New Enroll
Y/N Table Edit
Default Value: N
|
| 7 |
GPIT_INPS_CAT_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
INPS Category
Prompt Table:
GPIT_INPS_CAT
|
| 8 |
GPIT_INPS_PROF_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
INPS Contribution Profile
Default Value: 0000
Prompt Table:
GPIT_INPS_PROF
|
| 9 |
GPIT_INPS_PROF_END |
Date(10) |
DATE |
End Date Contribution Profile
|
| 10 |
GPIT_INPS_CDCTR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
INPS Contribution Code
Prompt Table:
GPIT_INPS_CDCTR
|
| 11 |
GPIT_INPDAI_ENROLL |
Date(10) |
DATE |
Enrollment Date
|
| 12 |
GPIT_INPDAI_MATR |
Character(15) |
VARCHAR2(15) NOT NULL |
INPDAI Matricula
|
| 13 |
GPIT_INPDAI_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
INPDAI Regime
CM=Contributivo Misto
CP=Contributivo Puro
RP=Retributivo Puro
|
| 14 |
GPIT_CCC_CTR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Contractor Contribution Type
N=No other Pension Fund
P=Retired Payee
Y=Other Pension Fund
|
| 15 |
GPIT_OTH_INSURANCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Other Insurance
|
| 16 |
GPIT_CONTRACT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Contract Type
01=Administrator
02=Cooperation with Newspapers
03=Commisioneer
04=Public Administration
05=Phd, Stages
06=Contractor
07=Door-to-door Sales
08=Occasional Contracts
09=Autonomous Contracts
10=Pensioner Contractors
11=Public Admin Contractors
12=Extended Contracts
|
| 17 |
GPIT_ACTIVITY_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Activity Type
01=Translator
02=Transportations
03=Real Estate
04=Insurance
05=Training
06=Credit Recovery
07=Fashion
08=Cooperativa Partner
09=Company Consultant
10=Tax Consultant
11=Finance and Administration
12=IT Services
13=Broker
14=Exhibition Set-up
15=Health Sector
16=Marketing
17=Other Activities
18=Customs Broker
27=Local Administrator DM25-05-01
28=Door to Door Seller
|