ORG_CMNT_DTL_SH (SQL View)	Index Back
Organization 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.

ORG_CMNT_DTL_SH

(SQL View)

Organization 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 D.OPRID , A.COMMON_ID , A.SEQ_3C , A.COMMENT_DTTM , A.ADMIN_FUNCTION , A.CMNT_CATEGORY , A.INSTITUTION , A.COMMENT_DT , B.OTH_NAME_SORT_SRCH , B.EXT_ORG_TYPE FROM PS_PERSON_COMMENT A , PS_EXT_ORG_TBL B , PS_CMNT_GRP_3C_TBL C , PS_OPR_GRP_3C_TBL D WHERE A.COMMON_ID = B.EXT_ORG_ID 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.INQUIRY_USE_IND = 'Y'

# 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 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
Prompt Table: EXT_ORG_SRCH

3 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number

4 COMMENT_DTTM DateTime(26) TIMESTAMP NOT NULL Comment DateTime
Default Value: %date

5 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
Prompt Table: ADM_FCN_PPL_VW

6 CMNT_CATEGORY Character(6) VARCHAR2(6) NOT NULL Comment Category
Prompt Table: CMNT_CATG_VW

7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

8 COMMENT_DT Date(10) DATE Comment Date

9 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name

10 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type
Prompt Table: SCC_ORG_TYP_TBL

#	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	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value Prompt Table: EXT_ORG_SRCH
3	SEQ_3C	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	COMMENT_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Comment DateTime Default Value: %date
5	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function Prompt Table: ADM_FCN_PPL_VW
6	CMNT_CATEGORY	Character(6)	VARCHAR2(6) NOT NULL	Comment Category Prompt Table: CMNT_CATG_VW
7	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
8	COMMENT_DT	Date(10)	DATE	Comment Date
9	OTH_NAME_SORT_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Search Name
10	EXT_ORG_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Organization Type Prompt Table: SCC_ORG_TYP_TBL