KCRT_FIELD_DEPENDENCIES
This table stores the field updateable and required attributes associated with the issue type status.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KNTA_PARAM_SET_FIELDS_NLS |
PARAMETER_SET_FIELD_ID |
PARAMETER_SET_FIELD_ID |
KCRT_REQUEST_TYPE_STATUSES |
REQUEST_TYPE_STATUS_ID |
REQUEST_TYPE_STATUS_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
FIELD_DEPENDENCY_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
CREATED_BY |
NOT NULL |
NUMBER |
User who created the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date the record was last updated |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
User who last updated the record |
REQUEST_TYPE_STATUS_ID |
NOT NULL |
NUMBER |
Request type status associated with this record |
PARAMETER_SET_FIELD_ID |
NOT NULL |
NUMBER |
Parameter field associated with this record |
HEADER_FIELD_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether this field is a header field |
REQUIRED_FIELD_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether this field is a required field |
DISABLED_FIELD_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether this field is available for use |
CLEAR_FIELD_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether this field is to be cleared |
RECONFIRM_FIELD_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether this field is to require reconfirmation. |
SOURCE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on) |
SOURCE |
NULLABLE |
VARCHAR2(100) |
For records that have been updated by an interface or migrator, provides additional information about the source of the external update. |
VISIBLE_FIELD_FLAG |
NOT NULL |
VARCHAR2(1) |
Flag that determines whether the field is visible to the end user |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_FIELD_DEPENDENCIES_N1 |
NONUNIQUE |
1 |
REQUEST_TYPE_STATUS_ID |
KCRT_FIELD_DEPENDENCIES_N1 |
NONUNIQUE |
2 |
PARAMETER_SET_FIELD_ID |
KCRT_FIELD_DEPENDENCIES_U1 |
UNIQUE |
1 |
FIELD_DEPENDENCY_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
KCRT_FIELD_DEPENDENCIES_S |
FIELD_DEPENDENCY_ID |