DP_INTUP_SEQ_VW (SQL View)	Index Back
Amend Stage, DP_SEQNUMBER Prompt Table for DP_SEQNUMBER, User Period.

DP_INTUP_SEQ_VW

(SQL View)

Amend Stage, DP_SEQNUMBER

Prompt Table for DP_SEQNUMBER, User Period.

SELECT DISTINCT DP_CONFIGVIEW ,DP_SEQNUMBER FROM PS_DP_INT_UPDATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

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_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW
2	DP_SEQNUMBER	Number(10,0)	DECIMAL(10) NOT NULL	MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.