LM_PRG_ATCH2_VW

(SQL View)
Index Back

Program Attachment

Program Attachment

SELECT A.LM_PRG_ID ,A.LM_ATTACH_ID ,A.LM_ATCH ,A.LM_SS_ATCH_DISP ,%subrec(FILE_ATTACH_SBR,A) FROM PS_LM_PRG_ATCH A , PS_LM_PRG B WHERE A.LM_PRG_ID = B.LM_PRG_ID AND A.EFFDT = B.EFFDT AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND A.LM_SS_ATCH_DISP = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
2 LM_ATTACH_ID Number(10,0) DECIMAL(10) NOT NULL Attachment ID - System generated unique ID created for each attachment.
3 LM_ATCH Character(50) VARCHAR2(50) NOT NULL Attachment Description
4 LM_SS_ATCH_DISP Character(1) VARCHAR2(1) NOT NULL Display attachment in self service

Y/N Table Edit

Default Value: N

5 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
6 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File