HRS_AL_LOG

(SQL Table)
Index Back

Resume Extraction Log

Log of all resumes recieved, where they were recieved from and their current state

  • Parent Record Of HRS_AL_LOG_EXTR HRS_AL_LOG_NOTI HRS_AL_LOG_RES HRS_AL_LOG_SRCE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID
    2 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    3 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    4 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
    5 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    6 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    7 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    8 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id