AR_DISPUTE_VW (SQL View)	Index Back
Dispute Table EffDate From-To

AR_DISPUTE_VW

(SQL View)

Dispute Table EffDate From-To

SELECT SETID , DISPUTE_STATUS , EFFDT AS EFFDT_FROM , CASE WHEN LEAD(DISPUTE_STATUS , 1 ,NULL) OVER ( ORDER BY SETID , DISPUTE_STATUS , EFFDT) <> DISPUTE_STATUS THEN %DateIn('9999-12-31') ELSE CASE WHEN LEAD(EFFDT ,1 ,NULL) OVER ( ORDER BY SETID , DISPUTE_STATUS , EFFDT) = EFFDT THEN EFFDT ELSE LEAD(EFFDT-1 ,1 ,%DateIn('9999-12-31')) OVER ( ORDER BY SETID , DISPUTE_STATUS , EFFDT) END END AS EFFDT_TO , EFF_STATUS FROM PS_DISPUTE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 DISPUTE_STATUS Character(3) VARCHAR2(3) NOT NULL Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.

3 EFFDT_FROM Date(10) DATE Effective Date From

4 EFFDT_TO Date(10) DATE Effective Date To

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	DISPUTE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.
3	EFFDT_FROM	Date(10)	DATE	Effective Date From
4	EFFDT_TO	Date(10)	DATE	Effective Date To
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive