PS Query & SQL

View Only

Alliance 2026 | March 8-11, 2026 | Orlando, FL

Back to discussions

Expand all | Collapse all

PSXLATITEM - Translate Value Items

1. PSXLATITEM - Translate Value Items

Recommend
Anna Kourouniotis

2025 CPE Presenter
Posted 10-15-2025 12:31 PM
Hi SQL experts,

Does anyone have any documentation (job aid) for working with translate values, particularly, how to join the PSXLATITEM (Translate Value Items) record on a student table such as STDTN_ENRL? I am trying to get the translate value for GRADING_BASIS_ENRL specifically. But really just looking for a go-to doc.

Thanks in advance!

Anna

------------------------------
HEUG Community of Practice
Reporting, Analytics, and Data Governance Subcommittee

Anna Kourouniotis MA
Database Analyst II
Duke University
------------------------------

2. RE: PSXLATITEM - Translate Value Items

Recommend

Stephen Forrest

Posted 10-15-2025 01:38 PM

We don't have grading basis on the translate table. It is on a setup table, GRADE_BASIS_TBL.

SELECT A.EMPLID, A.STRM, A.CLASS_NBR, A.GRADING_BASIS_ENRL
FROM PS_STDNT_ENRL A, PS_GRADE_BASIS_TBL B
WHERE ( A.STRM = '1257'
     AND B.GRADING_BASIS = A.GRADING_BASIS_ENRL
     AND B.GRADING_SCHEME = A.GRADING_SCHEME_ENR
     AND B.EFFDT =
        (SELECT MAX(B_ED.EFFDT) FROM PS_GRADE_BASIS_TBL B_ED
        WHERE B.SETID = B_ED.SETID
          AND B.GRADING_SCHEME = B_ED.GRADING_SCHEME
          AND B_ED.EFFDT <= SYSDATE))