GPFR_DA_EST_VW

(SQL View)
Index Back

Etablishment View (Company)

This view retrieves the establishments associated to a gien company

SELECT A.COMPANY , A.ESTABID , A.EFFDT , A.EFF_STATUS , A.DESCR , B.CLOSE_DT_FRA FROM PS_ESTAB_TBL A , PS_ESTAB_TBL_FRA B WHERE %Join(COMMON_KEYS, ESTAB_TBL A, ESTAB_TBL_FRA B)

  • Related Language Record: GPFR_DA_EVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_DA_COMPANY Character(3) VARCHAR2(3) NOT NULL DADS related field
    2 GPFR_DA_ESTAB Character(12) VARCHAR2(12) NOT NULL DADS related field
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 CLOSE_DT_FRA Date(10) DATE Establishment Close date