RS_FR_SUP_HIST

(SQL Table)
Index Back

Supply Forecast History Table

ESA for IT: Supply Forecast History Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FORECAST_ID_SUP Character(15) VARCHAR2(15) NOT NULL Supply Forecast ID

Default Value: RS_FR_SUP_HDR.FORECAST_ID_SUP

2 SEQ_NUMBER Number(3,0) SMALLINT NOT NULL Expense Sequence Number

Default Value: 1

3 UPDATE_ACTION Character(1) VARCHAR2(1) NOT NULL Update Action Codes
A=Add
D=Delete
U=Update
4 SETID_ROLE Character(5) VARCHAR2(5) NOT NULL SetID Role is used in the resource profile to allow select a valid project role.
5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
6 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.
7 SETID_REGION Character(5) VARCHAR2(5) NOT NULL Region SetID
8 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.
9 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee
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 COMMENTS Long Character CLOB Comment
14 FROM_MONTH_SCP Character(2) VARCHAR2(2) NOT NULL SCP- From Month
1=01 - January
10=10 - October
11=11 - November
12=12 - December
2=02 - February
3=03 - March
4=04 - April
5=05 - May
6=06 - June
7=07 - July
8=08 - August
9=09 - September
15 FROM_YEAR Number(4,0) SMALLINT NOT NULL From Year
16 TO_MONTH_SCP Character(2) VARCHAR2(2) NOT NULL SCP- To Month
1=01 - January
10=10 - October
11=11 - November
12=12 - December
2=02 - February
3=03 - March
4=04 - April
5=05 - May
6=06 - June
7=07 - July
8=08 - August
9=09 - September
17 TO_YEAR Number(4,0) SMALLINT NOT NULL To Year
18 FROM_DATE Date(10) DATE From Date
19 TO_DATE Date(10) DATE To Date
20 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
21 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
22 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
23 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.