IN_ITMCHG_RPT

(SQL Table)
Index Back

Item Change Process - Report

Item Change Process - Correct Rows for report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 TEMPLATE_LIST_ID Character(20) VARCHAR2(20) NOT NULL Item Template List ID
7 DATE1 Date(10) DATE Date
8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
11 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
12 VALUE_CHAR1 Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER