Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
OPR Meta Data Library > Permits and Conservation Division (F/PR1) > Public Display of Marine Mammals > National Inventory of Marine Mammals (NIMM) >

Table: AUDIT_SENDMAIL_HISTORIES

Entity (ENT)  |  NMFS Office Of Protected Resources (OPR)
GUID: gov.noaa.nmfs.inport:26989  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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).

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).

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AUDIT_SENDMAIL_HISTORY_ID
NUMBER 		System generated unique identifier for an audit sendmail history
ASH_APPLICATION_NAME
VARCHAR2 		The input parameter p_applicationname
ASH_SENDER
VARCHAR2 		The input parameter p_sender, which should be the sender email address
ASH_RECIPIENT
VARCHAR2 		The input parameter p_recipient, which should be the recipient email address(es)
ASH_SUBJECT
VARCHAR2 		The input parameter p_subject, which should be the subject of the email
ASH_MESSAGE
VARCHAR2 		The input parameter p_message, which should be the body of the email
ASH_USER_LOGON
VARCHAR2 		The input parameter p_user_logon, which shoud be the application user who makes the procedure call
ASH_ACTION_DATE
DATE 		The date this procedure call is made

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (OPR) for inquiries on this record.

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

Rubric Score Primary Key? Name Type Description
100
 Primary Key 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

CC ID: 219081
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

CC ID: 219082
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

CC ID: 219083
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

CC ID: 219084
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

CC ID: 219085
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

CC ID: 219086
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

CC ID: 219087
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

CC ID: 219088
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