SP Installed Item Information

Field Name

Format

Source/Value/Description

SP_ID

A10

CI_FA

SP_ITEM_HIST_ID

A10

CI_SP_ITEM_HIST

ITEM_ID

A10

CI_SP_ITEM_HIST

INSTALL_DTTM

Date

CI_SP_ITEM_EVT.EVENT_DTTM

BADGE_NBR

A30

CI_ITEM

ITEM_TYPE_CD

A8

CI_ITEM

ITEM_STATUS_FLG

A2

CI_ITEM

MFG_CD

A8

CI_ITEM

MODEL_CD

A8

CI_ITEM

SERIAL_NBR

A16

CI_ITEM

RECEIVE_DT

Date

CI_ITEM

ITEM_DESCR

A254

CI_ITEM.DESCR254

ITEM_TYPE_DESCR

A60

CI_ITEM_TYPE_L.DESCR

MFG_DESCR

A60

CI_MFG_L.DESCR

MODEL_DESCR

A60

CI_MODEL_L.DESCR