RB_OB_CM_VW

(SQL View)

SELECT B.CMF_ID , A.CMF_INSTANCE_ID , B.GEN_MSG_PRIORITY , B.RB_ACT_RQST_CD FROM PS_RBC_RECIPIENT A , PS_RBC_REQUEST B WHERE B.CMF_SOURCE = 'ERMS' AND B.CMF_ID = A.CMF_ID AND A.CMF_RECIP_SEQ_NUM = 1 AND A.CMF_TRNS_SEQ_NUM = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CMF_ID Character(36) VARCHAR2(36) NOT NULL Correspondence ID

2 CMF_INSTANCE_ID Character(36) VARCHAR2(36) NOT NULL Correspondence Instance ID

3 GEN_MSG_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=High
2=Medium
3=Low

4 RB_ACT_RQST_CD Character(30) VARCHAR2(30) NOT NULL Action Request Code - this code is used primarily for Quality Worklist/Workflow when 'Assign To' is manually entered.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CMF_ID	Character(36)	VARCHAR2(36) NOT NULL	Correspondence ID
2	CMF_INSTANCE_ID	Character(36)	VARCHAR2(36) NOT NULL	Correspondence Instance ID
3	GEN_MSG_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=High 2=Medium 3=Low
4	RB_ACT_RQST_CD	Character(30)	VARCHAR2(30) NOT NULL	Action Request Code - this code is used primarily for Quality Worklist/Workflow when 'Assign To' is manually entered.