PeopleSoft 9
Asset Management

Table Name ASSET_INSRNCE_H

Table Description
ASSET_INSRNCE_H
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
POLICY_ID char(50) Yes No
INSURANCE_VNDR char(10) Yes No
BUSINESS_UNIT_AM char(5) No No
INSURANCE_TYPE char(30) No Yes
Index
Name Type Unique Member
PS_ASSET_INSRNCE_H PK Yes
PS0ASSET_INSRNCE_H IE1 No
Member(s) of "PS_ASSET_INSRNCE_H" Index
BUSINESS_UNIT
ASSET_ID
POLICY_ID
INSURANCE_VNDR
Member(s) of "PS0ASSET_INSRNCE_H" Index
INSURANCE_TYPE
BUSINESS_UNIT
ASSET_ID
POLICY_ID
INSURANCE_VNDR

Published December 16, 2006