SDM_FORM

This table stores all form and journal templates of the system.

Primary Key

Table 4-63 Primary Key Table

Constraint Name	Columns
SDM_FORM_PK	FORM_ID

Foreign Key

Table 4-64 Foreign Key Table

Table	Foreign Table	Foreign Key Columns
SDM_FORM	SDM_FREQUENCY	FREQUENCY_ID
SDM_FORM	SDM_SCENARIO	SCENARIO_ID
SDM_FORM	SDM_DC_INTERVAL	DCI_ID
SDM_FORM	SDM_TARGET	TARGET_ID
SDM_FORM	SDM_FORM	MASTER_ID

Columns

Table 4-65 Column Details Table

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
FORM_ID	NUMBER		18	0	No	Unique identifier of the record.
NAME	VARCHAR2	80			No	Name of the form template.
DCI_ID	NUMBER		18	0	No	Interval, to which, this record belongs. Refers to DCI_ID of SDM_DC_INTERVAL table.
ALLOW_ADHOC_INSTANCE	CHAR	1			No	Indicates whether Ad-hoc form instance creation is permitted.
LOCK_DATA_AFTER_POST	CHAR	1			No	Indicates whether data should be locked once form or journal is posted.
APP_ID	NUMBER		1	0	No	Identifier for the application to which the row corresponds to, for example, SDM:4.
SCENARIO_ID	NUMBER		18	0	Yes	Scenario, to which, this form template belongs. Refers to DYNAMIC_DATA_ID of SDM_SCENARIO table.
DESCRIPTION	VARCHAR2	1000			Yes	Description of the form template.
TARGET_ID	NUMBER		18	0	Yes
FREQUENCY_ID	NUMBER		18	0	Yes
SCHEDULE_OPTION	VARCHAR2	80			Yes	Indicates the data collection period date, from which, start date of the form should be calculated, for example, End Date or Close Date
START_DAY_OFFSET	NUMBER		4	0	Yes	Indicates the offset from End Date or Close Date to calculate start date of the form.
WORKFLOW_OPTION	VARCHAR2	80			Yes	Indicates the workflow option to be used for form, for example, Prepare, Prepare->Approve, Prepare->Approve->Post, Prepare->Post, Post
APPROVAL_LEVEL	NUMBER		4	0	Yes	Number of level of approvals, required for the form.
PREPARER_DURATION	NUMBER		4	0	Yes	Number of days available to the preparer to work on the form.
APPROVER_DURATION	NUMBER		4	0	Yes	Number of days available to each approver to work on the form.
INTEGRATOR_DURATION	NUMBER		4	0	Yes	Number of days available to the integrator to work on the form.
WF_USER_VIEW_OPTION	VARCHAR2	40			Yes	Indicates when workflow user can view the form and data, for example, Always, Workflow.
MASTER_ID	NUMBER		18	0	Yes	During deploy, copy record is created. This field is populated in copy record to point to the master record. Refers to primary key of this same table.
IS_MASTER_MODIFIED	CHAR	1			Yes	Indicates whether master record is modified after deploy. This field is applicable for copy records only. It will always be NULL for master record.
DCP_ID	NUMBER		18	0	Yes	Data Collection Period, to which, this copy record belongs. Refers to DCP_ID of SDM_DATA_COLLECTION_PERIOD table.
APP_ID	NUMBER		1	0	No	Identifier for the application to which the row corresponds to, for example, SDM:4.
OBJECT_VERSION_NUMBER	NUMBER		9	0	No	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_UPDATED_BY	VARCHAR2	255			No	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	DATE				No	Who column: indicates the date and time of the last update of the row.
CREATED_BY	VARCHAR2	255			No	Who column: indicates the user who created the row.
CREATION_DATE	DATE				No	Who column: indicates the date and time of the creation of the row.

Indexes

Table 4-66 Index Table

Index	Uniqueness	Columns
SDM_FORM_PK	UNIQUE	FORM_ID
SDM_FORM_U2_MASTER_DCP	UNIQUE	MASTER_ID, DCP_ID
SDM_FORM_U1_NM_SNRIO_DCP	UNIQUE	SYS_NC00028$, SCENARIO_ID, DCP_ID, APP_ID