Project_ID Logical Attribute Properties

Logical Attribute Name	Project_ID
Datatype	BIGINT
Nullable	NO

Project_ID Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Project_ID Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Project_ID	NO
BARD - MySQL (MySQL) Project Project_ID	NO
BARD_Dev (Oracle) PROJECT PROJECT_ID	NO

Project_Name Logical Attribute Properties

Logical Attribute Name	Project_Name
Datatype	VARCHAR(256)
Nullable	NO

Project_Name Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Project_Name Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Project_Name	NO
BARD - MySQL (MySQL) Project Project_Name	NO
BARD_Dev (Oracle) PROJECT PROJECT_NAME	NO

Group_Type Logical Attribute Properties

Logical Attribute Name	Group_Type
Datatype	VARCHAR(20)
Nullable	NO

Group_Type Domain Restrictions

CheckConstraint	GROUP_TYPE in ('Project', 'Probe Report', 'Campaign', 'Panel', 'Study', 'Template')
Check Constraint Name	CK_Project_Type
Bound Rule
Declared Default	'Project'
Bound Default

Group_Type Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Group_Type	NO
BARD - MySQL (MySQL) Project Group_Type	NO
BARD_Dev (Oracle) PROJECT GROUP_TYPE	NO

Description Logical Attribute Properties

Logical Attribute Name	Description
Datatype	VARCHAR(1000)
Nullable	YES

Description Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Description Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Description	NO
BARD - MySQL (MySQL) Project Description	NO
BARD_Dev (Oracle) PROJECT DESCRIPTION	NO

Project_Status Logical Attribute Properties

Logical Attribute Name	Project_Status
Datatype	VARCHAR(10)
Nullable	YES

Project_Status Domain Restrictions

CheckConstraint	Project_Status IN ('Draft', 'Approved', 'Retired')
Check Constraint Name	CK_PROJECT_STATUS
Bound Rule
Declared Default
Bound Default

Project_Status Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Project_Status	NO
BARD - MySQL (MySQL) Project Project_Status	NO
BARD_Dev (Oracle) PROJECT PROJECT_STATUS	NO

ready_for_extraction Logical Attribute Properties

Logical Attribute Name	ready_for_extraction
Datatype	VARCHAR(20)
Nullable	NO

ready_for_extraction Domain Restrictions

CheckConstraint	@var IN ('Not Ready', 'Ready', 'Started', 'Complete')
Check Constraint Name	CK_PROJECT_EXTRACTION
Bound Rule
Declared Default	'Pending'
Bound Default

ready_for_extraction Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project ready_for_extraction	NO
BARD - MySQL (MySQL) Project ready_for_extraction	NO
BARD_Dev (Oracle) PROJECT ready_for_extraction	NO

Version Logical Attribute Properties

Logical Attribute Name	Version
Datatype	INTEGER
Nullable	NO

Version Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default	0
Bound Default

Version Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Version	NO
BARD - MySQL (MySQL) Project Version	NO
BARD_Dev (Oracle) PROJECT VERSION	NO

Date_Created Logical Attribute Properties

Logical Attribute Name	Date_Created
Datatype	TIMESTAMP/DATE
Nullable	NO

Date_Created Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default	sysdate
Bound Default

Date_Created Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Date_Created	NO
BARD - MySQL (MySQL) Project Date_Created	NO
BARD_Dev (Oracle) PROJECT Date_Created	NO

Last_Updated Logical Attribute Properties

Logical Attribute Name	Last_Updated
Datatype	DATETIME
Nullable	NO

Last_Updated Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default	SYSDATE
Bound Default

Last_Updated Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Last_Updated	NO
BARD - MySQL (MySQL) Project Last_Updated	NO
BARD_Dev (Oracle) PROJECT Last_Updated	NO

Modified_by Logical Attribute Properties

Logical Attribute Name	Modified_by
Datatype	VARCHAR(40)
Nullable	YES

Modified_by Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Modified_by Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Modified_by	NO
BARD - MySQL (MySQL) Project Modified_by	NO
BARD_Dev (Oracle) PROJECT MODIFIED_BY	NO

NCGC_WAREHOUSE_ID Logical Attribute Properties

Logical Attribute Name	NCGC_WAREHOUSE_ID
Datatype	NUMERIC(19, 0)
Nullable	YES

NCGC_WAREHOUSE_ID Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

NCGC_WAREHOUSE_ID Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project NCGC_WAREHOUSE_ID	NO
BARD - MySQL (MySQL) Project NCGC_WAREHOUSE_ID	NO
BARD_Dev (Oracle) PROJECT NCGC_WAREHOUSE_ID	NO

OWNER_ROLE_ID Logical Attribute Properties

Logical Attribute Name	Role_ID
Datatype	NUMERIC(19, 0)
Nullable	YES

OWNER_ROLE_ID Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

OWNER_ROLE_ID Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Project Role_ID	NO
BARD - MySQL (MySQL) Project OWNER_ROLE_ID	NO
BARD_Dev (Oracle) PROJECT OWNER_ROLE_ID	NO