RBI_COVERAGE_VW(SQL View) |
Index Back |
|---|---|
Insurance CoverageInsurance Coverage |
| SELECT FIN_ACCOUNT_ID , POLICY_TYPE , COVERAGE_ID , COVERAGE_CD , ITERATION_NUMBER , COVERAGE_DESC , CURR_TERM_AMOUNT , CURRENCY_CD , START_DATE , END_DATE , RATE , PREMIUM_BASIS_CD , TERRITORY_CD FROM PS_RBI_COVERAGE 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 | COVERAGE_CD | Character(5) | VARCHAR2(5) NOT NULL | coverage code |
| 5 | ITERATION_NUMBER | Number(3,0) | SMALLINT NOT NULL | iteration no |
| 6 | COVERAGE_DESC | Character(254) | VARCHAR2(254) NOT NULL | coverage description |
| 7 | CURR_TERM_AMOUNT | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Current Term Amount |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL |
| 9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 10 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 11 | RATE | Number(8,5) | DECIMAL(7,5) NOT NULL | Rate |
| 12 | PREMIUM_BASIS_CD | Character(18) | VARCHAR2(18) NOT NULL | Premium Basis Code |
| 13 | TERRITORY_CD | Character(4) | VARCHAR2(4) NOT NULL | Territory Code |