RPTDW_POOL Table

This section lists the database columns in the RPTDW_POOL table.

RPTDW_POOL Table

Database Column

Details

ID

Type: Decimal

POOL_NAME

Type: text. Unique.

INITIAL_VALUE

Type: Integer. Unique.

IS_PRODUCTION

Type: Boolean. Unique.

REMIXABLE_PERCENT

Type: Decimal. Unique.

REMIXES_PER_YEAR

Type: Integer. Unique.

NEXT_REMIX_DATE

Type: TimeStamp. Unique.

DISCOUNT_PERCENT

Type: Decimal. Unique.

UPLIFT_PERCENT

Type: Decimal. Unique.

ANNUAL_FEE_PERCENT

Type: Decimal. Unique.

SHAREABLE_TYPE

Type: Integer. Unique.

LICENSING_MODEL

Type: Integer. Unique.

GEOGRAPHY

Type: text. Unique.

SITE

Type: text. Unique.

NOTES

Type: text (max length 1000). Unique.

LAST_MODIFIED_TIME

Type: TimeStamp. Unique.

contract

Type: Decimal.

References Table: RPTDW_CONTRACT Table

orgUnit

Type: Decimal.

References Table: RPTDW_ORG_UNIT_NODE Table