CS_BINDS_D_VW

(SQL View)
 Index Back

Wizard Date Binds

2/4/2008 cel -- Wizard Date binds only

SELECT CS_BIND_VAR , DESCR , CS_BIND_TYPE , CS_FIELD_TYPE , CS_FIELD_LENGTH FROM PS_CS_BINDS WHERE CS_BIND_TYPE = '3' AND CS_FIELD_TYPE IN ('3')

  • Related Language Record: CS_BINDS_D_LVW

    • # 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
    5 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