SFA_COD_AWD_RSP

(SQL Table)
Index Back

COD Award Response

Contains warnings and error codes related to the award.

  • Parent record: SFA_COD_AWARD
  • # 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_RPT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Reporting School ID
    3 SFA_CR_ATT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Attended School ID
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 SFA_CR_AWARD_NAME Character(30) VARCHAR2(30) NOT NULL Award Name
    6 SFA_CR_AWARD_YEAR Character(4) VARCHAR2(4) NOT NULL Award Year
    7 SFA_CR_AWARD_NBR Number(2,0) SMALLINT NOT NULL Award Number
    8 SFA_CR_RSP_SEQ Number(3,0) SMALLINT NOT NULL Response Sequence Number
    9 SFA_CR_RSP_ERR_CD Character(4) VARCHAR2(4) NOT NULL Response Error Code
    10 SFA_CR_RSP_MESSAGE Character(150) VARCHAR2(150) NOT NULL Response Message
    11 SFA_CR_RSP_ERR_FLD Character(200) VARCHAR2(200) NOT NULL Response Error Field
    12 SFA_CR_RSP_ERR_VAL Character(150) VARCHAR2(150) NOT NULL Response Error Value
    13 SFA_CR_RPTD_VALUE Character(150) VARCHAR2(150) NOT NULL Reported Value