EXT_TERM_TBLV1L

(SQL View)
 Index Back

External Term Table

Use EXT_TERM_TBL to define external terms which includes defining them into external term types and relating these to month codes.

SELECT DISTINCT A.EXT_TERM_TYPE , B.LANGUAGE_CD , B.XLATLONGNAME FROM PS_EXT_TERM_TBL A , PSXLATITEMLANG B WHERE B.FIELDNAME = 'EXT_TERM_TYPE' AND B.FIELDVALUE = A.EXT_TERM_TYPE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PSXLATITEMLANG B1 WHERE B1.FIELDNAME = B.FIELDNAME AND B1.FIELDVALUE = B.FIELDVALUE)

  • Related Language Record for EXT_TERM_TBLV1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
    1YR=Full Year
    MINI=Miniterm
    OTHR=Other
    QTR=Quarter
    QUIN=Quinmester
    SEM=Semester
    TRIM=Trimester
    UNKN=Unknown
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description