12320
Table: OLS_STAFF_ROLE
OLS_STAFF_ROLE
Entity
Published / External
12269
AFSC/FMA/Observer Logistics System (OLS)
Data Set
Completed
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.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
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.
1
ROLE_CODE
VARCHAR2
10
Yes
Yes
Active
Alpha code uniquely identifying a staff members primary job performance roles.
VARCHAR2
NORPAC.OLS_LOV_STAFF_ROLE
2
STAFF_ID
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of an employee, here invoked as a foreign key to the OLS_LOV_STAFF table.
NUMBER
NORPAC.OLS_LOV_STAFF
3
DATE_ASSIGNED
DATE
7
Yes
No
Active
Date when personnel are assigned a new functional role.
DATE
4
DATE_RELIEVED
DATE
7
No
No
Active
Date when a staff member is releived of a specific responsibility.
DATE
5
COMMENTS
VARCHAR2
4000
No
No
Active
Comments - usually management notes as to reasons and purposes.
VARCHAR2
gov.noaa.nmfs.inport:12320
Doug Turnbull
2012-04-19T13:25:59
SysAdmin InPortAdmin
2022-08-09T17:11:04
2018-09-26
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26