PS_ORG_LOC_PHONES Table - Data Element Index


			<< go back

Select a data element to view its definition and its indexed, format, and null values.

Data element	Definition
EXT_ORG_ID Indexed - Yes Format - VARCHAR2 Nullable - N	unique identifier for org (non-individual) records
ORG_LOCATION Indexed - No Format - NUMBER Nullable - N	Number indicating the organization for which this record is valid. See PS_ORG_LOCATION table.
PHONE_TYPE Indexed - Yes Format - VARCHAR2 Nullable - N	Phone number type (ex. 'HOM1' for first home phone).
COUNTRY_CODE Indexed - Yes Format - VARCHAR2 Nullable - N	Country.
PHONE Indexed - No Format - VARCHAR2 Nullable - N	Phone number.

Questions about this page? Email us at da-staff@isc.upenn.edu