LM_CT_LOAD_ID10=In Preparation
20=Ready for Load
30=Load In Progress
40=Loaded
50=Error
Default Value: 10
10=Generic Import
Prompt Table: LM_CT_IMPORT_VW
Prompt Table: LM_CNT_TMPL_PT
LM_CT_LOAD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_CT_LOAD_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Content Template Load Id |
| 2 | LM_CT_LOAD_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Load Status
10=In Preparation 20=Ready for Load 30=Load In Progress 40=Loaded 50=Error Default Value: 10 |
| 3 | LM_CT_LOAD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Name |
| 4 | PROCESSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 6 | LM_CT_SEL_IMPORT | Character(25) | VARCHAR2(25) NOT NULL |
Select Type
10=Generic Import Prompt Table: LM_CT_IMPORT_VW |
| 7 | LM_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Template ID
Prompt Table: LM_CNT_TMPL_PT |
| 8 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 9 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 10 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 11 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 12 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 13 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |