CS_TMPL_REXP_VW

(SQL View)
 Index Back

Rule Drill Down Expression

10/23/06 SCC: Rule Expression 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.SORT_SEQ_NBR , B.OPEN_BRCKT , B.CS_BIND_VAR , B.COMPARE_OPERATOR , B.VALUE_NBR , B.VALUE_INTEGER , B.VALUE_CHAR , B.VALUE_DATE , B.VALUE_DTTM , B.CLOSE_BRCKT , B.AND_OR_TXT , C.CS_FIELD_TYPE , C.CS_FIELD_LENGTH , C.CS_DATE_DISPLAY , C.CS_CURRENCY , C.CS_PRECISION , C.CS_BIND_TYPE , C.CS_FORMAT FROM PS_CS_TMPL_RULE_VW A , PS_CS_RULE_EXP B , PS_CS_BINDS C WHERE A.SETID = B.SETID AND A.CS_RULE_ID=B.CS_RULE_ID AND A.EFFDT=B.EFFDT AND B.CS_BIND_VAR=C.CS_BIND_VAR

# 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 SORT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sort Sequence Number
7 OPEN_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data
01=(
02=((
03=(((
04=((((
8 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable

Prompt Table: CS_BINDS_VW2

9 COMPARE_OPERATOR Character(3) VARCHAR2(3) NOT NULL Compare Operator
BTW=Between
EQ==
EX=Exist
GE=>=
GT=>
LE=<=
LK=Like
LT=<
NBW=Not Between
NE=<>
NEX=Not Exist
NLK=Not Like

Prompt Table: CS_COMP_OPR_VW

10 VALUE_NBR Signed Number(33,8) DECIMAL(31,8) NOT NULL Numeric Value
11 VALUE_INTEGER Signed Number(24,0) DECIMAL(23) NOT NULL Interger
12 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
13 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
14 VALUE_DTTM DateTime(26) TIMESTAMP DateTime Value
15 CLOSE_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat
01=)
02=))
03=)))
04=))))
16 AND_OR_TXT Character(3) VARCHAR2(3) NOT NULL Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi
AND=AND
OR=OR
17 CS_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Field Type 5/11/07 F-AHAYT-X0ES6 - Added new field type of Prompt
1=String
3=Date
4=Date/Time
5=Yes/No
6=Integer
7=Decimal
8=Prompt Table
9=Checkbox
18 CS_FIELD_LENGTH Character(3) VARCHAR2(3) NOT NULL Field Length 5/11/07 F-AHAYT-X0ES6 Added new Field Len of LNG
002=002
005=005
012=012
030=030
254=254
LNG=Long Char
19 CS_DATE_DISPLAY Character(3) VARCHAR2(3) NOT NULL Display Format
001=December 31, 2005
002=31 December 2005
003=12/31/2005
004=31/12/2005
005=Dec 31, 2005
006=31 Dec 2005
100=December 31, 2005 at 11:59 PM
102=31 December 2005 at 11:59 PM
104=12/31/2005 at 11:59 PM
106=31/12/2005 at 11:59 PM
20 CS_CURRENCY Character(1) VARCHAR2(1) NOT NULL Currency Bind
21 CS_PRECISION Number(2,0) SMALLINT NOT NULL F-AHAYT-X0ES6 new field for bindvariable/wizard masking
22 CS_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
1=Transactional
3=Wizard
23 CS_FORMAT Character(30) VARCHAR2(30) NOT NULL F-AHAYT-X0ES6 New Field for bind variable masking