VRBT_CLAIM_WB_D(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: OPR_DEF_TBL_FS |
| 2 | WORKBENCH_ID |
Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |
| 3 | CLAIM_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Claim ID
Prompt Table: VRBT_CLAIM_HDR |
| 4 | CLAIM_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Claim Status Action
A=Approve C=Cancel D=Defer U=Return To Open |
| 5 | CLAIM_PROCESS_ACT | Character(1) | VARCHAR2(1) NOT NULL |
Claim Processing Action
1=Claim Settlement 2=Print for Dispatch 3=Payment Reconciliation 4=Overdue 5=Cancel Deduction |
| 6 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |