Slide Menu
Search Help Show/Hide Menu

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