Table: OLS_STAFF_ROLE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12320 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionFMA 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
ROLE_CODE | VARCHAR2 | Alpha code uniquely identifying a staff members primary job performance roles. | |
100
|
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
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
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
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
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
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 |