RE_SUNDCHG_SRCH

(SQL View)
 Index Back

Sundry Charges Charge Codes

Search view for the Charge Group Codes for the Manual Fee to be used by Lease Administration for Adhoc payment

SELECT A.SETID , A.CHG_GRP_CD , A.INSTANCE_NAME FROM PS_RE_SUNDRY_CHG A WHERE (%CurrentDateIn BETWEEN A.EFFDT AND A.END_EFFDT) OR (A.EFFDT = ( SELECT MIN(C.EFFDT) FROM PS_RE_SUNDRY_CHG C WHERE C.SETID = A.SETID AND C.CHG_GRP_CD = A.CHG_GRP_CD AND C.EFFDT > %CurrentDateIn) AND NOT EXISTS ( SELECT 1 FROM PS_RE_SUNDRY_CHG B WHERE B.SETID = A.SETID AND B.CHG_GRP_CD = A.CHG_GRP_CD AND %CurrentDateIn BETWEEN B.EFFDT AND B.END_EFFDT))

  • Related Language Record: RE_SUNDCHGSR_LG

    • # 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 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.
    3 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Manual Fee Name