RS_ACMP_DEG_LVW

(SQL View)
Index Back

Accomplishment Degree View-Lng

View to get the Accomplishment Degree values from Accomplishment Record.

SELECT A.ACCOMPLISHMENT , B.LANGUAGE_CD , B. DESCR FROM PS_ACCOMP_TBL A , PS_ACCOMP_TBL_LANG B WHERE A.ACCOMP_CATEGORY='DEG' AND A.ACCOMPLISHMENT = B.ACCOMPLISHMENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description