INSTITUTIONEMPLIDEXT_ORG_IDCNST_ACTN_NOLNK_IDAV_CNT_RPT_VW(SQL View) |
Index Back |
|---|---|
Contact ReportSelects all contact reports a staff/volunteer is linked to. |
| SELECT A.INSTITUTION , A.EMPLID , A.EXT_ORG_ID , A.CNST_ACTN_NO , A.LNK_ID , B.AUTHOR_ID , B.RPT_DT , B.CMPL_DT , B.CNTC_SMRY_DESCR FROM PS_AV_CNTC_RPT_LNK A , PS_AV_CNST_ACTN B WHERE A.INSTITUTION=B.INSTITUTION AND A.CNST_ACTN_NO=B.CNST_ACTN_NO AND A.EMPLID = B.EMPLID AND A.EXT_ORG_ID = B.EXT_ORG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 4 | CNST_ACTN_NO |
Character(10) | VARCHAR2(10) NOT NULL | Action Nbr |
| 5 | LNK_ID |
Character(11) | VARCHAR2(11) NOT NULL | Link ID |
| 6 | AUTHOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Author ID |
| 7 | RPT_DT | Date(10) | DATE | Report Date |
| 8 | CMPL_DT | Date(10) | DATE | Complete Date |
| 9 | CNTC_SMRY_DESCR | Long Character | CLOB | Contact Report |