RB_QUES_VAR_VW

(SQL View)
Index Back

Question Variable view

View of Question Variables for Branch Scripting

SELECT Q.QUESTION_ID , V.SCR_VAR_ID , V.SCR_VAR_NAME FROM PS_RC_QUESTION Q , PS_RC_VARIABLE V WHERE Q.SCR_VAR_ID = V.SCR_VAR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 QUESTION_ID Number(12,0) DECIMAL(12) NOT NULL Used in CRM branch script
2 SCR_VAR_ID Number(12,0) DECIMAL(12) NOT NULL Branch Scripting Value Field
3 SCR_VAR_NAME Character(40) VARCHAR2(40) NOT NULL Branch Scripting Variable Field