LM_CT_LOAD_ID10=In Preparation
20=Ready for Load
30=Load In Progress
40=Loaded
50=Error
LM_CT_LOAD_SRCH(SQL View) |
Index Back |
|---|
| SELECT LM_CT_LOAD_ID , LM_CT_LOAD_DESCR , LM_CT_LOAD_STATUS , LM_ROW_MAINT_DTTM , LM_ROW_ADDED_OPRID , RUN_CNTL_ID FROM PS_LM_CT_LOAD |
| # | 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_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Name |
| 3 | 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 |
| 4 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 5 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 6 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |