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_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

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.

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_USER_TYPES
Short Name: CAM_LOV_USER_TYPES
Status: Completed
Abstract:

Contains user types/roles of each application.
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 user types/roles of each application.

Data Attributes

Attribute Summary

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

Attribute Details

LOV_USER_TYPE_SEQ

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

Primary key sequence of CAM_LOV_USER_TYPES
General Data Type: NUMBER

USER_TYPE_CODE

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

Unique code for user type of each module. For example,N for NMFS, P for provider, C for captain
General Data Type: VARCHAR2

USER_TYPE_DESC

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

Describes the user type
General Data Type: VARCHAR2

APP_SEQ

CC ID: 84244
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Primary key sequence for MODULES table
General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_APPS

RECORD_HISTORY

CC ID: 84227
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: 84228
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: 84229
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: 84230
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: 84231
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: 84232
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: 84233
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: 84234
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: 84235
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: 84236
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: 84237
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: 84238
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: 84239
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Record revision number
General Data Type: NUMBER

RECORD_SOFT_DELETED

CC ID: 84240
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: 84241
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: 84242
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

PARENT_USER_TYPE_SEQ

CC ID: 84243
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The user type which includes this type. All of the privileges automatically available to the parent one.
General Data Type: NUMBER

Catalog Details

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