RE_EXPCLS_SRCH(SQL View) |
Index Back |
---|---|
Operating ExpensesSearch 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)) |
# | 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 |