Share this page
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_ID | NOT NULL | NUMBER | System-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 |
