!!!Alias: DED
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Date sensitive details about an entity.

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[DEN_ID]|Number(10)|[ID]|Y|link to [P2K_CM_ENTITIES]
|[DLN_ID]|Number(10)|[ID]|Y|link to [P2K_CM_LOCATIONS]
|[DIN_ID]|Number(10)|[ID]| |link to [P2K_CM_INDUSTRIES]
|[DCR_ID]|Number(10)|[ID]| |link to [P2K_CM_CHANGE_REASONS]
|[EFFECTIVE]|Date()|[EFFECTIVE]|Y|
|[EXPIRY]|Date()|[EXPIRY]|Y|
|[ENTITY_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[LEGISLATION]|Varchar2(2)|[X_LEGISLATION]|Y|
|[LANGUAGE_CODE]|Varchar2(3)|[X_LANGUAGE_CODE]|Y|
|[CURRENCY]|Varchar2(2)|[X_CURRENCY]|Y|
|[DUNS_NUMBER]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |no longer in the IDEN function
|[WEB_ADDRESS]|Varchar2(200)|[URL]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[ACTUAL_PERFORMANCE|PERFORMANCE_THRESHOLDS (CUSTOM NCRA)]|NUMBER(18,0)| [AMT12V6|AMTnn]| |
|[MAXIMUM_PERFORMANCE]|NUMBER(18,0)| [AMT12V6|AMTnn]| |
|[TARGET_PERFORMANCE]|NUMBER(18,0)| [AMT12V6|AMTnn]| |
|[THRESHOLD_PERFORMANCE]|NUMBER(18,0)| [AMT12V6|AMTnn]| |
|[INCENTIVE_WEIGHT]|NUMBER(5,0)| [NUMBER5]| |


User Fields: Allowed\\
Audit Logging: Allowed\\


----
![Notes|Edit:Internal.P2K_CM_ENTITY_DETAILS] 	
[{InsertPage page='Internal.P2K_CM_ENTITY_DETAILS' default='Click to create a new notes page'}]