ACA_WRKGRP_SRCH

(SQL View)
 Index Back

ACA Workgroup TRC search rec


SELECT A.WORKGROUP ,W.DESCR FROM PS_TL_WRKGRP_TBL W , PS_ACA_TRC_TBL A WHERE A.WORKGROUP = W.WORKGROUP AND W.EFFDT = ( SELECT MAX(M.EFFDT) FROM PS_TL_WRKGRP_TBL M WHERE M.WORKGROUP = W.WORKGROUP AND M.EFFDT <= %CurrentDateIn) AND W.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup

Prompt Table: TL_WRKGRP_TBL

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description