LM_CT_LOAD_IDLM_CT_LOAD_CS_ID10=In Preparation
20=Ready for Load
30=Load In Progress
40=Loaded
50=Error
Default Value: 20
10=Generic Import
Prompt Table: LM_CT_IMPORT_VW
LM_CT_LOAD_CS(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_CS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Load CS ID |
| 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 Default Value: 20 |
| 4 | LM_CT_SEL_IMPORT | Character(25) | VARCHAR2(25) NOT NULL |
Select Type
10=Generic Import Prompt Table: LM_CT_IMPORT_VW |
| 5 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 6 | LM_DMTHD_ID | Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method |
| 7 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 8 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 9 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 10 | LM_ERRORTEXT | Long Character | CLOB | Error Text |