CMNT1_VW

(SQL View)
 Index Back

Personal Comment View

Summary 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
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