OIA_INTERVIEW_VERSIONS

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_N6	Non Unique	DEFAULT	LAST_UPDATE_DATE
OIA_INTERVIEW_VERSIONS_PK	Unique	DEFAULT	INTERVIEW_VERSION_ID