EOCF_IMPLSRH_VW

(SQL View)
 Index Back

DL Search View for Impl Def

Data Library search view for implementation definition page

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

  • Related Language Record: EOCF_IMSRVW_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 EOCF_RES_MTHD_ID Number(31,0) DECIMAL(31) NOT NULL data library - resolution method id

    Prompt Table: EOCF_RES_METHD

    4 EOCF_RESMTHD_NAME Character(30) VARCHAR2(30) NOT NULL the name of the resolution method in the library
    5 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
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50