RPT_DIM_TM_CHARGE_CODES_MV

This table stores the definition of each PPM charge code.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

CHARGE_CODE_ID

NOT NULL

NUMBER

ID derived from the PPM KTMG_CHARGE_CODES table.

CHARGE_CODE_NAME

NOT NULL

VARCHAR2(80)

Name of the charge code

DESCRIPTION

NOT NULL

VARCHAR2(240)

Description of the charge code

CHARGE_CODE_CATEGORY

NULLABLE

VARCHAR2(150)

Category of the charge code

DEPARTMENT

NULLABLE

VARCHAR2(150)

Department of the charge code

CLIENT

NULLABLE

VARCHAR2(150)

Client of the charge code

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the charge code is enabled.

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.