CLAIM_NUMBERPrompt Table: RBF_FIN_ACCOUNT
Prompt Table: RBI_CLAIM_STATS
RBI_CLAIM_HDR_S(SQL View) |
Index Back |
|---|---|
claim header infoThis is the serach record for claim header search component |
| SELECT CLAIM_NUMBER , A.FIN_ACCOUNT_ID , CUST_ACCT_NBR , CLAIM_STATUS , DESCR FROM PS_RBI_CLAIM_HDR A , PS_RBF_FIN_ACCOUNT F WHERE A.FIN_ACCOUNT_ID = F.FIN_ACCOUNT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CLAIM_NUMBER |
Character(15) | VARCHAR2(15) NOT NULL | Insurance Claim Number |
| 2 | FIN_ACCOUNT_ID | Character(20) | VARCHAR2(20) NOT NULL |
Financial Account Number
Prompt Table: RBF_FIN_ACCOUNT |
| 3 | CUST_ACCT_NBR | Character(20) | VARCHAR2(20) NOT NULL | This is the Customer defined Account Number for a financial account |
| 4 | CLAIM_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Categories for Case Status.
These drive processing.
Prompt Table: RBI_CLAIM_STATS |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |