Table: ODDS_TRIP_WAIVER
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:18867 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: ODDS_TRIP_WAIVER |
---|---|
Short Name: | ODDS_TRIP_WAIVER |
Status: | Completed |
Notes: |
Loaded by batch 4561, 04-30-2013 18:33 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
Information on the request for an observed trip waiver by the observer provider and if it was approved |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
TRIP_WAIVER_SEQ | NUMBER | unique sequence for a trip log waiver | |
100
|
TRIP_PLAN_LOG_SEQ | NUMBER | parent trip log seq number | |
100
|
WAIVER_STATUS_SEQ | NUMBER | FK link to odds_lov_waiver_status | |
100
|
WAIVER_REQUEST_DATE_TIME | DATE | Date - time user requested a waiver for an observed trip | |
100
|
WAIVER_REQUEST_BY | NUMBER | User making the waiver request | |
100
|
REQUEST_COMMENT | CLOB | Waiver request comment | |
100
|
ACCEPT_DENY_DATE | DATE | Date - time waiver was accepted or denied. | |
100
|
ACCEPT_DENY_BY | NUMBER | user accepting or denying the waiver | |
100
|
WAIVER_RESPONSE_COMMENT | CLOB | Comments concerning the response to waiver request. |
Attribute Details
TRIP_WAIVER_SEQ
CC ID: 108127
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
unique sequence for a trip log waiver |
General Data Type: | NUMBER |
TRIP_PLAN_LOG_SEQ
CC ID: 108126
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
parent trip log seq number |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.ODDS_TRIP_PLAN_LOG |
WAIVER_STATUS_SEQ
CC ID: 108125
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
FK link to odds_lov_waiver_status |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.ODDS_LOV_WAIVER_STATUS |
WAIVER_REQUEST_DATE_TIME
CC ID: 108128
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date - time user requested a waiver for an observed trip |
General Data Type: | DATE |
WAIVER_REQUEST_BY
CC ID: 108129
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
User making the waiver request |
General Data Type: | NUMBER |
REQUEST_COMMENT
CC ID: 108130
Seq. Order: | 6 |
---|---|
Data Storage Type: | CLOB |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Waiver request comment |
General Data Type: | CLOB |
ACCEPT_DENY_DATE
CC ID: 108131
Seq. Order: | 7 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date - time waiver was accepted or denied. |
General Data Type: | DATE |
ACCEPT_DENY_BY
CC ID: 108132
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
user accepting or denying the waiver |
General Data Type: | NUMBER |
WAIVER_RESPONSE_COMMENT
CC ID: 108133
Seq. Order: | 9 |
---|---|
Data Storage Type: | CLOB |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments concerning the response to waiver request. |
General Data Type: | CLOB |
Catalog Details
Catalog Item ID: | 18867 |
---|---|
GUID: | gov.noaa.nmfs.inport:18867 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2013-04-30 18:33+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 |