ORG_CMNT_VW (SQL View)	Index Back
Organization Comment View ORG_CMNT_VW is a summary view of all comments about an organization. This view is linked with Oprid so that the summary can be limited to only the Inquiry Groups that the operator is authorized to see.

ORG_CMNT_VW

(SQL View)

Organization Comment View

ORG_CMNT_VW is a summary view of all comments about an organization. This view is linked with Oprid so that the summary can be limited to only the Inquiry Groups that the operator is authorized to see.

SELECT DISTINCT a.oprid , c.common_id , c.seq_3c , c.comment_dttm , c.admin_function , c.cmnt_category , c.deptid , c.cmnt_id , c.comment_dt , c.institution 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.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).

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 COMMENT_DTTM DateTime(26) TIMESTAMP NOT NULL Comment DateTime

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

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

7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

8 CMNT_ID Character(11) VARCHAR2(11) NOT NULL Comment ID
Prompt Table: PEOPLE_SRCH

9 COMMENT_DT Date(10) DATE Comment Date

10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_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
3	SEQ_3C	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	COMMENT_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Comment DateTime
5	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function Prompt Table: ADM_FUNCTN_TBL
6	CMNT_CATEGORY	Character(6)	VARCHAR2(6) NOT NULL	Comment Category Prompt Table: CMNT_CATG_VW
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
8	CMNT_ID	Character(11)	VARCHAR2(11) NOT NULL	Comment ID Prompt Table: PEOPLE_SRCH
9	COMMENT_DT	Date(10)	DATE	Comment Date
10	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL