SDM_FORM_INSTANCE
This table stores all forms/journals of the system.
Primary Key
Table 4-87 Primary Key Table
| Constraint Name | Columns |
|---|---|
| SDM_FRM_INS_PK | FORM_INSTANCE_ID |
Foreign Key
Table 4-88 Foreign Key Table
| Table | Foreign Table | Foreign Key Columns |
|---|---|---|
| SDM_FORM_INSTANCE | SDM_CURRENCY | ENTITY_CURRENCY_ID |
| SDM_FORM_INSTANCE | SDM_FORM | FORM_ID |
| SDM_FORM_INSTANCE | SDM_FORM_DCU | FORM_DCU_ID |
| SDM_FORM_INSTANCE | SDM_DATA_COLLECTION_PERIOD | DCP_ID |
| SDM_FORM_INSTANCE | SDM_FORM_DEPLOY | FORM_DEPLOY_ID |
Columns
Table 4-89 Column Details Table
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
| FORM_INSTANCE_ID | NUMBER | 18 | 0 | No | Unique identifier of the record. | |
| FORM_DEPLOY_ID | NUMBER | 18 | 0 | No | Deployment, to which, this form belongs. Refers to FORM_DEPLOY_ID of SDM_FORM_DEPLOY table. | |
| DCP_ID | NUMBER | 18 | 0 | No | Data Collection Period, to which, this form belongs. Refers to DCP_ID of SDM_DATA_COLLECTION_PERIOD table. | |
| FORM_DCU_ID | NUMBER | 18 | 0 | No | Data Collection Unit, to which, this form belongs. Refers to FORM_DCU_ID of SDM_FORM_DCU table. | |
| FORM_ID | NUMBER | 18 | 0 | No | Copy of Form template, to which, this form belongs. Refers to FORM_ID of SDM_FORM table. | |
| START_DATE | DATE | Start date of the form. | ||||
| CALC_END_DATE | DATE | Calculated end date of the form. | ||||
| FORM_INS_STATUS | NUMBER | 3 | 0 | No | Status of the form, for example, 32 - Pending, 6 - Open with Preparer, 10 - Open with Approver, 18 - Open with Integrator, 1 - Closed. | |
| IS_ADHOC | CHAR | 1 | No | Indicates whether this form is ad-hoc. | ||
| INTERNAL_ID | VARCHAR2 | 100 | No | Internal id for the object. Used primarily in LCM. | ||
| LOCK_DATA | CHAR | 1 | No | Indicates whether data should be locked or not. | ||
| POST_STATUS | VARCHAR2 | 20 | No | Target based posting status. NotPosted, ReadyToPost, PostInProgress, Posted, Failed etc. Not applicable to FCCS posting. | ||
| POST_STATUS_UPDATE_MODE | VARCHAR2 | 50 | Yes | Mode or method through which the status updated -Direct API, REST Service, EPM Automate etc. | ||
| POST_MESSAGE | VARCHAR2 | 255 | Yes | Message or Identifier for posting, This will store Batch ID in case of Cloud Financials. | ||
| POST_BATCH_NAME | VARCHAR2 | 100 | Yes | Stores batch name for the Cloud financial direct posting. | ||
| POST_GROUP_ID | NUMBER | 18 | 0 | Yes | Group identifier for the Cloud financial direct posting. | |
| VALIDATION_STATUS | VARCHAR2 | 20 | Yes | Target based validation status, for example, NotValidated, Passed, Failed. | ||
| POST_RESULT_IDENTIFIER | VARCHAR2 | 255 | Yes | Stores the Direct posting result ID, such as Batch ID in case of Cloud Financials. | ||
| DIRECT_POST_PROCESS_ID | VARCHAR2 | 40 | Yes | Direct posting process ID returned by the ERP in case of Async posting. This id will be used for polling. | ||
| DIRECT_POST_ERP_PHASE | VARCHAR2 | 40 | Yes | Stores the intermediate posting state of ERP. | ||
| ENTITY_CURRENCY_ID | NUMBER | 18 | 0 | Yes | Currency, associated with the Entity. | |
| ACTUAL_END_DATE | DATE | Yes | Actual end date of the form. | |||
| RESPONSIBILITY_LEVEL | NUMBER | 3 | 0 | Yes | Indicates the user level, who is currently responsible to take action on the form. | |
| EVER_BEEN_LATE | CHAR | 1 | Yes | Indicates whether at least one of the user was late or not. Value is Y or N. | ||
| EMAIL_SENT | CHAR | 1 | Yes | Indicates whether email is sent to the user or not. Value is Y or N. | ||
| EMAIL_SENT_DATE | DATE | Yes | Indicates the date, on which, email is sent to the user. | |||
| SOURCE_INTERNAL_ID | VARCHAR2 | 100 | Yes | Indicates source form instance internal id when it is copied from another instance. | ||
| FORCE_CLOSE_ACCESS_LEVEL | NUMBER | Yes | Indicates access level, at which, force close is triggered. | |||
| EXTERNAL_SOURCE | VARCHAR2 | 20 | Yes | Name of external source when it is created by another service, for example,ARCS. | ||
| 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-90 Index Table
| Index | Uniqueness | Columns |
|---|---|---|
| SDM_FRM_INS_PK | UNIQUE | FORM_INSTANCE_ID |
| SDM_FRM_INS_U1_DCP_DCU | UNIQUE | DCP_ID, FORM_DCU_ID |
| SDM_FRM_INS_U2_INTRNL_ID | UNIQUE | SYS_NC00037$, APP_ID |