PL_ERRCNTDT_VW (SQL View)	Index Back
PL_ERRCNTDT_VW PL_ERRCNTDT_VW

PL_ERRCNTDT_VW

(SQL View)

PL_ERRCNTDT_VW

SELECT DISTINCT probinst , pl_record_dttm , version FROM PS_PL_ERROR_COUNTS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

2 PL_RECORD_DTTM_SVD DateTime(26) TIMESTAMP a record timestamp used by PL_RECORD_COUNTS

3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	PL_RECORD_DTTM_SVD	DateTime(26)	TIMESTAMP	a record timestamp used by PL_RECORD_COUNTS
3	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference