TL_DU_PT_SEQ_VW (SQL View)	Index Back
Duplicate Sequence Number

TL_DU_PT_SEQ_VW

(SQL View)

Duplicate Sequence Number

SELECT A.SEQ_NBR , COUNT(*) FROM PS_TL_PAYABLE_TIME A GROUP BY A.SEQ_NBR HAVING COUNT(*) > 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

2 COUNT_TOTAL Number(2,0) SMALLINT NOT NULL Award Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
2	COUNT_TOTAL	Number(2,0)	SMALLINT NOT NULL	Award Count