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

Summary

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TYPE_LEVEL
NUMBER
LOV_USER_TYPE_SEQ
NUMBER
SHOW_HIERARCHY
VARCHAR2
USER_TYPE_CODE
VARCHAR2
USER_TYPE_DESC
VARCHAR2
APP_CODE
VARCHAR2
LSLEAF
NUMBER

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: View: ODDS_LOV_USER_TYPE_V
Short Name: ODDS_LOV_USER_TYPE_V
Status: Completed
Notes:

Loaded by batch 4561, 04-30-2013 18:33

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: NORPAC

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
TYPE_LEVEL NUMBER
67
LOV_USER_TYPE_SEQ NUMBER
67
SHOW_HIERARCHY VARCHAR2
67
USER_TYPE_CODE VARCHAR2
67
USER_TYPE_DESC VARCHAR2
67
APP_CODE VARCHAR2
67
LSLEAF NUMBER

Attribute Details

TYPE_LEVEL

CC ID: 108037
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

LOV_USER_TYPE_SEQ

CC ID: 108038
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

SHOW_HIERARCHY

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

USER_TYPE_CODE

CC ID: 108040
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

USER_TYPE_DESC

CC ID: 108041
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

APP_CODE

CC ID: 108042
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

LSLEAF

CC ID: 108043
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 18860
GUID: gov.noaa.nmfs.inport:18860
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-04-30 18:33+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