Table: NIMM_INSTITUTIONS
Entity (ENT) | NMFS Office Of Protected Resources (OPR)GUID: gov.noaa.nmfs.inport:27001 | Updated: August 9, 2022 | Published / External
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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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 |