KTMG_POLICY_CHARGE_CODES

This table stores the information that defines the charge codes that are associated with a time sheet policy. Any time sheet using this policy will have its items defaulted to use these charge codes.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KTMG_POLICIES

POLICY_ID

POLICY_ID

KTMG_CHARGE_CODES_NLS

CHARGE_CODE_ID

CHARGE_CODE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

POLICY_CHARGE_CODE_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

POLICY_ID

NOT NULL

NUMBER

Foreign key to KTMG_POLICIES table

CHARGE_CODE_ID

NOT NULL

NUMBER

Foreign key to KTMG_CHARGE_CODES table

CHARGE_PERCENT

NOT NULL

NUMBER

Percent of the users time that can be charged with this code

Indexes

Index Name

Index Type

Sequence

Column Name

KTMG_POLICY_CHARGE_CODES_U1

UNIQUE

1

POLICY_CHARGE_CODE_ID

KTMG_POLICY_CHARGE_CODES_U2

UNIQUE

1

POLICY_ID

KTMG_POLICY_CHARGE_CODES_U2

UNIQUE

2

CHARGE_CODE_ID

Sequences

Sequence Name

Sequence Type

KTMG_POLICY_CHARGE_CODES_S

POLICY_CHARGE_CODE_ID