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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ROLE_CODE
VARCHAR2
Alpha code uniquely identifying a staff members primary job performance roles.
STAFF_ID
NUMBER
Sequence generated unique identifier of an employee, here invoked as a foreign key to the OLS_LOV_STAFF table.
DATE_ASSIGNED
DATE
Date when personnel are assigned a new functional role.
DATE_RELIEVED
DATE
Date when a staff member is releived of a specific responsibility.
COMMENTS
VARCHAR2
Comments - usually management notes as to reasons and purposes.

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_STAFF_ROLE
Short Name: OLS_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.

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.

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
Primary Key STAFF_ID NUMBER Sequence generated unique identifier of an employee, here invoked as a foreign key to the OLS_LOV_STAFF table.
100
DATE_ASSIGNED DATE Date when personnel are assigned a new functional role.
100
DATE_RELIEVED DATE Date when a staff member is releived of a specific responsibility.
100
COMMENTS VARCHAR2 Comments - usually management notes as to reasons and purposes.

Attribute Details

ROLE_CODE

CC ID: 65349
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
Foreign Key Relations:

NORPAC.OLS_LOV_STAFF_ROLE

STAFF_ID

CC ID: 65350
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of an employee, here invoked as a foreign key to the OLS_LOV_STAFF table.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_LOV_STAFF

DATE_ASSIGNED

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

Date when personnel are assigned a new functional role.

General Data Type: DATE

DATE_RELIEVED

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

Date when a staff member is releived of a specific responsibility.

General Data Type: DATE

COMMENTS

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

Comments - usually management notes as to reasons and purposes.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 12320
GUID: gov.noaa.nmfs.inport:12320
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