OPRIDSCC_LETTER_CDEXT_ORG_IDLANGUAGE_CDSCC_CG_LTRORGLN(SQL View) |
Index Back |
|---|---|
Org Letter Code Language ViewSCC_CG_LTRORGVW is used as a prompt in the communication envelope/label generation process. The view lists all Person IDs with the same Letter Code. This view is used if Process Instance is blank and Letter Code is not blank and ID Selection is "One Org ID" or "All Org IDs." |
| SELECT DISTINCT D.OPRID , A.SCC_LETTER_CD , A.COMMON_ID , B.LANGUAGE_CD , B.DESCR FROM PS_COMMUNICATION A , PS_EXT_ORG_LANG B , PS_COMM_GRP_3C_TBL C , PS_OPR_GRP_3C_TBL D WHERE A.COMMON_ID = B.EXT_ORG_ID AND A.COMPLETED_COMM <> 'Y' AND A.INSTITUTION = C.INSTITUTION AND C.INSTITUTION = D.INSTITUTION AND A.COMM_CATEGORY = C.COMM_CATEGORY AND C.GROUP_3C = D.GROUP_3C AND D.ENTRY_USE_IND = 'Y' AND A.SA_ID_TYPE = 'O' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_EXT_ORG_LANG B1 WHERE B1.EXT_ORG_ID = B.EXT_ORG_ID AND B1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SCC_LETTER_CD |
Character(3) | VARCHAR2(3) NOT NULL | Letter Code |
| 3 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |