KCRT_FG_PROG_REFERENCE_INT
The KCRT_FG_PROG_REFERENCE_INT interface table stores validation information, for each request, that is related to the Program Reference on Request field group.
Column |
Usage |
Data Type |
Description |
---|---|---|---|
GROUP_ID |
I |
NUMBER |
Groups all the records that should be processed at the same time. Use only one GROUP_ID for each batch of imported users when running the User Open Interface report. Derived from the KNTA_INTERFACE_GROUPS_S sequence. This value should be the same as the parent's GROUP_ID in KCRT_REQUEST_INT. |
TRANSACTION_ID |
I |
NUMBER |
Uniquely identifies each transaction. |
PARENT_TRANSACTION_ID |
I |
NUMBER |
Provides the transaction ID (from KCRT_REQUESTS_INT) of the parent table being imported. |
REQUEST_ID |
I/O |
NUMBER |
Identifies the request. This is normally left blank and is derived from the KCRT_REQUESTS_S sequence. |
REQUEST_TYPE_ID |
I/O |
NUMBER |
Identifies the request type. This is normally left blank and is derived from REQUEST_TYPE_NAME. |
REF_PROGRAM_ID |
I |
VARCHAR2 |
Creates a reference to the specified program ID. |
REF_PROGRAM_NAME |
I |
VARCHAR2 |
Creates a reference to the specified program name. |