INV_LOCATION_VW

(SQL View)
 Index Back

Location Accept/Origin View

Defines the locations used to identify a particular route stop number on the Route Stop Assignment Panel.

SELECT a.setid , a.location , a.effdt , a.eff_status , a.descr , a.descr_ac , a.descrshort , a.address1 , a.address2 , a.address3 , a.address4 , a.city , a.state , a.postal , a.county , a.country FROM PS_LOCATION_TBL a WHERE a.effdt <= ( SELECT MAX(effdt) FROM PS_LOCATION_TBL WHERE setid=a.setid AND location=a.location AND effdt<=%CurrentDateIn) AND 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_FS.SETID

    Prompt Table: SP_SETID_NONVW

    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 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    9 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    10 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    11 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    12 CITY Character(30) VARCHAR2(30) NOT NULL City
    13 STATE Character(6) VARCHAR2(6) NOT NULL State
    14 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    15 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country