Address_Role


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name Address_Role
Entity Type Extension of Address
Description The role or purpose for which the address is used. For example, a single address may represent both the headquarters of a company and the place to which invoices are sent. These are two separate roles for a single address.
Submodel Business_Associate
Entity Scope Shared
Primary Key Id
Natural Key Address_Role_Type , Address_Id , Existence_Kind , Version
Generalizations IT_Object , Tracked_Object
Specializations


Columns

[Previous] [Next] [Top]
NameValue Domain /
Measurement
DescriptionRequired /
Default
Type
Address_Id Address
A number that uniquely identifies the address which plays a particular role. Yes
NUMBER(38)
Address_Role_Type R_Address_Role
A mnemonic code that defines the role of the address, i.e., the purpose for which an address is used. For example an address may serve as both the legal headquarters and as the site to which remittances are mailed, while another address for the same company is where invoices are mailed. Another use is to designate a person`s phone number as either a home phone or work phone. No
VARCHAR2(64)
End_Date DATE
NA
The date (and optionally time of day) that the address role expires. No
DATE
Existence_Kind REF_EXISTENCE_KIND
NA
A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. Yes
Actual
VARCHAR2(64)
GUID STRING128
NA
Globally Unique IDentifier for an instance of a class. This GUID is not generated by the database, but is the GUID used by the application on first access of this object. Use of this property is optional and completely under the control of application developers. No
VARCHAR2(128)
Id ID
No_Unit
Unique identifier for this entity. Yes
NUMBER(38)
Insert_Date DATE
NA
Date the entity was created in the repository No
DATE
Insert_User STRING64
NA
The name of the user responsible for the creation of this entity in the repository. No
VARCHAR2(64)
Produced_By STRING64
NA
ID of the activity that was executing when the entity was created, for data created programmatically. No
VARCHAR2(64)
Rank int
No_Unit
Identifies the priority of this address within the role for the business associate. Priority 1 indicates the primary address of this role for the business associate. No
1
NUMBER(10)
SDAT_Label int
No_Unit
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. No
NUMBER(10)
Start_Date DATE
NA
The date (and optionally the time of day) that the address role becomes effective. No
DATE
Update_Date DATE
NA
Date of the most-recent modification to the entity. No
DATE
Update_User STRING64
NA
The name of the user responsible for the last modification to this entity. No
VARCHAR2(64)
Version STRING255
NA
The form or variant of the entity. Yes
1
VARCHAR2(255)


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Address_Role_Type R_Address_Role A mnemonic code that defines the role of the address, i.e., the purpose for which an address is used. For example an address may serve as both the legal headquarters and as the site to which remittances are mailed, while another address for the same company is where invoices are mailed. Another use is to designate a person`s phone number as either a home phone or work phone. Restrict No
Address Address A number that uniquely identifies the address which plays a particular role. Cascade Yes


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2009 Schlumberger. All rights reserved.