HR_COMPANY_VW

(SQL View)
Index Back

Company View

Company View

SELECT A.COMPANY , A.DESCR , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.STATE , A.COUNTRY , A.POSTAL , A.FEDERAL_EIN , A.SETID_LOCATION , A.LOCATION , A.REG_REGION , B.DESCR , B.COUNTRY_2CHAR FROM PS_COMPANY_TBL A , PS_COUNTRY_TBL B WHERE A.COUNTRY = B.COUNTRY AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_COMPANY_TBL B WHERE A.COMPANY = B.COMPANY AND B.EFFDT <= %CurrentDateIn )

  • Related Language Record: HR_COMP_VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    4 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    5 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    6 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    7 CITY Character(30) VARCHAR2(30) NOT NULL City
    8 STATE Character(6) VARCHAR2(6) NOT NULL State
    9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    10 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    11 FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Federal EIN
    12 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

    Prompt Table: SET_LOC_VLD_VW

    13 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: SET_LOC_VW

    14 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    15 COUNTRY_NM Character(30) VARCHAR2(30) NOT NULL Country Name
    16 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code