RS_SNR_DTL_TMP

(SQL Table)
 Index Back

Commitment line detail Table

SCP - Has the Commitment action, effort, allocated demand information for each demand, month wise .Used in Consolidated Scenario Analysis ACE Page

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCENARIO_ID2 Character(15) VARCHAR2(15) NOT NULL SCP-Combined Scenario ID
2 FORECAST_ID_DMD Character(15) VARCHAR2(15) NOT NULL Demand Forecast ID
3 DEMAND_ID Character(15) VARCHAR2(15) NOT NULL Demand ID
4 SETID_ROLE Character(5) VARCHAR2(5) NOT NULL SetID Role is used in the resource profile to allow select a valid project role.

Prompt Table: SP_SETID_NONVW

5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
6 DATE_ENTERED Date(10) DATE Date
7 COMMITMENT_ACTION Character(1) VARCHAR2(1) NOT NULL SCP- Commitment Action for each Demand in Commitment Line Page of Consolidated Scenario
1=Commit
2=Defer
8 RANK Number(3,0) SMALLINT NOT NULL Priority Ranking
9 PRIORITY_DMD Character(1) VARCHAR2(1) NOT NULL Priority
1=1 - Critical
2=2 - High
3=3 - Medium
4=4 - Low
10 ALLOCATED_DEMAND Number(13,2) DECIMAL(12,2) NOT NULL SCP-Allocated Demand .
11 EFFORT Number(13,2) DECIMAL(12,2) NOT NULL Effort
12 ALERT Character(1) VARCHAR2(1) NOT NULL SCP - To indicate negative Variance.

Y/N Table Edit

13 VARIANCE_SCP Signed Number(14,2) DECIMAL(12,2) NOT NULL SCP-Difference in Capacity
14 MONTH_SCP Character(2) VARCHAR2(2) NOT NULL SCP- Month
1=January
10=October
11=November
12=December
2=February
3=March
4=April
5=May
6=June
7=July
8=August
9=September
15 YEAR_NUM Number(4,0) SMALLINT NOT NULL Year in Number
16 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
17 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
18 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
19 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.