SUBJECT_DTL_TBL

(SQL Table)
 Index Back

Contact Us Subject Table

This table is used to setup subjects and sub-topics for Contact Us.

  • Parent record: SUBJECT_HDR_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CONVER_SUBJECT Character(30) VARCHAR2(30) NOT NULL Contact Us Subject
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 CONVER_SUB_TOPIC Character(30) VARCHAR2(30) NOT NULL Contact Us Topic

    Prompt Table: SUB_TOPIC_TBL

    5 CONVR_QUALIFIER_CD Character(2) VARCHAR2(2) NOT NULL Conversation Qualifier Code
    D=Document Number
    DE=Deduction Item
    I=Item
    L=Bill of Lading
    P=Purchase Order Number
    PY=Payment ID
    6 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: ROLEUSER_VW

    7 EMAIL_FORMID Character(20) VARCHAR2(20) NOT NULL Email Template
    8 RULE_NAME Character(30) VARCHAR2(30) NOT NULL This field is a text field of 30 character long.

    Prompt Table: RB_WF_RULE

    9 LOGGED_IN Character(1) VARCHAR2(1) NOT NULL Logged In?

    Y/N Table Edit

    10 SHORT_PAY_FLAG Character(1) VARCHAR2(1) NOT NULL Short Pay

    Default Value: N

    11 RB_TEMPLATE_ID Number(10,0) DECIMAL(10) NOT NULL Template ID

    Prompt Table: RBC_CM_TMPLT_VW