BUSINESS_UNIT_RCCA_CASE_IDCA_TXN_CRM_2_VW(SQL View) |
Index Back |
|---|---|
View upon CA_TXN_CRMView upon CA_TXN_CRM - for case id |
| SELECT CRM.BUSINESS_UNIT_RF ,%NumToChar(CRM.CASE_ID) FROM PS_CA_TXN_CRM CRM , PS_CA_TXN_TBL TXN , PS_CA_CONTR_HDR HDR WHERE CRM.CA_TXN_ID = TXN.CA_TXN_ID AND HDR.CONTRACT_NUM = TXN.CONTRACT_NUM AND CRM.CASE_ID <> 0 AND HDR.CA_RQST_SRC <> 'OND' GROUP BY CRM.BUSINESS_UNIT_RF, CRM.CASE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RC |
Character(5) | VARCHAR2(5) NOT NULL | Call Center Business Unit |
| 2 | CA_CASE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Case Id |