SUBJECT_HDR_TBL

(SQL Table)
 Index Back

Conversation Subject Table

This table is used to setup subjects and sub-topics for conversations

  • Related Language Record: SUBJECT_HDR_LNG

  • Parent Record Of SUBJECT_DTL_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CONVER_SUBJECT Character(30) VARCHAR2(30) NOT NULL Conversation Subject
    3 BUSINESS_TRANS Character(2) VARCHAR2(2) NOT NULL Business Transaction
    AR=Accounts Receivable
    BI=Billing
    DM=Deduction Management
    ES=EStore
    OM=Order Management
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description