POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
The place or location where a business associate may be contacted or a facility may be located. The types of addresses include mailing addresses, physical or street addresses, email addresses and telephone numbers.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- instance_create_date (O: TIMESTAMP)
- e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
- last_updated (O: TIMESTAMP)
- e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
- entity_type_nm (M: CHAR VARYING(30))
- Column that contains the name of the entity that this row is an instance of in case a table represents multiple entities. Possible values are: email_address, mailing_address, phone_number, physical_address, www_address.
- area_code (O: CHAR VARYING(10))
- phone_number.area_code
The area code part of a telephone number.
- country_code (O: CHAR VARYING(10))
- phone_number.country_code
The country code part of a telephone number.
- data_value (O: CHAR VARYING(80))
- email_address.data_value
The address to which electronic mail can be sent.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- effective_date (O: DATE)
- address.effective_date
The date after which this address is effective.
- expiry_date (O: DATE)
- address.expiry_date
The date after which this address is no longer effective.
- extension_code (O: CHAR VARYING(10))
- phone_number.extension_code
The extension number or characters assigned to a business associate as part of a phone number.
- instance_creator (O: CHAR VARYING(80))
- e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
- last_updated_by (O: CHAR VARYING(80))
- e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
- line_1 (O: CHAR VARYING(40))
- mailing_address.line_1
The first line of a multi-line address. This line does not contain the city, state, country or postal code.
- line_2 (O: CHAR VARYING(40))
- mailing_address.line_2
The second line of a multi-line address. This line does not contain the city, state, country or postal code.
- line_3 (O: CHAR VARYING(40))
- mailing_address.line_3
The third line of a multi-line address. This line does not contain the city, state, country or postal code.
- local_phone_number (O: CHAR VARYING(10))
- phone_number.local_phone_number
The local phone number part of a telephone number.
- room_number (O: CHAR VARYING(40))
- physical_address.room_number
An identifier to specify a room, apartment or suite as part of a physical address. For example, the POSC Houston room number is suite 275.
- source (O: CHAR VARYING(80))
- e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
- street_name (O: CHAR VARYING(40))
- physical_address.street_name
The name of the street in a physical address. For example, the POSC Houston street name is Westheimer.
- street_number (O: CHAR VARYING(40))
- physical_address.street_number
The identification of a building on a street, such as a building number. For example, the POSC Houston street number is 10777. In places where buildings are named, this would be the name of the building.
- street_suffix (O: CHAR VARYING(40))
- physical_address.street_suffix
The address information which is placed after the street name in an address. An example is appending SW to a street name.
- url (O: CHAR VARYING(255))
- www_address.url
This is the Universal Resource Locator defined for a world wide web site.
- business_associate_s (FSK, O: CHAR VARYING(19))
- address.business_associate
Specifies the business associate located by this address.
Defines a foreign key to table business_associate.
- facility_s (FSK, O: CHAR VARYING(19))
facility_t (O: CHAR VARYING(30))
- address.facility
Specifies the facility located by this address.
facility_s: Implements a foreign key to a row in one of the tables projected from entity facility depending on the value of the next column (See below).
facility_t: Defines the name of the referenced table. Possible values are defined in @facility.
- physical_address_s (FSK, O: CHAR VARYING(19))
- phone_number.physical_address
Defines the physical address where this phone is located.
Defines a foreign key to table address.
- postal_code_s (FSK, O: CHAR VARYING(19))
- mailing_address.postal_code
A code defined by the postal authority at the receiving location. An example is the five or nine digit numeric code in the USA or the six digit alphanumeric code in Canada.
Defines a foreign key to table r_postal_code.
- r_address_qualifier (FNK, O: CHAR VARYING(80))
- address.ref_address_qualifier
The qualifier of an address, such as office or home.
Defines a foreign key to table r_address_qualifier.
Table is related to: contract_designation, contract_object_designation, contract_oblig_object_fulfil, data_collection_content, derived_interest_makeup, document_specification_part, @graphical_element, guideline_compliance, mailing_address_feature_incl, object_activity_involvement, object_remark, object_subject_to_guideline, address, phone_number_classification, physical_address_feature_incl, subject_of_contract
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:01:29 2001
© Copyright 2001 POSC. All rights reserved.