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_LDAPDN_TBCOL

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17378  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Contains column name mapping between NOAA LDAP (https://ai.nems.noaa.gov/) attributes and CAM_USER table columns. This table is used for populating cam_user table with LDAP record.

Description

Contains column name mapping between NOAA LDAP (https://ai.nems.noaa.gov/) attributes and CAM_USER table columns. This table is used for populating cam_user table with LDAP record.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LDAP_DN
VARCHAR2 		DN defined in NOAA LDAP. Primary key of table. Required.
TB_COL
VARCHAR2 		column names from CUST_AUTH.CAM_USER. Required.

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_LDAPDN_TBCOL
Short Name: CAM_LOV_LDAPDN_TBCOL
Status: Completed
Abstract:

Contains column name mapping between NOAA LDAP (https://ai.nems.noaa.gov/) attributes and CAM_USER table columns. This table is used for populating cam_user table with LDAP record.
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 column name mapping between NOAA LDAP (https://ai.nems.noaa.gov/) attributes and CAM_USER table columns. This table is used for populating cam_user table with LDAP record.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key LDAP_DN VARCHAR2 DN defined in NOAA LDAP. Primary key of table. Required.
100
 TB_COL VARCHAR2 column names from CUST_AUTH.CAM_USER. Required.

Attribute Details

LDAP_DN

CC ID: 84218
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: Yes
Status: Active
Description:

DN defined in NOAA LDAP. Primary key of table. Required.
General Data Type: VARCHAR2

TB_COL

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

column names from CUST_AUTH.CAM_USER. Required.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 17378
GUID: gov.noaa.nmfs.inport:17378
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: 2018-09-20
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-20
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-20