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 |