with Name

KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - SHCOSTR 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

	SACTION		number(3)				Yes		Action.
	SGROUP		number(1)				Yes		Shoulder Group: 1 = TURF 2 = ROCK 3 = SURFACED
	SCOSTYPE		number(1)				Yes		Shoulder Cost Type.
	SCWA1		number(5, 3)				Yes		Shoulder Const.Cost WageArea1.
	SCWA2		number(5, 3)				Yes		Shoulder Const.Cost WageArea2.
	SCWA3		number(5, 3)				Yes		Shoulder Const.Cost WageArea3.
	SCWA4		number(5, 3)				Yes		Shoulder Const.Cost WageArea4.
	SCWA5		number(5, 3)				Yes		Shoulder Const.Cost WageArea5.
	SMWA1		number(5, 3)				Yes		Shoulder MaintPrep.Cost WageArea1.
	SMWA2		number(5, 3)				Yes		Shoulder MaintPrep.Cost WageArea2.
	SMWA3		number(5, 3)				Yes		Shoulder MaintPrep.Cost WageArea3.
	SMWA4		number(5, 3)				Yes		Shoulder MaintPrep.Cost WageArea4.
	SMWA5		number(5, 3)				Yes		Shoulder MaintPrep.Cost WageArea5.

Columns Detail



	Name		Value

	Name		SACTION
	Description		Action.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		3
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SGROUP
	Description		Shoulder Group: 1 = TURF 2 = ROCK 3 = SURFACED
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SCOSTYPE
	Description		Shoulder Cost Type.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SCWA1
	Description		Shoulder Const.Cost WageArea1.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SCWA2
	Description		Shoulder Const.Cost WageArea2.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SCWA3
	Description		Shoulder Const.Cost WageArea3.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SCWA4
	Description		Shoulder Const.Cost WageArea4.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SCWA5
	Description		Shoulder Const.Cost WageArea5.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SMWA1
	Description		Shoulder MaintPrep.Cost WageArea1.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SMWA2
	Description		Shoulder MaintPrep.Cost WageArea2.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SMWA3
	Description		Shoulder MaintPrep.Cost WageArea3.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SMWA4
	Description		Shoulder MaintPrep.Cost WageArea4.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SMWA5
	Description		Shoulder MaintPrep.Cost WageArea5.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

Appears In



	Diagram

	KDOT_RPMS_PMISschema : Entity Relationship Diagram

KDOT PMS Replacement Project