PROCESS_INSTANCEALL=All Languages
BAS=Base Language
Default Value: ALL
N=Incremental Index
P=Data Partition
Y=Full index
LM_ACTCI_PR_AET(SQL Table) |
Index Back |
|---|---|
Course Pre-proc State RecordThis is the state record for Course pre-processing. |
| # | 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 |