ID

INTEGER

KEY

Unique (to the table) Numeric ID

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)

Specifies the name of the person who created this record. Should be in form: LastName, FirstName

creation_date

INTEGER

Indicates the timestamp indicating when this record was created

last_update_user

nvarchar(64)

Specifies the contact who last modified this record. Should be in form: LastName, FirstName

last_update_date

INTEGER

Indicates the timestamp of when this record was last modified

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)

Populates from the resource file.

LAST_MOD_DT_ TEXT

nvarchar(50)

Specifies the KRC calculation date.

DOCUMENTS_ PUBLISHED_ PERCENT

nvarchar(4)

AVG_HITS

nvarchar(20)

AVG_RATING_ TEXT

nvarchar(100)

last_mod_by

SREL

cnt

last_mod_dt

DATE