EODP_INT_LTSIMG (SQL View)	Index Back
Last Image for a record Internal Use only: List the last image in which a record was delivered

EODP_INT_LTSIMG

(SQL View)

Last Image for a record

Internal Use only: List the last image in which a record was delivered

SELECT A.OBJECTVALUE1 ,MAX(B.PTIASPSPVERS) FROM PS_PTIASPRPTHEAD B ,PS_PTIASPRPTMOL A WHERE A.PTIASPRPTNO=B.PTIASPRPTNO AND A.OBJECTTYPE=0 GROUP BY A.OBJECTVALUE1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN

2 PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
2	PTIASPSPVERS	Number(5,0)	INTEGER NOT NULL	Numeric value for Patch Database Version Number