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_LOV_USER_TYPES

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Contains user types/roles of each application.

Description

Contains user types/roles of each application.

Entity Type
Data Table

Data Attribute / Type	Description
LOV_USER_TYPE_SEQ NUMBER	Primary key sequence of CAM_LOV_USER_TYPES
USER_TYPE_CODE VARCHAR2	Unique code for user type of each module. For example,N for NMFS, P for provider, C for captain
USER_TYPE_DESC VARCHAR2	Describes the user type
APP_SEQ NUMBER	Primary key sequence for MODULES table
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.
PARENT_USER_TYPE_SEQ NUMBER	The user type which includes this type. All of the privileges automatically available to the parent one.

Data Attribute / Type

Description

LOV_USER_TYPE_SEQ
NUMBER

Primary key sequence of CAM_LOV_USER_TYPES

USER_TYPE_CODE
VARCHAR2

Unique code for user type of each module. For example,N for NMFS, P for provider, C for captain

USER_TYPE_DESC
VARCHAR2

Describes the user type

APP_SEQ
NUMBER

Primary key sequence for MODULES table

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.

PARENT_USER_TYPE_SEQ
NUMBER

The user type which includes this type. All of the privileges automatically available to the parent one.

Summary

Entity Information