ID

INTEGER

KEY

ID numerico univoco della tabella.

SUBJECT_ID

nvarchar(64)

PAST_DAYS

INTEGER

ORG_STATISTICS

INTEGER

DOCUMENTS_ SUBMITTED

INTEGER

DOCUMENTS_ PUBLISHED

INTEGER

TOTAL_HITS

INTEGER

AVERAGE_ EFFECTIVENESS_ RATING

INTEGER

TOTAL_SOLUTION_ COUNT

INTEGER

USER_SLV_CNT

INTEGER

TOTAL_VOTES

INTEGER

AVG_RATING

REAL

LINKED_ KNOWLEDGE_BY_ OTHERS

INTEGER

LINKED_ KNOWLEDGE_BY_ME

INTEGER

CLOSED_TICKETS

INTEGER

TICKETS_WITH KNOWLEDGE

INTEGER

TICKETS_HAD_ SEARCH_ ACTIVITES

INTEGER

KNOWLEDGE_ SUBMIT_FROM_ TICKET

INTEGER

TIME_TO_PUBLISH

INTEGER

MY_COMMENTS

INTEGER

DOCUMENTS_ RETIRED

INTEGER

TIME_TO_FIX

INTEGER

FLAGS_FIXED

INTEGER

COMMENTS_ON_ MY_DOCUMENTS

INTEGER

FIRST_CALL_RES_ WITH_KNOW

INTEGER

FIRST_CALL_RES_ WITHOUT_KNOW

INTEGER

creation_user

nvarchar(64)

Specifica il nome della persona che ha creato il record. Il formato deve essere: LastName, FirstName.

creation_date

INTEGER

Indica la data e l'ora di creazione del record.

last_update_user

nvarchar(64)

Specifica il contatto che ha modificato per ultimo questo record. Il formato deve essere: LastName, FirstName.

last_update_date

INTEGER

Indica la data/ora di sistema dell'ultima modifica del record corrente.

CONTRIBUTOR_ UUID

SREL

cnt

TENANCY_ UNRESTRICTED

IS_SUPERVISOR

INTEGER

SUPERVISOR_ UUID

SREL

cnt

TENANCY_ UNRESTRICTED

MY_ORG_REF_ID

SREL

KT_REPORT_ CARD

ALL_ORG_REF_ID

SREL

KT_REPORT_ CARD

PAST_DAYS_TEXT

nvarchar(20)

Viene popolato dal file di risorse.

LAST_MOD_DT_ TEXT

nvarchar(50)

Specifica la data del calcolo KRC.

DOCUMENTS_ PUBLISHED_ PERCENT

nvarchar(4)

AVG_HITS

nvarchar(20)

AVG_RATING_ TEXT

nvarchar(100)

last_mod_by

SREL

cnt

last_mod_dt

DATE