Search Help Show/Hide Menu
Metadata Rubric
96%
5.76 / 6
View Report
OPR Meta Data Library > Permits and Conservation Division (F/PR1) > Public Display of Marine Mammals > National Inventory of Marine Mammals (NIMM) >

Table: NIMM_INSTITUTIONS

Entity (ENT)  |  NMFS Office Of Protected Resources (OPR)
GUID: gov.noaa.nmfs.inport:27001  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

installations with the capability of housing animals

Description

installations with the capability of housing animals

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
INSTITUTION_ID
NUMBER 		the unique identifier of a facility
IN_INSTITUTION_TYPE
VARCHAR2 		the type of institution, ie, foreign or US
IN_INSTITUTION_NAME
VARCHAR2 		the name of the facility
IN_PHF_ID
VARCHAR2
IN_FILE_NBR
VARCHAR2
IN_HOLDER_FLAG
VARCHAR2 		indicates whether or not this institution may be identified as a holder
IN_PTGA_HOLDER_FLAG
VARCHAR2
IN_PTGA_APPLIED_FLAG
VARCHAR2 		indicates whether or not a PTGA holdership application is in progress
IN_PTGA_RETURNED_FLAG
VARCHAR2 		indicates whether or not a PTGA application has been returned
IN_FACILITY_FLAG
VARCHAR2 		indicates whether or not this institution may be identified as a (housing) facility
IN_REHAB_FACILITY_FLAG
VARCHAR2 		indicates whether or not the facility is a rehab facility
IN_TRAVEL_FACILITY_FLAG
VARCHAR2 		indicates whether or not this is a traveling facility
IN_APPLICATION_ACTIVE_FLAG
VARCHAR2 		indicates whether or not an application is active
IN_ADDRESS1
VARCHAR2 		the "main" street address of the facility
IN_ADDRESS2
VARCHAR2 		the secondary street address of the facility
IN_CITY
VARCHAR2 		the city in which the facility is located
IN_STATE_ABRV
VARCHAR2
IN_ZIP_POSTAL_CODE
VARCHAR2 		the zip or postal code in which the facility is located
IN_COUNTRY_NAME
VARCHAR2
IN_EMAIL
VARCHAR2 		the facility's email address
IN_PHONE
VARCHAR2 		the facility's phone number
IN_FAX
VARCHAR2 		the facility's fax number
IN_OPERATIONAL_HOUR
VARCHAR2 		the facility's normal operating hours
IN_USDA_REGISTRY
VARCHAR2
IN_ISSUE_DATE
DATE
IN_EXPIRY_DATE
DATE
IN_EDUCATIONAL_PROGRAM_DATE
DATE 		the date the education program plan was received
IN_INSTITUTION_COMMENT
VARCHAR2 		comments pertaining to the facility
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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

installations with the capability of housing animals
Notes:

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

Entity Information

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

installations with the capability of housing animals

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key INSTITUTION_ID NUMBER the unique identifier of a facility
100
 IN_INSTITUTION_TYPE VARCHAR2 the type of institution, ie, foreign or US
100
 IN_INSTITUTION_NAME VARCHAR2 the name of the facility
67
 IN_PHF_ID VARCHAR2
67
 IN_FILE_NBR VARCHAR2
100
 IN_HOLDER_FLAG VARCHAR2 indicates whether or not this institution may be identified as a holder
67
 IN_PTGA_HOLDER_FLAG VARCHAR2
100
 IN_PTGA_APPLIED_FLAG VARCHAR2 indicates whether or not a PTGA holdership application is in progress
100
 IN_PTGA_RETURNED_FLAG VARCHAR2 indicates whether or not a PTGA application has been returned
100
 IN_FACILITY_FLAG VARCHAR2 indicates whether or not this institution may be identified as a (housing) facility
100
 IN_REHAB_FACILITY_FLAG VARCHAR2 indicates whether or not the facility is a rehab facility
100
 IN_TRAVEL_FACILITY_FLAG VARCHAR2 indicates whether or not this is a traveling facility
100
 IN_APPLICATION_ACTIVE_FLAG VARCHAR2 indicates whether or not an application is active
100
 IN_ADDRESS1 VARCHAR2 the "main" street address of the facility
100
 IN_ADDRESS2 VARCHAR2 the secondary street address of the facility
100
 IN_CITY VARCHAR2 the city in which the facility is located
67
 IN_STATE_ABRV VARCHAR2
100
 IN_ZIP_POSTAL_CODE VARCHAR2 the zip or postal code in which the facility is located
67
 IN_COUNTRY_NAME VARCHAR2
100
 IN_EMAIL VARCHAR2 the facility's email address
100
 IN_PHONE VARCHAR2 the facility's phone number
100
 IN_FAX VARCHAR2 the facility's fax number
100
 IN_OPERATIONAL_HOUR VARCHAR2 the facility's normal operating hours
67
 IN_USDA_REGISTRY VARCHAR2
67
 IN_ISSUE_DATE DATE
67
 IN_EXPIRY_DATE DATE
100
 IN_EDUCATIONAL_PROGRAM_DATE DATE the date the education program plan was received
100
 IN_INSTITUTION_COMMENT VARCHAR2 comments pertaining to the facility
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

INSTITUTION_ID

CC ID: 219286
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 facility
General Data Type: NUMBER

IN_INSTITUTION_TYPE

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

the type of institution, ie, foreign or US
General Data Type: VARCHAR2

IN_INSTITUTION_NAME

CC ID: 219308
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 255
Required: Yes
Primary Key: No
Status: Active
Description:

the name of the facility
General Data Type: VARCHAR2

IN_PHF_ID

CC ID: 219313
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

IN_FILE_NBR

CC ID: 219314
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

IN_HOLDER_FLAG

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

indicates whether or not this institution may be identified as a holder
General Data Type: VARCHAR2

IN_PTGA_HOLDER_FLAG

CC ID: 219316
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

IN_PTGA_APPLIED_FLAG

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

indicates whether or not a PTGA holdership application is in progress
General Data Type: VARCHAR2

IN_PTGA_RETURNED_FLAG

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

indicates whether or not a PTGA application has been returned
General Data Type: VARCHAR2

IN_FACILITY_FLAG

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

indicates whether or not this institution may be identified as a (housing) facility
General Data Type: VARCHAR2

IN_REHAB_FACILITY_FLAG

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

indicates whether or not the facility is a rehab facility
General Data Type: VARCHAR2

IN_TRAVEL_FACILITY_FLAG

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

indicates whether or not this is a traveling facility
General Data Type: VARCHAR2

IN_APPLICATION_ACTIVE_FLAG

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

indicates whether or not an application is active
General Data Type: VARCHAR2

IN_ADDRESS1

CC ID: 219291
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 255
Required: Yes
Primary Key: No
Status: Active
Description:

the "main" street address of the facility
General Data Type: VARCHAR2

IN_ADDRESS2

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

the secondary street address of the facility
General Data Type: VARCHAR2

IN_CITY

CC ID: 219293
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 225
Required: Yes
Primary Key: No
Status: Active
Description:

the city in which the facility is located
General Data Type: VARCHAR2

IN_STATE_ABRV

CC ID: 219294
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

IN_ZIP_POSTAL_CODE

CC ID: 219295
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

the zip or postal code in which the facility is located
General Data Type: VARCHAR2

IN_COUNTRY_NAME

CC ID: 219296
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

IN_EMAIL

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

the facility's email address
General Data Type: VARCHAR2

IN_PHONE

CC ID: 219299
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

the facility's phone number
General Data Type: VARCHAR2

IN_FAX

CC ID: 219300
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

the facility's fax number
General Data Type: VARCHAR2

IN_OPERATIONAL_HOUR

CC ID: 219301
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

the facility's normal operating hours
General Data Type: VARCHAR2

IN_USDA_REGISTRY

CC ID: 219302
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

IN_ISSUE_DATE

CC ID: 219303
Seq. Order: 25
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

IN_EXPIRY_DATE

CC ID: 219304
Seq. Order: 26
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

IN_EDUCATIONAL_PROGRAM_DATE

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

the date the education program plan was received
General Data Type: DATE

IN_INSTITUTION_COMMENT

CC ID: 219306
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

comments pertaining to the facility
General Data Type: VARCHAR2

DELETED_FLAG

CC ID: 219307
Seq. Order: 29
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: 219309
Seq. Order: 30
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: 219310
Seq. Order: 31
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: 219311
Seq. Order: 32
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: 219312
Seq. Order: 33
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: 27001
GUID: gov.noaa.nmfs.inport:27001
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