RBC_IMPLDFN_VW

(SQL View)
 Index Back

Term Implementation

definition of Implementations of a term

SELECT A.EOCF_IMPL_ID ,A.EOCF_IMPL_NAME ,A.DESCR50 ,A.EOCF_IMPL_DATATYPE ,A.EOCF_RES_MTHD_ID ,B.EOCF_RESMTHD_NAME FROM PS_EOCF_IMPL_DEFN A , PS_EOCF_RES_METHD B WHERE A.EOCF_RES_MTHD_ID = B.EOCF_RES_MTHD_ID AND A.EOCF_IMPL_DATATYPE = 'RSET'

  • Related Language Record: RBC_IMPLDFN_LNG

    • # 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_IMPL_NAME Character(50) VARCHAR2(50) NOT NULL the name of the Implementation in the library
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 EOCF_IMPL_DATATYPE Character(4) VARCHAR2(4) NOT NULL data library IMPl return data type, possible values are scalar,composite
    A2AN=Array2 of Any
    ADAT=Date Array
    ADTT=Datetime Array
    ANUM=Number Array
    ARAN=Array of Any
    ASTR=String Array
    ATIM=Time Array
    DATE=Date
    DTTM=Datetime
    NUM=Number
    OTHR=Other
    REC=Record
    RSET=Rowset
    STR=String
    TIME=Time
    5 EOCF_RES_MTHD_ID Number(31,0) DECIMAL(31) NOT NULL data library - resolution method id

    Prompt Table: EOCF_RES_METHD

    6 EOCF_RESMTHD_NAME Character(30) VARCHAR2(30) NOT NULL the name of the resolution method in the library