RBC_RECP_LOG

(SQL Table)
Index Back

Correspondence Attachments

Correspondence Request File Attachments

  • Parent record: RBC_RECP_ATTACH
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CMF_ID Character(36) VARCHAR2(36) NOT NULL Correspondence ID
    2 CMF_TRNS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Correspondence Management Package Sequence Number
    3 CMF_RECIP_SEQ_NUM Number(18,0) DECIMAL(18) NOT NULL Correspondence Management Package Sequence Number
    4 HIST_SEQ Number(9,0) DECIMAL(9) NOT NULL History Sequence Number to be used in the History Records
    5 RB_TEMPLATE_ID Number(10,0) DECIMAL(10) NOT NULL Template ID
    6 CM_ERROR_TYPE Character(1) VARCHAR2(1) NOT NULL Correspndence Log Error Type
    1=Peoplecode Error
    2=SQL Error
    3=Token Error
    4=FTP Error
    5=Other Error
    6=Template Error
    7 DATETIME_LOG DateTime(26) TIMESTAMP CM Log Datetime
    8 DESCRLONG Long Character CLOB Long Description