LM_INSTR_AT_HST

(SQL Table)
Index Back

Instructor Attachments

Stores relationship between an instructor and individual attachments. Could be used to store a resume, for example - History Table

  • Related Language Record: LM_INSTRATL_HST
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    4 LM_ATTACH_ID Number(10,0) DECIMAL(10) NOT NULL Attachment ID - System generated unique ID created for each attachment.
    5 LM_ATCH Character(50) VARCHAR2(50) NOT NULL Attachment Description
    6 LM_SS_ATCH_DISP Character(1) VARCHAR2(1) NOT NULL Display attachment in self service
    7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    9 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    10 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    11 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    12 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid