Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Custom User Authentication > AFSC/FMA/CAMS Data Objects >

Table: CAM_APPS

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17375 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This entity contains application name, acronym and description. ODDS (Observer Declare and Deploy System), CAM (Custom Authentication Management system), Etc.

Description

This entity contains application name, acronym and description. ODDS (Observer Declare and Deploy System), CAM (Custom Authentication Management system), Etc.

Entity Type
Data Table

Data Attribute / Type	Description
APP_SEQ NUMBER	Primary key sequence of CAM_MODULES
APP_NAME VARCHAR2	Module/application name. Full name of the moducle, for example, Obeserver Logistics, Observer Declare and Deploy System, etc.
APP_CODE VARCHAR2	Abbreviated module name for example, OLS, ODDS
APP_DESC VARCHAR2	Describe module/application
RECORD_HISTORY CLOB	Entire record change history.
RECORD_JOURNAL_NOTE VARCHAR2	Comment for journaling record.
RECORD_APPROVED_BY_PERSON VARCHAR2	Person approved the record, such as QAQC manager for the record. Doesn't have to be a application user.
RECORD_APPROVED_ON_DATE DATE	Date when the data approved by QAQC manager/personell.
RECORD_COMPUTER_LOAD_BY_USER VARCHAR2	A application user who upload the record in to the database system.
RECORD_COMPUTER_LOAD_ON_DATE TIMESTAMP(4)	Date and time when the record loaded into the table.
RECORD_CREATED_BY_PERSON VARCHAR2	Data collector or creator, doesn't have to be an application user.
RECORD_CREATED_ON_DATE DATE	Date the record collected or created. Optional
RECORD_EFFECTIVE_DATE DATE	The date on which the record takes effect. Optional
RECORD_EXPIRATION_DATE DATE	The date on which the record is expired. Optional
RECORD_LAST_EDITED_BY_USER VARCHAR2	The application user who changed the record lastly.
RECORD_LAST_EDITED_ON_DATE TIMESTAMP(4)	The date on which the record was changed lastly.
RECORD_NUMBER_OF_EDITS NUMBER	Record revision number
RECORD_SOFT_DELETED VARCHAR2	Soft delete flag. Optional. Can be used as temporary delete, before hard delete.
RECORD_STEWARDSHIP VARCHAR2	A person that is responsible for maintaining a data element in a metadata registry.
RECORD_CHANGE_COMMENT VARCHAR2	Comment for data update.
APP_URL VARCHAR2	URL for applications.

Data Attribute / Type

Description

APP_SEQ
NUMBER

Primary key sequence of CAM_MODULES

APP_NAME
VARCHAR2

Module/application name. Full name of the moducle, for example, Obeserver Logistics, Observer Declare and Deploy System, etc.

APP_CODE
VARCHAR2

Abbreviated module name for example, OLS, ODDS

APP_DESC
VARCHAR2

Describe module/application

RECORD_HISTORY
CLOB

Entire record change history.

RECORD_JOURNAL_NOTE
VARCHAR2

Comment for journaling record.

RECORD_APPROVED_BY_PERSON
VARCHAR2

Person approved the record, such as QAQC manager for the record. Doesn't have to be a application user.

RECORD_APPROVED_ON_DATE
DATE

Date when the data approved by QAQC manager/personell.

RECORD_COMPUTER_LOAD_BY_USER
VARCHAR2

A application user who upload the record in to the database system.

RECORD_COMPUTER_LOAD_ON_DATE
TIMESTAMP(4)

Date and time when the record loaded into the table.

RECORD_CREATED_BY_PERSON
VARCHAR2

Data collector or creator, doesn't have to be an application user.

RECORD_CREATED_ON_DATE
DATE

Date the record collected or created. Optional

RECORD_EFFECTIVE_DATE
DATE

The date on which the record takes effect. Optional

RECORD_EXPIRATION_DATE
DATE

The date on which the record is expired. Optional

RECORD_LAST_EDITED_BY_USER
VARCHAR2

The application user who changed the record lastly.

RECORD_LAST_EDITED_ON_DATE
TIMESTAMP(4)

The date on which the record was changed lastly.

RECORD_NUMBER_OF_EDITS
NUMBER

Record revision number

RECORD_SOFT_DELETED
VARCHAR2

Soft delete flag. Optional. Can be used as temporary delete, before hard delete.

RECORD_STEWARDSHIP
VARCHAR2

A person that is responsible for maintaining a data element in a metadata registry.

RECORD_CHANGE_COMMENT
VARCHAR2

Comment for data update.

APP_URL
VARCHAR2

URL for applications.

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: CAM_APPS
Short Name:	CAM_APPS
Status:	Completed
Abstract:	This entity contains application name, acronym and description. ODDS (Observer Declare and Deploy System), CAM (Custom Authentication Management system), Etc.
Notes:	Loaded by batch 3994, 01-03-2013 16:38

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	CUST_AUTH
Description:	This entity contains application name, acronym and description. ODDS (Observer Declare and Deploy System), CAM (Custom Authentication Management system), Etc.

Attribute Summary

	Name	Type	Description
100	APP_SEQ	NUMBER	Primary key sequence of CAM_MODULES
100	APP_NAME	VARCHAR2	Module/application name. Full name of the moducle, for example, Obeserver Logistics, Observer Declare and Deploy System, etc.
100	APP_CODE	VARCHAR2	Abbreviated module name for example, OLS, ODDS
100	APP_DESC	VARCHAR2	Describe module/application
100	RECORD_HISTORY	CLOB	Entire record change history.
100	RECORD_JOURNAL_NOTE	VARCHAR2	Comment for journaling record.
100	RECORD_APPROVED_BY_PERSON	VARCHAR2	Person approved the record, such as QAQC manager for the record. Doesn't have to be a application user.
100	RECORD_APPROVED_ON_DATE	DATE	Date when the data approved by QAQC manager/personell.
100	RECORD_COMPUTER_LOAD_BY_USER	VARCHAR2	A application user who upload the record in to the database system.
100	RECORD_COMPUTER_LOAD_ON_DATE	TIMESTAMP(4)	Date and time when the record loaded into the table.
100	RECORD_CREATED_BY_PERSON	VARCHAR2	Data collector or creator, doesn't have to be an application user.
100	RECORD_CREATED_ON_DATE	DATE	Date the record collected or created. Optional
100	RECORD_EFFECTIVE_DATE	DATE	The date on which the record takes effect. Optional
100	RECORD_EXPIRATION_DATE	DATE	The date on which the record is expired. Optional
100	RECORD_LAST_EDITED_BY_USER	VARCHAR2	The application user who changed the record lastly.
100	RECORD_LAST_EDITED_ON_DATE	TIMESTAMP(4)	The date on which the record was changed lastly.
100	RECORD_NUMBER_OF_EDITS	NUMBER	Record revision number
100	RECORD_SOFT_DELETED	VARCHAR2	Soft delete flag. Optional. Can be used as temporary delete, before hard delete.
100	RECORD_STEWARDSHIP	VARCHAR2	A person that is responsible for maintaining a data element in a metadata registry.
100	RECORD_CHANGE_COMMENT	VARCHAR2	Comment for data update.
100	APP_URL	VARCHAR2	URL for applications.

Name

Type

Description

100

APP_SEQ

NUMBER

Primary key sequence of CAM_MODULES

100

APP_NAME

VARCHAR2

Module/application name. Full name of the moducle, for example, Obeserver Logistics, Observer Declare and Deploy System, etc.

100

APP_CODE

VARCHAR2

Abbreviated module name for example, OLS, ODDS

100

APP_DESC

VARCHAR2

Describe module/application

100

RECORD_HISTORY

CLOB

Entire record change history.

100

RECORD_JOURNAL_NOTE

VARCHAR2

Comment for journaling record.

100

RECORD_APPROVED_BY_PERSON

VARCHAR2

Person approved the record, such as QAQC manager for the record. Doesn't have to be a application user.

100

RECORD_APPROVED_ON_DATE

DATE

Date when the data approved by QAQC manager/personell.

100

RECORD_COMPUTER_LOAD_BY_USER

VARCHAR2

A application user who upload the record in to the database system.

100

RECORD_COMPUTER_LOAD_ON_DATE

TIMESTAMP(4)

Date and time when the record loaded into the table.

100

RECORD_CREATED_BY_PERSON

VARCHAR2

Data collector or creator, doesn't have to be an application user.

100

RECORD_CREATED_ON_DATE

DATE

Date the record collected or created. Optional

100

RECORD_EFFECTIVE_DATE

DATE

The date on which the record takes effect. Optional

100

RECORD_EXPIRATION_DATE

DATE

The date on which the record is expired. Optional

100

RECORD_LAST_EDITED_BY_USER

VARCHAR2

The application user who changed the record lastly.

100

RECORD_LAST_EDITED_ON_DATE

TIMESTAMP(4)

The date on which the record was changed lastly.

100

RECORD_NUMBER_OF_EDITS

NUMBER

Record revision number

100

RECORD_SOFT_DELETED

VARCHAR2

Soft delete flag. Optional. Can be used as temporary delete, before hard delete.

100

RECORD_STEWARDSHIP

VARCHAR2

A person that is responsible for maintaining a data element in a metadata registry.

100

RECORD_CHANGE_COMMENT

VARCHAR2

Comment for data update.

100

APP_URL

VARCHAR2

URL for applications.

Attribute Details

APP_SEQ

CC ID: 84189

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Primary key sequence of CAM_MODULES
General Data Type:	NUMBER

APP_NAME

CC ID: 84190

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Module/application name. Full name of the moducle, for example, Obeserver Logistics, Observer Declare and Deploy System, etc.
General Data Type:	VARCHAR2

APP_CODE

CC ID: 84191

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Abbreviated module name for example, OLS, ODDS
General Data Type:	VARCHAR2

APP_DESC

CC ID: 84192

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Describe module/application
General Data Type:	VARCHAR2

RECORD_HISTORY

CC ID: 84193

Seq. Order:	5
Data Storage Type:	CLOB
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Entire record change history.
General Data Type:	CLOB

RECORD_JOURNAL_NOTE

CC ID: 84194

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Comment for journaling record.
General Data Type:	VARCHAR2

RECORD_APPROVED_BY_PERSON

CC ID: 84195

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Person approved the record, such as QAQC manager for the record. Doesn't have to be a application user.
General Data Type:	VARCHAR2

RECORD_APPROVED_ON_DATE

CC ID: 84196

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when the data approved by QAQC manager/personell.
General Data Type:	DATE

RECORD_COMPUTER_LOAD_BY_USER

CC ID: 84197

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	Yes
Primary Key:	No
Status:	Active
Description:	A application user who upload the record in to the database system.
General Data Type:	VARCHAR2

RECORD_COMPUTER_LOAD_ON_DATE

CC ID: 84198

Seq. Order:	10
Data Storage Type:	TIMESTAMP(4)
Max Length:	11
Required:	Yes
Primary Key:	No
Scale:	4
Status:	Active
Description:	Date and time when the record loaded into the table.
General Data Type:	TIMESTAMP(4)

RECORD_CREATED_BY_PERSON

CC ID: 84199

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Data collector or creator, doesn't have to be an application user.
General Data Type:	VARCHAR2

RECORD_CREATED_ON_DATE

CC ID: 84200

Seq. Order:	12
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the record collected or created. Optional
General Data Type:	DATE

RECORD_EFFECTIVE_DATE

CC ID: 84201

Seq. Order:	13
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date on which the record takes effect. Optional
General Data Type:	DATE

RECORD_EXPIRATION_DATE

CC ID: 84202

Seq. Order:	14
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date on which the record is expired. Optional
General Data Type:	DATE

RECORD_LAST_EDITED_BY_USER

CC ID: 84203

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The application user who changed the record lastly.
General Data Type:	VARCHAR2

RECORD_LAST_EDITED_ON_DATE

CC ID: 84204

Seq. Order:	16
Data Storage Type:	TIMESTAMP(4)
Max Length:	11
Required:	Yes
Primary Key:	No
Scale:	4
Status:	Active
Description:	The date on which the record was changed lastly.
General Data Type:	TIMESTAMP(4)

RECORD_NUMBER_OF_EDITS

CC ID: 84205

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Record revision number
General Data Type:	NUMBER

RECORD_SOFT_DELETED

CC ID: 84206

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Soft delete flag. Optional. Can be used as temporary delete, before hard delete.
General Data Type:	VARCHAR2

RECORD_STEWARDSHIP

CC ID: 84207

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	A person that is responsible for maintaining a data element in a metadata registry.
General Data Type:	VARCHAR2

RECORD_CHANGE_COMMENT

CC ID: 84208

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Comment for data update.
General Data Type:	VARCHAR2

APP_URL

CC ID: 84209

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	URL for applications.
General Data Type:	VARCHAR2

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

Table: CAM_APPS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

APP_SEQ

APP_NAME

APP_CODE

APP_DESC

RECORD_HISTORY

RECORD_JOURNAL_NOTE

RECORD_APPROVED_BY_PERSON

RECORD_APPROVED_ON_DATE

RECORD_COMPUTER_LOAD_BY_USER

RECORD_COMPUTER_LOAD_ON_DATE

RECORD_CREATED_BY_PERSON

RECORD_CREATED_ON_DATE

RECORD_EFFECTIVE_DATE

RECORD_EXPIRATION_DATE

RECORD_LAST_EDITED_BY_USER

RECORD_LAST_EDITED_ON_DATE

RECORD_NUMBER_OF_EDITS

RECORD_SOFT_DELETED

RECORD_STEWARDSHIP

RECORD_CHANGE_COMMENT

APP_URL

Catalog Details