GPBR_NRP_HP_IAD

(SQL Table)
Index Back

DIRF Health Providers Inf.

DIRF Health Providers Information

  • Parent record: GPBR_PARM_DIRF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    3 EFFDT Date(10) DATE Effective Date
    4 GPBR_DIRF_HLT_TYPE Character(2) VARCHAR2(2) NOT NULL DIRF Health Type
    10=Employee
    20=Dependent
    5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    6 GPBR_HEALTH_FIELD Character(1) VARCHAR2(1) NOT NULL Healt Provider User Field Number
    1=User Field 1
    2=User Field 2
    3=User Field 3
    4=User Field 4
    5=User Field 5
    6=User Field 6
    7 GPBR_DEPEND_FIELD Character(1) VARCHAR2(1) NOT NULL Depdente User Field Number
    0=Not applicable
    1=User Field 1
    2=User Field 2
    3=User Field 3
    4=User Field 4
    5=User Field 5
    6=User Field 6