FIN_ACCOUNT_IDPROPERTY_NAMERBI_DRIVERS_VW(SQL View) |
Index Back |
|---|---|
View to get Drivers for InsuraView to get Drivers for Insurance |
| SELECT a.FIN_ACCOUNT_ID , a.PROPERTY_NAME , a.VALUE_OF_PROPERTY FROM PS_RBI_ASSET_PROP a , PS_RBI_COVER_ASSET b WHERE a.FIN_ACCOUNT_ID = b.FIN_ACCOUNT_ID AND a.ASSET_ID = b.ASSET_ID AND a.POLICY_TYPE= b.POLICY_TYPE AND a.PROPERTY_NAME = 'NAME' AND b.ASSET_TYPE= 'DRIV' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIN_ACCOUNT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 2 | PROPERTY_NAME |
Character(80) | VARCHAR2(80) NOT NULL | Property Name |
| 3 | VALUE_OF_PROPERTY | Character(80) | VARCHAR2(80) NOT NULL | property Value |