Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

Table: EDC_VALIDATION

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6863  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Physical Location
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Control Table holding Validation Rules And Messages To be used in validating Economic Data

Description

Control Table holding Validation Rules And Messages To be used in validating Economic Data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VALIDATION_ID
NUMBER 		Sequential Key
FORM_TYPE_CD
VARCHAR2 		Which Form this validation rule applies
FIELD_NAME
VARCHAR2 		Field/Column That is being validated
FIELD_DESC
VARCHAR2 		Field/Column Description
MIN_VALUE
NUMBER 		Minimum acceptable Value
MAX_VALUE
NUMBER 		Maximum Acceptable Value
WARNING_MSG
VARCHAR2 		Warning Message
DISPLAY_ORDER
NUMBER 		Display Order
IS_ENABLED
NUMBER 		Is This check enabled
IS_ACTIVE
NUMBER 		Is This check active
LU
DATE 		Date Record was last updated
MIN_HIST_RECORDS
NUMBER 		MINIMUM HISTORICAL RECORDS REQUIRED BEFORE VESSEL HISTORY VALIDATION WOULD TAKE PLACE
STD_DEV_COEFFICIENT
NUMBER 		THE STANDARD DEVIATION COEFFICIENT THRESHOLD USED DURING THE VESSEL HISTORY VALIDATION. CHECK VALUE IS COMPARED WITH THE AVERAGE PLUS OR MINUS THE STANDARD DEVIATION TIMES THE COEFFICIENT.
IS_CLUSTERED
NUMBER 		DETERMINES IF THE COST ELEMENT IS PART OF THE CLUSTER VALIDATION CHECK.
IS_VESSEL_HISTORY
NUMBER 		DETERMINES IF THE COST ELEMENT IS PART OF VESSEL HISTORY VALIDATION
TOTAL_DIST_POINTS
NUMBER 		TOTAL NUMBER OF DISTRIBUTION POINTS FOR THE CLUSTER. THIS IS A PARAMETER DEFINED BY THE USER. IT IS USED TO CALCULATED THE WIDTH OF THE DISTRIBUTION. (MAX - MIN)/TOTALDISTRIBUTIONPOINTS - 1
THRESHOLD_PERCENTAGE
NUMBER 		USED IN CLUSTERS - PERCENTAGE THRESHOLD DEFINED BY THE USER. DISTRIBUTION WITH PERCENTAGE BELOW THIS THRESHOLD FAIL CLUSTER VALIDATION
FIELD_ORDER
NUMBER 		USED TO STORE THE FIELD NUMBERS APPEARING ON THE EDC SG ANNUAL FORM SO THAT THEY MAY BE USED INSIDE ANY WARNING/ERROR MESSAGES.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Control Table holding Validation Rules And Messages To be used in validating Economic Data
Notes:

Loaded by batch 2043, 12-20-2007 08:10

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

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

Control Table holding Validation Rules And Messages To be used in validating Economic Data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key VALIDATION_ID NUMBER Sequential Key
100
 FORM_TYPE_CD VARCHAR2 Which Form this validation rule applies
100
 FIELD_NAME VARCHAR2 Field/Column That is being validated
100
 FIELD_DESC VARCHAR2 Field/Column Description
100
 MIN_VALUE NUMBER Minimum acceptable Value
100
 MAX_VALUE NUMBER Maximum Acceptable Value
100
 WARNING_MSG VARCHAR2 Warning Message
100
 DISPLAY_ORDER NUMBER Display Order
100
 IS_ENABLED NUMBER Is This check enabled
100
 IS_ACTIVE NUMBER Is This check active
100
 LU DATE Date Record was last updated
100
 MIN_HIST_RECORDS NUMBER MINIMUM HISTORICAL RECORDS REQUIRED BEFORE VESSEL HISTORY VALIDATION WOULD TAKE PLACE
100
 STD_DEV_COEFFICIENT NUMBER THE STANDARD DEVIATION COEFFICIENT THRESHOLD USED DURING THE VESSEL HISTORY VALIDATION. CHECK VALUE IS COMPARED WITH THE AVERAGE PLUS OR MINUS THE STANDARD DEVIATION TIMES THE COEFFICIENT.
100
 IS_CLUSTERED NUMBER DETERMINES IF THE COST ELEMENT IS PART OF THE CLUSTER VALIDATION CHECK.
100
 IS_VESSEL_HISTORY NUMBER DETERMINES IF THE COST ELEMENT IS PART OF VESSEL HISTORY VALIDATION
100
 TOTAL_DIST_POINTS NUMBER TOTAL NUMBER OF DISTRIBUTION POINTS FOR THE CLUSTER. THIS IS A PARAMETER DEFINED BY THE USER. IT IS USED TO CALCULATED THE WIDTH OF THE DISTRIBUTION. (MAX - MIN)/TOTALDISTRIBUTIONPOINTS - 1
100
 THRESHOLD_PERCENTAGE NUMBER USED IN CLUSTERS - PERCENTAGE THRESHOLD DEFINED BY THE USER. DISTRIBUTION WITH PERCENTAGE BELOW THIS THRESHOLD FAIL CLUSTER VALIDATION
100
 FIELD_ORDER NUMBER USED TO STORE THE FIELD NUMBERS APPEARING ON THE EDC SG ANNUAL FORM SO THAT THEY MAY BE USED INSIDE ANY WARNING/ERROR MESSAGES.

Attribute Details

VALIDATION_ID

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

Sequential Key
General Data Type: NUMBER

FORM_TYPE_CD

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

Which Form this validation rule applies
General Data Type: VARCHAR2

FIELD_NAME

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

Field/Column That is being validated
General Data Type: VARCHAR2

FIELD_DESC

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

Field/Column Description
General Data Type: VARCHAR2

MIN_VALUE

CC ID: 24745
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 2
Status: Active
Description:

Minimum acceptable Value
General Data Type: NUMBER

MAX_VALUE

CC ID: 24746
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 2
Status: Active
Description:

Maximum Acceptable Value
General Data Type: NUMBER

WARNING_MSG

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

Warning Message
General Data Type: VARCHAR2

DISPLAY_ORDER

CC ID: 24748
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Display Order
General Data Type: NUMBER

IS_ENABLED

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

Is This check enabled
General Data Type: NUMBER

IS_ACTIVE

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

Is This check active
General Data Type: NUMBER

LU

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

Date Record was last updated
General Data Type: DATE

MIN_HIST_RECORDS

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

MINIMUM HISTORICAL RECORDS REQUIRED BEFORE VESSEL HISTORY VALIDATION WOULD TAKE PLACE
General Data Type: NUMBER

STD_DEV_COEFFICIENT

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

THE STANDARD DEVIATION COEFFICIENT THRESHOLD USED DURING THE VESSEL HISTORY VALIDATION. CHECK VALUE IS COMPARED WITH THE AVERAGE PLUS OR MINUS THE STANDARD DEVIATION TIMES THE COEFFICIENT.
General Data Type: NUMBER

IS_CLUSTERED

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

DETERMINES IF THE COST ELEMENT IS PART OF THE CLUSTER VALIDATION CHECK.
General Data Type: NUMBER

IS_VESSEL_HISTORY

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

DETERMINES IF THE COST ELEMENT IS PART OF VESSEL HISTORY VALIDATION
General Data Type: NUMBER

TOTAL_DIST_POINTS

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

TOTAL NUMBER OF DISTRIBUTION POINTS FOR THE CLUSTER. THIS IS A PARAMETER DEFINED BY THE USER. IT IS USED TO CALCULATED THE WIDTH OF THE DISTRIBUTION. (MAX - MIN)/TOTALDISTRIBUTIONPOINTS - 1
General Data Type: NUMBER

THRESHOLD_PERCENTAGE

CC ID: 24757
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

USED IN CLUSTERS - PERCENTAGE THRESHOLD DEFINED BY THE USER. DISTRIBUTION WITH PERCENTAGE BELOW THIS THRESHOLD FAIL CLUSTER VALIDATION
General Data Type: NUMBER

FIELD_ORDER

CC ID: 24758
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

USED TO STORE THE FIELD NUMBERS APPEARING ON THE EDC SG ANNUAL FORM SO THAT THEY MAY BE USED INSIDE ANY WARNING/ERROR MESSAGES.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6863
GUID: gov.noaa.nmfs.inport:6863
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-20 08:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07