Search Help Show/Hide Menu
Metadata Rubric
100%
5.98 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Custom User Authentication > AFSC/FMA/CAMS Data Objects >

Table: CAM_USERS

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

Summary

Abstract

This entity contains user with contact information.

Description

This entity contains user with contact information.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
USER_SEQ
NUMBER 		Primary key sequence of CAM_USERS
USER_ID
VARCHAR2 		Login user name for applicattion.
SALTED_PASSWORD
VARCHAR2 		Hashed password with a salt, user_id, and endtered password Custom_Password_Hash function. Unable to decrypt.
PASSWORD_CHANGED_TIMESTAMP
TIMESTAMP(4) WITH LOCAL TIME Z 		Timestamp for the last password renew.
REMAINING_GRACE_LOGIN
NUMBER 		Number of available grace login for expired password.
IS_PASSWORD_TEMPORARY
VARCHAR2 		Password initialization flag. If password is reset it is set to y else null.
ACCOUNT_STATUS
VARCHAR2 		Status of account. Enabled/Disabled/Expired, etc.
FIRST_NAME
VARCHAR2 		User's first name
MIDDLE_NAME
VARCHAR2 		User's middle name
LAST_NAME
VARCHAR2 		User's last name
SECONDARY_EMAIL
VARCHAR2 		User's secondary email address. Can be used for password reset.
PRIMARY_PHONE
VARCHAR2 		Primary contact number, converted by application or trigger to (xxx) xxx-xxxx EX)xxxxxx. First 10 digit coverted to regular phone number and rest becomes extension number, if exists.
CELL_PHONE
VARCHAR2 		User's cellular phone number, converted by application or trigger to (xxx) xxx-xxxx EX)xxxxxx. First 10 digit coverted to regular phone number and rest becomes extension number, if exists.
ADDRESS_LINE_1
VARCHAR2 		building number, street
ADDRESS_LINE_2
VARCHAR2 		Suite, Cell or Room number.
ADDRESS_CITY
VARCHAR2 		City
ADDRESS_STATE
VARCHAR2 		Abbreviated State
ADDRESS_ZIPCODE
VARCHAR2 		Postal code
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_SEQ
NUMBER 		User seq for whom this user works. Could be the one created this user. Will be owner of vessel or provider manager.
LOV_MOBILE_PROVIDER_SEQ
NUMBER 		Primary key of CAM_LOV_MOBILE_PROVIDER..Mobile provider vor CELL_PHONE numbers with which user can receive temporary password..
PRIMARY_EMAIL
VARCHAR2 		User's primary Email address
EMPLOYER_CODE
VARCHAR2 		Foreign key to norpac.ols_lov_emplyer.employer_code.
OBSERVER_SEQ
NUMBER 		Foreign key to NORPAC.OLS_OBSERVER.observer_seq.
BUILDING
VARCHAR2 		Building code where User's office is located copied from building attribute in NOAA.LDAP
CENTER_CODE
VARCHAR2 		User's working location (branch) copied from ou attribute in NOAA.LDAP
DESCRIPTION
VARCHAR2 		User description copied from description attributes in NOAA.LDAP.
DIVISION_CODE
VARCHAR2 		Division where User is belonged to copied from ou1 attribute in NOAA.LDAP
FULL_NAME
VARCHAR2 		User's full name copied from cn attribute in NOAA.LDAP
GOV_EMPLOYEE_TYPE
VARCHAR2 		Employeed type of the user copied from employeetype attribute in NOAA.LDAP. Contractor, Federal, Function, Commissioned, and Associate. Optional
GOV_ROUTING_CODE
VARCHAR2 		Office Code for internal mail copied from routingcode attribute in NOAA.LDAP
ROOM_NUMBER
VARCHAR2 		Building code where User's office is located copied from roomnumber attribute in NOAA.LDAP
VESSEL_CONTACT_SEQ
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: Table: CAM_USERS
Short Name: CAM_USERS
Status: Completed
Abstract:

This entity contains user with contact information.
Notes:

Loaded by batch 3994, 01-03-2013 16:38

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CUST_AUTH
Description:

This entity contains user with contact information.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key USER_SEQ NUMBER Primary key sequence of CAM_USERS
100
 USER_ID VARCHAR2 Login user name for applicattion.
100
 SALTED_PASSWORD VARCHAR2 Hashed password with a salt, user_id, and endtered password Custom_Password_Hash function. Unable to decrypt.
100
 PASSWORD_CHANGED_TIMESTAMP TIMESTAMP(4) WITH LOCAL TIME Z Timestamp for the last password renew.
100
 REMAINING_GRACE_LOGIN NUMBER Number of available grace login for expired password.
100
 IS_PASSWORD_TEMPORARY VARCHAR2 Password initialization flag. If password is reset it is set to y else null.
100
 ACCOUNT_STATUS VARCHAR2 Status of account. Enabled/Disabled/Expired, etc.
100
 FIRST_NAME VARCHAR2 User's first name
100
 MIDDLE_NAME VARCHAR2 User's middle name
100
 LAST_NAME VARCHAR2 User's last name
100
 SECONDARY_EMAIL VARCHAR2 User's secondary email address. Can be used for password reset.
100
 PRIMARY_PHONE VARCHAR2 Primary contact number, converted by application or trigger to (xxx) xxx-xxxx EX)xxxxxx. First 10 digit coverted to regular phone number and rest becomes extension number, if exists.
100
 CELL_PHONE VARCHAR2 User's cellular phone number, converted by application or trigger to (xxx) xxx-xxxx EX)xxxxxx. First 10 digit coverted to regular phone number and rest becomes extension number, if exists.
100
 ADDRESS_LINE_1 VARCHAR2 building number, street
100
 ADDRESS_LINE_2 VARCHAR2 Suite, Cell or Room number.
100
 ADDRESS_CITY VARCHAR2 City
100
 ADDRESS_STATE VARCHAR2 Abbreviated State
100
 ADDRESS_ZIPCODE VARCHAR2 Postal code
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_SEQ NUMBER User seq for whom this user works. Could be the one created this user. Will be owner of vessel or provider manager.
100
 LOV_MOBILE_PROVIDER_SEQ NUMBER Primary key of CAM_LOV_MOBILE_PROVIDER..Mobile provider vor CELL_PHONE numbers with which user can receive temporary password..
100
 PRIMARY_EMAIL VARCHAR2 User's primary Email address
100
 EMPLOYER_CODE VARCHAR2 Foreign key to norpac.ols_lov_emplyer.employer_code.
100
 OBSERVER_SEQ NUMBER Foreign key to NORPAC.OLS_OBSERVER.observer_seq.
100
 BUILDING VARCHAR2 Building code where User's office is located copied from building attribute in NOAA.LDAP
100
 CENTER_CODE VARCHAR2 User's working location (branch) copied from ou attribute in NOAA.LDAP
100
 DESCRIPTION VARCHAR2 User description copied from description attributes in NOAA.LDAP.
100
 DIVISION_CODE VARCHAR2 Division where User is belonged to copied from ou1 attribute in NOAA.LDAP
100
 FULL_NAME VARCHAR2 User's full name copied from cn attribute in NOAA.LDAP
100
 GOV_EMPLOYEE_TYPE VARCHAR2 Employeed type of the user copied from employeetype attribute in NOAA.LDAP. Contractor, Federal, Function, Commissioned, and Associate. Optional
100
 GOV_ROUTING_CODE VARCHAR2 Office Code for internal mail copied from routingcode attribute in NOAA.LDAP
100
 ROOM_NUMBER VARCHAR2 Building code where User's office is located copied from roomnumber attribute in NOAA.LDAP
67
 VESSEL_CONTACT_SEQ NUMBER

Attribute Details

USER_SEQ

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

Primary key sequence of CAM_USERS
General Data Type: NUMBER

USER_ID

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

Login user name for applicattion.
General Data Type: VARCHAR2

SALTED_PASSWORD

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

Hashed password with a salt, user_id, and endtered password Custom_Password_Hash function. Unable to decrypt.
General Data Type: VARCHAR2

PASSWORD_CHANGED_TIMESTAMP

CC ID: 84298
Seq. Order: 4
Data Storage Type: TIMESTAMP(4) WITH LOCAL TIME Z
Max Length: 11
Required: No
Primary Key: No
Scale: 4
Status: Active
Description:

Timestamp for the last password renew.
General Data Type: TIMESTAMP(4) WITH LOCAL TIME Z

REMAINING_GRACE_LOGIN

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

Number of available grace login for expired password.
General Data Type: NUMBER

IS_PASSWORD_TEMPORARY

CC ID: 84300
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Password initialization flag. If password is reset it is set to y else null.
General Data Type: VARCHAR2

ACCOUNT_STATUS

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

Status of account. Enabled/Disabled/Expired, etc.
General Data Type: VARCHAR2

FIRST_NAME

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

User's first name
General Data Type: VARCHAR2

MIDDLE_NAME

CC ID: 84303
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

User's middle name
General Data Type: VARCHAR2

LAST_NAME

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

User's last name
General Data Type: VARCHAR2

SECONDARY_EMAIL

CC ID: 84305
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

User's secondary email address. Can be used for password reset.
General Data Type: VARCHAR2

PRIMARY_PHONE

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

Primary contact number, converted by application or trigger to (xxx) xxx-xxxx EX)xxxxxx. First 10 digit coverted to regular phone number and rest becomes extension number, if exists.
General Data Type: VARCHAR2

CELL_PHONE

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

User's cellular phone number, converted by application or trigger to (xxx) xxx-xxxx EX)xxxxxx. First 10 digit coverted to regular phone number and rest becomes extension number, if exists.
General Data Type: VARCHAR2

ADDRESS_LINE_1

CC ID: 84308
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 256
Required: No
Primary Key: No
Status: Active
Description:

building number, street
General Data Type: VARCHAR2

ADDRESS_LINE_2

CC ID: 84309
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Suite, Cell or Room number.
General Data Type: VARCHAR2

ADDRESS_CITY

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

City
General Data Type: VARCHAR2

ADDRESS_STATE

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

Abbreviated State
General Data Type: VARCHAR2

ADDRESS_ZIPCODE

CC ID: 84312
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Postal code
General Data Type: VARCHAR2

RECORD_HISTORY

CC ID: 84313
Seq. Order: 19
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: 84314
Seq. Order: 20
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: 84315
Seq. Order: 21
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: 84316
Seq. Order: 22
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: 84317
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 100
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: 84318
Seq. Order: 24
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: 84319
Seq. Order: 25
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: 84320
Seq. Order: 26
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: 84321
Seq. Order: 27
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: 84322
Seq. Order: 28
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: 84323
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 100
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: 84324
Seq. Order: 30
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: 84325
Seq. Order: 31
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: 84326
Seq. Order: 32
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: 84327
Seq. Order: 33
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: 84328
Seq. Order: 34
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_SEQ

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

User seq for whom this user works. Could be the one created this user. Will be owner of vessel or provider manager.
General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_USERS

LOV_MOBILE_PROVIDER_SEQ

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

Primary key of CAM_LOV_MOBILE_PROVIDER..Mobile provider vor CELL_PHONE numbers with which user can receive temporary password..
General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_LOV_MOBILE_PROVI

PRIMARY_EMAIL

CC ID: 84329
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

User's primary Email address
General Data Type: VARCHAR2

EMPLOYER_CODE

CC ID: 84341
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Foreign key to norpac.ols_lov_emplyer.employer_code.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.OLS_LOV_EMPLOYER

OBSERVER_SEQ

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

Foreign key to NORPAC.OLS_OBSERVER.observer_seq.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_OBSERVER

BUILDING

CC ID: 84330
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Building code where User's office is located copied from building attribute in NOAA.LDAP
General Data Type: VARCHAR2

CENTER_CODE

CC ID: 84331
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

User's working location (branch) copied from ou attribute in NOAA.LDAP
General Data Type: VARCHAR2

DESCRIPTION

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

User description copied from description attributes in NOAA.LDAP.
General Data Type: VARCHAR2

DIVISION_CODE

CC ID: 84333
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Division where User is belonged to copied from ou1 attribute in NOAA.LDAP
General Data Type: VARCHAR2

FULL_NAME

CC ID: 84334
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

User's full name copied from cn attribute in NOAA.LDAP
General Data Type: VARCHAR2

GOV_EMPLOYEE_TYPE

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

Employeed type of the user copied from employeetype attribute in NOAA.LDAP. Contractor, Federal, Function, Commissioned, and Associate. Optional
General Data Type: VARCHAR2

GOV_ROUTING_CODE

CC ID: 84336
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Office Code for internal mail copied from routingcode attribute in NOAA.LDAP
General Data Type: VARCHAR2

ROOM_NUMBER

CC ID: 84337
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Building code where User's office is located copied from roomnumber attribute in NOAA.LDAP
General Data Type: VARCHAR2

VESSEL_CONTACT_SEQ

CC ID: 84340
Seq. Order: 48
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_LOV_VESSEL_CONTACT

Catalog Details

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