PI_CONFIG_TBL

(SQL Table)
Index Back

PYI Configuration Table

Payroll Interface Configuration Definition

  • Related Language Record: PI_CONFIG_LANG
  • Parent Record Of PI_CONFIG_FILE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PI_CONFIG_ID Character(6) VARCHAR2(6) NOT NULL PI Configuration ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    5 PI_SYSTEM_ID Character(4) VARCHAR2(4) NOT NULL Payroll Interface System ID

    Prompt Table: PI_SYSTEM_TBL