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.

ORG_LOCATION

(SQL Table)

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.

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(6) VARCHAR2(6) 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: STATE_TBL

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

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.

#	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(6)	VARCHAR2(6) 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: STATE_TBL
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
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.