TRN_TUIT_EXPLVW

(SQL View)
Index Back

SELECT A.TUIT_EXPENSE_TYPE , B.LANGUAGE_CD , B.DESCR FROM PS_TUIT_EXPEN_TBL A , PS_TRN_EXPNTP_LANG B WHERE COST_UNIT_CD1 <> 'C' AND %Join(COMMON_KEYS, TUIT_EXPEN_TBL A, TRN_EXPNTP_LANG B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TUIT_EXPENSE_TYPE Character(10) VARCHAR2(10) NOT NULL Tuition Expense Type
2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description