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_LOV_MOBILE_PROVIDERS

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

Summary

Abstract

Contains list of mobile service provider with its email for text service email address. System can send a text message to a user phone with <<Cell phone number>> @ provider_text_emil. For example, an email sent to 1231231234@txt.att.net will be sent to (123) 123-1234 as phone text message.

Description

Contains list of mobile service provider with its email for text service email address. System can send a text message to a user phone with <<Cell phone number>> @ provider_text_emil. For example, an email sent to 1231231234@txt.att.net will be sent to (123) 123-1234 as phone text message.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LOV_MOBILE_PROVIDER_SEQ
NUMBER 		Primary sequence number. Unique. Required. Populated by lov_mobile_porvider_bir
PROVIDER_NAME
VARCHAR2 		Name of providers, ATT, Verizon, etc.
PROVIDER_TXT_EMAIL
VARCHAR2 		email domain name for email to text message service of providers.
PROVIDER_DESC
VARCHAR2 		description of provider.

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_LOV_MOBILE_PROVIDERS
Short Name: CAM_LOV_MOBILE_PROVIDERS
Status: Completed
Abstract:

Contains list of mobile service provider with its email for text service email address. System can send a text message to a user phone with <<Cell phone number>> @ provider_text_emil. For example, an email sent to 1231231234@txt.att.net will be sent to (123) 123-1234 as phone text message.
Notes:

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

Entity Information

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

Contains list of mobile service provider with its email for text service email address. System can send a text message to a user phone with <<Cell phone number>> @ provider_text_emil. For example, an email sent to 1231231234@txt.att.net will be sent to (123) 123-1234 as phone text message.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key LOV_MOBILE_PROVIDER_SEQ NUMBER Primary sequence number. Unique. Required. Populated by lov_mobile_porvider_bir
100
 PROVIDER_NAME VARCHAR2 Name of providers, ATT, Verizon, etc.
100
 PROVIDER_TXT_EMAIL VARCHAR2 email domain name for email to text message service of providers.
100
 PROVIDER_DESC VARCHAR2 description of provider.

Attribute Details

LOV_MOBILE_PROVIDER_SEQ

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

Primary sequence number. Unique. Required. Populated by lov_mobile_porvider_bir
General Data Type: NUMBER

PROVIDER_NAME

CC ID: 84221
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Name of providers, ATT, Verizon, etc.
General Data Type: VARCHAR2

PROVIDER_TXT_EMAIL

CC ID: 84222
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

email domain name for email to text message service of providers.
General Data Type: VARCHAR2

PROVIDER_DESC

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

description of provider.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 17379
GUID: gov.noaa.nmfs.inport:17379
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