SFA_COD_DOCUMNT

(SQL Table)
 Index Back

COD Document Information

Parent Table to all other Common Origination and Disbursement Tables. Contains general information about the COD document.

  • Parent Record Of SFA_COD_DOC_RSP SFA_COD_RPTSCHL SFA_FWS_RPTSCHL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_CR_DOCUMENT_ID Character(34) VARCHAR2(34) NOT NULL Document ID
    2 SFA_CR_CREATE_DTTM Character(22) VARCHAR2(22) NOT NULL Created Date & Time
    3 SFA_CR_SRC_TYPE Character(20) VARCHAR2(20) NOT NULL Source Type
    4 SFA_CR_SRC_ID Character(8) VARCHAR2(8) NOT NULL Source ID
    5 SFA_CR_DEST_TYPE Character(20) VARCHAR2(20) NOT NULL Destination Type
    6 SFA_CR_DEST_ID Character(8) VARCHAR2(8) NOT NULL Destination ID
    7 SFA_CR_SFTWARE_PRO Character(10) VARCHAR2(10) NOT NULL Software Provider
    8 SFA_CR_SFTWARE_VER Character(6) VARCHAR2(6) NOT NULL Software Version
    9 SFA_CR_FULL_RSP_CD Character(8) VARCHAR2(8) NOT NULL Full Response Flag
    10 SFA_CR_RECEIPT Character(22) VARCHAR2(22) NOT NULL Receipt Date
    11 SFA_CR_DOC_TYPE Character(35) VARCHAR2(35) NOT NULL Document Type
    12 SFA_CR_DOC_STATUS Character(1) VARCHAR2(1) NOT NULL Document Status
    13 SFA_CR_PROCESS_DT Character(10) VARCHAR2(10) NOT NULL Process Date
    14 SFA_CR_PS_PRC_STAT Character(1) VARCHAR2(1) NOT NULL Processing Status
    I=XML Processed
    L=Outbound to Stage
    P=Generated XML
    S=Ready to generate XML
    X=XML Loaded to Stage
    15 SFA_CR_PS_IN_DTTM DateTime(26) TIMESTAMP Inbound DateTime
    16 SFA_CR_PS_OUT_DTTM DateTime(26) TIMESTAMP Outbound DateTime
    17 SFA_CR_SCHEMA_VER Character(4) VARCHAR2(4) NOT NULL Schema Version
    2.0=Version 2.0
    3.0=Version 3.0
    4.0=Version 4.0
    4.0A=Version 4.0a
    4.0B=Version 4.0b
    4.0C=Version 4.0c
    4.0D=Version 4.0d
    4.0E=Version 4.0e
    5.0=Version 5.0
    5.0A=Version 5.0a
    5.0B=Version 5.0b
    18 SFA_FILE_PATH_NAME Character(128) VARCHAR2(128) NOT NULL File Path and Name
    19 SFA_CR_OTHSFT_PRO Character(10) VARCHAR2(10) NOT NULL Other Software Provider
    20 SFA_CR_OTHSFT_VER Character(6) VARCHAR2(6) NOT NULL Other Software Version