POZ_BUS_CLASS

Details

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

Primary Key

Name	Columns
POZ_BUS_CLASS_REQS_PK	BUS_CLASS_REQUEST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BUS_CLASS_REQUEST_ID	NUMBER		18	Yes	Business classification request identifier
STATUS	VARCHAR2	4			Status. This column is OBSOLETE.
MAPPING_ID	NUMBER		18	Yes	Identifier of the supplier mapping
REQUEST_TYPE	VARCHAR2	30		Yes	Type of the request
REQUEST_STATUS	VARCHAR2	30		Yes	Status of the request
CLASSIFICATION_ID	NUMBER		18		Identifier of a supplier business classification
LOOKUP_CODE	VARCHAR2	30		Yes	Code of business classification lookup
EXT_ATTR_1	VARCHAR2	240			Currently stores miniority group code
CERTIFICATION_NO	VARCHAR2	80			Certification number
CERTIFYING_AGENCY_ID	NUMBER		18		The identifier of the Certifying Agency, who has issued the business classification certificate.
CERTIFICATION_AGENCY	VARCHAR2	255			Certification agency. This column is OBSOLETE.
OTHER_CERTIFYING_AGENCY	VARCHAR2	255			Field to capture 'other cerifying agencies' apart from those in the certifying agencies list.
START_DATE	DATE				Start Date of the classification certificate.
EXPIRATION_DATE	DATE				Expiration date of the certification
NOTES	VARCHAR2	1000			Notes - 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 updated. This is used by POQ questionnaire response flows to update the date on which the record was last updated.
ROW_STATUS	VARCHAR2	15			Status of the business classification row – UNMODIFIED, UPDATED or NEW.
PROCESS_STATUS	VARCHAR2	15			Process status of the business classification row. Possible values are PROCESSED, DISCARDED, DUPLICATE.
DUP_OF_BC_REQ_ID	NUMBER		18		Stores the BUS_CLASS_REQUEST_ID of the original row that is going to be processed.
CLASSIFICATION_ID_ORIGINAL	NUMBER		18		Identifier of a business classification. This is used by POQ questionnaire response flows to identify the main table row on response submission.
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.
SUPPLIER_REG_ID	NUMBER		18		Identifier of the supplier registration

Foreign Keys

Table	Foreign Table	Foreign Key Column
POZ_BUS_CLASS_REQS	poz_supplier_mappings	MAPPING_ID
POZ_BUS_CLASS_REQS	poz_bus_classifications	CLASSIFICATION_ID
POZ_BUS_CLASS_REQS	hz_parties	PROVIDED_BY_CONTACT_ID
POZ_BUS_CLASS_REQS	poz_supplier_registrations	SUPPLIER_REG_ID
POZ_BUS_CLASS_REQS	poz_bus_classifications	CLASSIFICATION_ID_ORIGINAL
poz_supp_bus_class_requests	poz_bus_class_reqs	SUPP_BUS_CLASS_RQST_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POZ_BUS_CLASS_REQS_N1	Non Unique	Default	MAPPING_ID, REQUEST_STATUS
POZ_BUS_CLASS_REQS_N2	Non Unique	Default	CERTIFYING_AGENCY_ID
POZ_BUS_CLASS_REQS_N3	Non Unique	Default	SUPPLIER_REG_ID
POZ_BUS_CLASS_REQS_U1	Unique	Default	BUS_CLASS_REQUEST_ID