HRS_CMPNY_LVW

(SQL View)
 Index Back

Company View

Company Related Language View - Default Search by Company Description

SELECT A.COMPANY ,B.LANGUAGE_CD ,B.EFFDT ,B.DESCR ,B.DESCR_AC ,B.DESCRSHORT FROM %Table(COMPANY_TBL) A , %Table(COMPNY_TBL_LANG) B WHERE %EffdtCheck(COMPANY_TBL C, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.COMPANY=B.COMPANY

  • Related Language Record for HRS_CMPNY_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY_ALT Character(3) VARCHAR2(3) NOT NULL Company
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Char Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description