CMNT_VW(SQL View) |
Index Back |
|---|---|
Personal Comment ViewSummary view of all comments about a person. This view is linked with Oprid so that the summary can be limited to only the 3C Groups that the operator is authorized to see. |
| SELECT DISTINCT a.oprid , c.common_id , c.seq_3c , A.ENTRY_USE_IND , c.comment_dttm , c.admin_function , c.cmnt_category , c.deptid , c.cmnt_id , c.comment_dt , c.institution , C.VAR_DATA_SEQ , C.SA_ID_TYPE FROM ps_opr_grp_3c_tbl a , ps_cmnt_grp_3c_tbl b , PS_PERSON_COMMENT c WHERE a.institution = b.institution AND a.group_3c = b.group_3c AND a.inquiry_use_ind='Y' AND b.institution = c.institution AND b.cmnt_category=c.cmnt_category |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 2 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | SEQ_3C |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | ENTRY_USE_IND |
Character(1) | VARCHAR2(1) NOT NULL |
Update Indicator
Y/N Table Edit Default Value: N |
| 5 | COMMENT_DTTM | DateTime(26) | TIMESTAMP | Comment DateTime |
| 6 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: ADM_FCN_PPL_VW |
| 7 | CMNT_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL |
Comment Category
Prompt Table: CMNT_CATG_VW |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 9 | CMNT_ID | Character(11) | VARCHAR2(11) NOT NULL |
Comment ID
Prompt Table: PEOPLE_SRCH |
| 10 | COMMENT_DT | Date(10) | DATE | Comment Date |
| 11 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 12 | VAR_DATA_SEQ | Number(4,0) | SMALLINT NOT NULL | Variable Data Sequence Number |
| 13 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |