SM_RFC

This table contains information about RFC entities. RFC entities are created by integration between PPM and Service Manager (SM-RFC).

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_ENTITIES_NLS

ENTITY_ID

PARENT_ENTITY_ID

Column Descriptions

Column Name

Null?

Data Type

Description

RFC_ID

NOT NULL

NUMBER

System-generated identifier

REMOTE_RFC_ID

NULLABLE

VARCHAR2(255)

RFC ID in Service Manager

RFC_STATUS

NULLABLE

VARCHAR2(255)

RFC Status

RFC_CLOSURE_CODE

NULLABLE

VARCHAR2(255)

RFC Closure code (from SM)

RFC_CLOSURE_MEANING

NULLABLE

VARCHAR2(255)

RFC Closure meaning (from SM)

CREATION_DATE

NULLABLE

DATE

Date record was created

CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NULLABLE

DATE

Date record was last updated

LAST_UPDATED_BY

NULLABLE

NUMBER

Identifier for the user who last updated the record

RFC_LAST_UPDATED_DATE

NULLABLE

DATE

Time RFC was updated in Service Manager

RFC_LAST_UPDATED_BY

NULLABLE

VARCHAR2(255)

Identifier for the user who last updated the record in SM

PARENT_ENTITY_ID

NOT NULL

NUMBER

Entity ID of the PPM entity that contains this RFC (for example, task)

PARENT_PRIMARY_KEY

NOT NULL

NUMBER

Identifier for the entity that contains this RFC

SERVICE_STATUS_CODE

NULLABLE

NUMBER

Code representation of last service update status

SERVICE_MESSAGE

NULLABLE

VARCHAR2(2000)

Success or Error message describing the service update status

VERSION

NULLABLE

NUMBER

RFC version

Indexes

Index Name

Index Type

Sequence

Column Name

SM_RFC_U1

UNIQUE

1

PARENT_ENTITY_ID

SM_RFC_U1

UNIQUE

2

PARENT_PRIMARY_KEY

SYS_C005201875

UNIQUE

1

RFC_ID

Sequences

Sequence Name

Sequence Type

SM_RFC_S

RFC_ID