FM_BE_ROLLUP_PERIOD_SUM

This table stores monthly projected benefit rolled up to the financial summary.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

FM_ BENEFITS

BENEFIT_ID

BENEFIT_ID

KNTA_USERS

USER_ID

CREATED_BY

  KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

>

Column Name

Null?

Data Type

Description

ID

NOT NULL

NUMBER

System-generated identifier

PROJECTED_TOTAL

NULLABLE

NUMBER

Overall projected total in system base currency for the monthly period

FORECAST_ACTUAL_ID

NOT NULL

NUMBER

Period that this row refers to. Referenced by PPM_FISCAL_PERIODS

BENEFIT_ID

NOT NULL

NUMBER

System-generated identifier

PERIOD_IDNOT NULLNUMBERSystem-generated identifier

SEQ

NOT NULL

NUMBER

Period sequence, tied to the sequence in PPM_FISCAL_PERIODS.

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date when the record was created

LAST_UPDATE_DATE

NULLABLE

DATE

Date when the record was last updated

LAST_UPDATED_BY

NULLABLE

NUMBER

Identifier for the user who last updated the record

VERSION

NOT NULL

VERSION

System-generated version for the entity. This column must not be updated manually.

Indexes

Index Name

Index Type

Sequence

Column Name

FM_BE_ROLLUP_PERIOD_SUM_N1

NONUNIQUE

1

SEQ

FM_BE_ROLLUP_PERIOD_SUM_N2

NONUNIQUE

1

PERIOD_ID

FM_BE_ROLLUP_PERIOD_SUM_N3

NONUNIQUE

1

BENEFIT_ID

FM_BE_ROLLUP_PERIOD_SUM_PK

UNIQUE

1

ID

Sequences

Sequence Name

Sequence Type

FM_BE_ROLLUP_PERIOD_SUM_S

ID