SSF_DG_TREE_VW2(SQL View) |
Index Back |
|---|---|
SF Payment Diagnostic View2This view is created to assist with pulling data for Diagnostic Plugins. This view should not be used for any other purpose. |
| SELECT Y.SETID , M.CHARGE_PRIORITY , M.EFFDT , Y.TREE_NODE , D.SETCNTRLVALUE , Y.CURRENT_TERM_CHRGS , Y.PRIOR_TERM_CHARGES , Y.PRIOR_YEAR_CHARGES , Y.FUTURE_TERM_CHARGE FROM PS_PMT_CHRG_PRIOR Y , PS_PMT_CHRG_TBL M , PS_SET_CNTRL_REC D WHERE D.RECNAME = 'PMT_CHRG_TBL' AND M.SETID = D.SETID AND M.EFFDT = ( SELECT MAX(T.EFFDT) FROM PS_PMT_CHRG_TBL T WHERE T.SETID = M.SETID AND T.CHARGE_PRIORITY = M.CHARGE_PRIORITY AND T.EFFDT <= %CurrentDateIn ) AND M.EFF_STATUS = 'A' AND Y.SETID = M.SETID AND Y.CHARGE_PRIORITY = M.CHARGE_PRIORITY AND Y.EFFDT = M.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CHARGE_PRIORITY | Character(8) | VARCHAR2(8) NOT NULL | Charge Priority List |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 5 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 6 | CURRENT_TERM_CHRGS | Character(1) | VARCHAR2(1) NOT NULL |
Pay Current Term Charges?
G=Negative Permission N=No P=Positive Permission Y=Yes |
| 7 | PRIOR_TERM_CHARGES | Character(1) | VARCHAR2(1) NOT NULL |
Pay Prior Term Charges?
G=Negative Permission N=No P=Positive Permission Y=Yes |
| 8 | PRIOR_YEAR_CHARGES | Character(1) | VARCHAR2(1) NOT NULL |
Pay Prior Year Charges?
G=Negative Permission N=No P=Positive Permission Y=Yes |
| 9 | FUTURE_TERM_CHARGE | Character(1) | VARCHAR2(1) NOT NULL |
Future Term Charges
G=Negative Permission N=No P=Positive Permission Y=Yes |