GPIT_PROV

(SQL Table)
Index Back

INPS Site Table

INPS Site Table

  • Related Language Record: GPIT_PROV_LNG
  • Parent Record Of GPIT_PROV_ADDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPIT_PROVIDER_CD Character(4) VARCHAR2(4) NOT NULL Provider Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 GPIT_PROVIDER_TYPE Character(2) VARCHAR2(2) NOT NULL Provider Type
    01=Company sending File directly
    06=Government Administration
    07=Post Administration
    08=Partner Banks
    10=Others
    6 GPIT_TAX_CD Character(16) VARCHAR2(16) NOT NULL Tax Code
    7 GPIT_TAX_CD_1 Character(16) VARCHAR2(16) NOT NULL Tax Code
    8 GPIT_TAX_CD_2 Character(16) VARCHAR2(16) NOT NULL Tax Code
    9 INPS_SITE_CD_ITA Character(4) VARCHAR2(4) NOT NULL INPS Site Code

    Prompt Table: INPS_SITE_ITA