RS_SUP_CACH_TAO

(SQL Table)
 Index Back

Supply Cache table

ESA For IT: Supply Cache table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SESSION_ID Number(6,0) INTEGER NOT NULL Session ID
2 PC_CPY_UNIQUEID Character(15) VARCHAR2(15) NOT NULL Copy Unique ID
3 FORECAST_ID_SUP Character(15) VARCHAR2(15) NOT NULL Supply Forecast ID
4 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.
5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
6 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
7 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee
8 DATE_ENTERED Date(10) DATE NOT NULL Date
9 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
10 CAPACITY Signed Number(14,2) DECIMAL(12,2) NOT NULL SCP- Forecasted Supply stored as capacity.
11 UOM_SCP Character(1) VARCHAR2(1) NOT NULL SCP - Demand Setup UOM
1=Days
2=Hours
12 FULL_TIME_RES_SUP Signed Number(14,2) DECIMAL(12,2) NOT NULL Full Time Resources
13 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
14 SETID_REGION Character(5) VARCHAR2(5) NOT NULL Region SetID
15 SETID_ROLE Character(5) VARCHAR2(5) NOT NULL SetID Role is used in the resource profile to allow select a valid project role.
16 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
17 YEAR_NUM Number(4,0) SMALLINT NOT NULL Year in Number
18 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
19 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
20 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
21 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.