EOCF_BIND_SPEC_IDEOCF_SEQNUM00=Number
01=String
02=Date
03=Datetime
04=Time
05=Object
EOCF_BIND_SPEC(SQL Table) |
Index Back |
|---|---|
bind specificationspecification of required bind interface |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCF_BIND_SPEC_ID |
Number(31,0) | DECIMAL(31) NOT NULL | unique key identifying a set of bind requirements |
| 2 | EOCF_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | sequence number for line item rows |
| 3 | 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 |
| 4 | EOCF_BIND_PARMNAME | Character(30) | VARCHAR2(30) NOT NULL | the name of a specific bind parameter |
| 5 | EOCF_IS_TECHNICAL | Character(1) | VARCHAR2(1) NOT NULL | is this bind a technical consideration that the end-user(not IT) should never see |