| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
GPIN_REG_NAME |
Character(75) |
VARCHAR2(75) NOT NULL |
Registered name of establishment
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON_NAME
|
| 5 |
GPIN_BUS_NATURE |
Character(30) |
VARCHAR2(30) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Nature of Business of the Establishment.
|
| 6 |
GPIN_FS_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures under which Act the Establishment is covered under. i.e., Factories Act or Shops and Establishments Act
1=Factories Act
2=Shops and Establishments Act
Default Value: 1
|
| 7 |
GPIN_COVG_ESI_WC |
Character(1) |
VARCHAR2(1) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Coverage status under ESI or Worker's Compenstation Act.
1=Employee State Insurance
2=Workmen's Compensation Act
3=Both
Default Value: 1
|
| 8 |
GPIN_FS_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Factories / Shops and Establishments Registration number.
|
| 9 |
GPIN_FS_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Factories / Shops and Establishments Registration Date.
|
| 10 |
GPIN_FS_RENW_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Factories / Shops and Establishments Registration Renewal Date.
|
| 11 |
GPIN_PF_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Provident Fund Registration No.
|
| 12 |
GPIN_PF_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Provident Fund Registration Date.
|
| 13 |
GPIN_PF_RENW_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Provident Fund Registration Renewal Date.
|
| 14 |
GPIN_PF_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Type of Provident Fund.
10=Statutory Provident Fund
20=Recognised Provident Fund
|
| 15 |
GPIN_ESI_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Employee State Insurance Registration Number.
|
| 16 |
GPIN_ESI_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Employee's State Insurance Registration Date.
|
| 17 |
GPIN_ESI_RENW_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Employee State Insurance Registration Date.
|
| 18 |
GPIN_ESI_OFFICE |
Character(30) |
VARCHAR2(30) NOT NULL |
ESI Local Office of Employer
|
| 19 |
GPIN_PT_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Professional Tax Registration No.
|
| 20 |
GPIN_PT_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Professional Tax Registration Date.
|
| 21 |
GPIN_PT_RENW_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Professional Tax Registration Renewal Date.
|
| 22 |
GPIN_IT_PAN_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Permanent Account Number.
|
| 23 |
GPIN_IT_PAN_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Permanent Account Number (PAN) Registration Date.
|
| 24 |
GPIN_IT_PAN_RENWDT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Permanent Account Number (PAN) Registration Renewal Date.
|
| 25 |
GPIN_IT_TAN_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Tax Deduction Account Number.
|
| 26 |
GPIN_IT_TAN_DT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Tax Deduction Account Number (TAN) Registration Date.
|
| 27 |
GPIN_IT_TAN_RENWDT |
Date(10) |
DATE |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Tax Deduction Account Number (TAN) Registration Renewal Date.
|
| 28 |
GPIN_IT_WARD |
Character(50) |
VARCHAR2(50) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Income Tax Ward details.
|
| 29 |
GPIN_IT_RANGE |
Character(50) |
VARCHAR2(50) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Income Tax Range details.
|
| 30 |
GPIN_IT_TDS_CIRCLE |
Character(50) |
VARCHAR2(50) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Income Tax TDS Circle details.
|
| 31 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 32 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 33 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 34 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 35 |
GPIN_PT_PTO_CIRCLE |
Character(50) |
VARCHAR2(50) NOT NULL |
This Field is created for entering the PTO Circle for Profession Tax.
|
| 36 |
GPIN_CLS_EMPL_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Employee Clasification Code for Establishment IND
|
| 37 |
GPIN_LWF_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
This field holds the value for LWF Registration number.
|
| 38 |
GPIN_LWF_DT |
Date(10) |
DATE |
This holds as of when establishments has been registered for LWF
|
| 39 |
GPIN_LWF_RENEW_DT |
Date(10) |
DATE |
This field holds the value for Registration Renewal Date
|
| 40 |
GPIN_LWF_DEPT_NUM |
Character(50) |
VARCHAR2(50) NOT NULL |
This field holds LWF Department number.
|
| 41 |
GPIN_CENTRAL_HQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Central Headquaters Establishment
Y/N Table Edit
Default Value: N
|
| 42 |
GPIN_ED_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Deductor Type
A=Central Government
B=Body Of Individuals
D=Statutory Body (Central Govt.)
E=Statutory Body (State Govt.)
F=Firm
G=Autonomous body (Central Govt)
H=Autonomous body (State Govt)
J=Artificial Juridicial Person
K=Company
L=Local Authority (Central Govt)
M=Branch / Division of Company
N=Local Authority (State Govt.)
P=Association Of Person (AOP)
Q=Individual/HUF
S=State Government
T=Association Of Person (Trust)
|
| 43 |
GPIN_DS_DIGID |
Character(30) |
VARCHAR2(30) NOT NULL |
Digital Signature ID
Prompt Table:
GPIN_DS_SIG_TBL
|
| 44 |
GPIN_TAN_REG_NO |
Character(12) |
VARCHAR2(12) NOT NULL |
Tan Registration Number
|
| 45 |
GPIN_AIN |
Character(7) |
VARCHAR2(7) NOT NULL |
Account Office Identification Number (AIN) of PAO/ TO/ CDDO
|