KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - MRC_RECEIVING link

Properties
Name Value
Data Model Physical
Schema PMIS
Primary Key Clustered Unspecified
Unlogged false
Temporal false

Columns Summary
Column Name Data Type PK / FK Nullable Description
LABNUMBER varchar2(10) Yes
SECTION varchar2(1) Yes
CMSNO number(38) Yes
CMSSUFFIX varchar2(3) Yes
DATERECD date Yes
TYPEINSP varchar2(3) Yes
SAMPLE varchar2(60) Yes
SPECNO varchar2(30) Yes
QUANTITY varchar2(30) Yes
PROPMANF varchar2(60) Yes
LOCATION varchar2(60) Yes
MIXDESIGN varchar2(30) Yes
CONTRACTNO number(38) Yes
LEGDESCRI1 varchar2(50) Yes
LEGDESCRI2 varchar2(50) Yes
LEGDESCRI3 varchar2(50) Yes
COUNTY1 varchar2(50) Yes
COUNTY2 varchar2(50) Yes
COUNTY3 varchar2(50) Yes
DIST1 varchar2(2) Yes
DIST2 varchar2(2) Yes
DIST3 varchar2(2) Yes
IDMARK varchar2(100) Yes
SUBMITTER varchar2(60) Yes
PROJPOV1 varchar2(27) Yes
PROJPOV2 varchar2(27) Yes
PROJPOV3 varchar2(27) Yes
CODIST1 varchar2(10) Yes
CODIST2 varchar2(5) Yes
CODIST3 varchar2(5) Yes
EXAMFOR varchar2(255) Yes
REMARKS varchar2(100) Yes
CONTRACTOR varchar2(60) Yes
FILECODE varchar2(5) Yes
DATEREPT date Yes
ESTCOMPL date Yes
RESULTS varchar2(60) Yes
RECORDDATE date Yes
RECYEAR varchar2(4) Yes
RECNUMBER varchar2(10) Yes

Columns Detail
Name Value
Name LABNUMBER
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SECTION
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 1
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CMSNO
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 38
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CMSSUFFIX
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 3
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name DATERECD
Type date
Nullable true
Unique false
Primary Key false
Index false
Type Name DATE
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name TYPEINSP
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 3
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SAMPLE
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 60
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SPECNO
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 30
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name QUANTITY
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 30
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name PROPMANF
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 60
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LOCATION
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 60
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name MIXDESIGN
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 30
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CONTRACTNO
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 38
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LEGDESCRI1
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 50
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LEGDESCRI2
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 50
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LEGDESCRI3
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 50
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name COUNTY1
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 50
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name COUNTY2
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 50
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name COUNTY3
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 50
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name DIST1
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name DIST2
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name DIST3
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name IDMARK
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 100
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SUBMITTER
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 60
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name PROJPOV1
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 27
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name PROJPOV2
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 27
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name PROJPOV3
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 27
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CODIST1
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CODIST2
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 5
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CODIST3
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 5
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name EXAMFOR
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name REMARKS
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 100
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CONTRACTOR
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 60
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name FILECODE
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 5
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name DATEREPT
Type date
Nullable true
Unique false
Primary Key false
Index false
Type Name DATE
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name ESTCOMPL
Type date
Nullable true
Unique false
Primary Key false
Index false
Type Name DATE
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name RESULTS
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 60
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name RECORDDATE
Type date
Nullable true
Unique false
Primary Key false
Index false
Type Name DATE
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name RECYEAR
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 4
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name RECNUMBER
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

KDOT PMS Replacement Project