The object details are as follows:
Associated Table: KT_REPORT_CARD
Factories: default
REL_ATTR: id
Common Name: SUBJECT_ID
Function Group: reference
REST Operations: CREATE READ UPDATE
|
Attribute |
DB Field |
Data Type |
SREL References |
Flags |
|---|---|---|---|---|
|
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) |
|
Populates from the resource file. |
|
LAST_MOD_DT_ TEXT |
LAST_MOD_DT_ TEXT |
nvarchar(20) |
|
Specifies the KRC calculation date. |
|
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 |
|
|
Copyright © 2013 CA.
All rights reserved.
|
|