GL_AUTORUN_RUN_NOTIFY_USERS
This table contains which report submissions will be sent to each of the individual users for an automation run.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_AUTORUN_RUN_NTFY_USR_PK |
AUTORUN_REQUEST_ID, USER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AUTORUN_REQUEST_ID | NUMBER | 18 | Yes | Automation run request identifier. | |
| USER_ID | NUMBER | 18 | Yes | User to be notified when an issue occurs. | |
| REPORT_SUBMISSION_ID | NUMBER | 18 | Yes | Report submission identifier. Each report submission may combine what would otherwise be multiple reports intended for different users as long as those users have access to exactly the same set of ledgers and error categories. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_AUTORUN_RUN_NOTIFY_USERS | gl_autorun_runs | AUTORUN_REQUEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_AUTORUN_RUN_NTFY_USR_N1 | Non Unique | Default | AUTORUN_REQUEST_ID, REPORT_SUBMISSION_ID |
| GL_AUTORUN_RUN_NTFY_USR_U1 | Unique | Default | AUTORUN_REQUEST_ID, USER_ID |