AM_ASST_AUD_AET

(SQL Table)
Index Back

AM Asset Audit log state rec

AM Asset Audit log state record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUS_AM_NONVW

3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Default Value: NEXT

4 FS_EVENT_CODE Character(15) VARCHAR2(15) NOT NULL Event code
5 CHECK_STATUS Character(1) VARCHAR2(1) NOT NULL Work field used to store status values
6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.