REV_EST_OPT_VW (SQL View)	Index Back
Revenue Estimate Options View to use as prompt table to select CC_REV_BUCKET

REV_EST_OPT_VW

(SQL View)

Revenue Estimate Options

View to use as prompt table to select CC_REV_BUCKET

SELECT A.ENTRY_USE_ID , B.CC_REV_BUCKET , C.XLATSHORTNAME FROM PS_ENTRY_USE_TBL A , PS_REV_EST_OPT_TBL B , PSXLATITEM C WHERE A.CC_REV_BUCKET_FLG = B.CC_REV_BUCKET_FLG AND B.CC_REV_BUCKET = C.FIELDVALUE AND C.FIELDNAME = 'CC_REV_BUCKET' AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSXLATITEM D WHERE D.FIELDNAME = C.FIELDNAME AND D.FIELDVALUE = C.FIELDVALUE AND D.EFFDT <= %CurrentDateIn)

Related Language Record: REV_EST_OPT_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.

2 CC_REV_BUCKET Character(1) VARCHAR2(1) NOT NULL Inidcate which revenue bucket to update.
B=Both
C=Collected
N=None
R=Recognized

3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
2	CC_REV_BUCKET	Character(1)	VARCHAR2(1) NOT NULL	Inidcate which revenue bucket to update. B=Both C=Collected N=None R=Recognized
3	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name