with Name

KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - IRIMODELOUT link

Properties



	Name		Value

	Data Model		Physical
	Schema		dbo
	Primary Key Clustered		Unspecified
	Unlogged		false
	Temporal		false

Columns Summary



	Column Name		Data Type		PK / FK		Nullable		Description

	LOOKUPFIELD		varchar2(19)				Yes
	LRSKEY		varchar2(13)				Yes
	LOG_MILE_TENTHS		number(4, 1)				Yes
	LOG_MILE_END_TENTHS		number(4, 1)				Yes
	CountOfPSUEDOFRAME		number(0)				Yes
	LAST_DL		number(4, 1)				Yes
	LAST_YEAR		number(0)				Yes
	RDCAT		number(0)				Yes
	B1W0		number(0)				Yes
	IRI14		number(0)				Yes
	IRI15		number(0)				Yes
	IRI16		number(0)				Yes
	IRI17		number(0)				Yes
	IRI18		number(0)				Yes
	IRI2019		number(0)				Yes
	IRI2020		number(0)				Yes
	IRI2021		number(0)				Yes
	IRI2022		number(0)				Yes
	IRI2023		number(0)				Yes
	IRI2024		number(0)				Yes
	IRI2025		number(0)				Yes
	IRI2026		number(0)				Yes
	IRI2027		number(0)				Yes
	IRI2028		number(0)				Yes
	IRI2029		number(0)				Yes
	IRI2030		number(0)				Yes

Columns Detail



	Name		Value

	Name		LOOKUPFIELD
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LRSKEY
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		13
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LOG_MILE_TENTHS
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		4
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LOG_MILE_END_TENTHS
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		4
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CountOfPSUEDOFRAME
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LAST_DL
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		4
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LAST_YEAR
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RDCAT
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		B1W0
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI14
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI15
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI16
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI17
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI18
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2019
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2020
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2021
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2022
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2023
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2024
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2025
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2026
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2027
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2028
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2029
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IRI2030
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

Appears In



	Diagram

	KDOT_RPMS_Modeling(Reduced) : Entity Relationship Diagram

KDOT PMS Replacement Project