Table: CAM_USERS
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 17384
| Published / External
Created: 2013-01-03
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 17195
ID: 17384
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: CAM_USERS |
---|---|
Short Name | CAM_USERS |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This entity contains user with contact information. |
* Purpose | |
Notes |
Loaded by batch 3994, 01-03-2013 16:38 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | CUST_AUTH |
» Description |
This entity contains user with contact information. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | USER_SEQ | NUMBER | Primary key sequence of CAM_USERS |
100 | Yes | No | USER_ID | VARCHAR2 | Login user name for applicattion. |
100 | No | No | SALTED_PASSWORD | VARCHAR2 | Hashed password with a salt, user_id, and endtered password Custom_Password_Hash function. Unable to decrypt. |
100 | No | No | PASSWORD_CHANGED_TIMESTAMP | TIMESTAMP(4) WITH LOCAL TIME Z | Timestamp for the last password renew. |
100 | No | No | REMAINING_GRACE_LOGIN | NUMBER | Number of available grace login for expired password. |
100 | No | No | IS_PASSWORD_TEMPORARY | VARCHAR2 | Password initialization flag. If password is reset it is set to y else null. |
100 | No | No | ACCOUNT_STATUS | VARCHAR2 | Status of account. Enabled/Disabled/Expired, etc. |
100 | Yes | No | FIRST_NAME | VARCHAR2 | User's first name |
100 | No | No | MIDDLE_NAME | VARCHAR2 | User's middle name |
100 | Yes | No | LAST_NAME | VARCHAR2 | User's last name |
100 | No | No | SECONDARY_EMAIL | VARCHAR2 | User's secondary email address. Can be used for password reset. |
100 | No | No | 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 | No | No | 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 | No | No | ADDRESS_LINE_1 | VARCHAR2 | building number, street |
100 | No | No | ADDRESS_LINE_2 | VARCHAR2 | Suite, Cell or Room number. |
100 | No | No | ADDRESS_CITY | VARCHAR2 | City |
100 | No | No | ADDRESS_STATE | VARCHAR2 | Abbreviated State |
100 | No | No | ADDRESS_ZIPCODE | VARCHAR2 | Postal code |
100 | No | No | RECORD_HISTORY | CLOB | Entire record change history. |
100 | No | No | RECORD_JOURNAL_NOTE | VARCHAR2 | Comment for journaling record. |
100 | No | No | 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 | No | No | RECORD_APPROVED_ON_DATE | DATE | Date when the data approved by QAQC manager/personell. |
100 | Yes | No | RECORD_COMPUTER_LOAD_BY_USER | VARCHAR2 | A application user who upload the record in to the database system. |
100 | Yes | No | RECORD_COMPUTER_LOAD_ON_DATE | TIMESTAMP(4) | Date and time when the record loaded into the table. |
100 | No | No | RECORD_CREATED_BY_PERSON | VARCHAR2 | Data collector or creator, doesn't have to be an application user. |
100 | No | No | RECORD_CREATED_ON_DATE | DATE | Date the record collected or created. Optional |
100 | No | No | RECORD_EFFECTIVE_DATE | DATE | The date on which the record takes effect. Optional |
100 | No | No | RECORD_EXPIRATION_DATE | DATE | The date on which the record is expired. Optional |
100 | Yes | No | RECORD_LAST_EDITED_BY_USER | VARCHAR2 | The application user who changed the record lastly. |
100 | Yes | No | RECORD_LAST_EDITED_ON_DATE | TIMESTAMP(4) | The date on which the record was changed lastly. |
100 | No | No | RECORD_NUMBER_OF_EDITS | NUMBER | Record revision number |
100 | No | No | RECORD_SOFT_DELETED | VARCHAR2 | Soft delete flag. Optional. Can be used as temporary delete, before hard delete. |
100 | No | No | RECORD_STEWARDSHIP | VARCHAR2 | A person that is responsible for maintaining a data element in a metadata registry. |
100 | No | No | RECORD_CHANGE_COMMENT | VARCHAR2 | Comment for data update. |
100 | No | No | 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 | No | No | 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 | No | No | PRIMARY_EMAIL | VARCHAR2 | User's primary Email address |
100 | No | No | EMPLOYER_CODE | VARCHAR2 | Foreign key to norpac.ols_lov_emplyer.employer_code. |
100 | No | No | OBSERVER_SEQ | NUMBER | Foreign key to NORPAC.OLS_OBSERVER.observer_seq. |
100 | No | No | BUILDING | VARCHAR2 | Building code where User's office is located copied from building attribute in NOAA.LDAP |
100 | No | No | CENTER_CODE | VARCHAR2 | User's working location (branch) copied from ou attribute in NOAA.LDAP |
100 | No | No | DESCRIPTION | VARCHAR2 | User description copied from description attributes in NOAA.LDAP. |
100 | No | No | DIVISION_CODE | VARCHAR2 | Division where User is belonged to copied from ou1 attribute in NOAA.LDAP |
100 | No | No | FULL_NAME | VARCHAR2 | User's full name copied from cn attribute in NOAA.LDAP |
100 | No | No | GOV_EMPLOYEE_TYPE | VARCHAR2 | Employeed type of the user copied from employeetype attribute in NOAA.LDAP. Contractor, Federal, Function, Commissioned, and Associate. Optional |
100 | No | No | GOV_ROUTING_CODE | VARCHAR2 | Office Code for internal mail copied from routingcode attribute in NOAA.LDAP |
100 | No | No | ROOM_NUMBER | VARCHAR2 | Building code where User's office is located copied from roomnumber attribute in NOAA.LDAP |
67 | No | No | VESSEL_CONTACT_SEQ | NUMBER |
Attribute Details
Attribute Name | USER_SEQ |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | 38 |
Scale | |
Status | Active |
Description |
Primary key sequence of CAM_USERS |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | USER_ID |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Login user name for applicattion. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SALTED_PASSWORD |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 256 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hashed password with a salt, user_id, and endtered password Custom_Password_Hash function. Unable to decrypt. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PASSWORD_CHANGED_TIMESTAMP |
---|---|
Seq. Order | 4 |
Data Storage Type | TIMESTAMP(4) WITH LOCAL TIME Z |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 4 |
Status | Active |
Description |
Timestamp for the last password renew. |
General Data Type | TIMESTAMP(4) WITH LOCAL TIME Z |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REMAINING_GRACE_LOGIN |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Number of available grace login for expired password. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | IS_PASSWORD_TEMPORARY |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Password initialization flag. If password is reset it is set to y else null. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ACCOUNT_STATUS |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Status of account. Enabled/Disabled/Expired, etc. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FIRST_NAME |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User's first name |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MIDDLE_NAME |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User's middle name |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LAST_NAME |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User's last name |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SECONDARY_EMAIL |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User's secondary email address. Can be used for password reset. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PRIMARY_PHONE |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CELL_PHONE |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ADDRESS_LINE_1 |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 256 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
building number, street |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ADDRESS_LINE_2 |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Suite, Cell or Room number. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ADDRESS_CITY |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
City |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ADDRESS_STATE |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Abbreviated State |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ADDRESS_ZIPCODE |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Postal code |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_HISTORY |
---|---|
Seq. Order | 19 |
Data Storage Type | CLOB |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Entire record change history. |
General Data Type | CLOB |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_JOURNAL_NOTE |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comment for journaling record. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_APPROVED_BY_PERSON |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_APPROVED_ON_DATE |
---|---|
Seq. Order | 22 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when the data approved by QAQC manager/personell. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_COMPUTER_LOAD_BY_USER |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A application user who upload the record in to the database system. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_COMPUTER_LOAD_ON_DATE |
---|---|
Seq. Order | 24 |
Data Storage Type | TIMESTAMP(4) |
Max Length | 11 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | 4 |
Status | Active |
Description |
Date and time when the record loaded into the table. |
General Data Type | TIMESTAMP(4) |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_CREATED_BY_PERSON |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Data collector or creator, doesn't have to be an application user. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_CREATED_ON_DATE |
---|---|
Seq. Order | 26 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the record collected or created. Optional |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_EFFECTIVE_DATE |
---|---|
Seq. Order | 27 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date on which the record takes effect. Optional |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_EXPIRATION_DATE |
---|---|
Seq. Order | 28 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date on which the record is expired. Optional |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_LAST_EDITED_BY_USER |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The application user who changed the record lastly. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_LAST_EDITED_ON_DATE |
---|---|
Seq. Order | 30 |
Data Storage Type | TIMESTAMP(4) |
Max Length | 11 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | 4 |
Status | Active |
Description |
The date on which the record was changed lastly. |
General Data Type | TIMESTAMP(4) |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_NUMBER_OF_EDITS |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Record revision number |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_SOFT_DELETED |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Soft delete flag. Optional. Can be used as temporary delete, before hard delete. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_STEWARDSHIP |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A person that is responsible for maintaining a data element in a metadata registry. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORD_CHANGE_COMMENT |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comment for data update. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PARENT_USER_SEQ |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
CUST_AUTH.CAM_USERS |
Derivation | |
Validation Rules |
Attribute Name | LOV_MOBILE_PROVIDER_SEQ |
---|---|
Seq. Order | 36 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
CUST_AUTH.CAM_LOV_MOBILE_PROVI |
Derivation | |
Validation Rules |
Attribute Name | PRIMARY_EMAIL |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User's primary Email address |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EMPLOYER_CODE |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Foreign key to norpac.ols_lov_emplyer.employer_code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.OLS_LOV_EMPLOYER |
Derivation | |
Validation Rules |
Attribute Name | OBSERVER_SEQ |
---|---|
Seq. Order | 39 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Foreign key to NORPAC.OLS_OBSERVER.observer_seq. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.OLS_OBSERVER |
Derivation | |
Validation Rules |
Attribute Name | BUILDING |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Building code where User's office is located copied from building attribute in NOAA.LDAP |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CENTER_CODE |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User's working location (branch) copied from ou attribute in NOAA.LDAP |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DESCRIPTION |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User description copied from description attributes in NOAA.LDAP. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DIVISION_CODE |
---|---|
Seq. Order | 43 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Division where User is belonged to copied from ou1 attribute in NOAA.LDAP |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FULL_NAME |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User's full name copied from cn attribute in NOAA.LDAP |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GOV_EMPLOYEE_TYPE |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GOV_ROUTING_CODE |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Office Code for internal mail copied from routingcode attribute in NOAA.LDAP |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ROOM_NUMBER |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Building code where User's office is located copied from roomnumber attribute in NOAA.LDAP |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_CONTACT_SEQ |
---|---|
Seq. Order | 48 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.ATL_LOV_VESSEL_CONTACT |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2016-05-18 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-05-18 |
Tags |
---|