LM_CATG_LVL_AET

(SQL Table)
Index Back

Category Levels

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
3 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
4 PTSF_LANGUAGE Character(3) VARCHAR2(3) NOT NULL All Languages
ALL=All Languages
BAS=Base Language

Default Value: ALL

5 PTSF_RECRAWL_MODE Character(1) VARCHAR2(1) NOT NULL Indexing type
N=Incremental Index
P=Data Partition
Y=Full index
6 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).
7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
8 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time