Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Custom User Authentication > AFSC/FMA/CAMS Data Objects >

Table: CAM_USER_LAST_LOGIN

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17385 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Tracks each user last login time per application.

Description

Tracks each user last login time per application.

Entity Type
Data Table

Data Attribute / Type	Description
USER_LAST_LOGIN_SEQ NUMBER	Primary key of CAM_USER_LAST_LOGIN table
LAST_LOGIN_TIMESTAMP TIMESTAMP(4)	Last date and time (precision 4, 1/1000th of a second) of failed login attempt.
RECORD_HISTORY CLOB	Entire record change history.
RECORD_JOURNAL_NOTE VARCHAR2	Comment for journaling record.
RECORD_APPROVED_BY_PERSON VARCHAR2	Person approved the record, such as QAQC manager for the record. Doesn't have to be a application user.
RECORD_APPROVED_ON_DATE DATE	Date when the data approved by QAQC manager/personell.
RECORD_COMPUTER_LOAD_BY_USER VARCHAR2	A application user who upload the record in to the database system.
RECORD_COMPUTER_LOAD_ON_DATE TIMESTAMP(4)	Date and time when the record loaded into the table.
RECORD_CREATED_BY_PERSON VARCHAR2	Data collector or creator, doesn't have to be an application user.
RECORD_CREATED_ON_DATE DATE	Date the record collected or created. Optional
RECORD_EFFECTIVE_DATE DATE	The date on which the record takes effect. Optional
RECORD_EXPIRATION_DATE DATE	The date on which the record is expired. Optional
RECORD_LAST_EDITED_BY_USER VARCHAR2	The application user who changed the record lastly.
RECORD_LAST_EDITED_ON_DATE TIMESTAMP(4)	The date on which the record was changed lastly.
RECORD_NUMBER_OF_EDITS NUMBER	Record revision number
RECORD_SOFT_DELETED VARCHAR2	Soft delete flag. Optional. Can be used as temporary delete, before hard delete.
RECORD_STEWARDSHIP VARCHAR2	A person that is responsible for maintaining a data element in a metadata registry.
RECORD_CHANGE_COMMENT VARCHAR2	Comment for data update.
USER_SEQ NUMBER	Foreign key to cam_users.user_seq, primary key.
APP_SEQ NUMBER	Foreign key to cam_apps.app_seq, primary key.

Data Attribute / Type

Description

USER_LAST_LOGIN_SEQ
NUMBER

Primary key of CAM_USER_LAST_LOGIN table

LAST_LOGIN_TIMESTAMP
TIMESTAMP(4)

Last date and time (precision 4, 1/1000th of a second) of failed login attempt.

RECORD_HISTORY
CLOB

Entire record change history.

RECORD_JOURNAL_NOTE
VARCHAR2

Comment for journaling record.

RECORD_APPROVED_BY_PERSON
VARCHAR2

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

RECORD_APPROVED_ON_DATE
DATE

Date when the data approved by QAQC manager/personell.

RECORD_COMPUTER_LOAD_BY_USER
VARCHAR2

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

RECORD_COMPUTER_LOAD_ON_DATE
TIMESTAMP(4)

Date and time when the record loaded into the table.

RECORD_CREATED_BY_PERSON
VARCHAR2

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

RECORD_CREATED_ON_DATE
DATE

Date the record collected or created. Optional

RECORD_EFFECTIVE_DATE
DATE

The date on which the record takes effect. Optional

RECORD_EXPIRATION_DATE
DATE

The date on which the record is expired. Optional

RECORD_LAST_EDITED_BY_USER
VARCHAR2

The application user who changed the record lastly.

RECORD_LAST_EDITED_ON_DATE
TIMESTAMP(4)

The date on which the record was changed lastly.

RECORD_NUMBER_OF_EDITS
NUMBER

Record revision number

RECORD_SOFT_DELETED
VARCHAR2

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

RECORD_STEWARDSHIP
VARCHAR2

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

RECORD_CHANGE_COMMENT
VARCHAR2

Comment for data update.

USER_SEQ
NUMBER

Foreign key to cam_users.user_seq, primary key.

APP_SEQ
NUMBER

Foreign key to cam_apps.app_seq, primary key.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Title:	Table: CAM_USER_LAST_LOGIN
Short Name:	CAM_USER_LAST_LOGIN
Status:	Completed
Abstract:	Tracks each user last login time per application.
Notes:	Loaded by batch 3994, 01-03-2013 16:38

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	CUST_AUTH
Description:	Tracks each user last login time per application.

Attribute Summary

	Name	Type	Description
100	USER_LAST_LOGIN_SEQ	NUMBER	Primary key of CAM_USER_LAST_LOGIN table
100	LAST_LOGIN_TIMESTAMP	TIMESTAMP(4)	Last date and time (precision 4, 1/1000th of a second) of failed login attempt.
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	USER_SEQ	NUMBER	Foreign key to cam_users.user_seq, primary key.
100	APP_SEQ	NUMBER	Foreign key to cam_apps.app_seq, primary key.

Name

Type

Description

100

USER_LAST_LOGIN_SEQ

NUMBER

Primary key of CAM_USER_LAST_LOGIN table

100

LAST_LOGIN_TIMESTAMP

TIMESTAMP(4)

Last date and time (precision 4, 1/1000th of a second) of failed login attempt.

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

USER_SEQ

NUMBER

Foreign key to cam_users.user_seq, primary key.

100

APP_SEQ

NUMBER

Foreign key to cam_apps.app_seq, primary key.

Attribute Details

USER_LAST_LOGIN_SEQ

CC ID: 84343

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Primary key of CAM_USER_LAST_LOGIN table
General Data Type:	NUMBER

LAST_LOGIN_TIMESTAMP

CC ID: 84344

Seq. Order:	2
Data Storage Type:	TIMESTAMP(4)
Max Length:	11
Required:	No
Primary Key:	No
Scale:	4
Status:	Active
Description:	Last date and time (precision 4, 1/1000th of a second) of failed login attempt.
General Data Type:	TIMESTAMP(4)

RECORD_HISTORY

CC ID: 84345

Seq. Order:	3
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: 84346

Seq. Order:	4
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: 84347

Seq. Order:	5
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: 84348

Seq. Order:	6
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: 84349

Seq. Order:	7
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: 84350

Seq. Order:	8
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: 84351

Seq. Order:	9
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: 84352

Seq. Order:	10
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: 84353

Seq. Order:	11
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: 84354

Seq. Order:	12
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: 84355

Seq. Order:	13
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: 84356

Seq. Order:	14
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: 84357

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Record revision number
General Data Type:	NUMBER

RECORD_SOFT_DELETED

CC ID: 84358

Seq. Order:	16
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: 84359

Seq. Order:	17
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: 84360

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Comment for data update.
General Data Type:	VARCHAR2

USER_SEQ

CC ID: 84362

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Foreign key to cam_users.user_seq, primary key.
General Data Type:	NUMBER
Foreign Key Relations:	CUST_AUTH.CAM_USERS

APP_SEQ

CC ID: 84361

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Foreign key to cam_apps.app_seq, primary key.
General Data Type:	NUMBER
Foreign Key Relations:	CUST_AUTH.CAM_APPS

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

Table: CAM_USER_LAST_LOGIN

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

USER_LAST_LOGIN_SEQ

LAST_LOGIN_TIMESTAMP

RECORD_HISTORY

RECORD_JOURNAL_NOTE

RECORD_APPROVED_BY_PERSON

RECORD_APPROVED_ON_DATE

RECORD_COMPUTER_LOAD_BY_USER

RECORD_COMPUTER_LOAD_ON_DATE

RECORD_CREATED_BY_PERSON

RECORD_CREATED_ON_DATE

RECORD_EFFECTIVE_DATE

RECORD_EXPIRATION_DATE

RECORD_LAST_EDITED_BY_USER

RECORD_LAST_EDITED_ON_DATE

RECORD_NUMBER_OF_EDITS

RECORD_SOFT_DELETED

RECORD_STEWARDSHIP

RECORD_CHANGE_COMMENT

USER_SEQ

APP_SEQ

Catalog Details