HMCF_VALD_CHEVW (SQL View)	Index Back
HMCF VALID CACHE table This view is created based on the HMCF Valid Cache Table.

HMCF_VALD_CHEVW

(SQL View)

HMCF VALID CACHE table

This view is created based on the HMCF Valid Cache Table.

SELECT BUSINESS_UNIT_GL , FDM_HASH , TIME_STAMP FROM PS_HMCF_VALD_CACHE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit

2 FDM_HASH Character(31) VARCHAR2(31) NOT NULL Hash function

3 TIME_STAMP DateTime(26) TIMESTAMP Time Stamp

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
2	FDM_HASH	Character(31)	VARCHAR2(31) NOT NULL	Hash function
3	TIME_STAMP	DateTime(26)	TIMESTAMP	Time Stamp