POZ_APPROVAL_HISTORY
This table contains information about the approval and control history of supplier registration requests, spend authorization requests and supplier profile change requests, etc. This will enable us to show the critical approval action history even after SOA approval data is purged.
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
POZ_APPROVAL_HISTORY_PK |
APPROVAL_HISTORY_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
APPROVAL_HISTORY_ID | NUMBER | 18 | Yes | Approval history record unique identifier | |
APPROVAL_FLOW_CODE | VARCHAR2 | 25 | Yes | Stores the type of supplier approval, such as supplier registration approval, supplier spend authorization approval, supplier profile change approval, etc. | |
FLOW_OBJECT_ID | NUMBER | 18 | Yes | Stores Supplier Registration Request ID, Spend Authorization Request ID or Supplier Profile Change Request ID. | |
SEQUENCE_NUM | NUMBER | 18 | Yes | Sequence of the approval or control action for a request | |
ACTION_CODE | VARCHAR2 | 25 | Yes | Approval or control action type. Possible values are: SUBMIT (RESUBMIT), REQUEST_TO_RESUBMIT, APPROVE, REJECT, APPROVER_EDIT(for approver edit), REQUEST_FOR_INFO, SUBMIT_INFO, CANCEL etc | |
ACTION_DATE | TIMESTAMP | Yes | Approval or control action date | ||
ADDITIONAL_INFO | VARCHAR2 | 4000 | Additional information related to the approval or control action for a request | ||
PERFORMER_TYPE | VARCHAR2 | 30 | Yes | Type of the action performer. Possible values are PERSON, SUPP_USER and ANONYMOUS | |
PERFORMER_ID | NUMBER | 18 | Unique identifier of the person who took the action. PERSON_ID for internal person. If it is an anonymous user, then this will be null. If it is a supplier user, then it will the contact's PARTY_ID. | ||
AMX_IDENTIFICATION_KEY | VARCHAR2 | 100 | Identification Key for human task. | ||
VENDOR_ID | NUMBER | 18 | Refers to supplier vendor Id. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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_APPROVAL_HISTORY | poz_suppliers | VENDOR_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
POZ_APPROVAL_HISTORY_U1 | Unique | Default | APPROVAL_HISTORY_ID |
POZ_APPROVAL_HISTORY_U2 | Unique | Default | FLOW_OBJECT_ID, APPROVAL_FLOW_CODE, SEQUENCE_NUM |