RC_TREE_QUST_LN

(SQL View)
Index Back

RC_TREE_QUST_LN

RC_TREE_QUST_LN

SELECT DISTINCT A.SETID , A.SCRIPT_ID ,A.EFFDT ,B.QUESTION_ID , B.LANGUAGE_CD , B.QUESTION_DESC FROM PS_RC_BS_TREE A ,PS_RC_QUESTION_LNG B WHERE A.QUESTION_ID = B.QUESTION_ID

  • Related Language Record for RC_TREE_QUST_VW
  • # 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.
    2 SCRIPT_ID Number(12,0) DECIMAL(12) NOT NULL Script ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 QUESTION_ID Number(12,0) DECIMAL(12) NOT NULL Used in CRM branch script
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 QUESTION_DESC Character(254) VARCHAR2(254) NOT NULL Question