EOCF_BIND_SPEC

(SQL Table)
Index Back

bind specification

specification 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