RBI_CASSET_VW(SQL View) |
Index Back |
---|---|
Covered Assets for InsuranceCovered assets for Insurance |
SELECT FIN_ACCOUNT_ID , POLICY_TYPE , ASSET_ID , ASSET_TYPE , ASSET_DESCRIPTION FROM PS_RBI_COVER_ASSET 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 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identifier used in Contracts Integration |
4 | ASSET_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Asset Type
DRIV=Driver DWEL=Dwelling VEHI=Vehicle Prompt Table: RBI_ASSET_TYPE |
5 | ASSET_DESCRIPTION | Character(100) | VARCHAR2(100) NOT NULL | Asset Description |