Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: NIMM_TRANSPORT_TRANSFERS
Short Name: NIMM_TRANSPORT_TRANSFERS
Status: Completed
Abstract:

tracks requests for either the transfers of tracked animals between institutions or transfers between animal holders

Notes:

Loaded by batch 7077, 09-17-2015 08:15

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NIMM_APPS
Description:

tracks requests for either the transfers of tracked animals between institutions or transfers between animal holders

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRANSPORT_TRANSFER_ID NUMBER the unique identifier of a transport record
100
TT_TRANSPORT_TRANSFER_TYPE VARCHAR2 indicates whether this record is for a transport, transfer, or both
67
FROM_HOLDER_ID NUMBER
67
TO_HOLDER_ID NUMBER
67
FROM_FACILITY_ID NUMBER
67
TO_FACILITY_ID NUMBER
100
TT_PURPOSE VARCHAR2 the purpose behind the transport or transfer
100
TT_NOTIFICATION_DATE DATE the date and time of the notification of the planned transport
100
TT_SECTION_IV_FLAG VARCHAR2 indicates whether or not Section IV has been properly filled in
100
TT_PLANNED_DEPARTURE_DATE DATE the expected date of departure for the animals in this transport request
100
TT_PLANNED_ARRIVAL_DATE DATE the expected arrival date of the animals in this request
100
TT_TRANSFER_DATE DATE the date on which the transfer is expected to occur
100
DELETED_FLAG VARCHAR2 indicates whether or not this record has been logically deleted
100
DATE_CREATED DATE the date this record was inserted
100
CREATED_BY VARCHAR2 the user who inserted this record
100
DATE_MODIFIED DATE the date of the most recent modification to this record
100
MODIFIED_BY VARCHAR2 the last user who modified this record

Attribute Details

TRANSPORT_TRANSFER_ID

CC ID: 219386
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

the unique identifier of a transport record

General Data Type: NUMBER

TT_TRANSPORT_TRANSFER_TYPE

CC ID: 219395
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 9
Required: Yes
Primary Key: No
Status: Active
Description:

indicates whether this record is for a transport, transfer, or both

General Data Type: VARCHAR2

FROM_HOLDER_ID

CC ID: 219382
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_INSTITUTIONS

TO_HOLDER_ID

CC ID: 219383
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_INSTITUTIONS

FROM_FACILITY_ID

CC ID: 219384
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_INSTITUTIONS

TO_FACILITY_ID

CC ID: 219385
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_INSTITUTIONS

TT_PURPOSE

CC ID: 219396
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

the purpose behind the transport or transfer

General Data Type: VARCHAR2

TT_NOTIFICATION_DATE

CC ID: 219397
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

the date and time of the notification of the planned transport

General Data Type: DATE

TT_SECTION_IV_FLAG

CC ID: 219398
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

indicates whether or not Section IV has been properly filled in

General Data Type: VARCHAR2

TT_PLANNED_DEPARTURE_DATE

CC ID: 219387
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

the expected date of departure for the animals in this transport request

General Data Type: DATE

TT_PLANNED_ARRIVAL_DATE

CC ID: 219388
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

the expected arrival date of the animals in this request

General Data Type: DATE

TT_TRANSFER_DATE

CC ID: 219389
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

the date on which the transfer is expected to occur

General Data Type: DATE

DELETED_FLAG

CC ID: 219390
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

indicates whether or not this record has been logically deleted

General Data Type: VARCHAR2

DATE_CREATED

CC ID: 219391
Seq. Order: 14
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

the date this record was inserted

General Data Type: DATE

CREATED_BY

CC ID: 219392
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 200
Required: Yes
Primary Key: No
Status: Active
Description:

the user who inserted this record

General Data Type: VARCHAR2

DATE_MODIFIED

CC ID: 219393
Seq. Order: 16
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

the date of the most recent modification to this record

General Data Type: DATE

MODIFIED_BY

CC ID: 219394
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

the last user who modified this record

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 27008
GUID: gov.noaa.nmfs.inport:27008
Metadata Record Created By: Nathan Wilson
Metadata Record Created: 2015-09-17 08:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-05-16
Owner Org: OPR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-05-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-05-16