SFA_CRC_DOCUMNT

(SQL Table)
 Index Back

CRC Document Information

Parent Table to all other Common Origination and Disbursement

  • Parent Record Of SFA_CRC_ATTSCHL SFA_CRC_DOC_RSP SFA_CRC_FIN_SUM

    • # 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_RECIP_ID Character(12) VARCHAR2(12) NOT NULL CRC Recipient ID
    3 SFA_CR_DEST_TYPE Character(20) VARCHAR2(20) NOT NULL Destination Type
    4 SFA_CR_DEST_ID Character(8) VARCHAR2(8) NOT NULL Destination ID
    5 SFA_CR_DEST_BRANCH Character(4) VARCHAR2(4) NOT NULL Destination Branch ID
    6 SFA_CR_DEST_NAME Character(96) VARCHAR2(96) NOT NULL Destination Name
    7 SFA_CR_SRC_TYPE Character(20) VARCHAR2(20) NOT NULL Source Type
    8 SFA_CR_SRC_ID Character(8) VARCHAR2(8) NOT NULL Source ID
    9 SFA_CR_SRC_BRANCH Character(4) VARCHAR2(4) NOT NULL Source Branch ID
    10 SFA_CR_SRC_NAME Character(96) VARCHAR2(96) NOT NULL Source Name
    11 SFA_CR_DOC_TYPE Character(35) VARCHAR2(35) NOT NULL Document Type
    12 SFA_CR_CREATE_DTTM Character(22) VARCHAR2(22) NOT NULL Created Date & Time
    13 SFA_CR_SFTWARE_PRO Character(10) VARCHAR2(10) NOT NULL Software Provider
    14 SFA_CR_SFTWARE_VER Character(6) VARCHAR2(6) NOT NULL Software Version
    15 SFA_CR_DOC_STATUS Character(1) VARCHAR2(1) NOT NULL Document Status
    16 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
    17 SFA_CR_PS_OUT_DTTM DateTime(26) TIMESTAMP Outbound DateTime
    18 SFA_CR_PS_IN_DTTM DateTime(26) TIMESTAMP Inbound DateTime
    19 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
    20 SFA_FILE_PATH Character(250) VARCHAR2(250) NOT NULL File Path
    21 SFA_CR_RECEIPT Character(22) VARCHAR2(22) NOT NULL Receipt Date