Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Custom User Authentication > AFSC/FMA/CAMS Data Objects >

Table: CAM_EMAIL_TXT

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17376  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains password reset notification email text for each application. Application generates email body using text in this table.

Description

This table contains password reset notification email text for each application. Application generates email body using text in this table.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
EMAIL_TXT_SEQ
NUMBER 		Primary key sequence number generated by database.
APP_SEQ
NUMBER 		Primary key sequence number from cam_apps table.
EMAIL_ORDER
NUMBER 		Order number for email context. Email can have more than one paragraphs and stored seperately.
EMAIL_TXT
VARCHAR2 		email context. Email can consist of more than one paragraphs and be stored seperately.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: CAM_EMAIL_TXT
Short Name: CAM_EMAIL_TXT
Status: Completed
Abstract:

This table contains password reset notification email text for each application. Application generates email body using text in this table.
Notes:

Loaded by batch 3994, 01-03-2013 16:38

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CUST_AUTH
Description:

This table contains password reset notification email text for each application. Application generates email body using text in this table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key EMAIL_TXT_SEQ NUMBER Primary key sequence number generated by database.
100
 APP_SEQ NUMBER Primary key sequence number from cam_apps table.
100
 EMAIL_ORDER NUMBER Order number for email context. Email can have more than one paragraphs and stored seperately.
100
 EMAIL_TXT VARCHAR2 email context. Email can consist of more than one paragraphs and be stored seperately.

Attribute Details

EMAIL_TXT_SEQ

CC ID: 84210
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary key sequence number generated by database.
General Data Type: NUMBER

APP_SEQ

CC ID: 84213
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Primary key sequence number from cam_apps table.
General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_APPS

EMAIL_ORDER

CC ID: 84211
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Order number for email context. Email can have more than one paragraphs and stored seperately.
General Data Type: NUMBER

EMAIL_TXT

CC ID: 84212
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4000
Required: Yes
Primary Key: No
Status: Active
Description:

email context. Email can consist of more than one paragraphs and be stored seperately.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 17376
GUID: gov.noaa.nmfs.inport:17376
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-01-03 16:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18