RY_EE_LOC_VW

(SQL View)
 Index Back

WFC Location view

Workforce Connect - Related-display view on LOCATION_TBL

SELECT L.SETID %Concat '.' %Concat L.LOCATION , L.DESCR FROM PS_LOCATION_TBL L WHERE %EffdtCheck(LOCATION_TBL, L, %CurrentDateIn)

  • Related Language Record: RY_EE_LOC_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SID_LOCATION Character(21) VARCHAR2(21) NOT NULL Workforce Connect - Concatenated key for LOCATION_TBL
    2 DESCR_LOCATION Character(30) VARCHAR2(30) NOT NULL Description