PeopleSoft 9
Asset Management

Table Name ASSET_INSURANCE

Table Description
ASSET_INSURANCE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
POLICY_ID char(50) Yes Yes
INSURANCE_VNDR char(10) Yes Yes
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
DESCR char(30) No No
LONG_DESC char(50) No No
ISSUE_DT PSDATE No No
EXPIRE_DT PSDATE No No
INS_CALC_TYPE char(3) No No
POLICY_CD char(3) No No
INSURE_AMOUNT decimal(29,3) No No
APPRAISED_VAL decimal(29,3) No No
CURRENT_VAL decimal(29,3) No No
MIN_INSRD_VAL decimal(29,3) No No
ASSET_INDICTOR char(4) No No
OTHER_VAL decimal(29,3) No No
LAST_INDEX_DT PSDATE No No
LAST_UPDATE_DATE PSDATE No No
BUSINESS_UNIT_AM char(5) No No
LOCATION char(10) No No
PREMIUM_AMT decimal(29,3) No No
PREMIUM_FREQ char(20) No No
DESCRLONG TEXT No No
Index
Name Type Unique Member
PS_ASSET_INSURANCE PK Yes
Member(s) of "PS_ASSET_INSURANCE" Index
BUSINESS_UNIT
ASSET_ID
POLICY_ID
INSURANCE_VNDR
EFFDT

Published December 16, 2006