LM_CI_IDLM_ACT_IDLM_ATTACH_IDLM_ATCH_DISP_VW(SQL View) |
Index Back |
|---|---|
Attachment Subpage ViewThis view does NOT return any meaningful data. It is used as a no-auto-select record on the SS attachments page. The view is populated from multiple rowsets through code. Please do not change this view. |
| SELECT C.LM_CI_ID ,A.LM_ACT_ID ,A.LM_ATTACH_ID ,C.LM_CS_DESCR ,A.ATTACHSYSFILENAME ,A.ATTACHUSERFILE ,A.LM_ROW_ADDED_DTTM FROM PS_LM_ACT_ATCH A ,PS_LM_ACT B ,PS_LM_CI_ATT_VW C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND C.LM_CI_ID = B.LM_CI_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 2 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 3 | LM_ATTACH_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Attachment ID - System generated unique ID created for each attachment. |
| 4 | LM_CS_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Description - Describes an object with further detail |
| 5 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 6 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 7 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |