KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - TAMP2022_SCHACTS 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
LRS_TENTH varchar2(16) Yes
SCHACT2022 number(0) Yes
SCHACT2023 number(0) Yes
SCHACT2024 number(0) Yes
SCHACT2025 number(0) Yes
SCHACT2026 number(0) Yes

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

Name Value
Name SCHACT2022
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 SCHACT2023
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 SCHACT2024
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 SCHACT2025
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 SCHACT2026
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