1. Tables and Views for Sales and Fusion Service
  2. OIA_INTERVIEW_VERSIONS

OIA_INTERVIEW_VERSIONS

This table stores the details of each version of the Interview Definition.

Details

  • Schema: FUSION

  • Object owner: OIA

  • Object type: TABLE

  • Tablespace: DEFAULT

Primary Key

Name Columns

OIA_INTERVIEW_VERSIONS_PK

INTERVIEW_VERSION_ID

Columns

Name Datatype Length Precision Not-null Comments
INTERVIEW_VERSION_ID NUMBER 18 Yes Auto-generated number and primary key for this table.
INTERVIEW_NAME VARCHAR2 100 Yes Name of the Interview Definition.
INTERVIEW_ID NUMBER 18 Yes Foreign key that references OIA_INTERVIEWS (INTERVIEW_ID).
MAJOR_VERSION NUMBER 9 Yes Published version of the Interview, incremented by 1 when the Interview is published.
MINOR_VERSION NUMBER 9 Yes Interim version of the Interview, incremented by 1 when a new save is done on the interview. Reset to zero when the Interview is published.
FORMAT_VERSION VARCHAR2 64 Yes Version of the Interviews Flow Engine.
OWNER_PARTY_ID NUMBER 18 Yes The ID of the current owner of the Interview, this isn't necessarily the same as the creator of the document.
OWNER_NAME VARCHAR2 100 Yes Normalized username of the owner of the record.
CREATED_BY_NAME VARCHAR2 100 Yes Normalized username of the user who created the record.
UPDATED_BY_NAME VARCHAR2 100 Yes Normalized username of the user who updated the record.
USER_PARTY_ID NUMBER 18 Yes The ID of the user associated with this record.
CHECKED_OUT_BY_PARTY_ID NUMBER 18 The ID of the user that checked out the Interview Definition.
LATEST_VERSION_FLAG VARCHAR2 1 Used to track the latest version of the Interview Definition (with LATEST_VERSION_FLAG = 'Y').
PUBLISHED_DATE TIMESTAMP Indicates the date and time of the publishing of the interview.
PUBLISHED_FLAG VARCHAR2 1 Used to track the published Interview (with PUBLISHED_FLAG = 'Y').
CHECKED_OUT_FLAG VARCHAR2 1 Used to track if the Interview is checked out (with CHECKED_OUT_FLAG = 'Y').
DELETED_FLAG VARCHAR2 1 Used to track if the Interview is marked as deleted (with DELETED_FLAG = 'Y').
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.
LOCALE_CD VARCHAR2 30 Locale of the interview.

Foreign Keys

Table Foreign Table Foreign Key Column
OIA_INTERVIEW_VERSIONS oia_interviews INTERVIEW_ID
oia_interview_drafts oia_interview_versions INTERVIEW_VERSION_ID
oia_interview_user_groups oia_interview_versions INTERVIEW_VERSION_ID
oia_interview_history oia_interview_versions INTERVIEW_VERSION_ID
oia_interview_data_versions oia_interview_versions INTERVIEW_VERSION_ID
oia_interview_associations oia_interview_versions INTERVIEW_VERSION_ID

Indexes

Index Uniqueness Tablespace Columns
OIA_INTERVIEW_VERSIONS_N1 Non Unique DEFAULT PUBLISHED_FLAG
OIA_INTERVIEW_VERSIONS_N2 Non Unique DEFAULT DELETED_FLAG
OIA_INTERVIEW_VERSIONS_N3 Non Unique DEFAULT LATEST_VERSION_FLAG
OIA_INTERVIEW_VERSIONS_N4 Non Unique DEFAULT UPPER("INTERVIEW_NAME")
OIA_INTERVIEW_VERSIONS_N5 Non Unique DEFAULT INTERVIEW_ID
OIA_INTERVIEW_VERSIONS_PK Unique DEFAULT INTERVIEW_VERSION_ID