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 |