OPRIDSCC_LETTER_CDEMPLIDSCC_CG_LTRPERVW(SQL View) |
Index Back |
|---|---|
Person Letter Code ViewSCC_CG_LTRPERVW 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 Person ID" or "All Person IDs." |
| SELECT DISTINCT D.OPRID , A.SCC_LETTER_CD , A.COMMON_ID , B.NAME , E.CAMPUS_ID , F.NATIONAL_ID , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH FROM PS_COMMUNICATION A , PS_SCC_PRI_NAME_VW B , PS_COMM_GRP_3C_TBL C , PS_OPR_GRP_3C_TBL D , PS_PERSON_MSK_VW E , PS_PERS_NID_MSK_VW F WHERE A.COMMON_ID = B.EMPLID AND A.COMMON_ID = E.EMPLID AND A.COMMON_ID = F.EMPLID AND A.INSTITUTION = C.INSTITUTION AND C.INSTITUTION = D.INSTITUTION AND A.COMM_CATEGORY = C.COMM_CATEGORY AND A.COMPLETED_COMM <> 'Y' AND C.GROUP_3C = D.GROUP_3C AND D.ENTRY_USE_IND = 'Y' AND A.SA_ID_TYPE = 'P' |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | CAMPUS_ID | Character(16) | VARCHAR2(16) NOT NULL | Campus ID |
| 6 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 7 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |