Metadata Rubric

96%

5.76 / 6

OPR Meta Data Library > Permits and Conservation Division (F/PR1) > Public Display of Marine Mammals > National Inventory of Marine Mammals (NIMM) >

Table: NIMM_TRANSPORT_TRANSFERS

Entity (ENT) | NMFS Office Of Protected Resources (OPR)
GUID: gov.noaa.nmfs.inport:27008 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

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

Description

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

Entity Type
Data Table

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

Data Attribute / Type

Description

TRANSPORT_TRANSFER_ID
NUMBER

the unique identifier of a transport record

TT_TRANSPORT_TRANSFER_TYPE
VARCHAR2

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

FROM_HOLDER_ID
NUMBER

TO_HOLDER_ID
NUMBER

FROM_FACILITY_ID
NUMBER

TO_FACILITY_ID
NUMBER

TT_PURPOSE
VARCHAR2

the purpose behind the transport or transfer

TT_NOTIFICATION_DATE
DATE

the date and time of the notification of the planned transport

TT_SECTION_IV_FLAG
VARCHAR2

indicates whether or not Section IV has been properly filled in

TT_PLANNED_DEPARTURE_DATE
DATE

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

TT_PLANNED_ARRIVAL_DATE
DATE

the expected arrival date of the animals in this request

TT_TRANSFER_DATE
DATE

the date on which the transfer is expected to occur

DELETED_FLAG
VARCHAR2

indicates whether or not this record has been logically deleted

DATE_CREATED
DATE

the date this record was inserted

CREATED_BY
VARCHAR2

the user who inserted this record

DATE_MODIFIED
DATE

the date of the most recent modification to this record

MODIFIED_BY
VARCHAR2

the last user who modified this record

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (OPR) for inquiries on this record.

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 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

Attribute Summary

	Name	Type	Description
100	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

Name

Type

Description

100

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

FROM_HOLDER_ID

NUMBER

TO_HOLDER_ID

NUMBER

FROM_FACILITY_ID

NUMBER

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 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

Table: NIMM_TRANSPORT_TRANSFERS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRANSPORT_TRANSFER_ID

TT_TRANSPORT_TRANSFER_TYPE

FROM_HOLDER_ID

TO_HOLDER_ID

FROM_FACILITY_ID

TO_FACILITY_ID

TT_PURPOSE

TT_NOTIFICATION_DATE

TT_SECTION_IV_FLAG

TT_PLANNED_DEPARTURE_DATE

TT_PLANNED_ARRIVAL_DATE

TT_TRANSFER_DATE

DELETED_FLAG

DATE_CREATED

CREATED_BY

DATE_MODIFIED

MODIFIED_BY

Catalog Details