GPUS_RPT_CO_VW

(SQL View)
Index Back

Year End Company View

Year End Company View

SELECT GPUS_YE_RPT_CO , EFFDT , DESCR , GPUS_TAX_EIN FROM PS_GPUS_YE_CO_TBL

  • Related Language Record: GPUS_RPT_VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPUS_YE_RPT_CO Character(3) VARCHAR2(3) NOT NULL Year-End Reporting Company

    Prompt Table: GPUS_CO_USA_VW

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: GPUS_YECODSR_VW.DESCR

    4 GPUS_TAX_EIN Character(9) VARCHAR2(9) NOT NULL Federal Employer Identification Number

    Default Value: GPUS_YECOEIN_VW.GPUS_TAX_EIN