ACCTGRP_SRCH_VW

(SQL View)
Index Back

Account Group View


SELECT A.SETID , A.BNK_ACCTGRP_ID , A.DESCR FROM PS_BNK_ACCTGRP_HDR A WHERE A.EFFDT = ( SELECT MAX (EFFDT) FROM PS_BNK_ACCTGRP_HDR B WHERE B.SETID = A.SETID AND B.BNK_ACCTGRP_ID = A.BNK_ACCTGRP_ID AND B.EFFDT <=%CurrentDateIn)

# 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 BNK_ACCTGRP_ID Character(10) VARCHAR2(10) NOT NULL Account Group ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description