POZ_SUPP_BUS_CLASS

Details

Schema: FUSION
Object owner: POZ
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
POZ_SUPP_BUS_CLASS_RQST_PK	SUPP_BUS_CLASS_RQST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SUPP_BUS_CLASS_RQST_ID	NUMBER		18	Yes	This field is the unique identifier for business classification details change
SUPP_REQUEST_ID	NUMBER		18	Yes	This field is the unique identifier for a supplier request.
CHANGE_REQ_ROW_TYPE	VARCHAR2	30		Yes	Type of the request. This could either be 'CHANGE' or 'SNAPSHOT' or 'NEW'
BUS_CLASS_REQUEST_ID	NUMBER		18		Business classification request identifier
CLASSIFICATION_ID	NUMBER		18		Unique identifier of a business classification row
LOOKUP_CODE	VARCHAR2	30		Yes	Lookup code for the business classification type
SUB_CLASSIFICATION	VARCHAR2	40			This column is used to store the sub classification for the Minority Owned business classification.
CERTIFICATION_NO	VARCHAR2	80			Certificate Number of the certificate granted to the supplier for the classification
CERTIFYING_AGENCY_ID	NUMBER		18		Identifier of the certifying agency that granted the business classification certificate to the supplier
OTHER_CERTIFYING_AGENCY	VARCHAR2	255			Field to capture 'other certifying agencies' apart from those in the list.
START_DATE	DATE				The Start Date of the business classification certificate.
EXPIRATION_DATE	DATE				The Expiration date of the business classification certificate.
NOTES	VARCHAR2	1000			Provision to capture any additional information regarding the classification
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.
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.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
POZ_SUPP_BUS_CLASS_REQUESTS	poz_supp_requests	SUPP_REQUEST_ID
POZ_SUPP_BUS_CLASS_REQUESTS	poz_bus_class_reqs	SUPP_BUS_CLASS_RQST_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POZ_SUPP_BUS_CLASS_RQST_N1	Non Unique	Default	SUPP_REQUEST_ID
POZ_SUPP_BUS_CLASS_RQST_PK1	Unique	Default	SUPP_BUS_CLASS_RQST_ID