上一主题: kdlinks 对象下一主题: ktd 对象


KT_REPORT_CARD 对象

对象详细信息如下:

关联的表:KT_REPORT_CARD

工厂:default

REL_ATTR: id

公用名称:SUBJECT_ID

功能组:reference

REST 操作:CREATE READ UPDATE

属性

数据库字段

数据类型

SREL 引用

标志

id

ID

INTEGER

 

KEY

SUBJECT_ID

SUBJECT_ID

nvarchar(40)

 

 

PAST_DAYS

PAST_DAYS

INTEGER

 

 

ORG_STATISTICS

ORG_STATISTICS

INTEGER

 

 

DOCUMENTS_ SUBMITTED

DOCUMENTS_ SUBMITTED

INTEGER

 

 

DOCUMENTS_ PUBLISHED

DOCUMENTS_ PUBLISHED

INTEGER

 

 

TOTAL_HITS

TOTAL_HITS

INTEGER

 

 

AVERAGE_ EFFECTIVENESS_ RATING

AVERAGE_ EFFECTIVENESS_ RATING

INTEGER

 

 

TOTAL_ SOLUTION_ COUNT

TOTAL_ SOLUTION_ COUNT

INTEGER

 

 

creation_user

creation_user

nvarchar(64)

 

 

creation_date

creation_date

INTEGER

 

 

last_update_user

last_update_user

nvarchar(64)

 

 

last_update_date

last_update_date

INTEGER

 

 

TOTAL_VOTES

TOTAL_VOTES

INTEGER

 

 

AVG_RATING

AVG_RATING

DOUBLE

 

 

USER_SLV_CNT

USER_SLV_CNT

INTEGER

 

 

LINKED_ KNOWLEDGE_BY_OTHERS

LINKED_ KNOWLEDGE_BY_OTHERS

INTEGER

 

 

LINKED_ KNOWLEGE_BY_ ME

LINKED_ KNOWLEGE_BY_ ME

INTEGER

 

 

CLOSED_TICKETS

CLOSED_TICKETS

INTEGER

 

 

TICKETS_WITH_ KNOWLEDGE

TICKETS_WITH_ KNOWLEDGE

INTEGER

 

 

TICKETS_HAD_ SEARCH_ ACTIVITIES

TICKETS_HAD_ SEARCH_ ACTIVITIES

INTEGER

 

 

KNOWLEDGE_ SUBMIT_FROM_ TICKET

KNOWLEDGE_ SUBMIT_FROM_ TICKET

INTEGER

 

 

TIME_TO_PUBLISH

TIME_TO_PUBLISH

INTEGER

 

 

MY_COMMENTS

MY_COMMENTS

INTEGER

 

 

DOCUMENTS_ RETIRED

DOCUMENTS_ RETIRED

INTEGER

 

 

TIME_TO_FIX

TIME_TO_FIX

INTEGER

 

 

FLAGS_FIXED

FLAGS_FIXED

INTEGER

 

 

COMMENTS_ON_MY_DOCUMENTS

COMMENTS_ON_MY_DOCUMENTS

INTEGER

 

 

FIRST_CALL_RES_ WITH_KNOW

FIRST_CALL_RES_ WITH_KNOW

INTEGER

 

 

FIRST_CALL_RES_ WITHOUT_KNOW

FIRST_CALL_RES_WITHOUT_KNOW

INTEGER

 

 

CONTRIBUTOR_ UUID

CONTRIBUTOR_ UUID

SREL

cnt

TENANCY_ UNRESTRICTED

IS_SUPERVISOR

IS_SUPERVISOR

INTEGER

 

 

SUPERVISOR_ID

SUPERVISOR_ID

SREL

cnt

TENANCY_ UNRESTRICTED

MY_ORG_REF_ID

MY_ORG_REF_ID

SREL

KT_REPORT_CARD

 

PAST_DAYS_TEXT

PAST_DAYS_TEXT

nvarchar(20)

 

从资源文件填充。

LAST_MOD_DT_ TEXT

LAST_MOD_DT_ TEXT

nvarchar(20)

 

指定 KRC 计算日期。

DOCUMENTS_ PUBLISHED_ PERCENT

DOCUMENTS_ PUBLISHED_ PERCENT

nvarchar(4)

 

 

AVG_HITS

AVG_HITS

nvarchar(20)

 

 

AVG_RATING_ TEXT

AVG_RATING_ TEXT

nvarchar(100)

 

 

last_mod_dt

last_mod_dt

DATE

 

 

last_mod_by

last_mod_by

SREL

cnt