RBT_ACCTCASE_VW

(SQL View)
 Index Back

View to display Bill Disputes

Vies to display Bill Disputes for a Account

SELECT A.RBTACCTID , B.CASE_ID , B.BUSINESS_UNIT , B.RBTDISPTYPE , B.RBTADJTYPE , B.RBTRESOURCETYPE , B.RBTDISPUTEAMT , B.RBTDISPREASON , B.RBTDISPSTATUS , B.DESCR254 , C.CREATION_DATE , C.CLOSED_DATE , C.DISP_TMPL_FAM_CD FROM PS_RBT_ACCOUNT A , PS_RC_CASE_DISPUTE B , PS_RC_CASE C WHERE A.RBTACCTID = C.RBTACCTID AND B.CASE_ID = C.CASE_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.CASE_TYPE = 'BDP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

Default Value: NEXT

2 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 RBTDISPTYPE Character(4) VARCHAR2(4) NOT NULL Dispute Type
ACBL=Balance Dispute
ACCT=Account
ACUS=Usage Dispute
EVNT=Bill Event
ITM=Bill Item
5 RBTADJTYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type
CRED=Credit
DEBT=Debit
6 RBTRESOURCETYPE Character(4) VARCHAR2(4) NOT NULL Resource Type
EUM=EUM
KW=Kw
KWH=Kwh
MINS=Minutes
THER=Therms
USD=Dollars
7 RBTDISPUTEAMT Number(9,2) DECIMAL(8,2) NOT NULL Dispute Amount
8 RBTDISPREASON Character(4) VARCHAR2(4) NOT NULL Dispute Reason
BR2=Incorrect Balance
DR1=Billing Error
RB3=Others
9 RBTDISPSTATUS Character(4) VARCHAR2(4) NOT NULL rbtdispstatus
APR=Approved
DEN=Denied
HLD=Hold
PEN=Pending
10 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
11 CREATION_DATE Date(10) DATE Creation date of the case.
12 CLOSED_DATE Date(10) DATE Date Closed
13 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code