ORG_LOCATION

(SQL Table)
 Index Back

Organization Location Table

Use ORG_LOCATION to identify all the addresses an organization may have. Each location is assigned a unique number. Departments and contacts within an organization can be assigned a location number. Whenever an address changes it only has to be updated in one place, the ORG_LOCATION record.

  • Related Language Record: ORG_LOC_LANG

  • Parent record: EXT_ORG_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    2 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr
    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

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ORG_LOCATION.DESCR

    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    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 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    14 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2
    15 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    16 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    17 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    18 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    19 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    20 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    21 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    22 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    23 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    Default Value: Y

    24 URL_ADDRESS Character(254) VARCHAR2(254) NOT NULL URL Address
    25 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    26 EDI_ADDRESS Long Character(999) VARCHAR2(999) EDI Address
    27 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    28 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    29 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    30 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    31 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    32 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    33 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    34 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time