APP_POP_ATTRIBUTE_LOV
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:32691 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | APP_POP_ATTRIBUTE_LOV |
|---|---|
| Short Name: | APP_POP_ATTRIBUTE_LOV |
| Status: | Planned |
| Abstract: |
Table used to store how and when database columns are presented to the user through the SPS web application. |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | SPS |
| Description: |
Table used to store how and when database columns are presented to the user through the SPS web application. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
DISPLAY | VARCHAR2 | Database-generated primary key (unique identifier) for each APP_POP_ATTRIBUTE_LOV record, created by an internal sequence generator and used by the database to maintain referential integrity. This ID is not designed to be managed by users. This primary key constraint is named APP_POP_ATTRIBUTE_LOV_PK. |
|
100
|
VALUE | VARCHAR2 | The name of the database column that stores the data. | |
|
100
|
ORDER_NUMBER | NUMBER | The order in which the column is presented to the user through the SPS web application. | |
|
100
|
DATA_TYPE | VARCHAR2 | The type of data presented in a data column. | |
|
100
|
ATTRIBUTE_SCOPE_TYPE | VARCHAR2 | Used to control when a column is presented to a user. Acceptable values are ext (expired), std (standard), spz (SPAZ specific). | |
|
100
|
SPAZ_COLUMN | VARCHAR2 | How the column is downloaded for the SPAZ application. This is no longer used. |
Attribute Details
DISPLAY
| Data Storage Type: | VARCHAR2 |
|---|---|
| Max Length: | 100 |
| Required: | Yes |
| Primary Key: | Yes |
| Status: | Active |
| Description: |
Database-generated primary key (unique identifier) for each APP_POP_ATTRIBUTE_LOV record, created by an internal sequence generator and used by the database to maintain referential integrity. This ID is not designed to be managed by users. This primary key constraint is named APP_POP_ATTRIBUTE_LOV_PK. |
| General Data Type: | VARCHAR2 |
VALUE
| Data Storage Type: | VARCHAR2 |
|---|---|
| Max Length: | 32 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The name of the database column that stores the data. |
| General Data Type: | VARCHAR2 |
ORDER_NUMBER
| Data Storage Type: | NUMBER |
|---|---|
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The order in which the column is presented to the user through the SPS web application. |
| General Data Type: | NUMBER |
DATA_TYPE
| Data Storage Type: | VARCHAR2 |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The type of data presented in a data column. |
| General Data Type: | VARCHAR2 |
ATTRIBUTE_SCOPE_TYPE
| Data Storage Type: | VARCHAR2 |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Used to control when a column is presented to a user. Acceptable values are ext (expired), std (standard), spz (SPAZ specific). |
| General Data Type: | VARCHAR2 |
SPAZ_COLUMN
| Data Storage Type: | VARCHAR2 |
|---|---|
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
How the column is downloaded for the SPAZ application. This is no longer used. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 32691 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:32691 |
| Metadata Record Created By: | Jeffrey W Cowen |
| Metadata Record Created: | 2016-05-09 14:19+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-05-11 |
| Owner Org: | NWFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-05-11 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-05-11 |