RF_INST_PROD_PM

(SQL Table)
Index Back

Installed Product PM Child Rec

Preventive Maintenance History Child Record for Installed Product

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

Default Value: NEXT

3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
4 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

Prompt Table: RF_INSP_AGR_VW

5 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)

Prompt Table: RF_INSP_AGR1_VW

6 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number

Prompt Table: RF_INSP_AGR2_VW

7 CREATE_DATE Date(10) DATE Creation Date
8 SO_DATE Date(10) DATE Stores the Service Order creation date.
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RFPMNONVW

10 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
11 SETID_SERVICE Character(5) VARCHAR2(5) NOT NULL This field is used to represent the SETID of the Service
12 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID
13 INSPRD_PMSO_STATUS Character(3) VARCHAR2(3) NOT NULL Preventive Maintenance SO Status
CAN=Canceled
CMP=Completed
CRT=Created
INP=In Progress
PND=Pending
14 COMMENTS254 Character(254) VARCHAR2(254) NOT NULL Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)
15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
16 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
17 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
18 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
19 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
20 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time