EOCF_RULE_IDLANGUAGE_CDEOCF_RULTM_LVW(SQL View) |
Index Back |
|---|---|
Terms used in IA ViewClosed Loop Framework Terms used in IA View |
| SELECT DISTINCT B.EOCF_RULE_ID , D.LANGUAGE_CD , D.EOCF_LIB_TERM_NAME FROM PS_EOCF_PHRASE_XPR A , PS_EOCF_RULE_DEFN B , PS_EOCF_PHRASE_DFN C , PS_EOCF_TERMD_LNG D WHERE A.EOCF_PHRASE_ID = B.EOCF_PHRASE_ID AND A.EOCF_PHRASE_ID = C.EOCF_PHRASE_ID AND C.EOCF_PHRASE_STATUS = 'A' AND ((A.EOCF_LHS1_TYPE = '01' AND A.EOCF_LHS1_ELEM_ID = D.EOCF_LIB_TERM_ID) OR (A.EOCF_RHS1_TYPE = '01' AND A.EOCF_RHS1_TERM_ID = D.EOCF_LIB_TERM_ID) OR (A.EOCF_RHS2_TYPE = '01' AND A.EOCF_RHS2_TERM_ID = D.EOCF_LIB_TERM_ID)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCF_RULE_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework unique identifier for a policy |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EOCF_LIB_TERM_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of the Term in the library |