KCRT_REQUEST_HEADER_TYPES
This table stores the request header types. Request types derive attributes from request header types associated with them. Typically header types contain common attributes that can be used by different request types.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KACC_ACCELERATORS_NLS |
ACCELERATOR_ID |
ACCELERATOR_ID |
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KNTA_PARAMETER_SET_CONTEXTS |
PARAMETER_SET_CONTEXT_ID |
USER_DATA_SET_CONTEXT_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
REQUEST_HEADER_TYPE_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
User who last updated the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
ENTITY_LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date a record in the entity was last updated |
REQUEST_HEADER_TYPE_NAME |
NOT NULL |
VARCHAR2(80) |
Name of the header type |
DESCRIPTION |
NULLABLE |
VARCHAR2(240) |
Description of the header type |
ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Flag to enable the header type |
ACCELERATOR_ID |
NULLABLE |
NUMBER |
Accelerator ID |
USER_DATA_SET_CONTEXT_ID |
NULLABLE |
NUMBER |
Parameter set context identifier for the user data fields |
USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
VISIBLE_USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
SOURCE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
Source type if added externally or through interface. |
SOURCE |
NULLABLE |
VARCHAR2(100) |
Source if added externally or through interface |
DEFINITION_LANGUAGE |
NOT NULL |
VARCHAR2(40) |
Definition language in which the record was created |
REFERENCE_CODE |
NOT NULL |
VARCHAR2(200) |
Reference code to uniquely identify this record |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_REQUEST_HEADER_TYPES_U1 |
UNIQUE |
1 |
REQUEST_HEADER_TYPE_ID |
KCRT_REQUEST_HEADER_TYPES_U2 |
UNIQUE |
1 |
REQUEST_HEADER_TYPE_NAME |
SYS_C005197093 |
UNIQUE |
1 |
REFERENCE_CODE |
Sequences
Sequence Name |
Sequence Type |
---|---|
KCRT_REQUEST_HEADER_TYPES_S |
REQUEST_HEADER_TYPE_ID |