PC_PRQ_HDR_ATT

(SQL Table)
 Index Back

Attachments

Record is used to store references to attached files.

  • Related Language Record: PC_PRQ_ATT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PC_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL Request Id
    2 PC_REQUEST_TYPE Character(5) VARCHAR2(5) NOT NULL Request Type

    Prompt Table: PC_REQUEST_TYPE

    3 PC_REQUEST_DESCR Character(254) VARCHAR2(254) NOT NULL Request Description
    4 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    5 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    6 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
    7 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    8 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    9 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    10 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.