SR_SUM_DTL_AF

(SQL Table)
Index Back

Attached Files

Stores the attached files for Status Report

  • Parent record: PC_SR_SUM_DTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    4 SR_START_DATE Date(10) DATE NOT NULL Status Report start date
    5 SR_END_DATE Date(10) DATE Status Report end date
    6 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    10 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    11 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    12 DOCUMENT_REQUESTS Number(7,0) INTEGER NOT NULL Number of Requests