SAC_IDX_TBL

(SQL Table)
Index Back

Search Indexes

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INDEXNAME Character(30) VARCHAR2(30) NOT NULL Search Index Name
2 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
3 INDEX_PATH Character(254) VARCHAR2(254) NOT NULL Index Location
4 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
5 PV_RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
6 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
7 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
8 PV_APPCLASS_PATH_1 Character(254) VARCHAR2(254) NOT NULL Creating/Rebuilding
9 PV_APPCLASS_PATH_2 Character(254) VARCHAR2(254) NOT NULL Updating via Master Data Obj.
10 PV_APPCLASS_PATH_3 Character(254) VARCHAR2(254) NOT NULL Updating via Other Data Objs
11 PV_APPCLASS_PATH_4 Character(254) VARCHAR2(254) NOT NULL Updating Last Modified