HR_SRCH_LOC_VW

(SQL View)
Index Back

Company Site Locations

--This table has been synchronized with the ERP Table definition. Any changes will need to be applied to the LOCATION_TBL definition in the ERP database. LOCATION_TBL is an edit table. Use it to record information about your company's work sites.

SELECT SETID , LOCATION , EFFDT , EFF_STATUS , DESCR , DESCRSHORT ,DESCR_AC FROM PS_LOCATION_TBL LOC WHERE %EffdtCheck(LOCATION_TBL, LOC, %CurrentDateIn) AND LOC.EFF_STATUS='A'

  • Related Language Record: LOCATION_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_03

    2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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