RECIPINTREQVWLN(SQL View) |
Index Back |
---|---|
Merit Requirements ViewRECIPINTREQVWLN is the language record related to RECIPINT_REQ_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries. |
SELECT a.checklist_cd , B.LANGUAGE_CD , B.descr FROM PS_CS_CHKLST_TBL a , PS_CS_CHKLST_LANG B WHERE a.effdt = ( SELECT MAX(a1.effdt) FROM PS_CS_CHKLST_TBL a1 WHERE a.checklist_cd = a1.checklist_cd AND a1.effdt <= %CurrentDateIn) AND A.eff_status = 'A' AND A.INSTITUTION = B.INSTITUTION AND A.checklist_cd = B.checklist_cd AND a.effdt = B.effdt |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RECIPIENT_REQMNT | Character(6) | VARCHAR2(6) NOT NULL | Recipient Requirements |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |