CS_WD_BIND2

(SQL Table)
 Index Back

Working Doc Binds

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
3 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 CS_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
1=Transactional
3=Wizard
6 CS_DISPLAYTYPE Character(1) VARCHAR2(1) NOT NULL Display Type
1=Xlat Long Name
2=Xlat Short Name
3=Xlat Value
7 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
8 CS_RPT_FLG Character(1) VARCHAR2(1) NOT NULL Y means this is a repeating object.
9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
10 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
11 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
12 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
13 VALUE_DTTM DateTime(26) TIMESTAMP DateTime Value
14 VALUE_NBR Signed Number(33,8) DECIMAL(31,8) NOT NULL Numeric Value
15 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
16 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name