Share this page
RPT_DIM_PROGRAM_CONTENT_MV
This is a materialized view on top of PPM's PGM_PROGRAM_CONTENT table.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
PROGRAM_ID |
NOT NULL |
NUMBER |
ID of a program derived from PGM_PROGRAM_CONTENT table. |
|
LIFECYCLE_ID |
NOT NULL |
NUMBER |
Identifier for the parent of the financial summary.Based on PARENT_ENTITY_ID, the PARENT_ID could be LIFECYCLE_ID in PFM_LIFECYCLE_PARENT_ENTITY, ORG_UNIT_ID in KRSC_ORG_UNITS_NLS, PROGRAM_ID in PGM_PROGRAMS or REQUEST_ID in KCRT_REQUESTS |
|
ACTIVE_REQ_ID |
NULLABLE |
NUMBER |
Identifier of the active request Id |
|
ACTIVE_ENTITY |
NOT NULL |
VARCHAR2(20) |
Active entity name of the program |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.
