Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Contains user types/roles of each application.

Description

Contains user types/roles of each application.

Entity Information

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.