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 | Active Analytics Framework 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 |