CMNT_SRCH

(SQL View)
 Index Back

Person Comment Search

CMNT_SRCH is the search record for Comment Entry. It provides the ability to search based on category and administrative function as well as the standard name search.

SELECT DISTINCT e.oprclass , d.oprid , a.common_id , a.seq_3c , a.comment_dttm , a.admin_function , a.cmnt_category , a.institution , a.comment_dt , b.name , e.country , e.national_id_type , f.descrshort , e.national_id , e.national_id_msk , g.campus_id , b.last_name_srch , b.first_name_srch , a.var_data_seq FROM PS_PERSON_COMMENT a , PS_SCC_PRI_NAME_VW b , ps_cmnt_grp_3c_tbl c , ps_opr_grp_3c_tbl d , ps_pers_nid_msk_vw e , ps_nid_type_tbl f , PS_SCC_PERS_SA_VW g WHERE a.common_id = b.emplid AND a.common_id = g.emplid AND a.institution = c.institution AND a.cmnt_category = c.cmnt_category AND c.institution = d.institution AND c.group_3c = d.group_3c AND d.entry_use_ind = 'Y' AND a.common_id = e.emplid AND f.country = e.country AND f.national_id_type = e.national_id_type

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

Prompt Table: PEOPLE_SRCH

4 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
5 COMMENT_DTTM DateTime(26) TIMESTAMP NOT NULL Comment DateTime

Default Value: %date

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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

9 COMMENT_DT Date(10) DATE Comment Date
10 NAME Character(50) VARCHAR2(50) NOT NULL Name
11 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
12 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
13 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
14 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
15 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
16 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
17 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
18 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
19 VAR_DATA_SEQ Number(4,0) SMALLINT NOT NULL Variable Data Sequence Number