EOCF_IMPL_BINDS(SQL Table) |
Index Back |
|---|---|
Term Implementation Bindsdefinition of Implementations binds of a term |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOCF_IMPL_ID |
Number(31,0) | DECIMAL(31) NOT NULL | the ID value uniquely identifying a term implementation |
| 2 | EOCF_BIND_ORDERNUM |
Number(3,0) | SMALLINT NOT NULL |
bind order number
Default Value: 1 |
| 3 | EOCF_BIND_PARMNAME | Character(30) | VARCHAR2(30) NOT NULL | the name of a specific bind parameter |
| 4 | EOCF_BIND_DATATYPE | Character(2) | VARCHAR2(2) NOT NULL |
the type of SCALAR parameter that can be fed to a bind variable.
00=Number 01=String 02=Date 03=Datetime 04=Time 05=Object Default Value: 05 |
| 5 | EOCF_BIND_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
define bind types, possible values are technical and functional
EOCF_TBIND_MAP has similar field called source types and TEC and FUN should be same as functional and technical
FUN=User TEC=System Default Value: TEC |
| 6 | EOCF_PROMPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Data library - prompt type, Possible values are Prompt Edit, Translate, Dropdown and Custom. This field would be used to specify prompt table details, if any, for the term, bind, so that end users would be able to select valid values to fill in functional binds at rule/phrase design time.
Custom prompt type would be used to specify a custom app class when the prompt list has to be constrained by user specified filters.
1=Prompt With Edit 2=Translate Table 3=Dropdown List 4=Custom Prompt |
| 7 | EOCF_IS_SETID | Character(1) | VARCHAR2(1) NOT NULL | data library - is setid |
| 8 | EOCF_PROMPT_TBL | Character(15) | VARCHAR2(15) NOT NULL |
DATA LIBRARY - Prompt Table
Prompt Table: EOCF_SQLTBL_VW |
| 9 | EOCF_PROMPT_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Data Library, Name of the Prompt field/translate field
Prompt Table: %EDITTABLE |
| 10 | EOCF_PROMPT_OPTFLD | Character(18) | VARCHAR2(18) NOT NULL |
Data Library, Name of the Prompt field/translate field
Prompt Table: %EDITTABLE |
| 11 | EOCF_APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
data library - aplication class id
Prompt Table: EOCF_APPCLAS_VW |
| 12 | EOCF_APPCLASS_PATH | Character(167) | VARCHAR2(167) NOT NULL |
Application Class Full Path
Prompt Table: EOCF_APPPATH_VW |