EXT_TERM_TBLV1

(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.XLATLONGNAME FROM PS_EXT_TERM_TBL A , PSXLATITEM B WHERE B.FIELDNAME = 'EXT_TERM_TYPE' AND B.FIELDVALUE = A.EXT_TERM_TYPE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PSXLATITEM B1 WHERE B1.FIELDNAME = B.FIELDNAME AND B1.FIELDVALUE = B.FIELDVALUE)

  • Related Language Record: EXT_TERM_TBLV1L

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description