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

Summary

Abstract

FMA staff fill a number of overlapping job responsibilites and roles. Among these are debriefer, trainer, inseason advision. In prior iterations this was tracked by a series of flags on the staff table. This is now expanded to include temporal information as well. This entity represents the list of roles to which a staff member may be assigned.

Description

FMA staff fill a number of overlapping job responsibilites and roles. Among these are debriefer, trainer, inseason advision. In prior iterations this was tracked by a series of flags on the staff table. This is now expanded to include temporal information as well. This entity represents the list of roles to which a staff member may be assigned.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ROLE_CODE
VARCHAR2
Alpha code uniquely identifying a staff members primary job performance roles.
DESCRIPTION
VARCHAR2
Brief descrition of the role identified by a unique code.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

FMA staff fill a number of overlapping job responsibilites and roles. Among these are debriefer, trainer, inseason advision. In prior iterations this was tracked by a series of flags on the staff table. This is now expanded to include temporal information as well. This entity represents the list of roles to which a staff member may be assigned.

Notes:

Loaded by batch 3083, 04-19-2012 13:25

Entity Information

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

FMA staff fill a number of overlapping job responsibilites and roles. Among these are debriefer, trainer, inseason advision. In prior iterations this was tracked by a series of flags on the staff table. This is now expanded to include temporal information as well. This entity represents the list of roles to which a staff member may be assigned.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ROLE_CODE VARCHAR2 Alpha code uniquely identifying a staff members primary job performance roles.
100
DESCRIPTION VARCHAR2 Brief descrition of the role identified by a unique code.

Attribute Details

ROLE_CODE

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

Alpha code uniquely identifying a staff members primary job performance roles.

General Data Type: VARCHAR2

DESCRIPTION

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

Brief descrition of the role identified by a unique code.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 12301
GUID: gov.noaa.nmfs.inport:12301
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2012-04-19 13:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26