RCFCASE_COMPLVW(SQL View) |
Index Back |
|---|---|
Issue search subrecordThis is a Claim information view used in Issue Case |
| SELECT A.SYNCID %Sql(RCFCASESRCH2SBR_FIN, B) FROM PS_RC_CASE A , PS_RC_CASE_COMPLNT B WHERE A.CASE_ID = B.CASE_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 2 | COMPL_CAUSE | Character(4) | VARCHAR2(4) NOT NULL |
Complete Clause
ADVS=Advise / Information ERRO=System Error INC1=Incorrect Handling - FSI INC2=Incorrect Handling - Other INC3=Incorrect Entry - FSI INC4=Incorrect Entry - Other MISC=Miscellaneous MIST=Mistake Made by Customer POLC=Organization / Bank Policy PROD=Product Characteristics RTNG=Rating / Costs / Circulation SERV=Service / Transaction by FSI |
| 3 | COMPL_CAUSE_ENTITY | Character(4) | VARCHAR2(4) NOT NULL |
Complete Clause entity
ADMN=Administration & Services CALL=Call Center HOFF=Head Office MISC=Miscellaneous NOCS=No Case OFFC=Office OPTN=Options Market REGN=Regional Department(s) STCK=Stock Exchange |
| 4 | CLAIM_DATE | Date(10) | DATE | Claim Date |
| 5 | CLAIM_DATE_TO | Date(10) | DATE | Claim Date |
| 6 | CLAIM_SUBMITTED_BY | Character(4) | VARCHAR2(4) NOT NULL |
Claim Submitted by
CLNT=Client OTHR=Other FSI THRD=Third Party |
| 7 | CLAIM_PAID_DATE | Date(10) | DATE | Claim Paid date |
| 8 | CLAIM_PAID_DATE_TO | Date(10) | DATE | Claim Paid Date |
| 9 | COMPL_CLOSE_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Complete Clause reason
ASS1=Assigned without Financial Fee ASS2=Assigned with Paid Claim DCL1=Declined DCL2=Declined - No Case DCL3=Declined - Withdrawn by Client |
| 10 | COMPL_RECEIVED_VIA | Character(4) | VARCHAR2(4) NOT NULL |
Compl recd via
BORD=The Board CALL=Call Center HOFF=Head Office INET=Internet OFFC=Office |