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 |