POQ_RESP_REPOS_BUS

Details

Schema: FUSION
Object owner: POQ
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
POQ_RESP_REPOS_BUS_CLASS_PK	RESP_REPOS_BUS_CLASS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RESP_REPOS_BUS_CLASS_ID	NUMBER		18	Yes	Unique identifier for response respository business classification.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
RESPONSE_REPOSITORY_ID	NUMBER		18	Yes	Identifier of the response repository row.
CLASSIFICATION_CODE	VARCHAR2	30		Yes	Lookup code for the business classification type.
CLASSIFICATION_ID	NUMBER		18	Yes	Classification identifier on the POZ_BUS_CLASSIFICATIONS table.
POZ_VERSION_NUMBER	NUMBER		9	Yes	The value of the object version number on the corresponding POZ_BUS_CLASSIFICATIONS row.
CERTIFYING_AGENCY_ID	NUMBER		18		Identifier of the certifying agency that granted the business classification certificate to the supplier.
START_DATE	DATE				The start date of the business classification certificate.
EXT_ATTR_1	VARCHAR2	240			This is used to store some relevant information related to the row. For example, this column is used to store the minority type for the minority owned business classification.
OTHER_CERTIFYING_AGENCY	VARCHAR2	255			Field to capture other certifying agencies apart from those in the list.
CERTIFICATE_NUMBER	VARCHAR2	80			Certificate number of the certificate granted to the supplier for the classification.
EXPIRATION_DATE	DATE				Expiration date of the certificate.
PROVIDED_BY_CONTACT_ID	NUMBER		18		Identifier of the supplier contact who has provided the classification information.
CONFIRMED_ON	DATE				The date on which the classification row is last updated.
NOTES	VARCHAR2	1000			Provision to capture any additional information regarding the classification.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
POQ_RESP_REPOS_BUS_CLASS	poq_response_repository	RESPONSE_REPOSITORY_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POQ_RESP_REPOS_BUS_CLASS_PK	Unique	Default	RESP_REPOS_BUS_CLASS_ID
POQ_RESP_REPOS_BUS_CLASS_U1	Unique	Default	RESPONSE_REPOSITORY_ID, CLASSIFICATION_ID