OPRIDSCC_LETTER_CDEXT_ORG_IDSCC_CG_LTRORGVW(SQL View) |
Index Back |
|---|---|
Organization Letter Code 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.DESCR FROM PS_COMMUNICATION A , PS_EXT_ORG_TBL B , PS_COMM_GRP_3C_TBL C , PS_OPR_GRP_3C_TBL D WHERE A.COMMON_ID = B.EXT_ORG_ID 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.COMPLETED_COMM <> 'Y' AND A.SA_ID_TYPE = 'O' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_EXT_ORG_TBL B1 WHERE B1.EXT_ORG_ID = B.EXT_ORG_ID AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |