Table: AUDIT_SENDMAIL_HISTORIES
Entity (ENT) | NMFS Office Of Protected Resources (OPR)GUID: gov.noaa.nmfs.inport:26989 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: AUDIT_SENDMAIL_HISTORIES |
|---|---|
| Short Name: | AUDIT_SENDMAIL_HISTORIES |
| Status: | Completed |
| Abstract: |
Whenever STADM.STADM_UTILITY_API.stadm_send_email_prc is called, an audit record will be captured. This includes all the input parameters used to call the procedure (application name, sender, recipient, subject, message, caller) and the date of the call (sysdate). |
| Notes: |
Loaded by batch 7077, 09-17-2015 08:15 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | NIMM_APPS |
| Description: |
Whenever STADM.STADM_UTILITY_API.stadm_send_email_prc is called, an audit record will be captured. This includes all the input parameters used to call the procedure (application name, sender, recipient, subject, message, caller) and the date of the call (sysdate). |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
AUDIT_SENDMAIL_HISTORY_ID | NUMBER | System generated unique identifier for an audit sendmail history |
|
100
|
ASH_APPLICATION_NAME | VARCHAR2 | The input parameter p_applicationname | |
|
100
|
ASH_SENDER | VARCHAR2 | The input parameter p_sender, which should be the sender email address | |
|
100
|
ASH_RECIPIENT | VARCHAR2 | The input parameter p_recipient, which should be the recipient email address(es) | |
|
100
|
ASH_SUBJECT | VARCHAR2 | The input parameter p_subject, which should be the subject of the email | |
|
100
|
ASH_MESSAGE | VARCHAR2 | The input parameter p_message, which should be the body of the email | |
|
100
|
ASH_USER_LOGON | VARCHAR2 | The input parameter p_user_logon, which shoud be the application user who makes the procedure call | |
|
100
|
ASH_ACTION_DATE | DATE | The date this procedure call is made |
Attribute Details
AUDIT_SENDMAIL_HISTORY_ID
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
System generated unique identifier for an audit sendmail history |
| General Data Type: | NUMBER |
ASH_APPLICATION_NAME
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The input parameter p_applicationname |
| General Data Type: | VARCHAR2 |
ASH_SENDER
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The input parameter p_sender, which should be the sender email address |
| General Data Type: | VARCHAR2 |
ASH_RECIPIENT
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The input parameter p_recipient, which should be the recipient email address(es) |
| General Data Type: | VARCHAR2 |
ASH_SUBJECT
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The input parameter p_subject, which should be the subject of the email |
| General Data Type: | VARCHAR2 |
ASH_MESSAGE
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The input parameter p_message, which should be the body of the email |
| General Data Type: | VARCHAR2 |
ASH_USER_LOGON
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The input parameter p_user_logon, which shoud be the application user who makes the procedure call |
| General Data Type: | VARCHAR2 |
ASH_ACTION_DATE
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The date this procedure call is made |
| General Data Type: | DATE |
Catalog Details
| Catalog Item ID: | 26989 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:26989 |
| Metadata Record Created By: | Nathan Wilson |
| Metadata Record Created: | 2015-09-17 08:15+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2018-05-16 |
| Owner Org: | OPR |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2018-05-16 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2019-05-16 |