BUSINESS_UNIT_GLB=Biweekly
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
Default Value: 7
BU_OPT_FC_VW(SQL View) |
Index Back |
|---|---|
Forecasting Business UnitsForecasting Business Unit Setup for Forecasting |
| SELECT %Substring(S.SETCNTRLVALUE,1,5) , F.FORECAST_FREQUENCY , F.FORECAST_HORIZON , F.END_DAY_OF_PERIOD FROM PS_SET_CNTRL_REC S , PS_BUS_UNIT_OPT_FC F WHERE S.SETID = F.SETID AND S.RECNAME = 'BUS_UNIT_OPT_FC' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | FORECAST_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Forecast Frequency
B=Biweekly M=Monthly Q=Quarterly S=Semimonthly W=Weekly |
| 3 | FORECAST_HORIZON | Number(3,0) | SMALLINT NOT NULL | Forecast Horizon |
| 4 | END_DAY_OF_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Ending Day of Period
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday Default Value: 7 |