Manufacturer: The master list of component manufacturers legal business names used in the Beam Instrumentation Group (BIG).

Full Name:

Source:

Definition: 

Distributor Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Distributor Identifer		VARCHAR(20)	NO	Manufacturer Identifier: The unique code used to identify a manufacturer.
Distributor Name	Name	VARCHAR(120)	NO	Manufacturer Name: The full name of the manufacturer.
Distributor Type Identifier	Identifier	VARCHAR(20)	NO
Distributor Status Identifier	Identifier	VARCHAR(10)	NO
GSA Certification Identifier		VARCHAR(50)	YES
ISO 9000 Indicator	Indicator	CHAR(1)	NO
Address 1	Address 1	VARCHAR(120)	YES
Address 2	Address 2	VARCHAR(120)	YES
City	City	VARCHAR(75)	YES	City:
State	State	VARCHAR(50)	YES	State: State within the United States for America.
Postal Code	Postal Code	VARCHAR(10)	YES
Phone	Phone	VARCHAR(20)	YES
Fax Number	Fax Number	VARCHAR(20)	YES
Sales Contact Name	Name	VARCHAR(120)	YES	Name: A long description name usually accompanied by an abbreviated code.
Technical Support Name	Name	VARCHAR(120)	YES	Name: A long description name usually accompanied by an abbreviated code.
Web Addr	URL	VARCHAR(2048)	YES	Website Address" The internet website address (URL) for the manufacturer.
Buy American Documentation		VARBINARY/BLOB(50)	YES
Justification Documentation		VARBINARY/BLOB(50)	YES

Distributor Keys

Key Name	Key Type	Keys
PK_DISTR	PrimaryKey	Distributor Identifer

Distributor Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Distributor Status	Non-Identifying	One To Zero or More				Distributor Status Identifier	NO
Distributor Type	Non-Identifying	One To Zero or More				Distributor Type Identifier	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Manufacturer Distributor Association	Identifying	One To Zero or More					NO

Distributor Check Constraints

Check Constraint Name

CheckConstraint

Distributor Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Distributor Security Types

Name	Current Value

Distributor Bound Attachments

Name	Current Value

Distributor Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical BICS.Distributor	NO
ALARM_MYSQL (MySQL) Does Not Exist	NO
ALARM_ORACLE (Oracle) Does Not Exist	NO
BICS (Oracle) BICS.DISTR	NO
BLM (Oracle) Does Not Exist	NO
BYPASS_REQ (Oracle) Does Not Exist	NO
CHAN_ARCH (Oracle) Does Not Exist	NO
CNMS_PRPSL (Oracle) Does Not Exist	NO
DIAG (Oracle) Does Not Exist	NO
DIAG_MPS (Oracle) Does Not Exist	NO
ENGA (Oracle) Does Not Exist	NO
EPICS (Oracle) Does Not Exist	NO
EQUIP (Oracle) Does Not Exist	NO
EXPRESS (Oracle) Does Not Exist	NO
ICS_SFTW_APPL (Oracle) Does Not Exist	NO
INSTR (Oracle) Does Not Exist	NO
Instrument Logbook (Oracle) Does Not Exist	NO
INVT (Oracle) Does Not Exist	NO
IONSRC (Oracle) Does Not Exist	NO
IONSRC1 (Oracle) Does Not Exist	NO
IPTSv5 (Oracle) Does Not Exist	NO
IRMISBase (Oracle) Does Not Exist	NO
Logbook (Oracle) Does Not Exist	NO
Magnet (Oracle) Does Not Exist	NO
MPS (Oracle) Does Not Exist	NO
NS_OPER (Oracle) Does Not Exist	NO
OPER (Oracle) Does Not Exist	NO
PART (Oracle) Does Not Exist	NO
PRINT (Oracle) Does Not Exist	NO
PROC (Oracle) Does Not Exist	NO
PRPSL (Oracle) Does Not Exist	NO
PUBL (Oracle) Does Not Exist	NO
PUBL_V1 (Oracle) Does Not Exist	NO
PV_LOGGER (Oracle) Does Not Exist	NO
SCORE (Oracle) Does Not Exist	NO
SICAT (Oracle) Does Not Exist	NO
SMPL (Oracle) Does Not Exist	NO
SMPLACT (Oracle) Does Not Exist	NO
SURVEY (Oracle) Does Not Exist	NO
Watchman (Oracle) Does Not Exist	NO
XAL_OPTICS (Oracle) Does Not Exist	NO
XF_ADMIN (Oracle) Does Not Exist	NO

Distributor Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Beam Instrumentation Component
BICS (Oracle)	Main Model

Distributor Data Movement Rules

Name

Type

Rule Text/Value