PGM_ED_PRJ_ATTS

(SQL View)
 Index Back

Project Attachments

View of project attachments for Endeca.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , %NumToChar(A.DOCUMENT_REQUESTS) , 'P' , A.ATTACHSYSFILENAME FROM PS_PROJ_DOCUMENT A UNION SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.PC_IM_ISSUE_ID %Concat '::' %Concat A.DESCR , 'I' , A.ATTACHSYSFILENAME FROM PS_PC_IM_ATTCH_TBL A UNION SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.EMPLID %Concat '::' %Concat %CAST(A.SR_END_DATE , DATE , CHARACTER) , 'S' , A.ATTACHSYSFILENAME FROM PS_PC_SR_SUMDTL_AF A UNION SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.RISK_ID %Concat '::' %Concat A.DESCR , 'R' , A.ATTACHSYSFILENAME FROM PS_PGM_RISK_ATTACH 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 CONCAT_KEYS Character(50) VARCHAR2(50) NOT NULL Configuration Parameter Key
4 RECORD_TYPE Character(1) VARCHAR2(1) NOT NULL Record Type
F=Project Funding
R=Project Resource Transaction
5 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename