DP_INTIP_SEQ_VW (SQL View)	Index Back
Amend Stage, Sequence ID Prompt Table for Sequence ID.

DP_INTIP_SEQ_VW

(SQL View)

Amend Stage, Sequence ID

Prompt Table for Sequence ID.

SELECT DISTINCT DP_POLICYSET ,DP_SEQNUMBER FROM PS_DP_INT_IPMST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET

2 DP_SEQNUMBER Number(10,0) DECIMAL(10) NOT NULL MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DP_POLICYSET	Character(10)	VARCHAR2(10) NOT NULL	DP_POLICYSET
2	DP_SEQNUMBER	Number(10,0)	DECIMAL(10) NOT NULL	MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.