CS_BINDS

(SQL Table)
 Index Back

Binds

Binds F-AHAYT-X0ES6 - 04/17/07 added new fields for wizard enhancements to strings and numbers

  • Related Language Record: CS_BINDS_LANG

    • # 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
    6 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
    7 CS_FORMAT Character(30) VARCHAR2(30) NOT NULL F-AHAYT-X0ES6 New Field for bind variable masking
    8 CS_PRECISION Number(2,0) SMALLINT NOT NULL F-AHAYT-X0ES6 new field for bindvariable/wizard masking
    9 CS_CURRENCY Character(1) VARCHAR2(1) NOT NULL Currency Bind

    Y/N Table Edit

    Default Value: N

    10 CS_TABLENAME Character(15) VARCHAR2(15) NOT NULL Prompt Table

    Prompt Table: CS_PROMPTBL_VW