RE_EXPCLS_SRCH

(SQL View)
Index Back

Operating Expenses

Search View for the Operating Expense Categories to be used by Lease Administration.

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

  • Related Language Record: RE_EXPCATSR_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 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
    1=Base Rent
    2=Security Deposit
    3=Straightline Accounting
    4=Operating Expense
    5=Percent Rent
    6=Miscellaneous Rent
    7=Manual Fee
    8=Lease Obligation
    9=Lease Interest Expense
    A=Prior Period Lease Obligation
    B=Prior Period Lease Interest
    C=Rent Expense
    D=Lease Incentive

    Default Value: 4

    3 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.
    4 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Category Name