CS_BINDS_VW2

(SQL View)
 Index Back

Bind prompt within Rules

Bind prompt table used for rules. 6/19/09 -- cel Excluded LONG bind variables to be picked. Can't use them in rules.

SELECT CS_BIND_VAR , DESCR , CS_BIND_TYPE , CS_FIELD_TYPE FROM PS_CS_BINDS A WHERE CS_BIND_TYPE IN ('1', '3') AND CS_BIND_VAR <> 'PSFT_CONFIG_BIND' AND CS_FIELD_LENGTH <> 'LNG' AND NOT EXISTS ( SELECT 'X' FROM PS_CS_BIND_MAP_DTL B , PSDBFIELD F WHERE A.CS_BIND_VAR = B.CS_BIND_VAR AND B.FIELDNAME = F.FIELDNAME AND F.FIELDTYPE =1 )

  • Related Language Record: CS_BINDS_LVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 CS_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
    1=Transactional
    3=Wizard
    4 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