STD_COMM_SRCH

(SQL View)
Index Back

Std Comments Search


SELECT a.setid , a.std_comment_type , a.std_comment_id , a.effdt , a.descr FROM PS_STD_COMM_TBL_PO a WHERE a.Effdt = ( SELECT MAX(b.Effdt) FROM PS_STD_COMM_TBL_PO b WHERE b.Setid = a.SetID AND b.std_comment_type = a.std_comment_type AND b.std_comment_id = a.std_comment_id )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 STD_COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Standard Comment Type

Prompt Table: STD_COMM_TYP_PO

3 STD_COMMENT_ID Character(4) VARCHAR2(4) NOT NULL Standard Comment ID
4 EFFDT Date(10) DATE NOT NULL Effective Date
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description