LM_RSNCD_TBL

(SQL Table)
Index Back

Reason Code table

Reason Code table

  • Related Language Record: LM_RSNCD_LNG
  • Parent Record Of LM_CERT_RSN LM_CLS_RSN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_RSN_CD Character(10) VARCHAR2(10) NOT NULL Identifies the user defined reason code for program and activity status changes.
    2 LM_RSNCD_TYPE Character(2) VARCHAR2(2) NOT NULL Reason Code Type is used to identify whether the reason code is used for Programs or Activity status change.
    01=Program Status
    02=Class Status

    Default Value: 01

    3 LM_RSN_DESCR Character(50) VARCHAR2(50) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254