RS_SNR_COM_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 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 SCENARIO_ID2 Character(15) VARCHAR2(15) NOT NULL SCP-Combined Scenario ID
3 FORECAST_ID_DMD Character(15) VARCHAR2(15) NOT NULL Demand Forecast ID
4 DEMAND_ID Character(15) VARCHAR2(15) NOT NULL Demand ID
5 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

6 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
7 DATE_ENTERED Date(10) DATE NOT NULL Date
8 COMMIT_ACTN_STRNG Character(10) VARCHAR2(10) NOT NULL Commitment Line
9 RANK Number(3,0) SMALLINT NOT NULL Priority Ranking
10 PRIORITY_DMD_STRNG Character(10) VARCHAR2(10) NOT NULL Demand Priority
11 ALLOCATED_DEMAND Number(13,2) DECIMAL(12,2) NOT NULL SCP-Allocated Demand .
12 EFFORT Number(13,2) DECIMAL(12,2) NOT NULL Effort
13 ALERT Character(1) VARCHAR2(1) NOT NULL SCP - To indicate negative Variance.
14 VARIANCE_SCP Signed Number(14,2) DECIMAL(12,2) NOT NULL SCP-Difference in Capacity
15 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
16 YEAR_NUM Number(4,0) SMALLINT NOT NULL Year in Number
17 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
18 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
19 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
20 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.