SDM_STATUSES

This is a lookup table for form/journal statuses.

Primary Key

Table 4-183 Primary Key Table

Constraint Name	Columns
SDM_STATUSES_PK	STATUS_ID

Columns

Table 4-184 Column Details Table

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
STATUS_ID	NUMBER		18	0	No	Unique identifier of the record.
CATEGORY_ID	NUMBER		18	0	Yes	Numerical identifier of detail statuses category.
STATUS	VARCHAR2	32			Yes	Internal text representation of status, for example, PENDING.
CATEGORY	VARCHAR2	16			Yes	Category of detail status: in-process, completed, pending, empty for a status category.
TYPE	VARCHAR2	1			Yes	Descriminator: C = status category, T = detail status.
ICON	VARCHAR2	64			Yes	Internal path to the representative icon.
SORT_ORDER	NUMBER		2	0	Yes	Provides logical ordering for lists and tables.
CATEGORY_SORT_ORDER	NUMBER		2	0	Yes	Provides logical ordering by category in lists and tables.
OBJECT_VERSION_NUMBER	NUMBER		9	0	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.
LAST_UPDATE_LOGIN	VARCHAR2	255			Yes	Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATE_DATE	DATE				Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	255			Yes	Who column: indicates the user who last updated the row.
CREATED_BY	VARCHAR2	255			Yes	Who column: indicates the user who created the row.

Indexes

Table 4-185 Index Table

Index	Uniqueness	Columns
SDM_STATUSES_PK	UNIQUE	STATUS_ID