EXT_ORG_CODES (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.

EXT_ORG_CODES

(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.

# 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 EXT_ORG_CD_TYPE Character(10) VARCHAR2(10) NOT NULL Ext Org Code Type
Prompt Table: %EDITTABLE

3 POSTAL_EPS Character(5) VARCHAR2(5) NOT NULL EPS Postal Code
Prompt Table: EPS_ZIPMRKT_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	EXT_ORG_CD_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Ext Org Code Type Prompt Table: %EDITTABLE
3	POSTAL_EPS	Character(5)	VARCHAR2(5) NOT NULL	EPS Postal Code Prompt Table: EPS_ZIPMRKT_TBL