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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Summary
Abstract
Contains user types/roles of each application.
DescriptionContains 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. |