Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: CAM_APPS
Short Name: CAM_APPS
Status: Completed
Abstract:

This entity contains application name, acronym and description. ODDS (Observer Declare and Deploy System), CAM (Custom Authentication Management system), Etc.

Notes:

Loaded by batch 3994, 01-03-2013 16:38

Entity Information

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

This entity contains application name, acronym and description. ODDS (Observer Declare and Deploy System), CAM (Custom Authentication Management system), Etc.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key APP_SEQ NUMBER Primary key sequence of CAM_MODULES
100
APP_NAME VARCHAR2 Module/application name. Full name of the moducle, for example, Obeserver Logistics, Observer Declare and Deploy System, etc.
100
APP_CODE VARCHAR2 Abbreviated module name for example, OLS, ODDS
100
APP_DESC VARCHAR2 Describe module/application
100
RECORD_HISTORY CLOB Entire record change history.
100
RECORD_JOURNAL_NOTE VARCHAR2 Comment for journaling record.
100
RECORD_APPROVED_BY_PERSON VARCHAR2 Person approved the record, such as QAQC manager for the record. Doesn't have to be a application user.
100
RECORD_APPROVED_ON_DATE DATE Date when the data approved by QAQC manager/personell.
100
RECORD_COMPUTER_LOAD_BY_USER VARCHAR2 A application user who upload the record in to the database system.
100
RECORD_COMPUTER_LOAD_ON_DATE TIMESTAMP(4) Date and time when the record loaded into the table.
100
RECORD_CREATED_BY_PERSON VARCHAR2 Data collector or creator, doesn't have to be an application user.
100
RECORD_CREATED_ON_DATE DATE Date the record collected or created. Optional
100
RECORD_EFFECTIVE_DATE DATE The date on which the record takes effect. Optional
100
RECORD_EXPIRATION_DATE DATE The date on which the record is expired. Optional
100
RECORD_LAST_EDITED_BY_USER VARCHAR2 The application user who changed the record lastly.
100
RECORD_LAST_EDITED_ON_DATE TIMESTAMP(4) The date on which the record was changed lastly.
100
RECORD_NUMBER_OF_EDITS NUMBER Record revision number
100
RECORD_SOFT_DELETED VARCHAR2 Soft delete flag. Optional. Can be used as temporary delete, before hard delete.
100
RECORD_STEWARDSHIP VARCHAR2 A person that is responsible for maintaining a data element in a metadata registry.
100
RECORD_CHANGE_COMMENT VARCHAR2 Comment for data update.
100
APP_URL VARCHAR2 URL for applications.

Attribute Details

APP_SEQ

CC ID: 84189
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary key sequence of CAM_MODULES

General Data Type: NUMBER

APP_NAME

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

Module/application name. Full name of the moducle, for example, Obeserver Logistics, Observer Declare and Deploy System, etc.

General Data Type: VARCHAR2

APP_CODE

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

Abbreviated module name for example, OLS, ODDS

General Data Type: VARCHAR2

APP_DESC

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

Describe module/application

General Data Type: VARCHAR2

RECORD_HISTORY

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

Entire record change history.

General Data Type: CLOB

RECORD_JOURNAL_NOTE

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

Comment for journaling record.

General Data Type: VARCHAR2

RECORD_APPROVED_BY_PERSON

CC ID: 84195
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Person approved the record, such as QAQC manager for the record. Doesn't have to be a application user.

General Data Type: VARCHAR2

RECORD_APPROVED_ON_DATE

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

Date when the data approved by QAQC manager/personell.

General Data Type: DATE

RECORD_COMPUTER_LOAD_BY_USER

CC ID: 84197
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 40
Required: Yes
Primary Key: No
Status: Active
Description:

A application user who upload the record in to the database system.

General Data Type: VARCHAR2

RECORD_COMPUTER_LOAD_ON_DATE

CC ID: 84198
Seq. Order: 10
Data Storage Type: TIMESTAMP(4)
Max Length: 11
Required: Yes
Primary Key: No
Scale: 4
Status: Active
Description:

Date and time when the record loaded into the table.

General Data Type: TIMESTAMP(4)

RECORD_CREATED_BY_PERSON

CC ID: 84199
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Data collector or creator, doesn't have to be an application user.

General Data Type: VARCHAR2

RECORD_CREATED_ON_DATE

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

Date the record collected or created. Optional

General Data Type: DATE

RECORD_EFFECTIVE_DATE

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

The date on which the record takes effect. Optional

General Data Type: DATE

RECORD_EXPIRATION_DATE

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

The date on which the record is expired. Optional

General Data Type: DATE

RECORD_LAST_EDITED_BY_USER

CC ID: 84203
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 40
Required: Yes
Primary Key: No
Status: Active
Description:

The application user who changed the record lastly.

General Data Type: VARCHAR2

RECORD_LAST_EDITED_ON_DATE

CC ID: 84204
Seq. Order: 16
Data Storage Type: TIMESTAMP(4)
Max Length: 11
Required: Yes
Primary Key: No
Scale: 4
Status: Active
Description:

The date on which the record was changed lastly.

General Data Type: TIMESTAMP(4)

RECORD_NUMBER_OF_EDITS

CC ID: 84205
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Record revision number

General Data Type: NUMBER

RECORD_SOFT_DELETED

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

Soft delete flag. Optional. Can be used as temporary delete, before hard delete.

General Data Type: VARCHAR2

RECORD_STEWARDSHIP

CC ID: 84207
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

A person that is responsible for maintaining a data element in a metadata registry.

General Data Type: VARCHAR2

RECORD_CHANGE_COMMENT

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

Comment for data update.

General Data Type: VARCHAR2

APP_URL

CC ID: 84209
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

URL for applications.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 17375
GUID: gov.noaa.nmfs.inport:17375
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-01-03 16:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18