Table: CAM_PASSWORD_DICTIONARY
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:17381 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Contains all the prohibited words for password. For example, noaa, nmfs, afsc, and user, etc. This words cannot be used in passwords.
DescriptionContains all the prohibited words for password. For example, noaa, nmfs, afsc, and user, etc. This words cannot be used in passwords.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
PASSWORD_DICTIONARY_SEQ
NUMBER |
Primary key sequence of CAM_PASSWORD_DICITIONARY |
WORD
VARCHAR2 |
Word that is not allowed for password |
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. |
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_PASSWORD_DICTIONARY |
---|---|
Short Name: | CAM_PASSWORD_DICTIONARY |
Status: | Completed |
Abstract: |
Contains all the prohibited words for password. For example, noaa, nmfs, afsc, and user, etc. This words cannot be used in passwords. |
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 all the prohibited words for password. For example, noaa, nmfs, afsc, and user, etc. This words cannot be used in passwords. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
PASSWORD_DICTIONARY_SEQ | NUMBER | Primary key sequence of CAM_PASSWORD_DICITIONARY | |
100
|
WORD | VARCHAR2 | Word that is not allowed for password | |
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. |
Attribute Details
PASSWORD_DICTIONARY_SEQ
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Primary key sequence of CAM_PASSWORD_DICITIONARY |
General Data Type: | NUMBER |
WORD
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Word that is not allowed for password |
General Data Type: | VARCHAR2 |
RECORD_HISTORY
Seq. Order: | 3 |
---|---|
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
Seq. Order: | 4 |
---|---|
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
Seq. Order: | 5 |
---|---|
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
Seq. Order: | 6 |
---|---|
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
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
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
Seq. Order: | 8 |
---|---|
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
Seq. Order: | 9 |
---|---|
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
Seq. Order: | 10 |
---|---|
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
Seq. Order: | 11 |
---|---|
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
Seq. Order: | 12 |
---|---|
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
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
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
Seq. Order: | 14 |
---|---|
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
Seq. Order: | 15 |
---|---|
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
Seq. Order: | 16 |
---|---|
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
Seq. Order: | 17 |
---|---|
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
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comment for data update. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 17381 |
---|---|
GUID: | gov.noaa.nmfs.inport:17381 |
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 |