EOCF_REMTD_PRMS(SQL Table) |
Index Back |
---|---|
Resolution Method Parametersdata library- definition of resolution method parameters. It is based on name value pairs. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOCF_RES_MTHD_ID | Number(31,0) | DECIMAL(31) NOT NULL | data library - resolution method id |
2 | EOCF_SEQNUM | Number(3,0) | SMALLINT NOT NULL |
sequence number for line item rows
Default Value: 1 |
3 | EOCF_RES_PARM_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of the Resolution method parameter in the library |
4 | EOCF_RESPARM_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Label - Design Time Action |
5 | EOCF_IS_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Is this Implementation (resolution method) parameter required?
Y/N Table Edit Default Value: Y |
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 |