GP_COMPANY_VW

(SQL View)
Index Back

Company Codes

Clone company table used in Payroll Analytics

SELECT A.COMPANY ,A.EFFDT ,A.DESCR FROM PS_COMPANY_TBL A WHERE %EffdtCheck(COMPANY_TBL A1, A, %CurrentDateIn) AND A.EFF_sTATUS='A'

  • Related Language Record: GP_CMPNY_LNG_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 GP_PA_COMP_DESCR Character(30) VARCHAR2(30) NOT NULL Used in payroll analytics