MBL_NOTICES_VW (SQL View)	Index Back
Expenses Notices View

MBL_NOTICES_VW

(SQL View)

Expenses Notices View

SELECT A.MBL_PRODUCT , A.SEQ_NBR , A.TITLE , A.START_DT , A.END_DT , A.MBL_PRIORITY_CD , A.DESCRLONG , B.NOTICE_IMAGE FROM PS_MBL_NOTICES A , PS_MBL_NOTICES_IMG B WHERE A.MBL_PRODUCT = B.MBL_PRODUCT AND A.SEQ_NBR = B.SEQ_NBR AND A.MBL_PRODUCT = 'FEX' AND A.START_DT <= %CurrentDateIn AND A.END_DT >= %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MBL_PRODUCT Character(4) VARCHAR2(4) NOT NULL Object owner identifier
DBI=Billing
DIN=Inventory
DOE=Order Entry
DOM=Order Management
DPO=Purchasing
DPV=eProcurement
DSP=Services Procurement
ETE=Time Entry
FAM=Asset Management
FAP=Payables
FAR=Receivables
FCA=Contracts
FEX=Expenses
FGL=General Ledger
FGM=Grants Management
FPC=Projects
FPG=Program Management
FRE=Real Estate Management
FRS=Resource Management
FTE=Travel
FTR=Treasury
FWO=Work Order Management
HHR=Human Resources
YSC=Supply Chain

2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
Default Value: 0

3 TITLE Character(35) VARCHAR2(35) NOT NULL Title

4 START_DT Date(10) DATE NOT NULL Start Date
Default Value: %Date

5 END_DT Date(10) DATE NOT NULL End Date

6 MBL_PRIORITY_CD Character(1) VARCHAR2(1) NOT NULL Priority
1=High
2=Medium
3=Low
Default Value: 2

7 DESCRLONG Long Character CLOB Long Description

8 NOTICE_IMAGE Image / Attachment(62) VARCHAR2(62) Image

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MBL_PRODUCT	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier DBI=Billing DIN=Inventory DOE=Order Entry DOM=Order Management DPO=Purchasing DPV=eProcurement DSP=Services Procurement ETE=Time Entry FAM=Asset Management FAP=Payables FAR=Receivables FCA=Contracts FEX=Expenses FGL=General Ledger FGM=Grants Management FPC=Projects FPG=Program Management FRE=Real Estate Management FRS=Resource Management FTE=Travel FTR=Treasury FWO=Work Order Management HHR=Human Resources YSC=Supply Chain
2	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number Default Value: 0
3	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
4	START_DT	Date(10)	DATE NOT NULL	Start Date Default Value: %Date
5	END_DT	Date(10)	DATE NOT NULL	End Date
6	MBL_PRIORITY_CD	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=High 2=Medium 3=Low Default Value: 2
7	DESCRLONG	Long Character	CLOB	Long Description
8	NOTICE_IMAGE	Image / Attachment(62)	VARCHAR2(62)	Image