PC_AM_FLTR (SQL Table)	Index Back
PC Express Asset Filter Record used to store the express asset filter criteria header information, including the sql statement built by the filter criteria.

PC_AM_FLTR

(SQL Table)

PC Express Asset Filter

Record used to store the express asset filter criteria header information, including the sql statement built by the filter criteria.

Related Language Record: PC_AM_FLTR_LNG

Parent Record Of PC_AM_FLTR_FNAM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW

2 FILTER_ID Character(10) VARCHAR2(10) NOT NULL Filter criteria identification

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 FILTER_DTTM DateTime(26) TIMESTAMP Filter date time stamp

5 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
2	FILTER_ID	Character(10)	VARCHAR2(10) NOT NULL	Filter criteria identification
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	FILTER_DTTM	DateTime(26)	TIMESTAMP	Filter date time stamp
5	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause