|POSC Specifications: Epicentre Version 3.0 ||Relational Implementation|
An organization or a person, with which some form of business association is made.
Table is related to: address, business_associate_alias, business_associate_injury, guideline_or_privilege, business_associate_service, business_association, business_assoc_earth_ftr_role, business_assoc_facility_involv, business_assoc_security_status, business_contact, contract_designation, contract_object_designation, contract_oblig_object_fulfil, data_collection, data_collection_content, derived_interest_makeup, document_specification_part, document_spec_business_assoc, exploration_area, @graphical_element, guideline_compliance, object_activity_involvement, object_remark, object_subject_to_guideline, permit_specification, pfnu_grid_cell_connection, pfnu_group_allocation, pfnu_period_operation_report, pfnu_port, regulation_administration, reserves, subject_of_contract, surface_fluid_phase_condition
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
A name which identifies a business associate.
- instance_create_date (O: TIMESTAMP)
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)
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).
- kind (FNK, M: CHAR VARYING(80))
The type used to characterize a business associate. It is also used to validate business associations for business association structures for which rules have been defined.
Defines a foreign key to table r_business_associate.
- description (O: CHAR VARYING(2000))
A remark or comment about the instance.
- end_date (O: TIMESTAMP)
end_date_cd (O: CHAR(1))
end_date_yr (O: FLOAT)
end_date_yp (O: INTEGER)
end_date_dy (O: INTEGER)
end_date_hr (O: INTEGER)
end_date_mt (O: INTEGER)
end_date_st (O: FLOAT)
end_date_of (O: FLOAT)
The date and time of day that a business associate is defined to cease existence, such as the date of death of a person, the termination date of a team, or the date that a department was eliminated.
- instance_creator (O: CHAR VARYING(80))
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))
This records the person or application making the update to this instance.
- source (O: CHAR VARYING(80))
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".
- start_date (O: TIMESTAMP)
start_date_cd (O: CHAR(1))
start_date_yr (O: FLOAT)
start_date_yp (O: INTEGER)
start_date_dy (O: INTEGER)
start_date_hr (O: INTEGER)
start_date_mt (O: INTEGER)
start_date_st (O: FLOAT)
start_date_of (O: FLOAT)
The date and time of day that a business associate is defined to begin existence, such as the birth date of a person, the date of incorporation for a corporation, or the creation date of a team.
- naming_system (FNK, O: CHAR VARYING(80))
The type of identifier for the business associate to allow the identification of a standardized identifier instance. For example, employee number, social security number, full name, nickname, etc.
Defines a foreign key to table naming_system.
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: IDENTIFIER
Generated on Tue Jul 10 16:04:18 2001
© Copyright 2001 POSC. All rights reserved.