RC_ANSWERSET_IDD=Dynamic Answer
S=Static Answer
Default Value: S
RC_ANSWER_IDN=No
Y=Yes
RC_ANS_VALUE_VW(SQL View) |
Index Back |
|---|---|
Branch ScriptingBranch Scripting answer value view |
| SELECT A.RC_ANSWERSET_ID ,A.RC_ANSWERSET_TYPE , B.RC_ANSWER_ID , B.ANSWER_ORDER , B.ANSWER_VALUE , B.SCORE_NUM , B.IS_DEFAULT_FLG FROM PS_RC_ANSWER_SET A , PS_RC_ANSWER_VALUE B WHERE A.RC_ANSWERSET_ID = B.RC_ANSWERSET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RC_ANSWERSET_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Answer Set ID for Branch Scripting |
| 2 | RC_ANSWERSET_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Answer Set Types are:
1. Static Answer Set
2. Dynamic Answer Set
D=Dynamic Answer S=Static Answer Default Value: S |
| 3 | RC_ANSWER_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Answer ID |
| 4 | ANSWER_ORDER | Number(3,0) | SMALLINT NOT NULL | Answer Sequence |
| 5 | ANSWER_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Answer Value |
| 6 | SCORE_NUM | Number(3,0) | SMALLINT NOT NULL | Score |
| 7 | IS_DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default
N=No Y=Yes |