PeopleSoft 9
Asset Management

Table Name INTFC_PHY_B

Table Description
INTFC_PHY_B
Columns
Name Datatype Is PK Is FK
INTFC_ID int Yes No
INTFC_LINE_NUM int Yes No
BUSINESS_UNIT char(5) Yes No
ASSET_ID char(12) Yes No
INTFC_TYPE char(3) Yes No
SYSTEM_SOURCE char(3) No No
MC_DEFN_ID char(30) No No
APPROVAL_SW char(1) No No
INTFC_STATUS char(3) No No
LOAD_STATUS char(3) No No
ATTRIBUTE_EFFDT PSDATE No No
ASSET_COLOR char(15) No No
ASSET_WEIGHT decimal(12,3) No No
WEIGHT_UM char(3) No No
ASSET_HEIGHT decimal(12,3) No No
HEIGHT_UM char(3) No No
ASSET_WIDTH decimal(12,3) No No
WIDTH_UM char(3) No No
ASSET_LENGTH decimal(12,3) No No
LENGTH_UM char(3) No No
ASSET_CAPACITY decimal(12,3) No No
CAPACITY_UM char(3) No No
POWER_RATING decimal(12,3) No No
POWER_RATING_UM char(3) No No
COMMENT_DTTM_STAMP PSDATETIME No No
NAME char(50) No No
COMMENTS50 char(50) No No
AGENCY_ID char(20) No No
LICENSE_VENDOR_ID char(10) No No
REGISTRATION_NO char(25) No No
INSPECTION_SW char(1) No No
LIC_START_DT PSDATE No No
LIC_END_DT PSDATE No No
REGISTER_NAME char(30) No No
COUNTRY char(3) No No
ADDRESS1 char(55) No No
ADDRESS2 char(55) No No
ADDRESS3 char(55) No No
ADDRESS4 char(55) No No
CITY char(30) No No
NUM1 char(6) No No
NUM2 char(4) No No
HOUSE_TYPE char(2) No No
ADDR_FIELD1 char(2) No No
ADDR_FIELD2 char(4) No No
ADDR_FIELD3 char(4) No No
COUNTY char(30) No No
STATE char(6) No No
POSTAL char(12) No No
GEO_CODE char(11) No No
IN_CITY_LIMIT char(1) No No
JURISDICTION char(5) No No
LICENSE_COMMENTS50 char(50) No No
WARRANTY_EFFDT PSDATE No No
EFF_STATUS char(1) No No
WARRANTY_VENDOR_ID char(10) No No
WARRANTY_NUM char(30) No No
WARRANTY_DURATION int No No
COVERAGE50 char(50) No No
AM_AST_UD_CHAR1 char(10) No No
AM_AST_UD_CHAR2 char(10) No No
AM_AST_UD_DATE1 PSDATE No No
AM_AST_UD_NUM1 decimal(18,3) No No
AM_AST_UD_NUM2 decimal(18,3) No No
PROCESS_INSTANCE decimal(10) No No
Index
Name Type Unique Member
PS_INTFC_PHY_B PK Yes
PSAINTFC_PHY_B IE1 No
Member(s) of "PS_INTFC_PHY_B" Index
INTFC_ID
INTFC_LINE_NUM
BUSINESS_UNIT
ASSET_ID
INTFC_TYPE
Member(s) of "PSAINTFC_PHY_B" Index
PROCESS_INSTANCE

Published December 16, 2006