RBT_PER_CASE_VW(SQL View) |
Index Back |
|---|---|
My Cases ViewSELECT CAS.CASE_ID ,ACCT.RBTACCTNO ,CAS.RC_STATUS ,CAS.RC_SUMMARY ,CAS.BO_ID_CONTACT ,OPR.OPRID ,CAS.CASE_TYPE ,TCAS.RBTBILLID ,TCAS.DESCR100 ,TCAS.RBTDISPUTEAMT ,TCAS.RBTDISPSTATUS FROM PSOPRALIAS OPR ,PS_RD_PERSON PER ,PS_RC_CASE CAS ,PS_RBT_ACCOUNT ACCT ,PS_RCTCASE TCAS WHERE PER.PERSON_ID = OPR.PERSON_ID AND CAS.BO_ID_CONTACT=PER.BO_ID AND CAS.CASE_ID=TCAS.CASE_ID AND CAS.BUSINESS_UNIT=TCAS.BUSINESS_UNIT AND TCAS.RBTACCTID=ACCT.RBTACCTID AND EXISTS ( SELECT TCAS1.CASE_ID FROM PS_RCTCASE TCAS1 ,PS_RC_CASE CAS1 WHERE TCAS1.CASE_ID=CAS1.CASE_ID AND TCAS1.BUSINESS_UNIT=CAS1.BUSINESS_UNIT) UNION SELECT CAS3.CASE_ID ,' ' AS RBTACCTNO ,CAS3.RC_STATUS ,CAS3.RC_SUMMARY ,CAS3.BO_ID_CONTACT ,OPR3.OPRID ,CAS3.CASE_TYPE ,' ' AS RBTBILLID ,' ' AS DESCR100 ,0 AS RBTDISPUTEAMT ,' ' AS RBTDISPSTATUS FROM PSOPRALIAS OPR3 ,PS_RD_PERSON PER3 ,PS_RC_CASE CAS3 WHERE PER3.PERSON_ID = OPR3.PERSON_ID AND CAS3.BO_ID_CONTACT=PER3.BO_ID AND NOT EXISTS ( SELECT TCAS2.CASE_ID FROM PS_RCTCASE TCAS2 ,PS_RC_CASE CAS2 WHERE TCAS2.CASE_ID=CAS2.CASE_ID AND TCAS2.BUSINESS_UNIT=CAS2.BUSINESS_UNIT) |
| SELECT CAS.CASE_ID ,CAS.RBTACCTID ,CAS.RC_STATUS ,CAS.RC_SUMMARY ,CAS.BO_ID_CONTACT ,CAS.ROLE_TYPE_ID_CNTCT ,CAS.BO_ID_CUST ,CAS.ROLE_TYPE_ID_CUST ,CAS.CASE_TYPE ,TCAS.RBTBILLID ,TCAS.RBTDISPUTEAMT ,TCAS.RBTDISPSTATUS ,TCAS.DESCR254 ,CAS.BUSINESS_UNIT FROM PS_RC_CASE CAS , PS_RC_CASE_DISPUTE TCAS WHERE CAS.CASE_ID=TCAS.CASE_ID(+) AND CAS.BUSINESS_UNIT=TCAS.BUSINESS_UNIT(+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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.
Default Value: 999999999999999 |
| 2 | RBTACCTID | Character(15) | VARCHAR2(15) NOT NULL |
Unique service account indentifier
Prompt Table: RCT_ACCOUNT_VW |
| 3 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL |
Case Status
Default Value: BUS_UNIT_DEF_VW.RC_STATUS Prompt Table: RC_STATUS_TBL |
| 4 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 5 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
Prompt Table: BO |
| 6 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 7 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
Prompt Table: BO |
| 8 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 9 | CASE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Case Type
Default Value: BUS_UNIT_DEF_VW.CASE_TYPE Prompt Table: RC_CASETYPE_TBL |
| 10 | RBTBILLID | Character(15) | VARCHAR2(15) NOT NULL | Bill Id |
| 11 | RBTDISPUTEAMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Dispute Amount |
| 12 | RBTDISPSTATUS | Character(4) | VARCHAR2(4) NOT NULL |
rbtdispstatus
APR=Approved DEN=Denied HLD=Hold PEN=Pending |
| 13 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 14 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |