12312
Table: OLS_OBSERVER_CONTRACT
OLS_OBSERVER_CONTRACT
Entity
Published / External
12269
AFSC/FMA/Observer Logistics System (OLS)
Data Set
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Contract iformation for every contract an observer has had.
1
CONTRACT_NUMBER
NUMBER
22
Yes
Yes
9
0
Active
Unique identifier of a contract between an observer provider and an observer.
NUMBER
2
OBSERVER_SEQ
NUMBER
22
Yes
No
9
0
Active
A unique number that identifies a specific observer.
NUMBER
NORPAC.OLS_OBSERVER
3
EMPLOYER_CODE
VARCHAR2
3
Yes
No
Active
Three letter acronym forced to all caps representing a unique observer contractor
VARCHAR2
NORPAC.OLS_LOV_EMPLOYER
4
CONTRACT_STATUS
VARCHAR2
1
Yes
No
Active
Domain of valid contract status' (T- In Training, N - Not Deployed, D - Deployed, S - Deployed Scheduled, C - Closed, I - In Debriefing, E - Evaluated)
VARCHAR2
NORPAC.OLS_LOV_CONTRACT_STATUS
5
CREATE_DATE
DATE
7
Yes
No
Active
System generated timestamp for the date that contract record was created.
DATE
6
CREATED_BY
VARCHAR2
30
Yes
No
Active
System identified user who created this record
VARCHAR2
7
LAST_UPDATE_DATE
DATE
7
No
No
Active
System generated timestamp executed by after update trigger.
DATE
8
LAST_UPDATED_BY
VARCHAR2
30
No
No
Active
System identified user who updated this record
VARCHAR2
9
CONTRACT_END_DATE
DATE
7
No
No
Active
Contract close out or end date
DATE
10
CONTRACT_COMMENT
VARCHAR2
100
No
No
Active
close out comment if abnormal contract end
VARCHAR2
11
CONTRACT_ENDED_BY_USER
VARCHAR2
30
No
No
Active
User who closed or ended the contract.
VARCHAR2
12
CONTRACT_END_REASON
VARCHAR2
3
No
No
Active
Reason code for contract end
VARCHAR2
NORPAC.OLS_LOV_CONTRACT_CLOSE_
13
CONTRACT_END_REASON_COMMENT
VARCHAR2
200
No
No
Active
Comment added when contract not ended normally. Required for end reason code of other.
VARCHAR2
gov.noaa.nmfs.inport:12312
Doug Turnbull
2012-04-19T13:25:58
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