Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

tracks the positions of people at facilities

Description

tracks the positions of people at facilities

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FUNCTION_ID
NUMBER
the unique identifier of an employment record
INSTITUTION_ID
NUMBER
the facility at which the person's position is being recorded
PERSON_ID
NUMBER
the person whose position at the identified facility is being recorded
FN_FUNCTION
VARCHAR2
the position of the person at this 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_FUNCTIONS
Short Name: NIMM_FUNCTIONS
Status: Completed
Abstract:

tracks the positions of people at facilities

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 the positions of people at facilities

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FUNCTION_ID NUMBER the unique identifier of an employment record
100
INSTITUTION_ID NUMBER the facility at which the person's position is being recorded
100
PERSON_ID NUMBER the person whose position at the identified facility is being recorded
100
FN_FUNCTION VARCHAR2 the position of the person at this 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

FUNCTION_ID

CC ID: 219279
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 an employment record

General Data Type: NUMBER

INSTITUTION_ID

CC ID: 219277
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

the facility at which the person's position is being recorded

General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_INSTITUTIONS

PERSON_ID

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

the person whose position at the identified facility is being recorded

General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.NIMM_PERSONS

FN_FUNCTION

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

the position of the person at this facility

General Data Type: VARCHAR2

DELETED_FLAG

CC ID: 219281
Seq. Order: 5
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: 219282
Seq. Order: 6
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: 219283
Seq. Order: 7
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: 219284
Seq. Order: 8
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: 219285
Seq. Order: 9
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: 27000
GUID: gov.noaa.nmfs.inport:27000
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