OPRIDSETIDCS_TEMPLATE_IDCS_RULE_IDEFFDTCS_OBJ_TYPE_CHILD0001=Clause
0002=Section
0004=Rule
Prompt Table: CS_OBJ_TYPE_VW3
CS_CHILD_OBJIDPrompt Table: CS_OBJECTS3_VW
F=Full Text
R=By Reference Text
Default Value: F
CS_TMPL_ROBJ_VW(SQL View) |
Index Back |
|---|---|
Rule Drill Down Objects10/23/06 SCC: Rule Objects based on effective date of rule using View As of Date for document configurator. |
| SELECT A.OPRID , A.SETID , A.CS_TEMPLATE_ID , A.CS_RULE_ID , A.EFFDT , B.CS_OBJ_TYPE_CHILD , B.CS_CHILD_OBJID , B.SORT_SEQ_NBR , B.CS_BODY_TYPE FROM PS_CS_TMPL_RULE_VW A , PS_CS_RULE_OBJ B WHERE A.SETID = B.SETID AND A.CS_RULE_ID=B.CS_RULE_ID AND A.EFFDT=B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CS_TEMPLATE_ID |
Character(20) | VARCHAR2(20) NOT NULL | SCC 09/01/04 |
| 4 | CS_RULE_ID |
Character(20) | VARCHAR2(20) NOT NULL | t |
| 5 | EFFDT |
Date(10) | DATE | Effective Date |
| 6 | CS_OBJ_TYPE_CHILD |
Character(4) | VARCHAR2(4) NOT NULL |
Clause/section dependent
0001=Clause 0002=Section 0004=Rule Prompt Table: CS_OBJ_TYPE_VW3 |
| 7 | CS_CHILD_OBJID |
Character(20) | VARCHAR2(20) NOT NULL |
Child Object
Prompt Table: CS_OBJECTS3_VW |
| 8 | SORT_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 9 | CS_BODY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
indicates body type -- full or by ref for clause/section
F=Full Text R=By Reference Text Default Value: F |