RBI_COVASSET_VW(SQL View) |
Index Back |
|---|---|
Covered Asset ViewCovered Asset View |
| SELECT A.FIN_ACCOUNT_ID , A.POLICY_TYPE , A.ASSET_ID , B.PROPERTY_NAME , B.VALUE_OF_PROPERTY , A.ASSET_TYPE , A.ASSET_DESCRIPTION FROM PS_RBI_COVER_ASSET A , PS_RBI_ASSET_PROP B WHERE A.FIN_ACCOUNT_ID = B.FIN_ACCOUNT_ID AND A.POLICY_TYPE = B.POLICY_TYPE AND A.ASSET_ID = B.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 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identifier used in Contracts Integration |
| 4 | PROPERTY_NAME | Character(80) | VARCHAR2(80) NOT NULL | Property Name |
| 5 | VALUE_OF_PROPERTY | Character(80) | VARCHAR2(80) NOT NULL | property Value |
| 6 | ASSET_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Asset Type
DRIV=Driver DWEL=Dwelling VEHI=Vehicle |
| 7 | ASSET_DESCRIPTION | Character(100) | VARCHAR2(100) NOT NULL | Asset Description |