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

Summary

Abstract

List of FMA debriefing, and training personnel. This table was renamed from the old norpac STAFF

Description

List of FMA debriefing, and training personnel. This table was renamed from the old norpac STAFF

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
STAFF_ID
NUMBER
Sequence derived unique identifier of an employee.
STAFF_CODE
VARCHAR2
Three Letter acroynym uniquely identifying an employee.
NAME
VARCHAR2
Full Name of Employee
ACTIVE_FLAG
VARCHAR2
Boolean indicator of employee status. Active(T) Inactive(F)
ORACLE_USERID
VARCHAR2
OFIS assigned Oracle user name
EMAIL_ADDRESS
VARCHAR2
Email address of the debriefer-inseason advisor.

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
Short Name: OLS_LOV_STAFF
Status: Completed
Abstract:

List of FMA debriefing, and training personnel. This table was renamed from the old norpac STAFF

Notes:

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

Entity Information

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

List of FMA debriefing, and training personnel. This table was renamed from the old norpac STAFF

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key STAFF_ID NUMBER Sequence derived unique identifier of an employee.
100
STAFF_CODE VARCHAR2 Three Letter acroynym uniquely identifying an employee.
100
NAME VARCHAR2 Full Name of Employee
100
ACTIVE_FLAG VARCHAR2 Boolean indicator of employee status. Active(T) Inactive(F)
100
ORACLE_USERID VARCHAR2 OFIS assigned Oracle user name
100
EMAIL_ADDRESS VARCHAR2 Email address of the debriefer-inseason advisor.

Attribute Details

STAFF_ID

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

Sequence derived unique identifier of an employee.

General Data Type: NUMBER

STAFF_CODE

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

Three Letter acroynym uniquely identifying an employee.

General Data Type: VARCHAR2

NAME

CC ID: 65206
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
Description:

Full Name of Employee

General Data Type: VARCHAR2

ACTIVE_FLAG

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

Boolean indicator of employee status. Active(T) Inactive(F)

General Data Type: VARCHAR2

ORACLE_USERID

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

OFIS assigned Oracle user name

General Data Type: VARCHAR2

EMAIL_ADDRESS

CC ID: 65209
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Email address of the debriefer-inseason advisor.

General Data Type: VARCHAR2

Catalog Details

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