EOCF_IMPL_IDLANGUAGE_CDRBC_IMPLDFN_LNG(SQL View) |
Index Back |
|---|---|
Term Implementationdefinition of Implementations of a term |
| SELECT A.EOCF_IMPL_ID ,A1.LANGUAGE_CD ,A1.EOCF_IMPL_NAME ,A1.DESCR50 ,B1.EOCF_RESMTHD_NAME FROM PS_EOCF_IMPL_DEFN A , PS_EOCF_IMPDEN_LNG A1 , PS_EOCF_RESMTH_LNG B1 WHERE A.EOCF_IMPL_ID = A1.EOCF_IMPL_ID AND A.EOCF_RES_MTHD_ID = B1.EOCF_RES_MTHD_ID AND A.EOCF_IMPL_DATATYPE = 'RSET' |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EOCF_IMPL_NAME | Character(50) | VARCHAR2(50) NOT NULL | the name of the Implementation in the library |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | EOCF_RESMTHD_NAME | Character(30) | VARCHAR2(30) NOT NULL | the name of the resolution method in the library |