RS_SNR_SMRY_TMP

(SQL Table)
Index Back

Scenario Summary Table

SCP - Used to update Supply and Demand Comparison Grid of Consolidated Scenario, Scenario Summary Page

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CATEGORY_DESCR Character(60) VARCHAR2(60) NOT NULL Category Description
2 ESTIMATED_COST_TXT Signed Number(28,3) DECIMAL(26,3) NOT NULL SCP - Displays the formatted amount value in Scenario Summary Page
3 DIFFDAYS1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Used by AE (TR_EUROF) which recalculates fee positions after EURO conversion. It is the difference between FEE_END and FEE_START SCP - Modified to add a new label.Used in Scenario Summary Page
4 DIFFDAYS2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Used by AE (TR_EUROF) which recalculates fee positions after EURO conversion. It is the difference between FEE_END and VALUE_DT SCP - Modified to add a new label.Used in Scenario Summary page
5 OVERALLOCATED Number(4,0) SMALLINT NOT NULL SCP-Overallocated Roles