RBI_OPTION_VW(SQL View) |
Index Back |
|---|---|
Options for Insurance VWOptions for Insurance VW |
| SELECT FIN_ACCOUNT_ID , POLICY_TYPE , COVERAGE_ID , OPTION_ID , OPTION_TYPE_CD , OPTION_CD , VALUE_OF_OPTION , CURRENCY_CD FROM PS_RBI_OPTION WHERE ASSET_ID = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FIN_ACCOUNT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 2 | POLICY_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
policy type --------fsi
AUT=Auto Insurance BOA=Boat Insurance CRP=Crop Insurance EQK=Earthquake insurance FLD=Flood Insurance HLT=Health HOM=Homeowner's Insurance LIF=Life REN=Renter's Insurance TIT=Title Insurance |
| 3 | COVERAGE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Coverage ID |
| 4 | OPTION_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Option ID |
| 5 | OPTION_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Option Type
Prompt Table: RBI_XLAT_TBL |
| 6 | OPTION_CD | Character(4) | VARCHAR2(4) NOT NULL |
option code
Prompt Table: RBI_XLAT_TBL |
| 7 | VALUE_OF_OPTION | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | option value |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |