SETIDSCRIPT_IDEFFDTRC_SETIDRC_EFFDTRC_BS_WEIGHT_V3(SQL View) |
Index Back |
|---|---|
Branch ScriptingBranch Scripting answer weight view |
| SELECT A.SETID , A.SCRIPT_ID , A.EFFDT , B.RC_SETID , B.SUB_SCRIPT_ID , B.RC_EFFDT , C.RC_WEIGHT FROM PS_RC_BSCRIPT A , PS_RC_BS_TREE B , PS_RC_BSCRIPT C WHERE A.SETID = B.SETID AND A.SCRIPT_ID = B.SCRIPT_ID AND A.EFFDT = B.EFFDT AND B.RC_SETID IS NOT NULL AND B.SUB_SCRIPT_ID IS NOT NULL AND B.RC_EFFDT IS NOT NULL AND B.RC_SETID = C.SETID AND B.SUB_SCRIPT_ID = C.SCRIPT_ID AND B.RC_EFFDT = C.EFFDT AND C.RC_WEIGHT > 0 |
| # | 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 NOT NULL | Effective Date |
| 4 | RC_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Setid work field .................................... |
| 5 | SUB_SCRIPT_ID | Number(12,0) | DECIMAL(12) NOT NULL | Branch script |
| 6 | RC_EFFDT |
Date(10) | DATE | Branch Script Effective Date |
| 7 | RC_WEIGHT | Number(8,0) | INTEGER NOT NULL | Branch Scripting Number field |