WCB_INC_SUB_CLM

(SQL Table)
Index Back

  • Parent record: WCB_INC_SUB_STA
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
    2 TRANS_DT_TM DateTime(26) TIMESTAMP Transaction Date and Time
    3 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 CLAIM_NUMBER Number(10,0) DECIMAL(10) NOT NULL Claim Number
    6 CLAIM_STATUS_CODE Character(2) VARCHAR2(2) NOT NULL Claim Status Code
    7 CLAIM_MESSAGE Long Character CLOB Claim Status Message