BUSINESS_UNITPROJECT_IDACTIVITY_IDCONCAT_KEYSRECORD_TYPEF=Project Funding
R=Project Resource Transaction
PGM_ED_ACT_ATTS(SQL View) |
Index Back |
|---|---|
Activity AttachmentsView of activity attachments for Endeca. |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , %NumToChar(A.DOCUMENT_REQUESTS) , 'A' , A.ATTACHSYSFILENAME FROM PS_PC_ACT_DOCUMENT A UNION SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.PC_DELV_ID %Concat '::' %Concat A.DESCR , 'D' , A.ATTACHSYSFILENAME FROM PS_PC_DELV_DOC A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | CONCAT_KEYS |
Character(50) | VARCHAR2(50) NOT NULL | Configuration Parameter Key |
| 5 | RECORD_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Record Type
F=Project Funding R=Project Resource Transaction |
| 6 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |