with Name

KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

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

	PROJ_PROJECT_NUM		char(4)				Yes
	PROJ_HOST_NUM		char(4)				Yes
	PROJ_AGY_PROJ_NUM		varchar2(10)				Yes
	COPJ_BEG_REF_POST		number(7, 3)				Yes
	COPJ_END_REF_POST		number(7, 3)				Yes
	PROJ_WORK_TYPE_CD		char(5)				Yes
	PACT_ACT_STRT_DATE		number(8)				Yes
	PROJ_PRIM_CNTY_NUM		char(3)				Yes
	PROJ_PRIM_ROUTE_ID		char(5)				Yes
	PROJ_SCOPE_DESC		char(55)				Yes
	PROJ_LOC_DESC		char(55)				Yes
	PROJ_KDOT_JUR		char(2)				Yes
	PROJ_STATUS		char(5)				Yes
	PROJ_PROG_CATEGORY		char(2)				Yes
	PROJ_PROJECT_CODE		char(1)				Yes

Columns Detail



	Name		Value

	Name		PROJ_PROJECT_NUM
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		4
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_HOST_NUM
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		4
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_AGY_PROJ_NUM
	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		COPJ_BEG_REF_POST
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		7
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		COPJ_END_REF_POST
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		7
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_WORK_TYPE_CD
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		5
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

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



	Name		Value

	Name		PROJ_PRIM_CNTY_NUM
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		3
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_PRIM_ROUTE_ID
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		5
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_SCOPE_DESC
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		55
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_LOC_DESC
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		55
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_KDOT_JUR
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		2
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_STATUS
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		5
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_PROG_CATEGORY
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		2
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PROJ_PROJECT_CODE
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

KDOT PMS Replacement Project