RSF_FCAST_AB_VW (SQL View)	Index Back
Forecast Adjusted By Used to display the name of the Adjusted By person on a forecast.

RSF_FCAST_AB_VW

(SQL View)

Forecast Adjusted By

Used to display the name of the Adjusted By person on a forecast.

SELECT A.PERSON_ID , %Substring(B.BO_NAME_DISPLAY ,1 ,50) FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID_ADJUSTBY Character(15) VARCHAR2(15) NOT NULL Person id of person who adjusted a forecast.

2 ADJUSTBY_NAME Character(50) VARCHAR2(50) NOT NULL User who made forecast ajustment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID_ADJUSTBY	Character(15)	VARCHAR2(15) NOT NULL	Person id of person who adjusted a forecast.
2	ADJUSTBY_NAME	Character(50)	VARCHAR2(50) NOT NULL	User who made forecast ajustment